cancel
Showing results for 
Search instead for 
Did you mean: 

two oracle on one host

Former Member
0 Kudos

Dear Friends,

I have installed oracle and SAP which is working fine.now i have requirement where i have to install another database with smsaproper and smsaproperadm user database on one host. on second database sap is not installed. It is used for some other purpose ie for disaater recovery. First database is used for SAP and second one is used for non-sap.

Please suggest how to proceed with this.

Thanks in advance.

Regards

Jiggi

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

HI,

Sure you can use 2 oracle database instance on single host...

The things you need to take care of are :

1. Use different ORACLE_HOME for each instance.

2. Use different DBSID for each instance.

3. Use different LISTENER and PORT for each listener.

With above different you can use 2 database instance on single host with any problem...

I hope, you have sufficient space and memory for above requirement.

Regards.

Rajesh Narkhede

Former Member
0 Kudos

With a slight modification ... U donot need two separate listeners to support two databases on the same host.

You can very well have one listener control catering to both the databases.

Here are some tips ....

Say ur sap sid is S1 so u r having two OS id oras1 and s1adm with proper env settings.

For the non sap application say instance name is APP1

so u shud have oraapp1 Operating system user with proper env settings like

ORACLE_HOME= /oracle/APP1/10_2....

LIBPATH/LD_LIBRARY_PATH=$ORACLE_HOME/lib

ORACLE_SID=APP1

The path variable under this user ie(oraapp1) should not have any entry pointing to the ORACLE_HOME of SAP application.

As I said one listener is good enough to cater both the databases you just need to open up the listener file ie listener.ora under $ORACLE_HOME/network/admin (this oracle home can be of ur sap appliaction or ur APP1 home depending upon which listener u wish to make use of )If u wish to have app1 listener catering both app1 and sap DB then add entry for sap DB in the listener.ora of APP1 database or vice versa.

Any problem with this ,do write back.

Regards

Kausik

Former Member
0 Kudos

Dear Kaushik,

thanks for your reply.

I have installed 2nd instance with the oracle home where first instance is installed.

after that have installed listener for the 2nd instance.

now, both the listener services are working. but am not able to connect to 2nd instance.

is it possible to start oracle with 2nd listener.

and please suggest how to login to 2nd instance.

thanks in advance.

Regards,

jiggi

Former Member
0 Kudos

The following information are required

1. what does the following command shows

lsnrctl stat

2. echo $ORACLE_SID

echo $ORACLE_HOME

echo $TNS_ADMIN

3. Paste here the contents of the listerner.ora file under $ORACLE_HOME/network/admin

Regards

Kausik

Former Member
0 Kudos

Hello ,

you can very well install in a different oralce home directory.

Former Member
0 Kudos

Yes you can have easliy.. as there is no issue and you will be having 2 Oracle Homes. Even I had the same kind of situtaion where 2 Diff SAP were installed on Single Host.

SAPSID CUP

Oracle 9i

SAP 46c

SAPSID ADD

Oracle9i

SAP4.7

And we upgraded 46c system to ECC6 and Oracle to 10g. So no issue....