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

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>)
)
)
LVL 8
LindaCAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

sonicefuCommented:
are you able to ping

ping <my ip address>

---------------------
tnsping GENODS
0
sonicefuCommented:
0
LindaCAuthor Commented:
The ping gave the three replies.
The tnsping failed with:  TNS-12541: TNS:no listener

The proxy is not listed on the services list.

The windows firewall is "off".

No services of any listener.
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

sonicefuCommented:
C:\>sqlplus

Probably the OracleService for the database is not running.

*)
Check if the service is running, if not, startup the service.

**)
check whether environment variables are set or not

Right click at "My Computer"--->Properties---->Advanced---->Environment Varialbes
or
at DOS prompt using echo

if not set then set it
C:\>set ORACLE_SID=<oracleSID>

C:\>sqlplus
0
sonicefuCommented:
if still not working, then rename your origional listener.ora file for example listernerOLD.ora
and save the following as listener.ora , after providing information where --<---

and then try
lsnrctl start

----------------
or paste it in the listener.ora and rename LISTENER to LISTENER_TST in the following

save file
and try

lsnrctl start  LISTENER_TST

LISTENER=
  (DESCRIPTION=
    (ADDRESS_LIST=
      (ADDRESS=(PROTOCOL=tcp)(HOST=<ip-address of server>)(PORT=1521))--<--
      (ADDRESS=(PROTOCOL=ipc)(KEY=extproc))))
SID_LIST_LISTENER=
  (SID_LIST=
    (SID_DESC=
      (GLOBAL_DBNAME=abc.domainName.com)  --<---
      (ORACLE_HOME=/oracle11g)
      (SID_NAME=abc))                     --<---
    (SID_DESC=
      (SID_NAME=plsextproc)
      (ORACLE_HOME=/oracle11g)
      (PROGRAM=extproc)))

Open in new window

0
LindaCAuthor Commented:
I have verified that the oracle sid service is up and running.  

The listener.ora was renamed to listener.ora.bak and paste your instructions but still don't work.

Do the listener need a  "service" before it can start?  just like the database that needs the creation by oradim of the service before it can start?

0
schwertnerCommented:
Have you turned on the default firewall of Windows
before installing Oracle?
Any antivirus programs?
0
schwertnerCommented:
My mistake: Should be read:
turned OFF the default firewall of Windows
0
LindaCAuthor Commented:
The Windows Firewall setting have always been "off".
0
schwertnerCommented:
There are also hidden firewalls like OfficeScanNT Personal Firewall
0
LindaCAuthor Commented:
No OfficeScanNT Personal Firewall on the server.

This error is similar as if I stop the Database service and then go by sqlplus /nolog and trying to connect to the database:

C:\Documents and Settings\Oracle>echo %ORACLE_SID%
<My SID NAME>

C:\Documents and Settings\Oracle>sqlplus /nolog

SQL*Plus: Release 11.1.0.6.0 - Production on Thu Jan 31 14:08:47 2008

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

SQL> conn /as sysdba
ERROR:
ORA-12560: TNS:protocol adapter error


SQL>
0
schwertnerCommented:
   Check if Microsoft Winsock Proxy(WSP) Client is enabled on the
    Windows NT Server, if that is the case then go to windows Control Panel,
    click WSP icon and select the disable Proxy Client option.


Another cause may be a bad LISTENER.ORA


Also try to replace the IP with Domain name or vice versa.

Finally use Net Manager and delete the old Listener. Use my old posting cited above.
Delete or disable the Listener service.
Create a new Listener.
0
schwertnerCommented:
also macAffay antivirus can cause troubles. It is very agressive.
0
LindaCAuthor Commented:
At last !

The windows system admin told me to user "Dameware Nt Utilities" to enter remotely to the server instead of using Remote Desktop, because Remote Desktop goes into the server  as "underground".  (I really did'nt understand this), but anyway I entered the Windows server with the DameWare Utility and issue the lsnrctl start <my listener name>.  At last the listener service was created and I was able to start the listener.
0
schwertnerCommented:
Never administer servers remotly, please!
Forget this comfort. I know .. U.S. is a big country,
but ....
My last guess was that you have 2 Network Cards (NIC)
and so your server is Multi Home. In this case the 2 NIC cards
make bad jokes.

Good Luck!

Joseph
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.