[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 883
  • Last Modified:

ORA-12505

I am getting the following error in toad, i have checked the tnsnames.ora file, everything looks ok, but cannot connect to the database.
ORA-12505: TNS:listener does not currently know of SID given in connect descriptor

I am using toad on my machine and the database i am trying to connect to: is located on a remote database, the remote machine is in the same room as me and is connected to the network. I had to reboot the remote machine, and since then i am not able to connect to the database on the remoe machine.
0
Rao_S
Asked:
Rao_S
3 Solutions
 
slightwv (䄆 Netminder) Commented:
On the remote machine the database isn't registered with the listener.  The database might be shut down or just not registered.

From the database server verify which it is.

from a command prompt:
sqlpus / as sysdba

If you connect and not to an 'idle instance', then: alter system register.

exit sqlplus then form the command prompt: lsnrctl status
0
 
madunixChief Information Security Officer Commented:
Check if the port that the listener is using the standard port  for the Oracle listener 1521.
0
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 
slightwv (䄆 Netminder) Commented:
Guys, it's not a config issue.  It used to work, then a reboot, now it doesn't.

Something either didn't start up right or started in the wrong order (database then listener and the database didn't register with the listener yet).

>> that the listener is using the standard port  

There isn't anything saying it has to use this port.  Normally you do not use the default port.
0
 
Rao_SAuthor Commented:
Here is the tns:
USSDEV.psc.uss.com=
  (DESCRIPTION=
    (ADDRESS=
      (PROTOCOL=TCP)
      (HOST=170.191.35.182)
      (PORT=1521)
    )
    (CONNECT_DATA=
      (SID=ussdev)
    )
  )
 Here is a snipet of listner.log

29-APR-2011 08:54:47 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=USSDEV)) * (ADDRESS=(PROTOCOL=tcp)(HOST=170.191.35.182)(PORT=3185)) * establish * USSDEV * 12514
TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
29-APR-2011 08:54:49 * (CONNECT_DATA=(SID=USSDEV)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=170.191.35.180)(PORT=30459)) * establish * USSDEV * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
29-APR-2011 08:54:49 * (CONNECT_DATA=(SID=USSDEV)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=170.191.35.180)(PORT=30460)) * establish * USSDEV * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
29-APR-2011 08:54:54 * (CONNECT_DATA=(SID=USSDEV)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=170.191.35.180)(PORT=30462)) * establish * USSDEV * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
29-APR-2011 08:54:54 * (CONNECT_DATA=(SID=USSDEV)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=170.191.35.180)(PORT=30463)) * establish * USSDEV * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
29-APR-2011 08:54:59 * (CONNECT_DATA=(SID=USSDEV)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=170.191.35.180)(PORT=30465)) * establish * USSDEV * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
29-APR-2011 08:54:59 * (CONNECT_DATA=(SID=USSDEV)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=170.191.35.180)(PORT=30466)) * establish * USSDEV * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
29-APR-2011 08:55:04 * (CONNECT_DATA=(SID=USSDEV)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=170.191.35.180)(PORT=30469)) * establish * USSDEV * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
29-APR-2011 08:55:04 * (CONNECT_DATA=(SID=USSDEV)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=170.191.35.180)(PORT=30470)) * establish * USSDEV * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
29-APR-2011 08:55:05 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=USSDEV)) * (ADDRESS=(PROTOCOL=tcp)(HOST=170.191.35.182)(PORT=3195)) * establish * USSDEV * 12514
TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
0
 
slightwv (䄆 Netminder) Commented:
Who asked for output form the listener.log?

Please check out the commands I posted in http:#a35490757

I'm 90% sure:  The database isn't up or it hasn't registered with the listener.
0
 
Rao_SAuthor Commented:
when i:
sqlplus / as sysdba, i get
ora- 12560 TNS: protocal adaptor error
0
 
slightwv (䄆 Netminder) Commented:
Windows OS?  The Oracle service for the database isn't started. So, the database is down.
0
 
Rao_SAuthor Commented:
ok, thanks, started the database.
0
 
Rao_SAuthor Commented:
Thanks!
0

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Tackle projects and never again get stuck behind a technical roadblock.
Join Now