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

    AIK - "Relocate alephe directory - error 'drop user' " with TWO_TASK

    • Article Type: General
    • Product: Aleph
    • Product Version: 21

    Problem Symptoms:
    Error running AIK step 5.5 "Relocate alephe directory" with TWO_TASK:

    Failed during alephe relocation - drop user

    Cause:
    Defective tnsnames.ora entry; Oracle listener not connected.

    Resolution:
    Correct $ORACLE_HOME/network/admin/tnsnames.ora entry; connect listener.

    In TWO_TASK, the application server $ORACLE_HOME/network/admin/tnsnames.ora needs to match the "service_names" parameter found in Oracle on the DB server, as described in Article 000036064 (KB 16384-61809) ("Connection to the database aleph21 via listener hasn't been established yet").

    Additional Information

    Article link:  Connection to the database aleph21 via listener hasn't been established yet"

    See also, Article 000044596 (KB 16384-33490) {"Oracle on separate server (TWO_TASK environment)"}, with a reference to the Aleph 20 System Administration Guide:
    "... the parameter which specifies the database server is ORA_HOST in $alephe_root/aleph_start -- but the $ORACLE_HOME/network/admin/tnsnames.ora also needs to match."

    In this specific case, /exlibris/app/oracle/product/11r2/network/admin/tnsnames.ora had:

    .aleph21=(description=
    (address=
    (protocol=ipc)
    (key=aleph21))
    (address=
    (protocol=tcp)
    (host=)
    (port=1521))
    (connect_data=(service_name=aleph21.)(server=DEDICATED)))

    The ".aleph21" was incorrect.... Erroneous initial "." . Also, "service_name=aleph21." There should be no terminal period.

    AIK (Aleph Installation Kit), Appendix F, is related to this topic.

    Category: Installations & Upgrades

    Subject: AIK


    • Article last edited: 11/20/2013