Kathy, I did an ARS install on a RHEL5.5/Oracle 11g 64bit VM a couple of weeks ago for some research, also ran into a connection issue during the install. Whilst looking through the installer logs, it seemed that the BMC installer gets confused between using either the Service Name or the SID string as SID to connect to Oracle... and since the default install of Oracle sets different values for these, this error comes up...
Since I'm not an Oracle dba and did not have more time available to battle with a "research installation", I had to abandon the install at that point. HTH. Best Regards, Theo Sent from my Black/Silver Personal Computer .... From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Joe Martin D'Souza Sent: 04 March 2011 08:47 PM To: [email protected] Subject: Re: Oracle 11G and AR 7.6.04 64Bit Install issues ** That should be the 64 bit client then.. do you also have a 32 bit client which may be in your PATH? Joe From: Kathy Morris<mailto:[email protected]> Sent: Friday, March 04, 2011 1:24 PM Newsgroups: public.remedy.arsystem.general To: [email protected]<mailto:[email protected]> Subject: Re: Oracle 11G and AR 7.6.04 64Bit Install issues ** What I was stating in my email is how do I determine if I have the required 64 or not. I know the client libraries are required - that does not need to be determined. I installed the full package of the 64-Oracle11g which installed the clients. Thanks. In a message dated 3/4/2011 1:19:47 P.M. Eastern Standard Time, [email protected] writes: ** The client libraries are required.. there is no question of having to determine whether or not they are required.. The question is whether what you have is 32 or 64 bit.. As for how to determine if they are 64 bit, if you are not sure, uninstall the current client, and reinstall the 64 bit client, and reconfigure the tnsnames.ora upon installing the 64 client. The installer for the 64 bit client is different from the 32 bit installer.. It should be available on oracle.com for download.. There is a file command in unix to determine if files are 32 or 64 bit but I’m not sure how you would do that in windows.. This article may help.. http://stackoverflow.com/questions/495244/how-can-i-test-a-windows-dll-to-determine-if-it-is-32bit-or-64bit Joe From: Kathy Morris<mailto:[email protected]> Sent: Friday, March 04, 2011 1:09 PM Newsgroups: public.remedy.arsystem.general To: [email protected]<mailto:[email protected]> Subject: Re: Oracle 11G and AR 7.6.04 64Bit Install issues ** Hi, How could I determine if the Oracle client libraries are the required? I have win64-11g release that I downloaded. I am not sure how to verify if I have the 64 client. In a message dated 3/4/2011 1:05:09 P.M. Eastern Standard Time, [email protected] writes: ** Have you checked if the Oracle client libraries are the 64 bit libraries as required? And that you are using the right client and not a 32 bit client if that is installed too?? Your path does not look like what I think the default paths for the oracle client installs look like so its hard to say if it may be a 64 bit client.. Joe From: Kathy Morris<mailto:[email protected]> Sent: Friday, March 04, 2011 10:53 AM Newsgroups: public.remedy.arsystem.general To: [email protected]<mailto:[email protected]> Subject: Oracle 11G and AR 7.6.04 64Bit Install issues ** Hi, Can someone tell me how to get Oracle 11g to work/install with AR 7.6.04?. I have a 64-bit laptop. I installed 11g Oracle on Windows 7. I am trying to install AR 7.6.04 on Oracle 11g. During the AR install, I selected 64 bit. I am getting error messages and cannot proceed with the installation of AR System. The database seems to be running successfully. During the install when I connect to the database using DBMS account, I get a warning message that says: Possible causes - path variables point to incorrect Oracle client - tnsnames.ora does not exist or has incorrect connection details - missing 64 bit oracle client libraries My system path is: C:\app\oracle\product\11.2.0\dbhome_1\bin;C:\app\oracle\product\11.2.0\dbhome_1\lib; My tnsnames.ora displays: ORCL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl.Servername) ) ) ORCL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.x.x)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl.Servername) (SID = orcl) [ (GLOBAL_NAME=DatabaseName) ] ) ) _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_
