I am trying to start listener on NT for the newly installed 8.1.5. I get the following error:
TNS-12560: TNS Protocol adaptor error
TNS-00530: Protocol adaptor error
someone please tell me what exactly is the problem.
Thanks
Shobha
Printable View
I am trying to start listener on NT for the newly installed 8.1.5. I get the following error:
TNS-12560: TNS Protocol adaptor error
TNS-00530: Protocol adaptor error
someone please tell me what exactly is the problem.
Thanks
Shobha
Could you post your listener.ora file thats in /O_H/net80/admin location ? with your host/machin name and database name thats currently running on the host.
I am pasting here the contents of Listener.ora. Machine name is shobha and the database running at the time is Oracle8.
Thanks
shobha
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = SHOBHA)(PORT = 1521))
(PROTOCOL_STACK =
(PRESENTATION = TTC)
(SESSION = NS)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = Oracle8.WORLD)
(ORACLE_HOME = d:\oracle\ora81)
(SID_NAME = oracle8)
)
)
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = SHOBHA)(PORT = 1521))
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = Oracle8.WORLD)
(ORACLE_HOME = d:\oracle\ora81)
(SID_NAME = oracle8)
)
)
Sorry, even this doesn't work and I get the same error.
Try with the following this is my server listener.ora. I modified it for you.
# LISTENER.ORA Network Configuration File: E:\Oracle\Ora816\network\admin\listener.ora
# Generated by Oracle configuration tools.
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 60
TRACE_LEVEL_LISTENER = OFF
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = shobha)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = oracle8.world)
(ORACLE_HOME = d:\oracle\ora81)
(SID_NAME = oracle8)
)
)
If it doesn't work you have to troubleshoot swtiching on tracing.