Two SAP Systems in MSCS Oracle

[Former Member]

Hi,

I would like to install two systems in MSCS Oracle with two nodes. In the first node I'll install a PI, and in the other one SAP Portal. My question is :

How many Oracle Database Engine should I install ? Or I should install one Oracle Database Engine with two oracle instance ?

Thank's in advanced

Francesc

[Former Member · Accepted solution]

I think you mean: How many oracle_home / oracle-binaries are required.

You can install:

- 1 oracle-homes with 2 database

- 2 oracle-homes with 2 database

1 oracle-homes with 2 database

The 2 databases are not completly idependent because they share 1 oracle-home. if you want to update oracle you need to update both databases at the same time.

2 oracle-homes with 2 database

The database are completly idependent. You can update both db's separately.

[Former Member · Accepted solution]

Hi Thomas,

Would appreciate if you clarify following on Windows Server 2003 - Oracle 10g.

1 oracle-homes with 2 database

The 2 databases are not completly idependent because they share 1 oracle-home. if you want to update oracle you need to update both databases at the same time.

What are the points which needs to be taken care before using this option. During installation it prompts for Listener name and port - so should we use the same as used in first SAP instance.

2 oracle-homes with 2 database

The database are completly idependent. You can update both db's separately

Is there any pre and post installation steps before installation of second instance. In this case, listener would also be independent. And owner of SAP instance can start its own SAP instance.

Thanks

Davinder