That depends on your ARS Server platform. If you are on UNIX, modify the .profile of the user that runs the AR System services to point to the 9 libraries and not 10 after you install your 9 client. This would mean you would need to change the ORACLE_HOME settings essentially. Ask your DBA about any other variables that you might need, to connect 9 clients to the 10 server. I think your TWO_TASK and ORACLE_SID should be the same irrespective so no changes may be required for these two variables.
I am not sure what you do on Windows, but I guess it might have to modify the PATH in the environment to point to the right Oracle client. Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Sharma, Tarun Sent: Thursday, August 23, 2007 1:14 PM To: [email protected] Subject: Re: URGENT:Upgraded Oracle 10g on server but not able to start server. ** Hello, Can you please explain a bit more what should I do to use 9 libraries and not 10. Can you specify some exact steps? We have both kind of environment ARS and DB on same server, ARS and DB on different server. Do we require any cursor_sharing settings as FALSE also. Regards, Tarun ---------------------------------------------------------------------------- -- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Thursday, August 23, 2007 10:30 PM To: [email protected] Subject: Re: URGENT:Upgraded Oracle 10g on server but not able to start server. Install in a separate directory and change your environment to have the ARS use the 9 libraries and not 10 Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Sharma, Tarun Sent: Thursday, August 23, 2007 12:52 PM To: [email protected] Subject: Re: URGENT:Upgraded Oracle 10g on server but not able to start server. Importance: High ** Hello, But where we should install Oracle Client 9. I think it should be in directory 10.2.0 Do we need to set Dbhome directory path as 10.2.0 or 9.2.0 ? I think it should be 10.2.0 because in my ORACLE HOME it is 10.2.0 Regards, Tarun ---------------------------------------------------------------------------- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mahesh Patil Sent: Thursday, August 23, 2007 9:31 PM To: [email protected] Subject: Re: URGENT:Upgraded Oracle 10g on server but not able to start server. ** Yes Tarun, You are right. ARS 6.3 needs Oracle 9i client . Rgds, Mahesh "Sharma, Tarun" <[EMAIL PROTECTED]> wrote: ** Patrick, We are on ARS 6.3, SunOS 5.9, Remote Database. And I think our admin installed Oracle client 10 and remedy will need Oracle Client 9. Regards, Tarun ---------------------------------------------------------------------------- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of patrick zandi Sent: Thursday, August 23, 2007 9:16 PM To: [email protected] Subject: Re: URGENT:Upgraded Oracle 10g on server but not able to start server. ** I am using 10i client with ars server.. Also what version are you installing of ARS ? What OS are you running ? is the database local or remote ? Which Oracle Client do you have installed? Just ot help us all out.. On 8/23/07, Sharma, Tarun <[EMAIL PROTECTED]> wrote: ** Hello, We have upgraded from Oracle 9.2 to Oracle 10g. But when we are staring AR Services. It is giving error as: "arserverd: fatal: libclntsh.so.9.0 : open failed: No such file or directory" though we have already changed Dbhome Directory for this server. It looks it is referring some older reference of Oracle 9. Please share if somebody has an idea why this is giving error or if any other changes are required at remedy end. Regards, Tarun __20060125_______________________This posting was submitted with HTML in it___ This message contains information that may be privileged or confidential and is the property of the Capgemini Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, you are not authorized to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message. __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
