Home » RDBMS Server » Networking and Gateways » Getting error ORA-12560: TNS:protocol adapter error (littlefoot ,last two commands)
Getting error ORA-12560: TNS:protocol adapter error [message #569621] Tue, 30 October 2012 06:54 Go to next message
ariffcal
Messages: 100
Registered: April 2011
Senior Member
Getting error ORA-12560: TNS:protocol adapter error


My database is PACKS and user ID is PACKS .


Below tnsnames.ora

# tnsnames.ora Network Configuration File: C:\DevSuiteHome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

STOREDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = mst009.stc.corp)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = storedb)
)
)

PACKS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = mst009.stc.corp)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = PACKS)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = mst009.stc.corp)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = PLSExtProc)
)
)

Re: Getting error ORA-12560: TNS:protocol adapter error [message #569625 is a reply to message #569621] Tue, 30 October 2012 07:19 Go to previous messageGo to next message
Michel Cadot
Messages: 58625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-12560: TNS:protocol adapter error
 *Cause: A generic protocol adapter error occurred.
 *Action: Check addresses used for proper protocol specification. Before
 reporting this error, look at the error stack and check for lower level
 transport errors. For further details, turn on tracing and reexecute the
 operation. Turn off tracing when the operation is complete.

Regards
Michel
Re: Getting error ORA-12560: TNS:protocol adapter error [message #569633 is a reply to message #569625] Tue, 30 October 2012 08:55 Go to previous messageGo to next message
BlackSwan
Messages: 22539
Registered: January 2009
Senior Member
>Getting error ORA-12560: TNS:protocol adapter error
ORA-12560 is common error on Windows that results from any number of different causes.
Re: Getting error ORA-12560: TNS:protocol adapter error [message #569634 is a reply to message #569621] Tue, 30 October 2012 09:47 Go to previous messageGo to next message
John Watson
Messages: 4404
Registered: January 2010
Location: Global Village
Senior Member
It's a brave man who will take on an ora-12560 on Windws. But here we go:

To begin with, please run these commands to make some basic checks:
ping mst009.stc.corp
tnsping packs
sqlplus username/password@mst009.stc.corp:1521/packs
sqlplus username/password@packs

Run them from a CMD prompt, and copy/pastge the results here. Be sure to enclose the copy/paste in "code" tags, as described here How to use [code] tags and make your code easier to read
Like this:
c:\users\john\home>ping jwdell.bplc.co.za

Pinging jwdell.bplc.co.za [127.0.0.1] with 32 bytes of data:
Reply from 127.0.0.1: bytes=32 time<1ms TTL=128
Reply from 127.0.0.1: bytes=32 time<1ms TTL=128
Reply from 127.0.0.1: bytes=32 time<1ms TTL=128

Ping statistics for 127.0.0.1:
    Packets: Sent = 3, Received = 3, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
    Minimum = 0ms, Maximum = 0ms, Average = 0ms
Control-C
^C
c:\users\john\home>tnsping orcl

TNS Ping Utility for 32-bit Windows: Version 11.2.0.3.0 - Production on 30-OCT-2012 14:39:15

Copyright (c) 1997, 2011, Oracle.  All rights reserved.

Used parameter files:
c:\app\john\product\11.2.0\dbhome_1\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = jwdell.bplc.co.za)(PORT = 1521)) 
(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))
OK (10 msec)

c:\users\john\home>sqlplus scott/tiger@jwdell.bplc.co.za:1521/orcl

SQL*Plus: Release 11.2.0.3.0 Production on Tue Oct 30 14:39:47 2012

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options


Session altered.

jwdell.bplc.co.za:1521/orcl> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options

c:\users\john\home>sqlplus scott/tiger@orcl

SQL*Plus: Release 11.2.0.3.0 Production on Tue Oct 30 14:40:00 2012

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options


Session altered.

[Updated on: Sat, 03 November 2012 07:30] by Moderator

Report message to a moderator

Re: Getting error ORA-12560: TNS:protocol adapter error [message #569909 is a reply to message #569621] Sat, 03 November 2012 00:49 Go to previous messageGo to next message
ariffcal
Messages: 100
Registered: April 2011
Senior Member
This Is result , below

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\sibnaahmed>ping mst009.stc.corp

Pinging mst009.stc.corp [10.33.88.13] with 32 bytes of data:

Reply from 10.33.88.13: bytes=32 time<1ms TTL=128
Reply from 10.33.88.13: bytes=32 time<1ms TTL=128
Reply from 10.33.88.13: bytes=32 time<1ms TTL=128
Reply from 10.33.88.13: bytes=32 time<1ms TTL=128

Ping statistics for 10.33.88.13:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 0ms, Maximum = 0ms, Average = 0ms

C:\Documents and Settings\sibnaahmed>tnsping packs

TNS Ping Utility for 32-bit Windows: Version 10.1.0.4.2 - Production on 03-NOV-2
012 08:36:16

Copyright (c) 1997, 2003, Oracle. All rights reserved.

Used parameter files:
C:\DevSuiteHome_1\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = mst009.stc.corp)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SE
RVICE_NAME = PACKS)))
OK (70 msec)

C:\Documents and Settings\sibnaahmed>
Re: Getting error ORA-12560: TNS:protocol adapter error [message #569929 is a reply to message #569909] Sat, 03 November 2012 05:24 Go to previous messageGo to next message
Littlefoot
Messages: 19335
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
That output seems to be just fine.

However, you "forgot" to execute two last statements John specified. These are "SQLPLUS", just in case you are in doubt.

littlefoot ,last two commands,pls help [message #569937 is a reply to message #569621] Sat, 03 November 2012 06:36 Go to previous messageGo to next message
ariffcal
Messages: 100
Registered: April 2011
Senior Member
SQL> tnsping packs
SP2-0734: unknown command beginning "tnsping pa..." - rest of line ignored.
SQL> username/password@packs
SP2-0734: unknown command beginning "username/p..." - rest of line ignored.
SQL> packs/packs@packs
SP2-0734: unknown command beginning "packs/pack..." - rest of line ignored.
SQL> username/password@mst009.stc.corp:1521/packs
SP2-0734: unknown command beginning "username/p..." - rest of line ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.
SQL> username/password@mst009.stc.corp:1521/packs;
SP2-0734: unknown command beginning "username/p..." - rest of line ignored.
SQL> packs/packs@mst009.stc.corp:1521/packs
SP2-0734: unknown command beginning "packs/pack..." - rest of line ignored.
SQL>
Re: littlefoot ,last two commands,pls help [message #569938 is a reply to message #569937] Sat, 03 November 2012 06:59 Go to previous messageGo to next message
Michel Cadot
Messages: 58625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
tnsping packs


Is not a SQL*Plus command but an OS one.

Quote:
username/password@packs


Is nothing.

Quote:
packs/packs@packs


Is nothing.

Quote:
username/password@mst009.stc.corp:1521/packs


Is nothing.

What about following what SQL*Plus tells you?

Quote:
For a list of known commands enter HELP


And what about reading the documentation and following the program command instead of trying to invent your own syntax that no one but you can understand?

SQL*PlusĀ® User's Guide and Reference

Regards
Michel

[Updated on: Sat, 03 November 2012 07:00]

Report message to a moderator

Re: littlefoot ,last two commands,pls help [message #569939 is a reply to message #569937] Sat, 03 November 2012 07:16 Go to previous messageGo to next message
John Watson
Messages: 4404
Registered: January 2010
Location: Global Village
Senior Member
Ariff, I have merged your two topics and put them where they should be: in the Networking forum.
Now, your problem: you must read what I told you to do. I gave you the exact commands, and told you to run them from a CMD prompt. And to be certain, I even gave you a demonstration.
If you want help, you must put some effort in yourself. Otherwise people will lose patience with you. The same thing may happen of you do not say "thank you".
Re: littlefoot ,last two commands,pls help [message #569952 is a reply to message #569939] Sat, 03 November 2012 12:41 Go to previous message
Littlefoot
Messages: 19335
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Huh, it might be my fault; I said that these commands are "SQLPLUS" ones so - maybe Ariff thought that they should be run at SQL*Plus prompt. Though, John's example is more than descriptive, but it requires some reading and paying attention.
Previous Topic: ora-12203:TNS: unable to connect to destination
Next Topic: ORA-12514: TNS:listener does not currently know of service requested
Goto Forum:
  


Current Time: Wed Jul 30 20:28:43 CDT 2014

Total time taken to generate the page: 0.07216 seconds