Monday 24 June 2013

"afdbprf.sh" Exception occurred: 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



oradev@cstsd $ adautocfg.sh
Enter the APPS user password:
The log file for this session is located at: /u01/oracle/10.2.0/appsutil/log/ebsdev_ebsdev/06180805/adconfig.log

AutoConfig is configuring the Database environment...

AutoConfig will consider the custom templates if present.
Using ORACLE_HOME location : /u01/oracle/10.2.0
Classpath : /u01/oracle/10.2.0/jdk/jre/lib/rt.jar:/u01/oracle/10.2.0/jdk/lib/dt.jar:/u01/oracle/10.2.0/jdk/lib/tools.jar:/u01/oracle/10.2.0/jdbc/lib/ojdbc14.jar:/u01/oracle/10.2.0/appsutil/java/xmlparserv2.zip:/u01/oracle/10.2.0/appsutil/java:/u01/oracle/10.2.0/jlib/netcfg.jar:/u01/oracle/10.2.0/jlib/ldapjclnt10.jar

Using Context file : /u01/oracle/10.2.0/appsutil/ebsdev_ebsdev.xml

Context Value Management will now update the Context file

Updating Context file...COMPLETED

Attempting upload of Context file and templates to database...COMPLETED

Updating rdbms version in Context file to db102
Updating rdbms type in Context file to 64 bits
Configuring templates from ORACLE_HOME ...

AutoConfig completed with errors.
oradev@cstsd $



Autoconfig failed on database node and logfile contain below error messages.
========================================================


/u01/oracle/10.2.0/appsutil/log/ebsdev_ebsdev/06180805/adconfig.log

getConnectionUsingSID() -->
JDBC URL: jdbc:oracle:thin:@ebsdev.user.com:1603:ebsdev
Exception occurred: 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

Trying to connect using SID as ServiceName
getConnectionUsingServiceName() -->
JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ebsdev.user.com)(PORT=1603))(CONNECT_DAT
A=(SERVICE_NAME=ebsdev)))
Exception occurred: java.sql.SQLException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

Trying to connect using SID as ServiceName.DomainName
getConnectionUsingServiceName() -->
JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ebsdev.user.com)(PORT=1603))(CONNECT_DAT
A=(SERVICE_NAME=ebsdev.user.com)))
Exception occurred: java.sql.SQLException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

[PROFILE PHASE]
AutoConfig could not successfully execute the following scripts:
Directory: /u01/oracle/10.2.0/appsutil/install/ebsdev_ebsdev
afdbprf.sh INSTE8_PRF 1

AutoConfig is exiting with status 1..

When i try to check the status giving below error.
==================================

oradev@cstsd $ lsnrctl start ebsdev

LSNRCTL for Solaris: Version 10.2.0.5.0 - Production on 18-JUN-2013 08:08:44

Copyright (c) 1991, 2010, Oracle. All rights reserved.

Starting /u01/oracle/10.2.0/bin/tnslsnr: please wait...

TNSLSNR for Solaris: Version 10.2.0.5.0 - Production
System parameter file is /u01/oracle/10.2.0/network/admin/ebsdev_ebsdev/listener.ora
Log messages written to /u01/oracle/10.2.0/network/log/ebsdev.log
TNS-01151: Missing listener name, ebsdev, in LISTENER.ORA

Listener failed to start. See the error message(s) above...

oradev@cstsd $


Cause:Entries are pointing to production listener name i.e why we are getting missing
listener name when we check status or start it.

Solution:
1)Take the backup of the listener.ora file and change the entry which is pointing to produciton.
2)Now start the listener.
3)Run autoconfig issue will get fixed.

Happy learning !!!!!!!!!!.







No comments:

Post a Comment