Installing second oracle on same host

[former_member184628]

Hi All,

We already have one Netweaver Installed with oracle as a database. Now want to install IDES server with independent Oracle Database on windows.

Can any one guide me in installing second Oracle.

Thanks in advance.

Sharib

[Former Member · Accepted solution]

Hi Sharib,

Just make the different envoirnment as per the <SID>.

For Example.

SID = ABC

Users:

oraabc

abcadm

SAPServiceABC

Instance Directory =D:\usr\sap\ABC

ORACLE_HOME=D:\oracle\ABC\102_64

SAPDATAHOME=D:\oracle\ABC\sapdata1, D:\oracle\ABC\sapdata<n>

All other directories will be under D:\oracle\ABC

set the ORACLE_HOME and ORACLE_SID in oraabc users environment settings

SID = XYZ

Users:

oraxyz

xyzadm

SAPServiceXYZ

Instance Directory =D:\usr\sap\XYZ

ORACLE_HOME=D:\oracle\XYZ\102_64

SAPDATAHOME=D:\oracle\XYZ\sapdata1, D:\oracle\XYZ\sapdata<n>

All other directories will be under D:\oracle\XYZ

set the ORACLE_HOME and ORACLE_SID in oraxyz users environment settings.

In short make the same Directory structure and User environment with different SID.

You can also keep the second instance on another drive, for example E:

Its depend on available partitions and their free space.

Regards.

Rajesh Narkhede

Edited by: Rajesh Narkhede on Apr 26, 2010 2:04 PM

[former_member184628 · Accepted solution]

Hi Rajesh,

Do i need to create these things manually or it will be created automatically while installing oracle (with new SID).

Thanks,

Sharib

[former_member227283 · Accepted solution]

Hi,

Everything will be automatic .

Thanks

Anil

[Former Member · Accepted solution]

Hi Sharib,

Do i need to create these things manually or it will be created automatically while installing oracle (with new SID).

I would recommend to create users manually and asign the Administrative rights.. Also manually add the profile parameters (ORACLE_HOME and ORACLE_SID) for ora<sid> user.

Rest of the things will be managed by SAP Installer, once you give NEW SID.

Regards.

Rajesh Narkhede

[kishore_soma · Accepted solution]

Hi,

If you want to install 2 oracle instances iin one system , then please do follow the below note - 350251 - Creating a New or 2nd Oracle SID with runInstaller

Regards,

Kishore S

[former_member184628]

Thanks you all.

The installation was successfull.

regards,

Sharib

[former_member227283]

Hi Sharib,

SAP installation differ on SID and instance no .

So when you install new instance , give a sid and instance different from the existing SAP instance.

Thanks

Anil

[former_member184628]

Hello Anil,

What precautions i need to take before installing second Oracle.

Definitely i have to provide new SID, but is there any specific note that i need to follow.

Thanks and regards,

Sharib

[Former Member]

Dear Sharib,

Kindly look at following points before installatiing second oracle .

1- SID must be different

2- There should be proper space avaiable

3-DB growth of the existing system and size of the new system .

Thanks and Regards,

Arun Kumar