oracleappsdba: Oracle EBS R12.2 Cloning using RMAN Backup Step by Steps

1.Execute the adpreclone.pl both application and database.

2.Move the RMAN Backup, database ORACLE HOME, and application backup to the target server.

Source Database: PROD

Target Database: TEST

Backup Details (PROD): /prod/rman_backup/15Jul2021_bkp

Database backup move to target Server (testdb) :

*****************************************************

Copy Command from Source (PROD) server to Target server(TEST)

scp -P 15Jul2021_bkp oracle@172.165.12.15:/test/rman_backup/

scp -P Oracle_Home_bkp15Jul2021.tar.gz oracle@172.165.12.15:/oracledb/TEST/db/tech_st/

The Backup location is /test/rman_backup/15Jul2021_bkp

Application Backup move to target Server:

**********************************************

Copy Command from Source(PROD) server to Target server(TEST)

scp -P EBSapps.tar.gz applmgr@172.165.12.16:/test/applmgr/

The backup Location is /test/applmgr/EBSapps.tar.gz

Untar the backup

tar -xvzf EBSapps.tar.gz

I ) Database Cloning :

Untar the Oracle_home backup file

cd /oracledb/TEST/db/tech_st/

Oracle_Home_bkp15Jul2021.tar.gz

tar -xvzf Oracle_Home_bkp15Jul2021.tar.gz

[oracle testdb tech_st] 12.1.0

[oracle testdb tech_st] cd 12.1.0

Export PERL5LIB and PATH

export PERL5LIB=/oracledb/TEST/db/tech_st/12.1.0/perl/lib/5.14.1:/oracledb/TEST/db/tech_st/12.1.0/perl/lib/site_perl/5.14.1

export PATH=/oracledb/TEST/db/tech_st/12.1.0/perl/bin:/oracledb/TEST/db/tech_st/12.1.0/bin:$PATH

cd /oracledb/TEST/db/tech_st/12.1.0/appsutil/clone/bin

[oracle@testdb bin]$ perl adcfgclone.pl dbTechStack

Redwood Shores, California, USA

Oracle E-Business Suite Rapid Clone

Version 12.2

adcfgclone Version 120.63.12020000.56

Enter the APPS password : <Source<PROD> Apps Password>

Running: Context clone...

Log file located at /oracledb/TEST/db/tech_st/12.1.0/appsutil/clone/bin/CloneContext_1004214819.log

Provide the values required for creation of the new Database Context file.

Target System Hostname (virtual or normal) [testdb] :

Target Instance is RAC (y/n) [n] : n

Target System Database SID : TEST

Target System Base Directory : /oracledb/TEST

Target System utl_file_dir Directory List : /usr/tmp

Number of DATA_TOP's on the Target System [2] : 1

Target System DATA_TOP Directory 1 : /oracledb/TEST/apps_st/data

Target System RDBMS ORACLE_HOME Directory [/oracledb/TEST/12.1.0] : /oracledb/TEST/db/tech_st/12.1.0

Do you want to preserve the Display [oracledb:0.0] (y/n) : n

Target System Display [testdb:0.0] : testdb:1.0

Do you want the target system to have the same port values as the source system (y/n) [y] ? : n

Target System Port Pool [0-99] : 15

Checking the port pool 15

done: Port Pool 15 is free

Report file located at /oracledb/TEST/db/tech_st/12.1.0/appsutil/temp/portpool.lst

The new database context file has been created :

/oracledb/TEST/db/tech_st/12.1.0/appsutil/TESR_testdb.xml

Check Clone Context logfile /oracledb/TEST/db/tech_st/12.1.0/appsutil/clone/bin/CloneContext_1004214819.log for details.

..............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................

cd /oracledb/TEST/db/tech_st/12.1.0/dbs=>TEST_testdb_ifile.ora

set value in TEST_testdb_ifile.ora

[oracle@testdb dbs]$ cat TEST_testdb_ifile.ora

db_file_name_convert=('/erpprod/prod/oracle/PROD/data/datafile','/oracledb/TEST/db/apps_st/data'

log_file_name_convert=('/erpprod/prod/oracle/PROD/data','/oracledb/TEST/db/apps_st/data')

Restore RMAN BACKUP :

[oracle@devebsdb 12.1.0]$ . TEST_TESTDB.env

sqlplus '/as sysdba'

SQL> startup nomount pfile='initTEST.ora';

SQL> select name,open_mode from v$database;

NAME OPEN_MODE

--------- --------------------

TEST NOMOUNT

Create RMAN Script(duplicate.sql):

run

{

allocate auxiliary channel t1 type disk;

allocate auxiliary channel t2 type disk;

duplicate database to "TEST" BACKUP LOCATION '/test/rman_backup/27Jul2021bkp';

release channel t1;

release channel t2;

}

[oracle@testdb 12.1.0]$ . TEST_testdb.env

rman auxiliary / cmdfile=duplicate.sql log=rmanlog.log

Note : Rman restored took some times

SQL> select name,open_mode from v$database;

NAME OPEN_MODE

--------- --------------------

TEST READ WRITE

Now check the Archive log mode:

SQL> archive log list;

Database log mode No Archive Mode

Automatic archival Enabled

Archive destination oracledb/TEST/db/apps_st/data

Oldest online log sequence 173

Current log sequence 174

TEST instance no need Archive log mode, So now we need to disable the Archive log mode

SQL> shut immediate;

SQL>startup mount;

SQL>alter database noarchivelog

SQL>alter database open;

SQL> archive log list;

Database log mode No Archive Mode

Automatic archival Enabled

Archive destination oracledb/TEST/db/apps_st/data

Oldest online log sequence 176

Current log sequence 177

Database in open mode
Run the library update script against the database
cd [RDBMS ORACLE_HOME]/appsutil/install/[CONTEXT NAME] $ sqlplus "/ as sysdba" @adupdlib.sql so
Where [libext] should be set to 'sl' for HP-UX, 'so' for any other UNIX platform, or 'dll' for Windows.
Configure the target database The database must be running and open before performing this step.
cd [RDBMS ORACLE_HOME]/appsutil/clone/bin $ perl adcfgclone.pl dbconfig [Database target context file] Where Database target context file is: [RDBMS ORACLE_HOME]/appsutil/[Target CONTEXT_NAME].xml.

[oracle@testdb bin]$ perl adcfgclone.pl dbconfig oracledb/TEST/db/tech_st/12.1.0/appsutil/TEST_testdb.xml

Redwood Shores, California, USA

Oracle E-Business Suite Rapid Clone

Version 12.2

adcfgclone Version 120.63.12020000.56

Enter the APPS password :

Running Rapid Clone with command:

Running:

perl /oracledb/TEST/db/tech_st/12.1.0/appsutil/clone/bin/adclone.pl java=/oracledb/TEST/db/tech_st/12.1.0/appsutil/clone/bin/../jre mode=apply stage=/oracledb/TEST/db/tech_st/12.1.0/appsutil/clone component=dbconfig method=CUSTOM dbctxtg=/oracledb/TEST/db/tech_st/12.1.0/appsutil/TEST_testdb.xml showProgress contextValidated=false

Beginning dbconfig Apply - Tue 27 10:58:57 2021

/oracledb/TEST/db/tech_st/12.1.0/appsutil/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/oracledb/TEST/db/tech_st/12.1.0/oui -classpath /oracledb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/xmlparserv2.jar://oracledb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/ojdbc6.jar:/oracledb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/java:/oracledb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/oui/OraInstaller.jar:/oracledb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/oui/ewt3.jar://oracledb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/oui/share.jar:/oracledb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/oui/srvm.jar:/oracledb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/ojmisc.jar oracle.apps.ad.clone.ApplyDatabase -e /oracledb/TEST/db/tech_st/12.1.0/appsutil/TEST_testdb.xml -stage /oracledb/TEST/db/tech_st/12.1.0/appsutil/clone -showProgress -noRmanRecovery yes -checkDBConnection

APPS Password : Log file located at /oracledb/TEST/db/tech_st/12.1.0/appsutil/log/TEST_testdbt/ApplyDatabase_10051058.log

| 0% completed

Log file located at /oracledb/TEST/db/tech_st/12.1.0/appsutil/logTEST_testdb/ApplyDatabase_10051058.log

- 30% completed

Completed Apply...

Tue Jul 5 11:00:09 2021

Starting database listener for TEST:

Running:

/oracledb/TEST/db/tech_st/12.1.0/appsutil/scripts/TEST_testdb/addlnctl.sh start TEST

Logfile: /oracledb/TEST/db/tech_st/12.1.0/appsutil/log/TEST_testdb/addlnctl.txt

You are running addlnctl.sh version 120.4

Starting listener process TEST ...

Listener TEST has already been started.

addlnctl.sh: exiting with status 0

addlnctl.sh: check the logfile /oracledb/TEST/db/tech_st/12.1.0/appsutil/log/TEST_testdb/addlnctl.txt for more information ...

Running ETCC to check status of DB technology patches...

+===============================================================+

| Oracle E-Business Suite Release 12.2 |

| Database EBS Technology Codelevel Checker |

+===============================================================+

Executing the following Script:

sqlplus apps/Passw0rd

EXEC FND_CONC_CLONE.SETUP_CLEAN;

Run Autoconfiq in Database:

./adautocfg.sh

Enter the APPS user password:

The log file for this session is located at: /oracledb/TEST/db/tech_st/12.1.0/appsutil/log/WLAUAT_wonderlauat/10051106/adconfig.log

AutoConfig is configuring the Database environment...

AutoConfig will consider the custom templates if present.

Using ORACLE_HOME location : /oracledb/TEST/db/tech_st/12.1.0

Classpath : :/oracledb/TEST/db/tech_st/12.1.0/jdbc/lib/ojdbc6.jar:/oracledb/TEST/db/tech_st/12.1.0/appsutil/java/xmlparserv2.jar:/oracledb/TEST/db/tech_st/12.1.0/appsutil/java:/oracledb/TEST/db/tech_st/12.1.0/jlib/netcfg.jar:/oracledb/TEST/db/tech_st/12.1.0/jlib/ldapjclnt12.jar

Using Context file: /oracledb/TEST/db/tech_st/12.1.0/appsutil/TEST_testdb.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 db121

Updating rdbms type in Context file to 64 bits

Configuring templates from ORACLE_HOME ...

AutoConfig completed successfully.

II ) APPS Cloning:

/test/applmgr/fs1/EBSapps/comn/clone/bin

[applmgrt@testapps bin]$ perl adcfgclone.pl appsTier dualfs

Redwood Shores, California, USA

Oracle E-Business Suite Rapid Clone

Version 12.2

adcfgclone Version 120.63.12020000.56

Enter the APPS password :

Enter the Weblogic AdminServer password :

Do you want to add a node (yes/no) [no] : no

Running: Context clone...

Log file located at /test/applmgr/fs1/EBSapps/comn/clone/bin/CloneContext_1005111910.log

Provide the values required for creation of the new APPL_TOP Context file.

Target System Hostname (virtual or normal) [testapps] :

Target System Database SID : TEST

Target System Database Server Node [testdb] : testdb

Target System Database Domain Name [xyz.com] : xyz.org

Target System Base Directory : /test/applmgr

Target System Base Directory set to /test/applmgr

Target System Current File System Base set to /test/applmgr/fs1

Target System Other File System Base set to /test/applmgr/fs2

Target System Fusion Middleware Home set to /test/applmgr/fs1/FMW_Home

Target System Other File System Fusion Middleware Home set to /test/applmgr/fs2/FMW_Home

Target System Web Oracle Home set to /test/applmgr/fs1/FMW_Home/webtier

Target System Other File System Web Oracle Home set to /test/applmgr/fs2/FMW_Home/webtier

Target System Appl TOP set to /test/applmgr/fs1/EBSapps/appl

Target System Other File System Appl TOP set to /test/applmgr/fs2/EBSapps/appl

Target System COMMON TOP set to /test/applmgr/fs1/EBSapps/comn

Target System Other File System COMMON TOP set to /test/applmgr/fs2/EBSapps/comn

Target System Instance Home Directory [/test/applmgr] :

Target System Current File System Instance Top set to /test/applmgr/fs1/inst/apps/TEST_testapps

Do you want to preserve the Display [oraebsapps:0.0] (y/n) : n

Target System Display [testapps:0.0] : testapps:1.0

Target System Root Service [enabled] :

Target System Web Entry Point Services [enabled] :

Target System Web Application Services [enabled] :

Target System Batch Processing Services [enabled] :

Target System Other Services [disabled] :

Do you want the target system to have the same port values as the source system (y/n) [y] ? : n

Target System Port Pool [0-99] : 15

Checking the port pool 15

done: Port Pool 15 is free

Report file located at /test/applmgr/fs1/inst/apps/TEST_testapps/admin/out/portpool.lst

UTL_FILE_DIR on database tier consists of the following directories.

1. /usr/tmp

2. /usr/tmp

3. /oracledb/TEST/db/tech_st/12.1.0/appsutil/outbound/TEST_testdb

4. /usr/tmp

Choose a value which will be set as APPLPTMP value on the target node [1] : 1

The new APPL_TOP context file has been created :

/test/applmgr/fs1/inst/apps/TEST_testapps/appl/admin/TEST_testapps.xml

Check Clone Context logfile /test/applmgr/fs1/EBSapps/comn/clone/bin/CloneContext_1005111910.log for details.

Creating Patch file system context file.....

Log file located at /test/applmgr/fs1/EBSapps/comn/clone/bin/CloneContextPatch_1005112418.log

Target System Other File System Instance Top set to /test/applmgr/fs2/inst/apps/TEST_testapps

Target System Port Pool [0-99] : 16

Checking the port pool 16

done: Port Pool 16 is free

Report file located at /test/applmgr/fs2/inst/apps/TEST_testapps/admin/out/portpool.lst

The new APPL_TOP context file has been created :

/test/applmgr/fs2/inst/apps/TEST_testapps/appl/admin/TEST_testapps.xml

Check Clone Context logfile /test/applmgr/fs1/EBSapps/comn/clone/bin/CloneContextPatch_1005112418.log for details.

FMW Pre-requisite check log file location : /test/applmgr/fs1/EBSapps/comn/clone/FMW/logs/prereqcheck.log

Running: FMW pre-req check...

Configuring: Run file system....

LogFile located at /test/applmgr/fs1/inst/apps/TEST_testapps/admin/log/clone/run/RCloneApplyAppstier_10051124.log

Configuring: Patch file system....

LogFile located at /test/applmgr/fs2/inst/apps/TEST_testapps/admin/log/clone/run/RCloneApplyAppstier_10061125.log

Post-Clone Steps:

1. System password changed in Database

SQL>alter user system identified by welcome123;

2. Apps Password changed

Syntax:

FNDCPASS apps/<old password> 0 y system/Password SYSTEM APPLSYS <apss new password>

FNDCPASS apps/PassW0rd 0 y system/welcome123 SYSTEM APPLSYS apps123

3.Sysadmin Password Changed

FNDCPASS apps/<apps new password> 0 y system/Password USER SYSADMIN <sysadmin Password>

FNDCPASS apps/apps123 0 y system/welcome123 USER SYSADMIN Welcome#123

4.Weblogic console to connect :

Note: Weblogic to connect need to start the Admin server

[applmgr@testapps scripts]$ adadminsrvctl.sh start

You are running adadminsrvctl.sh version 120.10.12020000.10

Enter the WebLogic Admin password:

Enter the APPS Schema password:

Starting WLS Admin Server...

Refer /test/applmgr/fs1/inst/apps/TEST_testapps/logs/appl/admin/log/adadminsrvctl.txt for details

AdminServer logs are located at /test/applmgr/fs1/FMW_Home/user_projects/domains/EBS_domain_TEST/servers/AdminServer/logs

adadminsrvctl.sh: exiting with status 0

adadminsrvctl.sh: check the logfile /test/applmgr/fs1/inst/apps/TEST_testapps/logs/appl/admin/log/adadminsrvctl.txt for more information ...

[applmgr@testapps scripts]$

To find out WebLogic console:

grep -i "wls_admin" $CONTEXT_FILE

[applmgr@testapps TEST]$ grep -i "wls_admin" $CONTEXT_FILE

<wls_admin_host oa_var="s_wls_admin_host">testdb</wls_admin_host>

<wls_admin_domain oa_var="s_wls_admin_domain">.xyz.org</wls_admin_domain>

<wls_admin_user oa_var="s_wls_admin_user">weblogic</wls_admin_user>

<wls_adminport oa_var="s_wls_adminport" oa_type="PORT" base="7001" step="1" range="-1" label="WLS Admin Server Port">7016</wls_adminport>

[appluat@testapps TEST]$ grep login $CONTEXT_FILE

<login_page oa_var="s_login_page">http://testdb.xyz.org:8015/OA_HTML/AppsLogin</login_page>

The WebLogic Console is: http://testdb.xyz.org:7016/console

+ services

+ Data sourecs

+ EBS Data sources

+ Connection Pool

Apps Username <apps>

Apps Password <apps123>

and Save it

Auto Config Run in Database and Application:

1.Database :

./adautocfg.sh

Enter the APPS user password:

The log file for this session is located at: /oracledb/TEST/db/tech_st/12.1.0/appsutil/log/WLAUAT_wonderlauat/10051106/adconfig.log

AutoConfig is configuring the Database environment...

AutoConfig will consider the custom templates if present.

Using ORACLE_HOME location : /oracledb/TEST/db/tech_st/12.1.0

Using Context file: /oracledb/TEST/db/tech_st/12.1.0/appsutil/TEST_testdb.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 db121

Updating rdbms type in Context file to 64 bits

Configuring templates from ORACLE_HOME ...

AutoConfig completed successfully.

2. Application Autoconfiq:

Enter the APPS user password:

The log file for this session is located at: /test/applmgr/fs1/inst/apps/TEST_testapps/admin/log/10051828/adconfig.log

AutoConfig is configuring the Applications environment...

AutoConfig will consider the custom templates if present.

Using CONFIG_HOME location : /test/applmgr/fs1/inst/apps/TEST_testapps

Classpath : /test/applmgr/fs1/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar:/test/applmgr/fs1/EBSapps/comn/java/classes

Using Context file: /test/applmgr/fs1/inst/apps/TEST_testapps/appl/admin/Test_testapps.xml

Context Value Management will now update the Context file

Updating Context file...COMPLETED

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

Configuring templates from all of the product tops...

Configuring AD_TOP........COMPLETED

Configuring FND_TOP.......COMPLETED

Configuring ICX_TOP.......COMPLETED

Site Name Changed:

DECLARE

a BOOLEAN;

BEGIN

a :=

FND_PROFILE.SAVE ('SITENAME',

'Test instance Refreshed on:28-JUL-2021 Backup Date:15-JUL 2021',

'SITE');

END;

Color Changed:

DECLARE

a BOOLEAN;

BEGIN

a := FND_PROFILE.SAVE ('FND_COLOR_SCHEME', 'red', 'SITE');

END;

1.Execute the adpreclone.pl both application and database.

2.Move the RMAN Backup, database ORACLE HOME, and application backup to the target server.

Source Database: PROD

Target Database: TEST

Backup Details (PROD): /prod/rman_backup/15Jul2021_bkp

Database backup move to target Server (testdb) :

*****************************************************

Copy Command from Source (PROD) server to Target server(TEST)

scp -P 15Jul2021_bkp oracle@172.165.12.15:/test/rman_backup/

scp -P Oracle_Home_bkp15Jul2021.tar.gz oracle@172.165.12.15:/oracledb/TEST/db/tech_st/

The Backup location is /test/rman_backup/15Jul2021_bkp

Application Backup move to target Server:

**********************************************

Copy Command from Source(PROD) server to Target server(TEST)

scp -P EBSapps.tar.gz applmgr@172.165.12.16:/test/applmgr/

The backup Location is /test/applmgr/EBSapps.tar.gz

Untar the backup

tar -xvzf EBSapps.tar.gz

I ) Database Cloning :

Untar the Oracle_home backup file

cd /oracledb/TEST/db/tech_st/

Oracle_Home_bkp15Jul2021.tar.gz

tar -xvzf Oracle_Home_bkp15Jul2021.tar.gz

[oracle testdb tech_st] 12.1.0

[oracle testdb tech_st] cd 12.1.0

Export PERL5LIB and PATH

export PERL5LIB=/oracledb/TEST/db/tech_st/12.1.0/perl/lib/5.14.1:/oracledb/TEST/db/tech_st/12.1.0/perl/lib/site_perl/5.14.1

export PATH=/oracledb/TEST/db/tech_st/12.1.0/perl/bin:/oracledb/TEST/db/tech_st/12.1.0/bin:$PATH

cd /oracledb/TEST/db/tech_st/12.1.0/appsutil/clone/bin

[oracle@testdb bin]$ perl adcfgclone.pl dbTechStack

Redwood Shores, California, USA

Oracle E-Business Suite Rapid Clone

Version 12.2

adcfgclone Version 120.63.12020000.56

Enter the APPS password : <Source<PROD> Apps Password>

Running: Context clone...

Log file located at /oracledb/TEST/db/tech_st/12.1.0/appsutil/clone/bin/CloneContext_1004214819.log

Provide the values required for creation of the new Database Context file.

Target System Hostname (virtual or normal) [testdb] :

Target Instance is RAC (y/n) [n] : n

Target System Database SID : TEST

Target System Base Directory : /oracledb/TEST

Target System utl_file_dir Directory List : /usr/tmp

Number of DATA_TOP's on the Target System [2] : 1

Target System DATA_TOP Directory 1 : /oracledb/TEST/apps_st/data

Target System RDBMS ORACLE_HOME Directory [/oracledb/TEST/12.1.0] : /oracledb/TEST/db/tech_st/12.1.0

Do you want to preserve the Display [oracledb:0.0] (y/n) : n

Target System Display [testdb:0.0] : testdb:1.0

Do you want the target system to have the same port values as the source system (y/n) [y] ? : n

Target System Port Pool [0-99] : 15

Checking the port pool 15

done: Port Pool 15 is free

Report file located at /oracledb/TEST/db/tech_st/12.1.0/appsutil/temp/portpool.lst

The new database context file has been created :

/oracledb/TEST/db/tech_st/12.1.0/appsutil/TESR_testdb.xml

Check Clone Context logfile /oracledb/TEST/db/tech_st/12.1.0/appsutil/clone/bin/CloneContext_1004214819.log for details.

cd /oracledb/TEST/db/tech_st/12.1.0/dbs=>TEST_testdb_ifile.ora

set value in TEST_testdb_ifile.ora

[oracle@testdb dbs]$ cat TEST_testdb_ifile.ora

db_file_name_convert=('/erpprod/prod/oracle/PROD/data/datafile','/oracledb/TEST/db/apps_st/data'

log_file_name_convert=('/erpprod/prod/oracle/PROD/data','/oracledb/TEST/db/apps_st/data')

Restore RMAN BACKUP :

[oracle@devebsdb 12.1.0]$ . TEST_TESTDB.env

sqlplus '/as sysdba'

SQL> startup nomount pfile='initTEST.ora';

SQL> select name,open_mode from v$database;

NAME OPEN_MODE

--------- --------------------

TEST NOMOUNT

Create RMAN Script(duplicate.sql):

run

{

allocate auxiliary channel t1 type disk;

allocate auxiliary channel t2 type disk;

duplicate database to "TEST" BACKUP LOCATION '/test/rman_backup/27Jul2021bkp';

release channel t1;

release channel t2;

}

[oracle@testdb 12.1.0]$ . TEST_testdb.env

rman auxiliary / cmdfile=duplicate.sql log=rmanlog.log

Note : Rman restored took some times

SQL> select name,open_mode from v$database;

NAME OPEN_MODE

--------- --------------------

TEST READ WRITE

Now check the Archive log mode:

SQL> archive log list;

Database log mode No Archive Mode

Automatic archival Enabled

Archive destination oracledb/TEST/db/apps_st/data

Oldest online log sequence 173

Current log sequence 174

TEST instance no need Archive log mode, So now we need to disable the Archive log mode

SQL> shut immediate;

SQL>startup mount;

SQL>alter database noarchivelog

SQL>alter database open;

SQL> archive log list;

Database log mode No Archive Mode

Automatic archival Enabled

Archive destination oracledb/TEST/db/apps_st/data

Oldest online log sequence 176

Current log sequence 177

Database in open mode
Run the library update script against the database
cd [RDBMS ORACLE_HOME]/appsutil/install/[CONTEXT NAME] $ sqlplus "/ as sysdba" @adupdlib.sql so
Where [libext] should be set to 'sl' for HP-UX, 'so' for any other UNIX platform, or 'dll' for Windows.
Configure the target database The database must be running and open before performing this step.
cd [RDBMS ORACLE_HOME]/appsutil/clone/bin $ perl adcfgclone.pl dbconfig [Database target context file] Where Database target context file is: [RDBMS ORACLE_HOME]/appsutil/[Target CONTEXT_NAME].xml.