Solved

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

Posted on 2015-01-28
9
573 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 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
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

 
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

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
By default the complete memory dump option is disabled in windows . If we want to enable the complete memory dump for a diagnostic purpose, we have a solution for it. here we are using the registry method to enable this.
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.
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…

825 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