Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2015-01-28
9
Medium Priority
?
723 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
9 Comments
 
LVL 77

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 71

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
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 
LVL 71

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
 

Author Comment

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

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 71

Accepted Solution

by:
Qlemo earned 2000 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

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

This article helps those who get the 0xc004d307 error when trying to rearm (reset the license) Office 2013 in a Virtual Desktop Infrastructure (VDI) and/or those trying to prep the master image for Microsoft Key Management (KMS) activation. (i.e.- Cā€¦
Compliance and data security require steps be taken to prevent unauthorized users from copying data.  Here's one method to prevent data theft via USB drives (and writable optical media).
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.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to ā€¦

604 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