[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 21763
  • Last Modified:

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>)
)
)
0
LindaC
Asked:
LindaC
  • 6
  • 5
  • 4
1 Solution
 
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 new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
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

Featured Post

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

  • 6
  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now