19c cloning

[raiq1]

Dear sir,

Hope you are doing well, is it possible to provide me your document for 19c cloning in ebs 12.1 environment in both cases.

a) ASM to ASM

b) ASM to filesystem.

Regards,
Raiq

[ErmanArslansOracleBlog]

The cloning process is already documented Raiq..

Please see -> Cloning Oracle E-Business Suite Release 12.1 with Multitenant Database using Rapid Clone (Doc ID 2560690.1)

Only the physical cloning is not documented there..
That is done by you.. Using your preferred method, such as RMAN restore, Flash Copy, Snap View, or Mirror View..

Probably you will use rman and you got to check Oracle documentation for this... You may use RMAN DUPLICATE..

See -> https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/rman-duplicating-databases.html

You have DB_FILE_NAME_CONVERT and LOG_FILE_NAME_CONVERT parameters..

See the example given in the above document..
For instance: Example: Duplicating a Database to a Remote ASM Host by Using Active Database Duplication with Backup Sets

[raiq1]

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

[ErmanArslansOracleBlog]

Check the listener and tnsnames... You may need to correct the settings there..

[raiq1]

Sir,

For that connection string, application are connected fine, only issue are for preclone and it has failed.

Below are the example, I ran the PDB environment file and make test all are well.

[oracle@proddb01 ~]$ . ./TEST_proddb01.env
[oracle@proddb01 ~]$ sqlplus apps/testapps07@TEST

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Apr 27 11:13:13 2022
Version 19.14.0.0.0

Copyright (c) 1982, 2021, Oracle.  All rights reserved.

Last Successful login time: Wed Apr 27 2022 11:11:41 +03:00

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.14.0.0.0

SQL>


I ran the preclone in appstier and it has successfully completed but quite strange is in dbtier are failed.


Below are the tnsnames. ora
TEST=
        (DESCRIPTION=
                (ADDRESS=(PROTOCOL=tcp)(HOST=proddb01.al-haddad.com)(PORT=1531))
            (CONNECT_DATA=
                (SERVICE_NAME=ebs_TEST)
                (INSTANCE_NAME=TESTCDB)
            )
        )

Kindly advice .

Regards,
Raiq

[ErmanArslansOracleBlog]

What is in the /u02/oracle/TEST/19.0.0/appsutil/log/TEST_proddb01/StageDBTier_04270241.log?

[raiq1]

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---------------

[ErmanArslansOracleBlog]

no errors here.. We have only "connection obtained" here..

[ErmanArslansOracleBlog]

If your tnsnames.ora and listener.ora is okay, then you should check the db context file..
->=/u02/oracle/TEST/19.0.0/appsutil/TEST_proddb01.xml
There may be a problem in the db context file.. Especially the db name,sid,service name related values may be wrong there.. This is what I can say right now.. We don't have anything in the log so.. Either we have some wrong values in that xml, or we are hitting a bug..

[raiq1]

Yes, there is no error , only connection obtained. any advice to fix this issue.

[raiq1]

zHi sir,

below is the details for service,sid,dbname in context file, all are fine, kindly check & confirm.


[oracle@proddb01 appsutil]$ grep -i service TEST_proddb01.xml
      <service_names oa_var="s_dbService">ebs_TEST</service_names>
      <cluster_port oa_var="s_clusterServicePort">9998</cluster_port>
      <oa_environment type="generic_service">

[oracle@proddb01 appsutil]$ grep -i sid TEST_proddb01.xml
      <global_db_name oa_var="s_dbSid">TEST</global_db_name>
      <db_name_lower oa_var="s_dbSidLower">test</db_name_lower>



[oracle@proddb01 appsutil]$ grep -i db_name TEST_proddb01.xml
      <global_db_name oa_var="s_dbSid">TEST</global_db_name>
      <db_name_lower oa_var="s_dbSidLower">test</db_name_lower>
      <pdb_name oa_var="s_pdb_name">TEST</pdb_name>
      <cdb_name oa_var="s_cdb_name">TESTCDB</cdb_name>
[oracle@proddb01 appsutil]$

[ErmanArslansOracleBlog]

Okay..
You got "stty: standard input: Inappropriate ioctl for device", but I think that error may be ignored, but still it makes me think..
1)Ensure your env is correct. (only set the run edition env..)
&
2)Ensure you are supplying the correct APPS password to the adpreclone..

[raiq1]

Dear sir,

Issue has been resolved, one of my friend helped me to fix the issue.

you are right, in context file db_hostname, s_cmanhost are in Capital

PRODBDB01 are exist, it should be in proddb01 , this is first changes in context file...

second issue as per the master note, when I run autoconfig orai18n.jar are not exist.

cp $ORACLE_HOME/jlib/orai18n.jar $ORACLE_HOME/jdk/jre/lib/ext


after copied the file , run autoconfig and tried preclone , it has worked fine.


Thanks a lot for your guidance and support.

Regards,
Raiq