Hello Folks - We have an oracle rac instance (sid test1 and sid test2 ) with service name of test. My question is in our ars.cfg we have the instance name as test. When the arssockd daemon starts does it actually go off the tnsnames in the ARS_ORACLE_HOME ? I am trying to figure out this because when we execute our arsload, I have seen it go to both the rac instances? So I am trying to understand how ars resolves the instance name in oracle RAC? I am guessing it is using the service name in tnsnames?
Thanks
Siva
Quote from: kbsiva on July 27, 2012, 03:53:24 PM
Hello Folks - We have an oracle rac instance (sid test1 and sid test2 ) with service name of test. My question is in our ars.cfg we have the instance name as test. When the arssockd daemon starts does it actually go off the tnsnames in the ARS_ORACLE_HOME ? I am trying to figure out this because when we execute our arsload, I have seen it go to both the rac instances? So I am trying to understand how ars resolves the instance name in oracle RAC? I am guessing it is using the service name in tnsnames?
Thanks
Siva
Hello Siva,
I have experience with Oracle and CMOD, but I'm a newbie in Oracle (read, I'm not a Oracle DBA).
In order to have CMOD and Oracle configured, you need to have the following:
ars.ini
====
SRVR_INSTANCE_OWNER -> unix user which will need to administer the CMOD instance
SRVR_INSTANCE -> The TNSNAMES that you will use (short name ARCHIVE instead of ARCHIVE.world)
This will be used everywhere in CMOD to defined where the documents ars saved in TSM/Cache/etc... So be careful to choose the same SID as the TNSNAMES (it is possible to have different name, but then you need to be careful for the confusions)
ars.cfg
=====
ARS_DB_ENGINE=ORACLE -> Tell CMOD to use Oracle instead of DB2
ARS_ORACLE_HOME -> same as your ORACLE_HOME variable
ARS_ORACLE_USER -> login for the Oracle Schema user
ARS_ORACLE_USERID -> Password for the Oracle Schema user
That's it, you must not set the ARS_DB2_* variables, you can, but they will be ignored.
You might want to setup the following variable in ars.cfg ARS_DB_TABLESPACE to the tablespace where you want that the OnDemand ARS% table will be created. Otherwise it will be the default one.
I don't know if I'm answering your question... but that's what I've found during the last few years on how to make CMOD work with Oracle with a very limited knowledge of Oracle :-D
Sincerely yours,
Alessandro
hi Alessandro,
Thanks , I have it set up and working. I need this info in order to test load balancing and fail over capabilities. Basically I was trying to figure out how cmod is resolving the oracle instance names for example if I have TEST in ars.ini and my ars process is running as TEST and when it connects to Oracle using the tnsnames in the ARS_ORCLE_HOME, will it be able to fail over if one instance goes down say (SID) TEST1 is down and (SID) TEST2 is up? Usually all applications using OCI and tnsnames will be able to load balance as long as tnsnmaes has the entry for the addresses(TEST1,TEST2) against service name TEST. Just not sure how CMOD works. I will try to test this out and post here provided DBA's are cooperating ...)
Thanks,
Siva
Hi,
To any body trying to do a load balancing and fail over in CMOD with Oracle. The solution to go will be HACMP. I have tried to use tns entries in the oracle home to do load balancing and the arssockd kind of makes connections and goes to different nodes (or SID in oracle) but as soon as one of the nodes goes down , these connections become stale. So the IBM recommended way is to go with HACMP. There is a white paper with how it is done with DB2 just google it.
Thanks
Siva
Siva...
Can you link to that article, or even upload it here? Google can be fickle depending on where you are in the world...
Thx.
-JD.
Hello Justin,
Here you go,
http://www.ibm.com/developerworks/data/library/techarticle/dm-0407vanwinkle/index.html