No data displayed for some tables EBS 12.2 with SQL Developer V18

No data displayed for some tables EBS with SQL Developer V18

when select data from some tables such as fa_additions using sql developper v18, no row displayed.

select * from fa_additions

No rows

This will not the only view showing no rows. but all synonyms for views creating with the T.LANGUAGE = userenv('LANG'); 

to check the nls lang from sql developer, 

select userenv('LANG') from dual;
GB.

To change the LANG in sql developer, please to
1. Start sqldeveloper.
2. Go to Tools-->preferences-->database-->NLS parameters.
3. Change LANGUAGE to AMERICAN.
4. Restart sql developer.

The data will displayed normally now.

Validate Hyperion ESSBASE Database

Validate Hyperion ESSBASE Database


Some time a corruption can be occured on Planning database for essbase application, the aim of this tuto is to show how to validate Essbase planning database when needed.


[oracle@hyperion essbaseserver1]$ pwd
/u01/EPM/Oracle/Middleware/user_projects/epmsystem1/EssbaseServer/essbaseserver1
[oracle@hyperion essbaseserver1]$ cd bin/
[oracle@hyperion bin]$ sh startEsscmd.sh
which: no startEsscmd.sh in (/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/oracle/bin)
Essbase Command Mode Interface 64-bit - Release 11.1.2 (ESB11.1.2.4.000B193)
Copyright (c) 1991, 2015, Oracle and/or its affiliates. All rights reserved.
U.S. Patent Number 5,359,724
U.S. Patent Number 6,317,750

:::[0]->login
Login:
Host Node >localhost
User >admin
Password >*********
[Wed Sep 26 19:41:02 2018]Local////Info(1051034)
Logging in user [admin@Native Directory]

Available Application Database:
PRODAPP                       ==> PRODPlan1

localhost:::admin[1]->select PRODAPP PRODPlan1
Select:
localhost:PRODAPP:PRODPlan1:admin[1]->validate
Validate:
Enter error log file name >./PRODPlan1_error2.log
Validate in progress (Hit <Esc> key to cancel).
[Wed Sep 26 19:41:27 2018]localhost/PRODAPP/PRODPlan1/admin/Info(1006078)
Invalid block header: Illegal block type -- Please restore from backup

[Wed Sep 26 19:41:27 2018]localhost/PRODAPP/PRODPlan1/admin/Info(1006078)
Invalid block header: Illegal block type -- Please restore from backup

[Wed Sep 26 19:41:27 2018]localhost/PRODAPP/PRODPlan1/admin/Info(1006078)
Invalid block header: Illegal block type -- Please restore from backup

[Wed Sep 26 19:41:27 2018]localhost/PRODAPP/PRODPlan1/admin/Error(1042013)
Network error [104]: Failed to receive data

[Wed Sep 26 19:41:27 2018]localhost/PRODAPP/PRODPlan1/admin/Error(1006032)
Invalid stored logical data block size [96].

Validate completed
sts = 1006032
Command Failed. Return Status = 1006032
localhost:PRODAPP:PRODPlan1:admin[1]->^C
[oracle@hyperion bin]$
Note: The file ./PRODPlan1_error2.log will give the errored combinations


 

EBS 12.2 Clone step by step

EBS 12.2 Clone step by step:

Introduction

The aim of this document to introduce the cloning process from production EBS to Test server including both application and database.

The same procedure can be used to refresh the database only

Below the main steps of the clone process:

1. Take a backup from production database
2. Copy the backup to test server
3. Restore the backup as PROD
4. Rename the database to TEST
5. Disable the archive log mode
6. Configure the database node
7. Execute the preclone on the production master server (ebs)
8.  Copy the $RUN_BASE/EBSapps to test server
9. Configure the RUN FS
10. Configure the Patch FS
11. Start the application and do some preliminary checks (login, start request, start Forms)

With the same, as recommended to change the apps password after every clone on the test to not share the production password, the procedure included in the same document.

The procedure tested steps by steps for multiple operations.

Backup the production database

[oracle@db backups]$ cd /d01/PROD/db_scripts/ [oracle@db db_scripts]$ rman target / @backupdb.full_PROD_BA.rman

Create pfile from the spfile

[oracle@test bkp]$ !sql sqlplus / as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Mon Feb 5 18:37:33 2018 Copyright (c) 1982, 2014, Oracle.  All rights reserved. Connected to an idle instance. SQL> create pfile='/home/oradb/bkp/initPROD.ora' from spfile='/home/oradb/bkp/spfilePROD.ora'; File created. SQL>

Change the necessary parameters

Start the database as PROD on test server

[oracle@test data]$ export ORACLE_SID=PROD [oracle@test bkp]$ !sql sqlplus / as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Mon Feb 5 18:43:08 2018 Copyright (c) 1982, 2014, Oracle.  All rights reserved. def Connected to an idle instance. SQL> DEFINE _DATE              = "05-FEB-18" (CHAR) DEFINE _CONNECT_IDENTIFIER = "PROD" (CHAR) DEFINE _USER           = "SYS" (CHAR) DEFINE _PRIVILEGE      = "AS SYSDBA" (CHAR) DEFINE _SQLPLUS_RELEASE = "1201000200" (CHAR) DEFINE _EDITOR         = "ed" (CHAR) DEFINE _O_VERSION      = "" (CHAR) DEFINE _O_RELEASE      = "" (CHAR) SQL> SQL> startup nomount pfile='/home/oradb/bkp/initPROD.ora'; ORA-32006: SEC_CASE_SENSITIVE_LOGON initialization parameter has been deprecated ORACLE instance started. Total System Global Area 2684354560 bytes Fixed Size                  2928008 bytes Variable Size            1879048824 bytes Database Buffers          788529152 bytes Redo Buffers               13848576 bytes SQL>

Restore control files

[oracle@test bkp]$ rman target / Recovery Manager: Release 12.1.0.2.0 - Production on Mon Feb 5 18:44:27 2018 Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved. connected to target database: PROD (not mounted) RMAN> restore controlfile from '/home/oradb/bkp/c-762427319-20180205-01'; Starting restore at 05-FEB-18 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=3601 device type=DISK channel ORA_DISK_1: restoring control file channel ORA_DISK_1: restore complete, elapsed time: 00:00:01 output file name=/home/oradb/TEST/data/cntrl01.dbf output file name=/home/oradb/TEST/data/cntrl02.dbf output file name=/home/oradb/TEST/data/cntrl03.dbf Finished restore at 05-FEB-18 RMAN>

Mount the database

SQL> alter database mount; Database altered. SQL>

Catalog the backup

[oracle@test bkp]$ rman target / Recovery Manager: Release 12.1.0.2.0 - Production on Mon Feb 5 18:49:24 2018 Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved. connected to target database: PROD (DBID=762427319, not open) RMAN> catalog start with '/home/oradb/bkp/CLONE_PROD'; using target database control file instead of recovery catalog searching for all files that match the pattern /home/oradb/bkp/CLONE_PROD List of Files Unknown to the Database ===================================== File Name: /home/oradb/bkp/CLONE_PROD_hlsqg10j_1_1 File Name: /home/oradb/bkp/CLONE_PROD_hlsqg10j_1_2 File Name: /home/oradb/bkp/CLONE_PROD_hmsqg10j_1_1 ….. File Name: /home/oradb/bkp/CLONE_PROD_ibsqg1ak_1_1 File Name: /home/oradb/bkp/CLONE_PROD_ibsqg1ak_1_2 File Name: /home/oradb/bkp/CLONE_PROD_icsqg1es_1_1 File Name: /home/oradb/bkp/CLONE_PROD_icsqg1es_1_2 Do you really want to catalog the above files (enter YES or NO)? yes cataloging files... cataloging done List of Cataloged Files ======================= File Name: /home/oradb/bkp/CLONE_PROD_hlsqg10j_1_1 File Name: /home/oradb/bkp/CLONE_PROD_hlsqg10j_1_2 ….. File Name: /home/oradb/bkp/CLONE_PROD_icsqg1es_1_1 File Name: /home/oradb/bkp/CLONE_PROD_icsqg1es_1_2 RMAN> RMAN> crosscheck backup; allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=2407 device type=DISK allocated channel: ORA_DISK_2 channel ORA_DISK_2: SID=6 device type=DISK crosschecked backup piece: found to be 'AVAILABLE' … crosschecked backup piece: found to be 'EXPIRED' backup piece handle=/d04/backups/data/CLONE_PROD_icsqg1es_1_2 RECID=2502 STAMP=967312860 Crosschecked 279 objects RMAN> RMAN> delete expired backup; using channel ORA_DISK_1 using channel ORA_DISK_2 … … 2500    1331    1   2   EXPIRED     DISK        /d04/backups/data/CLONE_PROD_hssqg10o_1_2 2501    1332    1   1   EXPIRED     DISK        /d04/backups/data/CLONE_PROD_icsqg1es_1_1 2502    1332    1   2   EXPIRED     DISK        /d04/backups/data/CLONE_PROD_icsqg1es_1_2 Do you really want to delete the above objects (enter YES or NO)? yes deleted backup piece backup piece handle=/d01/backups/data/FULLBKP_PROD_dvsq8ib7_1_1 RECID=2219 STAMP=967068007 deleted backup piece … deleted backup piece backup piece handle=/d04/backups/data/CLONE_PROD_icsqg1es_1_2 RECID=2502 STAMP=967312860 Deleted 279 EXPIRED objects RMAN> RMAN> list backup summary; List of Backups =============== Key     TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag ------- -- -- - ----------- --------------- ------- ------- ---------- --- 1309    B  A  A DISK        05-FEB-18       1       2       YES        DATABASE FULL BACKUP FOR CLONE 1310    B  A  A DISK        05-FEB-18       1       2       YES        DATABASE FULL BACKUP FOR CLONE 1311    B  A  A DISK        05-FEB-18       1       2       YES        DATABASE FULL BACKUP FOR CLONE 1312    B  A  A DISK        05-FEB-18       1       2       YES        DATABASE FULL BACKUP FOR CLONE 1313    B  A  A DISK        05-FEB-18       1       2       YES        DATABASE FULL BACKUP FOR CLONE 1314    B  A  A DISK        05-FEB-18       1       2       YES        DATABASE FULL BACKUP FOR CLONE 1315    B  A  A DISK        05-FEB-18       1       2       YES        DATABASE FULL BACKUP FOR CLONE 1316    B  0  A DISK        05-FEB-18       1       2       YES        TAG20180205T175327 1317    B  0  A DISK        05-FEB-18       1       2       YES        TAG20180205T175327 1318    B  0  A DISK        05-FEB-18       1       2       YES        TAG20180205T175327 1319    B  0  A DISK        05-FEB-18       1       2       YES        TAG20180205T175327 1320    B  0  A DISK        05-FEB-18       1       2       YES        TAG20180205T175327 1321    B  0  A DISK        05-FEB-18       1       2       YES        TAG20180205T175327 1322    B  0  A DISK        05-FEB-18       1       2       YES        TAG20180205T175327 1323    B  0  A DISK        05-FEB-18       1       2       YES        TAG20180205T175327 1324    B  0  A DISK        05-FEB-18       1       2       YES        TAG20180205T175327 1325    B  0  A DISK        05-FEB-18       1       2       YES        TAG20180205T175327 1326    B  0  A DISK        05-FEB-18       1       2       YES        TAG20180205T175327 1327    B  0  A DISK        05-FEB-18       1       2       YES        TAG20180205T175327 1328    B  0  A DISK        05-FEB-18       1       2       YES        TAG20180205T175327 1329    B  0  A DISK        05-FEB-18       1       2       YES        TAG20180205T175327 1330    B  0  A DISK        05-FEB-18       1       2       YES        TAG20180205T175327 1331    B  0  A DISK        05-FEB-18       1       2       YES        TAG20180205T175327 1332    B  A  A DISK        05-FEB-18       1       2       YES        DATABASE FULL BACKUP FOR CLONE RMAN>

Rename the data files;

select '  Set Newname For Datafile ' || file# || ' to '''|| replace(replace(name,'/d02/PROD/data/','/home/oradb/TEST/data/'),'/d01/PROD/data/','/home/oradb/TEST/data/') || ''';' from v$datafile; output: Set Newname For Datafile 1 to '/home/oradb/TEST/data/system01.dbf';   Set Newname For Datafile 2 to '/home/oradb/TEST/data/system02.dbf';   Set Newname For Datafile 3 to '/home/oradb/TEST/data/system03.dbf';   Set Newname For Datafile 4 to '/home/oradb/TEST/data/system04.dbf';   Set Newname For Datafile 5 to '/home/oradb/TEST/data/system05.dbf';   …..   Set Newname For Datafile 403 to '/home/oradb/TEST/data/a_txn_ind02.dbf';   Set Newname For Datafile 404 to '/home/oradb/TEST/data/a_txn_ind03.dbf';   Set Newname For Datafile 405 to '/home/oradb/TEST/data/a_txn_ind04.dbf';   Set Newname For Datafile 406 to '/home/oradb/TEST/data/a_txn_ind05.dbf';   Set Newname For Datafile 407 to '/home/oradb/TEST/data/a_ref02.dbf';

Restore / recover the database:

RMAN> run { Set Newname For Datafile 1 to '/home/oradb/TEST/data/system01.dbf';   Set Newname For Datafile 2 to '/home/oradb/TEST/data/system02.dbf';   Set Newname For Datafile 3 to '/home/oradb/TEST/data/system03.dbf';   Set Newname For Datafile 4 to '/home/oradb/TEST/data/system04.dbf';   Set Newname For Datafile 5 to '/home/oradb/TEST/data/system05.dbf';  … RESTORE DATABASE;     SWITCH DATAFILE ALL; } executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME … … input datafile copy RECID=196 STAMP=967317851 file name=/home/oradb/TEST/data/a_txn_ind05.dbf datafile 407 switched to datafile copy input datafile copy RECID=197 STAMP=967317851 file name=/home/oradb/TEST/data/a_ref02.dbf RMAN> recover database; Starting recover at 05-FEB-18 using channel ORA_DISK_1 using channel ORA_DISK_2 starting media recovery channel ORA_DISK_1: starting archived log restore to default destination channel ORA_DISK_1: restoring archived log archived log thread=1 sequence=1020 channel ORA_DISK_1: reading from backup piece /home/oradb/bkp/CLONE_PROD_icsqg1es_1_1 channel ORA_DISK_1: piece handle=/home/oradb/bkp/CLONE_PROD_icsqg1es_1_1 tag=DATABASE FULL BACKUP FOR CLONE channel ORA_DISK_1: restored backup piece 1 channel ORA_DISK_1: restore complete, elapsed time: 00:00:01 archived log file name=/home/oradb/TEST/archivelogs/1_1020_961687373.dbf thread=1 sequence=1020 unable to find archived log archived log thread=1 sequence=1021 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of recover command at 02/05/2018 20:56:47 RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 1021 and starting SCN of 5965245111520 RMAN>

Note: ignore the error as we do a point in time restore/recovery (simulate archive and redo log online loss)

Rename redo log members and open the database

select 'Alter Database Rename File '''||member||''' to '''||replace(replace(MEMBER,'/d02/PROD/data/','/home/oradb/TEST/data/'),'/d01/PROD/data/','/home/oradb/TEST/data/') ||''';' from v$logfile; Alter Database Rename File '/d01/PROD/data/log01a.dbf' to '/home/oradb/TEST/data/log01a.dbf'; Alter Database Rename File '/d02/PROD/data/log02b.dbf' to '/home/oradb/TEST/data/log02b.dbf'; Alter Database Rename File '/d02/PROD/data/log01b.dbf' to '/home/oradb/TEST/data/log01b.dbf'; Alter Database Rename File '/d01/PROD/data/log03a' to '/home/oradb/TEST/data/log03a'; Alter Database Rename File '/d02/PROD/data/log03b' to '/home/oradb/TEST/data/log03b'; Alter Database Rename File '/d01/PROD/data/log04a' to '/home/oradb/TEST/data/log04a'; Alter Database Rename File '/d02/PROD/data/log04b' to '/home/oradb/TEST/data/log04b'; Alter Database Rename File '/d01/PROD/data/log05a' to '/home/oradb/TEST/data/log05a'; Alter Database Rename File '/d02/PROD/data/log05b' to '/home/oradb/TEST/data/log05b'; Alter Database Rename File '/d01/PROD/data/log06a' to '/home/oradb/TEST/data/log06a'; Alter Database Rename File '/d02/PROD/data/log06b' to '/home/oradb/TEST/data/log06b'; Alter Database Rename File '/d01/PROD/data/log02a.dbf' to '/home/oradb/TEST/data/log02a.dbf'; No need to execute this part select 'ALTER DATABASE ADD LOGFILE MEMBER ''' || member ||'_tst'' to group '|| GROUP#||';' from V$LOGFILE ; ALTER DATABASE ADD LOGFILE MEMBER '/home/oradb/TEST/data/log01a.dbf_tst' to group 1; ALTER DATABASE ADD LOGFILE MEMBER '/home/oradb/TEST/data/log02b.dbf_tst' to group 2; ALTER DATABASE ADD LOGFILE MEMBER '/home/oradb/TEST/data/log01b.dbf_tst' to group 1; ALTER DATABASE ADD LOGFILE MEMBER '/home/oradb/TEST/data/log03a_tst' to group 3; ALTER DATABASE ADD LOGFILE MEMBER '/home/oradb/TEST/data/log03b_tst' to group 3; ALTER DATABASE ADD LOGFILE MEMBER '/home/oradb/TEST/data/log04a_tst' to group 4; ALTER DATABASE ADD LOGFILE MEMBER '/home/oradb/TEST/data/log04b_tst' to group 4; ALTER DATABASE ADD LOGFILE MEMBER '/home/oradb/TEST/data/log05a_tst' to group 5; ALTER DATABASE ADD LOGFILE MEMBER '/home/oradb/TEST/data/log05b_tst' to group 5; ALTER DATABASE ADD LOGFILE MEMBER '/home/oradb/TEST/data/log06a_tst' to group 6; ALTER DATABASE ADD LOGFILE MEMBER '/home/oradb/TEST/data/log06b_tst' to group 6; ALTER DATABASE ADD LOGFILE MEMBER '/home/oradb/TEST/data/log02a.dbf_tst' to group 2; SQL> select status from v$instance; STATUS ------------ MOUNTED SQL> alter database open resetlogs; alter database open resetlogs * ERROR at line 1: ORA-00392: log 1 of thread 1 is being cleared, operation not allowed ORA-00312: online log 1 thread 1: '/home/oradb/TEST/data/log01b.dbf' ORA-00312: online log 1 thread 1: '/home/oradb/TEST/data/log01a.dbf' ORA-00312: online log 1 thread 1: '/home/oradb/TEST/data/log01a.dbf_tst' ORA-00312: online log 1 thread 1: '/home/oradb/TEST/data/log01b.dbf_tst' SQL> select group#,thread#,status from v$log;     GROUP#    THREAD# STATUS ---------- ---------- ----------------          1          1 CLEARING_CURRENT          2          1 CLEARING          3          2 CLEARING          4          2 CLEARING          5          3 CLEARING          6          3 CLEARING 6 rows selected. SQL>  alter database clear logfile group 1; Database altered. SQL> select group#,thread#,status from v$log;     GROUP#    THREAD# STATUS ---------- ---------- ----------------          1          1 CURRENT          2          1 CLEARING          3          2 CLEARING          4          2 CLEARING          5          3 CLEARING          6          3 CLEARING 6 rows selected.

Open the database

SQL> alter database open resetlogs; Database altered. SQL>  Alter system switch logfile; System altered. SQL>  Alter system switch logfile; System altered.

Disable archive log mode

As the database will use for test only, no need to keep the archive log mode enabled

Below the step to disable it

SQL> select log_mode from v$database; LOG_MODE ------------ ARCHIVELOG SQL> shut immediate Database closed. Database dismounted. ORACLE instance shut down. SQL> SQL> startup nomount pfile='/home/oradb/bkp/initPROD.ora'; ORA-32006: SEC_CASE_SENSITIVE_LOGON initialization parameter has been deprecated ORACLE instance started. Total System Global Area 2684354560 bytes Fixed Size                  2928008 bytes Variable Size            1879048824 bytes Database Buffers          788529152 bytes Redo Buffers               13848576 bytes SQL> SQL> Alter database mount; Database altered. SQL> alter database noarchivelog; Database altered. SQL> alter database open; Database altered. SQL> SQL> archive log list Database log mode              No Archive Mode Automatic archival             Disabled Archive destination            /home/oradb/TEST/archivelogs Oldest online log sequence     10 Current log sequence           11 SQL>

Add new temporary files / drop old temp files

With database restoren the temporary files are not concerned by the restore operation, and we need to add new temporaray data file in the new server as below:

SQL> select ts# from v$tempfile;        TS# ----------        284        394        284 SQL> select name from v$tablespace where ts# in (284,394,284); NAME ------------------------------ TEMP1 TEMP2 SQL>  Alter tablespace temp1 add tempfile '/home/oradb/TEST/data/temp1.dbf' size 100M autoextend on next 10M; Tablespace altered. SQL> SQL> Alter tablespace temp2 add tempfile '/home/oradb/TEST/data/temp21.dbf' size 100M autoextend on next 10M; Tablespace altered. SQL> SQL>  alter tablespace temp1 drop tempfile '/d02/PROD/data/temp01.dbf'; Tablespace altered. SQL> alter tablespace temp1 drop tempfile '/d02/PROD/data/temp0001.dbf'; Tablespace altered. SQL>  alter tablespace temp2  drop tempfile '/d02/PROD/data/temp02.dbf'; Tablespace altered. SQL>

Rename the database

The restored database takes the same name as production, we use the nid utility to change it to the corresponding environment (Test, DEV, UAT)

[oracle@test data]$ !sql sqlplus / as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Mon Feb 5 21:38:02 2018 Copyright (c) 1982, 2014, Oracle.  All rights reserved. Connected to an idle instance. SQL> startup nomount pfile='/home/oradb/bkp/initPROD.ora'; ORA-32006: SEC_CASE_SENSITIVE_LOGON initialization parameter has been deprecated ORACLE instance started. Total System Global Area 2684354560 bytes Fixed Size                  2928008 bytes Variable Size            1879048824 bytes Database Buffers          788529152 bytes Redo Buffers               13848576 bytes SQL> alter database mount; Database altered. SQL> exit Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options [oracle@test data]$ [oracle@test data]$ nid target=/ DBNAME=TEST DBNEWID: Release 12.1.0.2.0 - Production on Mon Feb 5 21:40:09 2018 Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved. Connected to database PROD (DBID=762427319) Connected to server version 12.1.0 Control Files in database:     /home/oradb/TEST/data/cntrl01.dbf     /home/oradb/TEST/data/cntrl02.dbf     /home/oradb/TEST/data/cntrl03.dbf Change database ID and database name PROD to TEST? (Y/[N]) => Y Proceeding with operation Changing database ID from 762427319 to 923625657 Changing database name from PROD to TEST     Control File /home/oradb/TEST/data/cntrl01.dbf - modified     Control File /home/oradb/TEST/data/cntrl02.dbf - modified     Control File /home/oradb/TEST/data/cntrl03.dbf - modified     Datafile /home/oradb/TEST/data/system01.db - dbid changed, wrote new name … …    Control File /home/oradb/TEST/data/cntrl03.dbf - dbid changed, wrote new name     Instance shut down Database name changed to TEST. Modify parameter file and generate a new password file before restarting. Database ID for database TEST changed to 923625657. All previous backups and archived redo logs for this database are unusable. Database has been shutdown, open database with RESETLOGS option. Succesfully changed database name and ID. DBNEWID - Completed succesfully. [oracle@test data]$ [oracle@test data]$ export ORACLE_SID=TEST Check the Control files [oracle@test dbs]$ grep control initTEST.ora #       of the control files. #       There should be at least two control files, preferably three, #       located on different disks. The control files can dynamically grow, control_files                   = /home/oradb/TEST/data/cntrl01.dbf,/home/oradb/TEST/data/cntrl02.dbf,/home/oradb/TEST/data/cntrl03.dbf #       The log writer parameters control the size of the log buffer #       The checkpoint interval and timeout control the frequency of [oracle@test dbs]$ ll /home/oradb/TEST/data/cntrl0* -rw-r----- 1 oracle oinstall 35864576 Feb  5 21:40 /home/oradb/TEST/data/cntrl01.dbf -rw-r----- 1 oracle oinstall 35864576 Feb  5 21:40 /home/oradb/TEST/data/cntrl02.dbf -rw-r----- 1 oracle oinstall 35864576 Feb  5 21:40 /home/oradb/TEST/data/cntrl03.dbf [oracle@test dbs]$ [oracle@test dbs]$ sqlplus / as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Mon Feb 5 21:42:45 2018 Copyright (c) 1982, 2014, Oracle.  All rights reserved. Connected to an idle instance. SQL> startup nomount; ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance ORACLE instance started. Total System Global Area 2147483648 bytes Fixed Size                  2926472 bytes Variable Size            1392511096 bytes Database Buffers          738197504 bytes Redo Buffers               13848576 bytes SQL> Alter database mount; Database altered. SQL> Alter Database Open ResetLogs; Database altered. SQL> select name from v$database; NAME --------- TEST SQL>

Configure database

Clean the production configuration

[oracle@test ~]$ sqlplus apps SQL*Plus: Release 12.1.0.2.0 Production on Mon Feb 5 21:56:56 2018 Copyright (c) 1982, 2014, Oracle.  All rights reserved. Enter password: ***** Last Successful login time: Mon Feb 05 2018 18:00:00 +01:00 Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options SQL> def DEFINE _DATE           = "05-FEB-18" (CHAR) DEFINE _CONNECT_IDENTIFIER = "TEST" (CHAR) DEFINE _USER            = "APPS" (CHAR) DEFINE _PRIVILEGE      = "" (CHAR) DEFINE _SQLPLUS_RELEASE = "1201000200" (CHAR) DEFINE _EDITOR        = "ed" (CHAR) DEFINE _O_VERSION      = "Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options" (CHAR) DEFINE _O_RELEASE      = "1201000200" (CHAR) SQL> select node_name from fnd_nodes; NODE_NAME -------------------------------------------------------------------------------- AUTHENTICATION EBS DB SQL> SQL> exec fnd_conc_clone.setup_clean; PL/SQL procedure successfully completed. SQL> commit; Commit complete. SQL> SQL> select node_name from fnd_nodes; no rows selected SQL>

Autoconfig for database

Start listener

[oracle@test TEST_test]$ ./addlnctl.sh start TEST Logfile: /home/oradb/TEST/12.1.0/appsutil/log/TEST_test/addlnctl.txt You are running addlnctl.sh version 120.4 Starting listener process TEST ... LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 05-FEB-2018 22:05:53 Copyright (c) 1991, 2014, Oracle.  All rights reserved. Starting /home/oradb/TEST/12.1.0/bin/tnslsnr: please wait... TNSLSNR for Linux: Version 12.1.0.2.0 - Production System parameter file is /home/oradb/TEST/12.1.0/network/admin/TEST_test/listener.ora Log messages written to /home/oradb/TEST/12.1.0/admin/TEST_test/diag/tnslsnr/test/TEST/alert/log.xml Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=test.domain .com)(PORT=1521))) Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=test.domain .com)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias                     TEST Version                   TNSLSNR for Linux: Version 12.1.0.2.0 - Production Start Date                05-FEB-2018 22:05:53 Uptime                    0 days 0 hr. 0 min. 0 sec Trace Level               off Security                  ON: Local OS Authentication SNMP                      OFF Listener Parameter File   /home/oradb/TEST/12.1.0/network/admin/TEST_test/listener.ora Listener Log File         /home/oradb/TEST/12.1.0/admin/TEST_test/diag/tnslsnr/test/TEST/alert/log.xml Listening Endpoints Summary...   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=test.domain .com)(PORT=1521))) Services Summary... Service "TEST" has 1 instance(s).   Instance "TEST", status UNKNOWN, has 1 handler(s) for this service... The command completed successfully addlnctl.sh: exiting with status 0 addlnctl.sh: check the logfile /home/oradb/TEST/12.1.0/appsutil/log/TEST_test/addlnctl.txt for more information ...  [oracle@test TEST_test]$

[oracle@test TEST_test]$ ./adautocfg.sh Enter the APPS user password:***** The log file for this session is located at: /home/oradb/TEST/12.1.0/appsutil/log/TEST_test/02052206/adconfig.log AutoConfig is configuring the Database environment... AutoConfig will consider the custom templates if present.               Using ORACLE_HOME location : /home/oradb/TEST/12.1.0               Classpath                   : :/home/oradb/TEST/12.1.0/jdbc/lib/ojdbc6.jar:/home/oradb/TEST/12.1.0/appsutil/java/xmlparserv2.jar:/home/oradb/TEST/12.1.0/appsutil/java:/home/oradb/TEST/12.1.0/jlib/netcfg.jar:/home/oradb/TEST/12.1.0/jlib/ldapjclnt12.jar               Using Context file          : /home/oradb/TEST/12.1.0/appsutil/TEST_test.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. [oracle@test TEST_test]$

Checks

[oracle@test TEST_test]$ !sql sqlplus apps SQL*Plus: Release 12.1.0.2.0 Production on Mon Feb 5 22:08:01 2018 Copyright (c) 1982, 2014, Oracle.  All rights reserved. Enter password: ***** Last Successful login time: Mon Feb 05 2018 22:06:29 +01:00 Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options SQL> select node_name from fnd_nodes; NODE_NAME -------------------------------------------------------------------------------- TEST SQL>

Preclone Prod  

Ssh applmgr@ebs's password: ***** Last login: Mon Feb  5 08:46:13 2018 from 10.35.32.216   E-Business Suite Environment Information   ----------------------------------------   RUN File System           : /a01/PROD/fs1/EBSapps/appl   PATCH File System         : /a01/PROD/fs2/EBSapps/appl   Non-Editioned File System : /a01/PROD/fs_ne   DB Host: ebs-prd-db1.domain.com  Service/SID: PROD   Sourcing the RUN File System ... [applmgr@ebs ~]$

[applmgr@ebs ~]$ adpreclone.pl appsTier                      Copyright (c) 2011, 2014 Oracle Corporation                         Redwood Shores, California, USA                         Oracle E-Business Suite Rapid Clone                                  Version 12.2                       adpreclone Version 120.31.12020000.22 Enter the APPS User Password: ***** Enter the Weblogic AdminServer password : *****  Checking the status of the Oracle WebLogic Administration Server....  Running perl /a01/PROD/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/adProvisionEBS.pl ebs-get-serverstatus -contextfile=/a01/PROD/fs1/inst/apps/PROD_ebs/appl/admin/PROD_ebs.xml -servername=AdminServer -promptmsg=hide  The Oracle WebLogic Administration Server is up. Running: perl /a01/PROD/fs1/EBSapps/appl/ad/12.0.0/bin/adclone.pl java=/a01/PROD/fs1/EBSapps/comn/util/jdk64 mode=stage stage=/a01/PROD/fs1/EBSapps/comn/clone component=appsTier method= appctx=/a01/PROD/fs1/inst/apps/PROD_ebs/appl/admin/PROD_ebs.xml showProgress  Setting the wls environment Beginning application tier Stage - Mon Feb  5 22:17:59 2018 /a01/PROD/fs1/EBSapps/comn/util/jdk64/bin/java -Xmx600M -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/oui -classpath /a01/PROD/fs1/FMW_Home/webtier/lib/xmlparserv2.jar:/a01/PROD/fs1/FMW_Home/webtier/jdbc/lib/ojdbc6.jar:/a01/PROD/fs1/EBSapps/comn/java/classes:/a01/PROD/fs1/FMW_Home/webtier/oui/jlib/OraInstaller.jar:/a01/PROD/fs1/FMW_Home/webtier/oui/jlib/ewt3.jar:/a01/PROD/fs1/FMW_Home/webtier/oui/jlib/share.jar:/a01/PROD/fs1/FMW_Home/webtier/../Oracle_EBS-app1/oui/jlib/srvm.jar:/a01/PROD/fs1/FMW_Home/webtier/jlib/ojmisc.jar:/a01/PROD/fs1/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:/a01/PROD/fs1/FMW_Home/oracle_common/jlib/obfuscatepassword.jar  oracle.apps.ad.clone.StageAppsTier -e /a01/PROD/fs1/inst/apps/PROD_ebs/appl/admin/PROD_ebs.xml -stage /a01/PROD/fs1/EBSapps/comn/clone -tmp /tmp -method CUSTOM   -showProgress -nopromptmsg Log file located at /a01/PROD/fs1/inst/apps/PROD_ebs/admin/log/clone/StageAppsTier_02052218.log   \     20% completed       Completed Stage... Mon Feb  5 22:24:39 2018 [applmgr@ebs ~]$

Copy the files from the RUN fs to the test server

[applmgr@ ebs ~]$ scp –R /a01/PROD/fs1/EBSapps applmgr@test :/home/apps/TEST/fs1/EBSapps

Clean the inventory

applmgr@test ContentsXML]$ cat /etc/oraInst.loc # Oracle Inventory des software inventory_loc=/home/oraInventory #Group d'installation des softwares inst_group=oinstall [applmgr@test ContentsXML]$

[applmgr@test ContentsXML]$ cat inventory.xml <?xml version="1.0" standalone="yes" ?> <!-- Copyright (c) 2009 Oracle Corporation. All rights Reserved --> <!-- Do not modify the contents of this file by hand. --> <INVENTORY> <COMPOSITEHOME_LIST> </COMPOSITEHOME_LIST> <VERSION_INFO>    <SAVED_WITH>10.1.0.6.0</SAVED_WITH>    <MINIMUM_VER>2.1.0.6.0</MINIMUM_VER> </VERSION_INFO> <HOME_LIST> </HOME_LIST> </INVENTORY> [applmgr@test ContentsXML]$

Config clone

Note : The config clone can be executed in a single step using the dualfs option as below :

[applmgr@test bin]$ perl adcfgclone.pl appsTier dualfs

Configure RUN FS

[applmgr@test ContentsXML]$ cd /home/apps/TEST/fs1/EBSapps/comn/clone/bin/ applmgr@test bin]$ perl adcfgclone.pl appsTier                      Copyright (c) 2002, 2015 Oracle Corporation                         Redwood Shores, California, USA                         Oracle E-Business Suite Rapid Clone                                  Version 12.2                       adcfgclone Version 120.63.12020000.60                             ***********************************************************                             In AD-TXK Delta 7, we recommend you clone the run and patch                             file systems in a single operation using the 'dualfs' option.                             Separate cloning of the run and patch file systems will be deprecated                             ************************************************************ Enter the APPS password : **** Enter the Weblogic AdminServer password : **** Do you want to add a node (yes/no) [no] : Running: Context clone... Log file located at /home/apps/TEST/fs1/EBSapps/comn/clone/bin/CloneContext_0205233106.log Target System File Edition type [run] : Provide the values required for creation of the new APPL_TOP Context file. Target System Hostname (virtual or normal) [test] : Target System Database SID : TEST Target System Database Server Node [test] : Target System Database Domain Name [domain .com] : Target System Base Directory : /home/apps/TEST Target System Base Directory set to /home/apps/TEST Target System Current File System Base set to /home/apps/TEST/fs1 Target System Other File System Base set to /home/apps/TEST/fs2 Target System Fusion Middleware Home set to /home/apps/TEST/fs1/FMW_Home Target System Web Oracle Home set to /home/apps/TEST/fs1/FMW_Home/webtier Target System Appl TOP set to /home/apps/TEST/fs1/EBSapps/appl Target System COMMON TOP set to /home/apps/TEST/fs1/EBSapps/comn Target System Instance Home Directory [/home/apps/TEST] : Target System Instance Top set to /home/apps/TEST/fs1/inst/apps/TEST_test Do you want to preserve the Display [ebs:0.0] (y/n)  : n Target System Display [test:0.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] ? : Validating if the source port numbers are available on the target system.. Complete port information available at /home/apps/TEST/fs1/EBSapps/comn/clone/bin/out/TEST_test/portpool.lst UTL_FILE_DIR on database tier consists of the following directories. 1. /usr/tmp 2. /usr/tmp 3. /home/oradb/TEST/12.1.0/appsutil/outbound/TEST_test 4. /usr/tmp Choose a value which will be set as APPLPTMP value on the target node [1] : 3 The new APPL_TOP context file has been created :   /home/apps/TEST/fs1/inst/apps/TEST_test/appl/admin/TEST_test.xml Check Clone Context logfile /home/apps/TEST/fs1/EBSapps/comn/clone/bin/CloneContext_0205233106.log for details. Running Rapid Clone with command: Running: perl /home/apps/TEST/fs1/EBSapps/comn/clone/bin/adclone.pl java=/home/apps/TEST/fs1/EBSapps/comn/clone/bin/../jre mode=apply stage=/home/apps/TEST/fs1/EBSapps/comn/clone component=appsTier method=CUSTOM appctxtg=/home/apps/TEST/fs1/inst/apps/TEST_test/appl/admin/TEST_test.xml showProgress contextValidated=true FMW Pre-requisite check log file location : /home/apps/TEST/fs1/EBSapps/comn/clone/FMW/logs/prereqcheck.log Running: /home/apps/TEST/fs1/EBSapps/comn/clone/FMW/t2pjdk/bin/java -classpath /home/apps/TEST/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/engine.jar:/home/apps/TEST/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraPrereq.jar:/home/apps/TEST/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraPrereqChecks.jar:/home/apps/TEST/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraInstaller.jar:/home/apps/TEST/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraInstallerNet.jar:/home/apps/TEST/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/srvm.jar:/home/apps/TEST/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl.jar:/home/apps/TEST/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl2.jar:/home/apps/TEST/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl-log4j.jar:/home/apps/TEST/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/xmlparserv2.jar:/home/apps/TEST/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/share.jar:/home/apps/TEST/fs1/EBSapps/comn/clone/jlib/java oracle.apps.ad.clone.util.FMWOracleHomePreReqCheck -prereqCheckFMW -e /home/apps/TEST/fs1/inst/apps/TEST_test/appl/admin/TEST_test.xml -stage /home/apps/TEST/fs1/EBSapps/comn/clone -log /home/apps/TEST/fs1/EBSapps/comn/clone/FMW/logs/prereqcheck.log Beginning application tier Apply - Mon Feb  5 23:33:25 2018 /home/apps/TEST/fs1/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true -Doracle.installer.oui_loc=/oui -classpath /home/apps/TEST/fs1/EBSapps/comn/clone/jlib/xmlparserv2.jar:/home/apps/TEST/fs1/EBSapps/comn/clone/jlib/ojdbc6.jar:/home/apps/TEST/fs1/EBSapps/comn/clone/jlib/java:/home/apps/TEST/fs1/EBSapps/comn/clone/jlib/oui/OraInstaller.jar:/home/apps/TEST/fs1/EBSapps/comn/clone/jlib/oui/ewt3.jar:/home/apps/TEST/fs1/EBSapps/comn/clone/jlib/oui/share.jar:/home/apps/TEST/fs1/FMW_Home/webtier/../Oracle_EBS-app1/oui/jlib/srvm.jar:/home/apps/TEST/fs1/EBSapps/comn/clone/jlib/ojmisc.jar:/home/apps/TEST/fs1/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:/home/apps/TEST/fs1/EBSapps/comn/clone/jlib/obfuscatepassword.jar  oracle.apps.ad.clone.ApplyAppsTier -e /home/apps/TEST/fs1/inst/apps/TEST_test/appl/admin/TEST_test.xml -stage /home/apps/TEST/fs1/EBSapps/comn/clone    -showProgress -nopromptmsg Log file located at /home/apps/TEST/fs1/inst/apps/TEST_test/admin/log/clone/ApplyAppsTier_02052333.log   \    100% completed       Completed Apply... Mon Feb  5 23:54:44 2018  Executing command: /home/apps/TEST/fs1/EBSapps/10.1.2/bin/sqlplus @/home/apps/TEST/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/truncate_ad_nodes_config_status.sql Do you want to startup the Application Services for TEST? (y/n) [n] : n Services not started Running: perl /home/apps/TEST/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/adcleansrccfg.pl context=/home/apps/TEST/fs1/inst/apps/TEST_test/appl/admin/TEST_test.xml promptmsg=hide logfile=/home/apps/TEST/fs1/inst/apps/TEST_test/admin/log/clone/ApplyAppsTier_02052333.log *** ALL THE FOLLOWING FILES ARE REQUIRED FOR RESOLVING RUNTIME ERRORS *** Log File = /home/apps/TEST/fs1/inst/apps/TEST_test/logs/appl/rgf/TXK/txkSetOAMReg_Mon_Feb_5_23_57_05_2018.log *** LOG FILE: /home/apps/TEST/fs1/inst/apps/TEST_test/admin/log/clone/ApplyAppsTier_02052333.log *** Removing SSO/OID references if present... Config Cleanup Complete [applmgr@test bin]$

 Check

applmgr@test ~]$ . .bash_profile   E-Business Suite Environment Information   ----------------------------------------   RUN File System           : /home/apps/TEST/fs1/EBSapps/appl   PATCH File System         : /home/apps/TEST/fs2/EBSapps/appl   Non-Editioned File System : /home/apps/TEST/fs_ne   DB Host: test.domain .com  Service/SID: TEST   Sourcing the RUN File System ... [applmgr@test ~]$ ll /home/apps/TEST/fs2/ total 0 [applmgr@test ~]$

Configure Patch FS

Preclone run FS

applmgr@test ~]$ . .bash_profile   E-Business Suite Environment Information   ----------------------------------------   RUN File System           : /home/apps/TEST/fs1/EBSapps/appl   PATCH File System         : /home/apps/TEST/fs2/EBSapps/appl   Non-Editioned File System : /home/apps/TEST/fs_ne   DB Host: test.domain .com  Service/SID: TEST   Sourcing the RUN File System ... [applmgr@test ~]$ ll /home/apps/TEST/fs2/ total 0 [applmgr@test ~]$ 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 /home/apps/TEST/fs1/inst/apps/TEST_test/logs/appl/admin/log/adadminsrvctl.txt for details AdminServer logs are located at /home/apps/TEST/fs1/FMW_Home/user_projects/domains/EBS_domain_TEST/servers/AdminServer/logs adadminsrvctl.sh: exiting with status 0 adadminsrvctl.sh: check the logfile /home/apps/TEST/fs1/inst/apps/TEST_test/logs/appl/admin/log/adadminsrvctl.txt for more information ...  [applmgr@test ~]$  [applmgr@test ~]$ [applmgr@test ~]$ adpreclone.pl appsTier                      Copyright (c) 2011, 2014 Oracle Corporation                         Redwood Shores, California, USA                         Oracle E-Business Suite Rapid Clone                                  Version 12.2                       adpreclone Version 120.31.12020000.22 Enter the APPS User Password: ****** Enter the Weblogic AdminServer password :******  Checking the status of the Oracle WebLogic Administration Server....  Running perl /home/apps/TEST/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/adProvisionEBS.pl ebs-get-serverstatus -contextfile=/home/apps/TEST/fs1/inst/apps/TEST_test/appl/admin/TEST_test.xml -servername=AdminServer -promptmsg=hide  The Oracle WebLogic Administration Server is up. Running: perl /home/apps/TEST/fs1/EBSapps/appl/ad/12.0.0/bin/adclone.pl java=/home/apps/TEST/fs1/EBSapps/comn/util/jdk64 mode=stage stage=/home/apps/TEST/fs1/EBSapps/comn/clone component=appsTier method= appctx=/home/apps/TEST/fs1/inst/apps/TEST_test/appl/admin/TEST_test.xml showProgress  Setting the wls environment Beginning application tier Stage - Tue Feb  6 00:06:20 2018 /home/apps/TEST/fs1/EBSapps/comn/util/jdk64/bin/java -Xmx600M -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/oui -classpath /home/apps/TEST/fs1/FMW_Home/webtier/lib/xmlparserv2.jar:/home/apps/TEST/fs1/FMW_Home/webtier/jdbc/lib/ojdbc6.jar:/home/apps/TEST/fs1/EBSapps/comn/java/classes:/home/apps/TEST/fs1/FMW_Home/webtier/oui/jlib/OraInstaller.jar:/home/apps/TEST/fs1/FMW_Home/webtier/oui/jlib/ewt3.jar:/home/apps/TEST/fs1/FMW_Home/webtier/oui/jlib/share.jar:/home/apps/TEST/fs1/FMW_Home/webtier/../Oracle_EBS-app1/oui/jlib/srvm.jar:/home/apps/TEST/fs1/FMW_Home/webtier/jlib/ojmisc.jar:/home/apps/TEST/fs1/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:/home/apps/TEST/fs1/FMW_Home/oracle_common/jlib/obfuscatepassword.jar  oracle.apps.ad.clone.StageAppsTier -e /home/apps/TEST/fs1/inst/apps/TEST_test/appl/admin/TEST_test.xml -stage /home/apps/TEST/fs1/EBSapps/comn/clone -tmp /tmp -method CUSTOM   -showProgress -nopromptmsg Log file located at /home/apps/TEST/fs1/inst/apps/TEST_test/admin/log/clone/StageAppsTier_02060006.log   |     20% completed       Completed Stage... Tue Feb  6 00:11:07 2018 [applmgr@test ~]$ [applmgr@test ~]$ cp –R /home/apps/TEST/fs1/EBSapps /home/apps/TEST/fs2/EBSapps

Configure patch FS

applmgr@test ~]$ cd /home/apps/TEST/fs2/EBSapps/comn/clone/bin/ [applmgr@test bin]$ perl adcfgclone.pl appsTier                      Copyright (c) 2002, 2015 Oracle Corporation                         Redwood Shores, California, USA                         Oracle E-Business Suite Rapid Clone                                  Version 12.2                       adcfgclone Version 120.63.12020000.60                             ***********************************************************                             In AD-TXK Delta 7, we recommend you clone the run and patch                             file systems in a single operation using the 'dualfs' option.                             Separate cloning of the run and patch file systems will be deprecated                             ************************************************************ Enter the APPS password : ****** Enter the Weblogic AdminServer password : ****** Do you want to add a node (yes/no) [no] : Running: Context clone... Log file located at /home/apps/TEST/fs2/EBSapps/comn/clone/bin/CloneContext_0206003053.log Target System File Edition type [run] : patch Enter the full path of Run File System Context file : /home/apps/TEST/fs1/inst/apps/TEST_test/appl/admin/TEST_test.xml Provide the values required for creation of the new APPL_TOP Context file. Target System Fusion Middleware Home set to /home/apps/TEST/fs2/FMW_Home Target System Web Oracle Home set to /home/apps/TEST/fs2/FMW_Home/webtier Target System Appl TOP set to /home/apps/TEST/fs2/EBSapps/appl Target System COMMON TOP set to /home/apps/TEST/fs2/EBSapps/comn Target System Instance Top set to /home/apps/TEST/fs2/inst/apps/TEST_test Target System Port Pool [0-99] : 1 Checking the port pool 1 done: Port Pool 1 is free Report file located at /home/apps/TEST/fs2/inst/apps/TEST_test/admin/out/portpool.lst The new APPL_TOP context file has been created :   /home/apps/TEST/fs2/inst/apps/TEST_test/appl/admin/TEST_test.xml Check Clone Context logfile /home/apps/TEST/fs2/EBSapps/comn/clone/bin/CloneContext_0206003053.log for details. Running Rapid Clone with command: Running: perl /home/apps/TEST/fs2/EBSapps/comn/clone/bin/adclone.pl java=/home/apps/TEST/fs2/EBSapps/comn/clone/bin/../jre mode=apply stage=/home/apps/TEST/fs2/EBSapps/comn/clone component=appsTier method=CUSTOM appctxtg=/home/apps/TEST/fs2/inst/apps/TEST_test/appl/admin/TEST_test.xml showProgress contextValidated=true FMW Pre-requisite check log file location : /home/apps/TEST/fs2/EBSapps/comn/clone/FMW/logs/prereqcheck.log Running: /home/apps/TEST/fs2/EBSapps/comn/clone/FMW/t2pjdk/bin/java -classpath /home/apps/TEST/fs2/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/engine.jar:/home/apps/TEST/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraPrereq.jar:/home/apps/TEST/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraPrereqChecks.jar:/home/apps/TEST/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraInstaller.jar:/home/apps/TEST/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraInstallerNet.jar:/home/apps/TEST/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/srvm.jar:/home/apps/TEST/fs2/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl.jar:/home/apps/TEST/fs2/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl2.jar:/home/apps/TEST/fs2/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl-log4j.jar:/home/apps/TEST/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/xmlparserv2.jar:/home/apps/TEST/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/share.jar:/home/apps/TEST/fs2/EBSapps/comn/clone/jlib/java oracle.apps.ad.clone.util.FMWOracleHomePreReqCheck -prereqCheckFMW -e /home/apps/TEST/fs2/inst/apps/TEST_test/appl/admin/TEST_test.xml -stage /home/apps/TEST/fs2/EBSapps/comn/clone -log /home/apps/TEST/fs2/EBSapps/comn/clone/FMW/logs/prereqcheck.log Beginning application tier Apply - Tue Feb  6 00:36:31 2018 /home/apps/TEST/fs2/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true -Doracle.installer.oui_loc=/oui -classpath /home/apps/TEST/fs2/EBSapps/comn/clone/jlib/xmlparserv2.jar:/home/apps/TEST/fs2/EBSapps/comn/clone/jlib/ojdbc6.jar:/home/apps/TEST/fs2/EBSapps/comn/clone/jlib/java:/home/apps/TEST/fs2/EBSapps/comn/clone/jlib/oui/OraInstaller.jar:/home/apps/TEST/fs2/EBSapps/comn/clone/jlib/oui/ewt3.jar:/home/apps/TEST/fs2/EBSapps/comn/clone/jlib/oui/share.jar:/home/apps/TEST/fs2/FMW_Home/webtier/../Oracle_EBS-app1/oui/jlib/srvm.jar:/home/apps/TEST/fs2/EBSapps/comn/clone/jlib/ojmisc.jar:/home/apps/TEST/fs2/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:/home/apps/TEST/fs2/EBSapps/comn/clone/jlib/obfuscatepassword.jar  oracle.apps.ad.clone.ApplyAppsTier -e /home/apps/TEST/fs2/inst/apps/TEST_test/appl/admin/TEST_test.xml -stage /home/apps/TEST/fs2/EBSapps/comn/clone    -showProgress -nopromptmsg Log file located at /home/apps/TEST/fs2/inst/apps/TEST_test/admin/log/clone/ApplyAppsTier_02060036.log   -    100% completed       Completed Apply... Tue Feb  6 00:58:58 2018 Looking for incomplete CLONE record in ad_adop_session_patches table The CLONE record status is no rows selected [applmgr@test bin]$

Start the application

[applmgr@test ~]$ adstrtal.sh You are running adstrtal.sh version 120.24.12020000.11 Enter the APPS username: apps Enter the APPS password: ***** Enter the WebLogic Server password: ***** The logfile for this session is located at /home/apps/TEST/fs1/inst/apps/TEST_test/logs/appl/admin/log/adstrtal.log …. All enabled services for this node are started. adstrtal.sh: Exiting with status 0 adstrtal.sh: check the logfile /home/apps/TEST/fs1/inst/apps/TEST_test/logs/appl/admin/log/adstrtal.log for more information ...  [applmgr@test ~]$

Test access to the application

In your explorer introduce the link http://test.domain .com:8000/

Change apps password

The password need to be changed on both Run and Patch file systems

Stop the application

[applmgr@test ~]$ adstpall.sh You are running adstpall.sh version 120.22.12020000.7 Enter the APPS username: apps Enter the APPS password: Enter the WebLogic Server password: The logfile for this session is located at /home/apps/TEST/fs1/inst/apps/TEST_test/logs/appl/admin/log/adstpall.log … All enabled services on this node are stopped. adstpall.sh:Exiting with status 0 adstpall.sh: check the logfile /home/apps/TEST/fs1/inst/apps/TEST_test/logs/appl/admin/log/adstpall.log for more information ...  [applmgr@test ~]$

FNDCPASS

[applmgr@test ~]$ FNDCPASS apps/changeme 0 Y system/manager SYSTEM APPLSYS apps Log filename : L642476.log Report filename : O642476.out [applmgr@test ~]$ [applmgr@test ~]$ FNDCPASS apps/apps 0 Y system/manager USER sysadmin sysadmin123

Check the log if the change done successfully

Start the admin server only

[applmgr@test ~]$ 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 /home/apps/TEST/fs1/inst/apps/TEST_test/logs/appl/admin/log/adadminsrvctl.txt for details AdminServer logs are located at /home/apps/TEST/fs1/FMW_Home/user_projects/domains/EBS_domain_TEST/servers/AdminServer/logs adadminsrvctl.sh: exiting with status 0 adadminsrvctl.sh: check the logfile /home/apps/TEST/fs1/inst/apps/TEST_test/logs/appl/admin/log/adadminsrvctl.txt for more information ...  [applmgr@test ~]$

Change data source password:

Connect to the weblogic admin console,

1.     Click on lock and Edit,

2.     In the Domain Structure tree, expand Services, then select Data Sources.

3.     Select the EBSDatasource

4.     On the “Settings for EBSDataSource” page, select the Connection Pool tab.

Enter the new password and confirm, than click save

5.     Click Activate Changes in Change Center.

6.     Execute autoconfig

[applmgr@test ~]$ adautocfg.sh Enter the APPS user password: The log file for this session is located at: /home/apps/TEST/fs1/inst/apps/TEST_test/admin/log/02060802/adconfig.log AutoConfig is configuring the Applications environment... AutoConfig will consider the custom templates if present.               Using CONFIG_HOME location     : /home/apps/TEST/fs1/inst/apps/TEST_test               Classpath                   : /home/apps/TEST/fs1/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar:/home/apps/TEST/fs1/EBSapps/comn/java/classes               Using Context file          : /home/apps/TEST/fs1/inst/apps/TEST_test/appl/admin/TEST_test.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               Configuring MSC_TOP.......COMPLETED               Configuring IEO_TOP.......COMPLETED               Configuring BIS_TOP.......COMPLETED               Configuring CZ_TOP........COMPLETED               Configuring SHT_TOP.......COMPLETED               Configuring AMS_TOP.......COMPLETED               Configuring CCT_TOP.......COMPLETED               Configuring WSH_TOP.......COMPLETED               Configuring CLN_TOP.......COMPLETED               Configuring OKE_TOP.......COMPLETED               Configuring OKL_TOP.......COMPLETED               Configuring OKS_TOP.......COMPLETED               Configuring CSF_TOP.......COMPLETED               Configuring IBY_TOP.......COMPLETED               Configuring JTF_TOP.......COMPLETED               Configuring MWA_TOP.......COMPLETED               Configuring CN_TOP........COMPLETED               Configuring CSI_TOP.......COMPLETED               Configuring WIP_TOP.......COMPLETED               Configuring CSE_TOP.......COMPLETED               Configuring EAM_TOP.......COMPLETED               Configuring GMF_TOP.......COMPLETED               Configuring PON_TOP.......COMPLETED               Configuring FTE_TOP.......COMPLETED               Configuring ONT_TOP.......COMPLETED               Configuring AR_TOP........COMPLETED               Configuring AHL_TOP.......COMPLETED               Configuring IES_TOP.......COMPLETED               Configuring OZF_TOP.......COMPLETED               Configuring CSD_TOP.......COMPLETED               Configuring IGC_TOP.......COMPLETED AutoConfig completed successfully. [applmgr@test ~]$

Start the application

[applmgr@test ~]$ adstrtal.sh You are running adstrtal.sh version 120.24.12020000.11 Enter the APPS username: apps Enter the APPS password: Enter the WebLogic Server password: The logfile for this session is located at /home/apps/TEST/fs1/inst/apps/TEST_test/logs/appl/admin/log/adstrtal.log …. All enabled services for this node are started. adstrtal.sh: Exiting with status 0 adstrtal.sh: check the logfile /home/apps/TEST/fs1/inst/apps/TEST_test/logs/appl/admin/log/adstrtal.log for more information ...  [applmgr@test ~]$

Test the data source

Patch FS

As the each WLS instance has it’s own and configuration, we need to change the datasource password to be the new password changed using FNDCPASS

Source the patch FS

[applmgr@test ~]$ . EBSapps.env patch

Start the AdminServer

[applmgr@test ~]$ adadminsrvctl.sh start  forcepatchfs

Change the password using the same steps described before.

Sync the patch Context file

[applmgr@test TEST]$ adadminsrvctl.sh start forcepatchfs 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 /home/apps/TEST/fs2/inst/apps/TEST_test/logs/appl/admin/log/adadminsrvctl.txt for details AdminServer logs are located at /home/apps/TEST/fs2/FMW_Home/user_projects/domains/EBS_domain_TEST/servers/AdminServer/logs adadminsrvctl.sh: exiting with status 0 adadminsrvctl.sh: check the logfile /home/apps/TEST/fs2/inst/apps/TEST_test/logs/appl/admin/log/adadminsrvctl.txt for more information ...  [applmgr@test TEST]$ perl $AD_TOP/bin/adSyncContext.pl contextfile=$CONTEXT_FILE Enter the APPS user password: Enter the WebLogic AdminServer password: The log file is /home/apps/TEST/fs2/inst/apps/TEST_test/logs/appl/rgf/Fri_Feb_9_19_17_27_2018/adSyncContext.log [applmgr@test TEST]$ vi /home/apps/TEST/fs2/inst/apps/TEST_test/logs/appl/rgf/Fri_Feb_9_19_17_27_2018/adSyncContext.log

Concurrent Manager issue:

The CM not started after the clone, no error was raised on the ICM log file

After investigation, we found the CM, need to access the ping command from the OS to check the availability of the EBS nodes

Status:

[applmgr@test ~]$ /bin/ping test ping: socket: Operation not permitted [applmgr@test ~]$ ping 127.0.0.1 ping: socket: Operation not permitted [applmgr@test ~]$

Check ping tool

[oracle@test ~]$ ls -al /bin/ping -rwxr-xr-x 1 root root 62088 Nov  4  2016 /bin/ping [oracle@test ~]$

Change the permissions

[root@test ~]# chmod 4755 /bin/ping [root@test ~]# [root@test ~]#  ls -al /bin/ping -rwsr-xr-x 1 root root 62088 Nov  4  2016 /bin/ping [root@test ~]#

Test with applmgr

[applmgr@test ~]$ /bin/ping test PING test.domain .com (172.30.1.50) 56(84) bytes of data. 64 bytes from test.domain .com (172.30.1.50): icmp_seq=1 ttl=64 time=0.051 ms 64 bytes from test.domain .com (172.30.1.50): icmp_seq=2 ttl=64 time=0.042 ms

Start CM

applmgr@test sql]$ adcmctl.sh start apps/**** You are running adcmctl.sh version 120.19.12020000.7 Starting concurrent manager for TEST ... Starting TEST_0206@TEST Internal Concurrent Manager Default printer is noprint adcmctl.sh: exiting with status 0 adcmctl.sh: check the logfile /home/apps/TEST/fs1/inst/apps/TEST_test/logs/appl/admin/log/adcmctl.txt for more information ...  [applmgr@test sql]$

Check FND processes

[applmgr@test sql]$ ps -ef | grep FND applmgr  26723 26718  0 18:20 pts/5    00:00:01 FNDLIBR                                                                                                                                                            applmgr  26744     1  0 18:20 ?        00:00:00 FNDSM … applmgr  27087 26744  0 18:20 ?        00:00:00 FNDLIBR                           applmgr  27088 26744  0 18:20 ?        00:00:00 FNDLIBR                                                  applmgr  27089 26744  0 18:20 ?        00:00:00 FNDLIBR                  applmgr  27795     1  0 18:21 ?        00:00:00 /home/apps/TEST/fs1/EBSapps/appl/fnd/12.0.0/bin/FNDFSFNDFS (LOCAL=NO) applmgr  28411 26744  0 18:32 ?        00:00:00 [FNDSM] <defunct> applmgr  28414 32589  0 18:32 pts/2    00:00:00 grep --color=auto FND [applmgr@test sql]$

Check password for users

select fnd_web_sec.validate_login('GUEST','ORACLE') from dual; FND_WEB_SEC.VALIDATE_LOGIN('GUEST','ORACLE') -------------------------------------------------------------------------------- Y SQL> select fnd_web_sec.validate_login('SYSADMIN','SYSADMIN123') from dual; FND_WEB_SEC.VALIDATE_LOGIN('SYSADMIN','SYSADMIN123') -------------------------------------------------------------------------------- N

Issues after clone:

The adop_valid_nodes still contain the production nodes(Doc ID 2064223.1),

1. Backup the fnd_oam_context_files, fnd_nodes, and adop_valid_nodes tables in the EBS env:       sqlplus applsys/pwd       create table fnd_oam_context_files_bkp as select * from fnd_oam_context_files;       create table fnd_nodes_bk as select * from fnd_nodes;         create table adop_valid_nodes_bk as select * from adop_valid_nodes; 2. Truncate the following tables:       truncate table applsys.fnd_oam_context_files;       truncate table applsys.fnd_nodes;       truncate table applsys.adop_valid_nodes; 3.  Run AutoConfig on the DB tier         Confirm Autoconfig completes successfully 4.  Run Autoconfig on the run file system.         Confirm Autoconfig completes successfully 5.  Run Autoconfig on the patch file system

[UNEXPECTED]Master node for the current cycle is <source_node>.   [UNEXPECTED]Hint: Please run actions like "allnodes=yes" or "allnodes=no action=db" from master node.   [UNEXPECTED]Unrecoverable error occured. Exiting the current session. FIX: login to apps user and perform the following tasks. SQL> create table apps.ad_adop_sessions_bkp as select * from apps.ad_adop_sessions; Table created. SQL> update apps.ad_adop_sessions set NODE_NAME='&target_node' where node_name='&source_node'; 9 rows updated. SQL> commit; Commit complete. SQL> Abort the patch session and restart: $ adop phase=abort $ adop phase=cleanup cleanup_mode=full