on 06-10-2010 3:27 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
Hello ,
you can very well install in a different oralce home directory.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.