OraFAQ Forum: Windows » ORA-12560: TNS:protocol adapter error

Home » Infrastructure » Windows » ORA-12560: TNS:protocol adapter error

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-12560: TNS:protocol adapter error [message #223981]

Mon, 12 March 2007 09:16

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

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

Report message to a moderator

Re: ORA-12560: TNS:protocol adapter error [message #224020 is a reply to message #223981]

Mon, 12 March 2007 12:07

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 2373 times)

Report message to a moderator

Re: ORA-12560: TNS:protocol adapter error [message #224021 is a reply to message #223981]

Mon, 12 March 2007 12:08

ddkdhar
Messages: 68
Registered: February 2007

Member

tnsnames.ora file attached

Attachment: tnsnames.ora
(Size: 0.33KB, Downloaded 3198 times)

Report message to a moderator

Re: ORA-12560: TNS:protocol adapter error [message #224027 is a reply to message #223981]

Mon, 12 March 2007 12:47

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

Report message to a moderator

Re: ORA-12560: TNS:protocol adapter error [message #224080 is a reply to message #224027]

Mon, 12 March 2007 23:13

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

ddkdhar
Messages: 68
Registered: February 2007

Member

what about ulcase files these are not in my rdbms/demo folder
thank you very much

Report message to a moderator

Re: ORA-12560: TNS:protocol adapter error [message #224181 is a reply to message #224178]

Tue, 13 March 2007 06:34

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Don't believe the ulcase file is available on Windows.

Report message to a moderator

Re: ORA-12560: TNS:protocol adapter error [message #224184 is a reply to message #223981]

Tue, 13 March 2007 06:37

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