Here is the solution, try it
http://www.experts-exchang
Main Topics
Browse All TopicsSubject: 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.c
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>)
)
)
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.

Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Here is the solution, try it
http://www.experts-exchang
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---
or
at DOS prompt using echo
if not set then set it
C:\>set ORACLE_SID=<oracleSID>
C:\>sqlplus
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
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?
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>
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.
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.
Business Accounts
Answer for Membership
by: sonicefuPosted on 2008-01-30 at 08:08:57ID: 20778123
are you able to ping
ping <my ip address>
---------------------
tnsping GENODS