Friday 4 October 2013

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


When trying to create xml file,got below error in oracle applications 11i for rdbms $ORACLE_HOME.

[oratest1@ctsst11 bin]$ perl adbldxml.pl tier=db appsuser=apps appspasswd=apps#opps

Starting context file generation for db tier..
Using JVM from /ebstest1/oracle/11.2.0/jdk/bin/java to execute java programs..

The log file for this adbldxml session is located at:
/ebstest1/oracle/11.2.0/appsutil/log/adbldxml_10021445.log

Could not Connect to the Database : Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

Connecting to the ebstest12 database instance...

Connection paramaters values:
Database server hostname ==> ctsst11-vip.user.com
Database listener port ==> 1592
Database SID ==> ebstest12
Database schema name ==> apps

Could not Connect to the Database : Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor


AC-40000: Error: Exception - java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
occured while connecting to the database - ebstest12

Could not Connect to the Database with the above parameters, Please answer the Questions below

Enter Hostname of Database server[ctsst11-vip.user.com]:


Solution *:-
1)Check listener status ==> you will find the sentence in the last line "listener support no service" it's mean that your listener is not register with the database.
2)login to sysdba ==>sqlplus "/as sysdba"
3)alter system register;
4)stop and start listener.
5)Re test the issue

No comments:

Post a Comment