Here are a couple of thoughts:
- path variables point to incorrect Oracle client
Add an environment variable on your machine:
ORACLE_HOME=C:\app\oracle\product\11.2.0\dbhome_1
- tnsnames.ora does not exist or has incorrect connection details
Add an environment variable:
TNS_ADMIN=C:\app\oracle\product\11.2.0\dbhome_1\network\admin
The Oracle modules will use the 2 environment variables to find the libraries
and tnsnames.ora file.
I notice in your TNSNAMES you have 2 ORCL entries. I would change one to
ORCL.EXTRA (as you really shouldn't have 2 entries with the same name). I have
found it best to use an entry with the same name as the database (something
like the following).
MYDATA =
(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST =
127.0.0.1)(PORT = 1521)) )
(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = mydata) )
)
Fred
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Kathy Morris
Sent: Monday, March 07, 2011 12:01 PM
To: arslist@ARSLIST.ORG
Subject: Re: Oracle 11G and AR 7.6.04 64Bit Install issues
**
Also - during the install I noticed the system does not proceed when the
message below is on the screen.
arserver.validation.dbauser.input.validateCLIclientlibrary
-----Original Message-----
In a message dated 3/7/2011 3:01:42 A.M. Eastern Standard Time,
t...@remex.co.za writes:
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 ....
-----Original Message-----
From: Kathy Morris
Sent: Friday, March 04, 2011 10:53 AM
Newsgroups: public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
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) ]
)
)
