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