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