Skip to main content
ExLibris
  • Subscribe by RSS
    • Back
    Aleph
    Ex Libris Knowledge Center

    ORA-12154: TNS:could not resolve the connect identifier specified

    1. Last updated
    2. Save as PDF
    • 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