Re: 19c cloning

Posted by raiq1 on Apr 26, 2022; 11:55pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/19c-cloning-tp10865p10869.html

Sir,

I have an issue while running adpreclone on dbtier in 19c , error are Rc-40003 unable to connect to database as apps schema.

Kindly guide us to fix the issue.



 perl adpreclone.pl dbTier

                     Copyright (c) 2002 Oracle Corporation
                        Redwood Shores, California, USA

                        Oracle Applications Rapid Clone

                                 Version 12.0.0

                      adpreclone Version 120.20.12010000.5

Enter the APPS User Password:
Running:
perl /u02/oracle/TEST/19.0.0/appsutil/bin/adclone.pl java=/u02/oracle/TEST/19.0.0/jdk/jre mode=stage stage=/u02/oracle/TEST/19.0.0/appsutil/clone component=dbTier method=CUSTOM dbctx=/u02/oracle/TEST/19.0.0/appsutil/TEST_proddb01.xml showProgress
stty: standard input: Inappropriate ioctl for device
APPS Password :
stty: standard input: Inappropriate ioctl for device


Beginning database tier Stage - Wed Apr 27 02:41:00 2022

/u02/oracle/TEST/19.0.0/jdk/jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=false  -Doracle.installer.oui_loc=/u02/oracle/TEST/19.0.0/oui -classpath /u02/oracle/TEST/19.0.0/lib/xmlparserv2.jar:/u02/oracle/TEST/19.0.0/jdbc/lib/ojdbc8.jar:/u02/oracle/TEST/19.0.0/appsutil/java:/u02/oracle/TEST/19.0.0/oui/jlib/OraInstaller.jar:/u02/oracle/TEST/19.0.0/oui/jlib/ewt3.jar:/u02/oracle/TEST/19.0.0/oui/jlib/share.jar:/u02/oracle/TEST/19.0.0/oui/jlib/srvm.jar:/u02/oracle/TEST/19.0.0/jlib/ojmisc.jar   oracle.apps.ad.clone.StageDBTier -e /u02/oracle/TEST/19.0.0/appsutil/TEST_proddb01.xml -stage /u02/oracle/TEST/19.0.0/appsutil/clone -tmp /tmp -method CUSTOM    -showProgress
APPS Password :
Log file located at /u02/oracle/TEST/19.0.0/appsutil/log/TEST_proddb01/StageDBTier_04270241.log

RC-40003: Fatal: Unable to connect to database as APPS schema.

ERROR while running Stage...
Wed Apr 27 02:41:02 2022

ERROR while running perl /u02/oracle/TEST/19.0.0/appsutil/bin/adclone.pl java=/u02/oracle/TEST/19.0.0/jdk/jre mode=stage stage=/u02/oracle/TEST/19.0.0/appsutil/clone component=dbTier method=CUSTOM dbctx=/u02/oracle/TEST/19.0.0/appsutil/TEST_proddb01.xml showProgress ...
Wed Apr 27 02:41:02 2022

after open the log file, connection are establish.


 more /u02/oracle/TEST/19.0.0/appsutil/log/TEST_proddb01/StageDBTier_04270241.log
#############################################################
Started StageDBTier at Wed Apr 27 02:41:01 AST 2022
Version:
        StageDBTier.java        :       120.8.12010000.3
#############################################################

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

getConnectionUsingAppsJDBCConnector() -->
    APPS_JDBC_URL='null'
    Trying to get connection using SID based connect descriptor
getConnection() -->
    sDbHost    : PRODDB01
    sDbDomain  : abc.com
    sDbPort    : 1531
    sDbSid     : TEST
    sDbUser    : apps
    Trying to connect using SID...
getConnectionUsingSID() -->
    JDBC URL: jdbc:oracle:thin:@PRODDB01.abc.com:1531:TEST
    Connection obtained

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



Need your advice to fix the issue.

Regards,
Raiq