Database bounce while running adpreclone DBTier and passing wrong apps password

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem Description: By running adpreclone on the database and passing wrong apps password, it causes database bounce


Problem Description: By running adpreclone on the database and passing wrong apps password, it causes database bounce


Trace Files shows:


Started StageDBTier at Thu Jun 10 12:45:49 GST 2010
Version:
StageDBTier.java : 120.6.12000000.3
#############################################################

---------------------------------------------------------------
ADX Database Utility
---------------------------------------------------------------

getConnectionUsingAppsJDBCConnector() -->
APPS_JDBC_URL='null'
Trying to get connection using SID based connect descriptor
getConnection() -->
sDbHost : erpdev
sDbDomain : auh.police
sDbPort : 1524
sDbSid : addev
sDbUser : APPS
Trying to connect using SID...
getConnectionUsingSID() -->
JDBC URL: jdbc:oracle:thin:@erpdev.auh.police:1524:addev
Exception occurred: java.sql.SQLException: ORA-01017: invalid username/password; logon denied

Trying to connect using SID as ServiceName
getConnectionUsingServiceName() -->
JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=erpdev.auh.police)(PORT=1524))(CONNECT_DATA=(SERVICE_NAME=addev)))
Exception occurred: java.sql.SQLException: ORA-01017: invalid username/password; logon denied

Trying to connect using SID as ServiceName.DomainName
getConnectionUsingServiceName() -->
JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=erpdev.auh.police)(PORT=1524))(CONNECT_DATA=(SERVICE_NAME=addev.auh.police)))
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
The Connection descriptor used by the client was:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=erpdev.auh.police)(PORT=1524))(CONNECT_DATA=(SERVICE_NAME=addev.auh.police)))

Connection could not be obtained; returning null

-------------------ADX Database Utility Finished---------------



StackTrace:
java.lang.NullPointerException
at oracle.apps.ad.clone.util.CreateCloningStage.promptYesNoQuestion(CreateCloningStage.java:981)
at oracle.apps.ad.clone.StageDBTier.main(StageDBTier.java:576)
...............
................
................

---------------------------------------------------------------
ADX Database Utility
---------------------------------------------------------------

getConnectionUsingAppsJDBCConnector() -->
APPS_JDBC_URL='null'
Trying to get connection using SID based connect descriptor
getConnection() -->
sDbHost : erpdev
sDbDomain : auh.police
sDbPort : 1524
sDbSid : addev
sDbUser : APPS
Trying to connect using SID...
getConnectionUsingSID() -->
JDBC URL: jdbc:oracle:thin:@erpdev.auh.police:1524:addev
Exception occurred: java.sql.SQLException: ORA-01017: invalid username/password; logon denied

Trying to connect using SID as ServiceName
getConnectionUsingServiceName() -->
JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=erpdev.auh.police)(PORT=1524))(CONNECT_DATA=(SERVICE_NAME=addev)))
Exception occurred: java.sql.SQLException: ORA-01017: invalid username/password; logon denied

Trying to connect using SID as ServiceName.DomainName
getConnectionUsingServiceName() -->
JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=erpdev.auh.police)(PORT=1524))(CONNECT_DATA=(SERVICE_NAME=addev.auh.police)))
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
The Connection descriptor used by the client was:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=erpdev.auh.police)(PORT=1524))(CONNECT_DATA=(SERVICE_NAME=addev.auh.police)))

Connection could not be obtained; returning null

-------------------ADX Database Utility Finished---------------

RC-40000: Unable to start up the database
Raised by oracle.apps.ad.clone.StageDatabase
RC-40000: Unable to start up the database
Raised by oracle.apps.ad.clone.StageDatabase


Solution:




This is a known bug
Bug 7533866 - R12 PRECLONE SCRIPT BOUNCING PRODUCTION DATABASE WITHOUT PROMPTING THE USER


This is an enhancement to avoid bouncing the Database (to force a fresh
start) when there is no Database connection when the user runs adpreclone.
This also happens when the user enters the wrong password for Apps User.
The issue was detected on 11i under Bug 7362282.




Bug created the following file versions to fix this issue

Product Directory File Version
==== ================= ============== ==================
ad java/clone StageDBTier.java 120.6.12000000.5
ad java/clone StageDatabase.java 120.10.12000000.14
ad java/util MessageResourceBundle.java 120.2.12000000.6
ad patch/115/manualsteps ad_apply_patch.xml 120.4

There is no patch created for bug 7533866 but the fixed files are available in
12.0 RAPIDCLONE CONSOLIDATED FIXES JAN/2010 - 8360494:R12.OAM.A

Get Oracle Certifications for all Exams
Free Online Exams.com