ORA-12154: TNS:could not resolve the connect identifier specified
- Article Type: General
- Product: Aleph
- Product Version: 20
Problem Symptoms:
* ARC ETL fails since Aleph 20 upgrade
The log files contains the following error :
Error found in log file: ORA-12154: TNS:could not resolve the connect identifier specified
* $aleph_proc/p_arc_01_test gives the following error
*********
ARC_VERSION = 2.0
Now checking license permission
There is a valid ARC license
Now testing Oracle connection with ARC DB
Testing TWO_TASK connection to arc.ar2:
ORA-12154: TNS:could not resolve the connect identifier specified
ORA-12154: TNS:could not resolve the connect identifier specified
Could not connect to ARC_ADMIN (ARC_ADMIN)
**** Aborting ****
Cause:
This is happening because file tnsnames.ora is missing reference to arc.arc2
Resolution:
The ARC_TWO_TASK variable set in ./xxx50/prof_library must have a matching entry in /exlibris/app/oracle/product/11/network/admin/tnsnames.ora.
Additional Information
Example
./xxx50/prof_library:
setenv ARC_TWO_TASK arc.arc2
/exlibris/app/oracle/product/11/network/admin/tnsnames.ora:
arc.arc2=(description=
(address=
(protocol=ipc)
(key=arc2))
(address=
(protocol=tcp)
(host=arc)
(port=1521))
(connect_data=(service_name=arc2.arc.server.com)(server=DEDICATED)))
Results of $aleph_proc/p_arc_01_test for checking the correct setup:
*********
ARC_VERSION = 2.0
Now checking license permission
There is a valid ARC license
Now testing Oracle connection with ARC DB
Testing TWO_TASK connection to arc.arc2 :
ARC_ADMIN connection OK
arc_user (XXXR0) connection OK
creating/altering ALEPH user on ARC DB...
User altered.
Checking user ALEPH on ARC DB...
ALEPH connection OK
Connection test: PASSED
***********************
- Article last edited: 10/8/2013