MCSG config

[Vogra]

Hi All,

we have 2 rp2470 and one DS2300 on cluster system with MCService guard and we are instaling...
We'll run Oracle 8.1.6 (one instance) and Baan acessing it instance.

well, my doubt is only about Oracle:

we are get the Oracle on both server installed on systems disks (db engine)
The aplications tablespaces will on array like this:

|instance|-------|Tablespace data|--------|instance|

But consider the situation where we have a public synonym:
when the first node are running and I create a public synonym, it is on data dictionary -Tablespace System (right me if I'm wrong)...
well if the node get fail, the second node will get the public synonym ?
Thanx in advance,
Lima.

[A. Clay Stephenson]

If I understand your question then , yse, once the synonym is created on the active node it will be available on the failover node.

The problem with your setup (again, if I understand you) is keeping the init.ora changes "in sync". You must remember to make these changes in both places so that the parameters are the same upon failover. I would suggest that you copy the files rather than editing them in both places so that possible syntax errors don't creep in.

While there is no "correct" method, I actually prefer to move everything datafiles, init.ora's etc. and executables including the listener with the package.

[Julio Yamawaki]

Hi,

if I correct get what you wrote, I think you're thinking in the wrong way:
1. If you plan to have two db engines (i.e, database), and for the same application (in your case Baan), you cannot. You MUST have one database that will be started up at one machine each time. In this case, you will not have problema in creating your synonym, because it will be in one database.
2. You can have two database configured in the cluster, but for two differente packages, holding different data.

[Jeff Schussele]

Hi Vogra,

I agree w/Clay for the most part.
In a *true* Active/Standby cluster where one is just waiting to be failed over to, we move the binaries & config files over with the data. For many reasons - Oracle licensing being just one - it's better to have the binaries on ONLY one system.

Now, on Active/Active clusters, of course, you MUST have the binaries on BOTH systems. In these cases they MUST be using different data sources UNLESS one is STRICTLY in read-only mode & will NOT be writing to the data AT ALL. You must not have both systems writing to the same data area or you'll have nothing but trouble - guaranteed. But if they write to different DBs, then you'll be OK.

My 2 cents,
Jeff

[subhashpakhare]

Dear Vogra
Could you please share you configuration details with me.I also wanted to configure cluster useing ds2300 with rp2405 servers.
Please could you send your configuration & how you mirrored in ds2300.

Regards
SP

[Vogra]

Dear subhashpakhare,
I was in vacation...
Well, the doubt I posted here don't exist anymore.
My configuration is:
We have 45 licenses of Baan and to user Baan in cluster we would have to have 100 licenses...
finaly we have oracle installed on both of servers and Baan too (system disks).
The cluster is active/passive.
The database (datafiles) are on the disk array (DS2300).
If you want the config of cluster (or packages), please post one reply.

Vogra.