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

Problem Symptoms:
Executing step 3.4 of ikit_menu script it displays these error messages:
idle> ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
idle> idle> SP2-0640: Not connected
idle> SP2-0640: Not connected
idle> idle> idle> select * from v$version;
SP2-0640: Not connected
idle> /
SP2-0640: Not connected
idle> spool off

Cause:
The table listener.ora in $ORACLE_HOME/network/admin contains wrong definitions.

Resolution:
The listener.ora now contains:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = server_name)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = REGISTER))
)
)


sid_list_listener=(sid_list=
(sid_desc=
(global_name=server_name)
(sid_name=aleph21)
(oracle_home=/exlibris/app/oracle/product/11r2)
)
)
SECURE_REGISTER_LISTENER = (IPC)

Category: Installation & Upgrades (500)

Subject: New Installation (500)

• Article last edited: 10/8/2013