Home » Infrastructure » Windows » ORA-12560: TNS:protocol adapter error
ORA-12560: TNS:protocol adapter error [message #223981] Mon, 12 March 2007 09:16 Go to next message
ddkdhar
Messages: 68
Registered: February 2007
Member

my isqlplus running properly whereas command prompt sqlplus showing error like this
SQL> conn scott/tiger
ERROR:
ORA-12560: TNS:protocol adapter error


SQL> conn scott/tiger@oracle
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified

but isqlplus running properly
i can able to login in isqlplus

my databae
Personal Oracle Database 10g Release 10.1.0.2.0 - Production
PL/SQL Release 10.1.0.2.0 - Production
CORE 10.1.0.2.0 Production
TNS for 32-bit Windows: Version 10.1.0.2.0 - Production
NLSRTL Version 10.1.0.2.0 - Production

operating system is windows xp sp2
thanks in advance

[Updated on: Mon, 12 March 2007 09:19]

Report message to a moderator

Re: ORA-12560: TNS:protocol adapter error [message #224015 is a reply to message #223981] Mon, 12 March 2007 11:21 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
SQL> conn scott/tiger
ERROR:
ORA-12560: TNS:protocol adapter error


possible you have more than one database on your machine.

and isqlplus connect with different machine. becuase most possible clause of above error is DATABASE SERVICES IS NOT START.

you should start first database services and try to connect.


ORA-12154: TNS:could not resolve the connect identifier specified

lsnrctl status ... you database service_names is register..
and point to right services names.

also post your
lsnrctl status
or
tnsnames.ora file

regards
Taj
Re: ORA-12560: TNS:protocol adapter error [message #224020 is a reply to message #223981] Mon, 12 March 2007 12:07 Go to previous messageGo to next message
ddkdhar
Messages: 68
Registered: February 2007
Member

lsnr after start

LSNRCTL> start
Starting tnslsnr: please wait...

Service OracleOraDb10g_home4TNSListener already running.
TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error
32-bit Windows Error: 1056: Unknown error

LSNRCTL> services
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=karimojj-c876e5)(PORT=15
21)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "oracle" has 1 instance(s).
Instance "oracle", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:32 refused:0 state:ready
LOCAL SERVER
Service "oracleXDB" has 1 instance(s).
Instance "oracle", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1002 state:ready
DISPATCHER <machine: KARIMOJJ-C876E5, pid: 2356>
(ADDRESS=(PROTOCOL=tcp)(HOST=karimojj-c876e5)(PORT=1035))
The command completed successfully



  • Attachment: listener.log
    (Size: 459.11KB, Downloaded 2055 times)
Re: ORA-12560: TNS:protocol adapter error [message #224021 is a reply to message #223981] Mon, 12 March 2007 12:08 Go to previous messageGo to next message
ddkdhar
Messages: 68
Registered: February 2007
Member

tnsnames.ora file attached
  • Attachment: tnsnames.ora
    (Size: 0.33KB, Downloaded 2896 times)
Re: ORA-12560: TNS:protocol adapter error [message #224027 is a reply to message #223981] Mon, 12 March 2007 12:47 Go to previous messageGo to next message
ddkdhar
Messages: 68
Registered: February 2007
Member

i want to install sql * loader . From the oracle documents i have read that companion products to be installed to run case studies. but this companion installation asking about html db password. what is the procedure for this companion and sql * loader ulcase
case study files
Re: ORA-12560: TNS:protocol adapter error [message #224080 is a reply to message #224027] Mon, 12 March 2007 23:13 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

In your tnsnames.ora file not content any entry for ORCL database.
you have two database in your machine.
1.oracle
2.orcl

1.oracle is open and running fine.
but you should first check ORCL SERVICES and i edit your tnsnames.ora file for orcl database.
# tnsnames.ora Network Configuration File: G:\oracle\product\10.1.0\db_4\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORACLE =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.60.87)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = oracle)
    )
  )

ORCL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.60.87)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl)
    )
  )





and sql*loader is install during oracle software installation time.


regards
Taj
  • Attachment: tnsnames.ora
    (Size: 0.52KB, Downloaded 1792 times)

[Updated on: Mon, 12 March 2007 23:14]

Report message to a moderator

Re: ORA-12560: TNS:protocol adapter error [message #224178 is a reply to message #223981] Tue, 13 March 2007 06:26 Go to previous messageGo to next message
ddkdhar
Messages: 68
Registered: February 2007
Member

what about ulcase files these are not in my rdbms/demo folder
thank you very much
Re: ORA-12560: TNS:protocol adapter error [message #224181 is a reply to message #224178] Tue, 13 March 2007 06:34 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Don't believe the ulcase file is available on Windows.
Re: ORA-12560: TNS:protocol adapter error [message #224184 is a reply to message #223981] Tue, 13 March 2007 06:37 Go to previous messageGo to next message
ddkdhar
Messages: 68
Registered: February 2007
Member

i already deleted my database orcl now i have only one database that is oracle .
now these are the listener servies output

LSNRCTL> services
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=karimojj-c876e5)(PORT=15
21)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "oracle" has 1 instance(s).
Instance "oracle", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:67 refused:0 state:ready
LOCAL SERVER
Service "oracleXDB" has 1 instance(s).
Instance "oracle", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1002 state:ready
DISPATCHER <machine: KARIMOJJ-C876E5, pid: 2336>
(ADDRESS=(PROTOCOL=tcp)(HOST=karimojj-c876e5)(PORT=1035))
The command completed successfully



----------------------------------------------------

LSNRCTL> start
Starting tnslsnr: please wait...

Service OracleOraDb10g_home4TNSListener already running.
TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error
32-bit Windows Error: 1056: Unknown error
-----------------------------------------------------------
LSNRCTL> version
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=karimojj-c876e5)(PORT=15
21)))
(SERVICE=(SERVICE_NAME=PLSExtProc)(INSTANCE=(INSTANCE_NAME=PLSExtProc)(NUM=1)(IN
STANCE_STATUS=UNKNOWN)(HANDLER=(HANDLER_DISPLAY=DEDICATED SERVER)(HANDLER_INFO=L
OCAL SERVER)(HANDLER_MAXLOAD=0)(HANDLER_LOAD=0)(ESTABLISHED=0)(REFUSED=0)(HANDLE
R_ID=57CDADD4D83B-4469-AF3F-526804B4C8E8)(PRE=any)(HANDLER_NAME=DEDICATED)(SESSI
ON=NS)(ADDRESS=(PROTOCOL=beq)(PROGRAM=extproc)(ENVS='ORACLE_HOME=G:\oracle\produ
ct\10.1.0\db_4,ORACLE_SID=PLSExtProc')(ARGV0=extprocPLSExtProc)(ARGS='(LOCAL=NO)
')))(NUMREL=1)))
The command completed successfully
------------------------------------------------------------------
LSNRCTL> reload
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=karimojj-c876e5)(PORT=15
21)))
The command completed successfully
-----------------------------------------------------------------
following tnsnames.ora attached
  • Attachment: tnsnames.ora
    (Size: 0.33KB, Downloaded 1934 times)
Re: ORA-12560: TNS:protocol adapter error [message #224185 is a reply to message #223981] Tue, 13 March 2007 06:38 Go to previous messageGo to next message
ddkdhar
Messages: 68
Registered: February 2007
Member

No Message Body
  • Attachment: sqlnet.ora
    (Size: 0.23KB, Downloaded 2293 times)
Re: ORA-12560: TNS:protocol adapter error [message #224187 is a reply to message #223981] Tue, 13 March 2007 06:39 Go to previous message
ddkdhar
Messages: 68
Registered: February 2007
Member

No Message Body
  • Attachment: listener.ora
    (Size: 0.65KB, Downloaded 2532 times)
Previous Topic: Plz help me
Next Topic: TNSPING nor working
Goto Forum:
  


Current Time: Thu Mar 28 14:22:06 CDT 2024