Solved

ORA:12505: TNS:listener does not currently know of SID given in connect descriptor

Posted on 2015-01-28
9
554 Views
Last Modified: 2015-01-29
suddenly got error on one computer

ORA:12505: TNS:listener does not currently know of SID given in connect descriptor

for test : after  installing on new computer with configuration ,everything works

so what happened to old computer ?
0
Comment
Question by:techp
  • 4
  • 4
9 Comments
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 40575924
The listener on the other machine isn't listening for connections for the instance you provided.

From a cmd prompt on the database server:
lsnrctl status

Look for the instance you want.  If it isn't there then it is one of two things:
The instance is down
or
Hasn't registered itself with that listener.

As for why it happened all of a sudden:  What changed?
0
 
LVL 68

Expert Comment

by:Qlemo
ID: 40576225
Are talking about servers or clients by "old" and "new"?
0
 

Author Comment

by:techp
ID: 40576937
client
0
 
LVL 68

Expert Comment

by:Qlemo
ID: 40576961
Check the local tnsnames.ora, if used against the "new" one.
How is the connection info supplied to the application?
0
Being driven mad by email signature updates?

Having to make a change to your users’ email signatures, yet again? Feel like your head is going to explode? Rely on an Exclaimer email signature management solution to make the process simple!

 

Author Comment

by:techp
ID: 40576972
i replaced tnsnames.ora from new computer . same error
 (system is developer 2000 client)
0
 
LVL 68

Expert Comment

by:Qlemo
ID: 40576990
Is sqlplus available for testing the connection? If so, try it.
0
 

Author Comment

by:techp
ID: 40577091
sql plus 3.3 available...what is username password hoststring ? and what to test ?
0
 
LVL 68

Accepted Solution

by:
Qlemo earned 500 total points
ID: 40577150
You would need the (exact) connection string of the application, including a valid username and password. But for the connection test user and pwd do not matter, the hoststring or connection string is the alias defined in TNSNames.ora.
A complete connection string would look like this:
   user1/pwd1@db1
if db1 is defined in TNSNames.ora like
   db1 = sever1/instance1
(probably the string after = is much longer and contains a complete connection descriptor).

Do you know what the application uses for connecting?
0
 

Author Comment

by:techp
ID: 40577257
thank you olemo
 i changed database instance from sql net and it became ok
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Join Greg Farro and Ethan Banks from Packet Pushers (http://packetpushers.net/podcast/podcasts/pq-show-93-smart-network-monitoring-paessler-sponsored/) and Greg Ross from Paessler (https://www.paessler.com/prtg) for a discussion about smart network …
This Micro Tutorial will go in depth within Systems and Security in Windows 7 and will go into detail regarding Action Center, Windows Firewall, System, etc. This will be demonstrated using Windows 7 operating system.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

947 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now