Getting error ORA-12560: TNS:protocol adapter error [message #569621] |
Tue, 30 October 2012 06:54 |
|
ariffcal
Messages: 107 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 #569634 is a reply to message #569621] |
Tue, 30 October 2012 09:47 |
John Watson
Messages: 8938 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: littlefoot ,last two commands,pls help [message #569939 is a reply to message #569937] |
Sat, 03 November 2012 07:16 |
John Watson
Messages: 8938 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 |
|
Littlefoot
Messages: 21813 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.
|
|
|