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:
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:

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: localhost
<IP of the host> TELPRI-CCAnalyser

The listener.ora has the following entry:

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

SID_LIST_<my listener name> =
(SID_NAME = <My oracle SID>)

The tnsnames.ora has the following entry:

(ADDRESS = (PROTOCOL = TCP)(HOST =<my ip address>)(PORT =<my port number>))
(SERVICE_NAME = <my sid>)
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