troubleshooting Question

TNS-12560: TNS:protocol adapter error and TNS-00530: Protocol adapter error in lsnrctl start

Avatar of LindaC
LindaCFlag for Puerto Rico asked on
Oracle Database
15 Comments1 Solution27855 ViewsLast Modified:
Subject: Create db 11g now creating and starting listener give tns-12560

RDBMS Version: 11.1.0.6
Operating System and Version: Windows 2003
Error Number (if applicable): TNS-12560 and TNS-00530
Product (i.e. SQL*Loader, Import, etc.): LSNRCTL
Product Version: 11.1.0.6

Create db 11g now creating and starting listener give tns-12560

Creating the listener in 11g gave the following error:

Copyright (c) 1991, 2007, Oracle. All rights reserved.

Starting tnslsnr: please wait...

TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error

The host file has the following:

127.0.0.1 localhost
<IP of the host> TELPRI-CCAnalyser TELPRI-CCAnalyser.telpri.com

The listener.ora has the following entry:

<my listener name> =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = <Ip of the host>)(PORT=<my port>))
)
)
)

SID_LIST_<my listener name> =
(SID_LIST =
(SID_DESC =
(SID_NAME = <My oracle SID>)
(ORACLE_HOME =<My %ORACLE_HOME%)
)
)

The tnsnames.ora has the following entry:

GENODS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =<my ip address>)(PORT =<my port number>))
)
(CONNECT_DATA =
(SERVICE_NAME = <my sid>)
)
)
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 15 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 15 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros