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