Solved

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

Posted on 2015-01-28
9
610 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 69

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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 69

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 69

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 69

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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

In this article, I will show you HOW TO: Install VMware Tools for Windows on a VMware Windows virtual machine on a VMware vSphere Hypervisor 6.5 (ESXi 6.5) Host Server, using the VMware Host Client. The virtual machine has Windows Server 2016 instal…
A quick guide on how to use Group Policy to create a custom power plan and set it active on Windows 7.
This Micro Tutorial will teach you how to change your appearance and customize your Windows 7 interface to your unique preference. This will be demonstrated using Windows 7 operating system.
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

730 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