Two Oracle Instances

[Former Member]

Hi,

We had a SAP Netweaver engine (ABAP stack) installed with Oracle 9i in a server. We wanted to install XI instance in the same machine. So we installed the XI instance with a new Oracle 10g database. Now, we are not able to start the old Oracle server. However we are able to start and stop the new Oracle database.

Can multiple Oracle instances can be installed in the same machine?

Regards,

Venkat

[former_member433984 · Accepted solution]

Hi,

yes, they can.

But you have to take care about environment variables.

You have to move Oracle related from system environment variable %PATH% into the %PATH% of corresponding SAP (<sid>adm) user for corresponding Oracle.

Sample:

System Path: ...c:\windows\system32... %OHOME10%\bin;%OHOME9%\bin....

Correct:

System Path: ...c:\windows\system32... - nothing related to %ORACLE_HOME% here

<sid1>adm Path: ... %OHOME10%\bin... etc

<sid2>adm Path: ... %OHOME9%\bin... etc

Then login under <sid1>adm or <sid2>adm correspondingly and make your admin activities.

-

---

see also, parts "Multiple Oracle Homes", "Setting Up Multiple Homes" in "SAP NetWeaver 7.0 SR2 ABAP on Windows: Oracle" installation guide

best regards

[Former Member · Accepted solution]

and you have to choose different tcp/ip port numbers for the listeners!!!

or just read carefully the chapter

Multiple Oracle Homes

in the SAP/Windows/Oracle installation manual.

regards

Peter

[Former Member · Accepted solution]

Hi,

Thank you sooo much. It worked straight away.

Excellent point.

Regards,

Venkat