Solved

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

Posted on 2015-01-28
9
540 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
Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

 

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

Do email signature updates give you a headache?

Do you feel like you are constantly making changes to email signatures? Are the images not formatting how you want them to? Want high-quality HTML signatures on all devices, including on mobiles and Macs? Then, let Exclaimer solve all your email signature problems today.

Join & Write a Comment

Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
This Micro Tutorial will teach you how to the overview of Microsoft Security Essentials. This is a free anti-virus software that guards your PC against viruses, spyware, worms, and other malicious software. This will be demonstrated using Windows…
This Micro Tutorial will give you a introduction in two parts how to utilize Windows Live Movie Maker to its maximum capability. This will be demonstrated using Windows Live Movie Maker on Windows 7 operating system.

758 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

21 Experts available now in Live!

Get 1:1 Help Now