Source CDB environment file
Source CDB environment file
$ sqlplus "/as sysdba"
SQL>administer key management set keystore open force keystore identified by "<password>";
SQL> alter session set container=TESTPDB;
Open the wallet
SQL> ADMINISTER KEY MANAGEMENT SET KEYSTORE OPEN IDENTIFIED BY "<password>";
Import the wallet
SQL> administer key management import encryption keys with secret "<password>" from '/d01/wallet/tde/testpdb.key' identified by "<password>" with backup;
Verify Wallet Status
SQL> select STATUS from V$ENCRYPTION_WALLET;
Before import, we need to open the wallet.
Open the wallet
SQL> ADMINISTER KEY MANAGEMENT SET KEYSTORE OPEN IDENTIFIED BY "<password>";
Import the wallet
SQL> administer key management import encryption keys with secret "<password>" from '/d01/wallet/tde/testpdb.key' identified by "<password>" with backup;
Verify Wallet Status
SQL> select STATUS from V$ENCRYPTION_WALLET;
SQL>administer key management set keystore close identified by "<password>";
Verify the wallet Status
SQL> select status from v$encryption_wallet;
STATUS
CLOSED
SQL>administer key management set keystore close identified by "<password>";
Verify the wallet Status
SQL> select status from v$encryption_wallet;
STATUS
CLOSED
SQL> select wrl_parameter, status, wallet_type from v$encryption_wallet;
WRL_PARAMETER STATUS WALLET_TYPE
OPEN_NO_MASTER_KEY PASSWORD
SQL> select wrl_parameter, status, wallet_type from v$encryption_wallet;
Example:
'(DESCRIPTION =(ADDRESS = (PROTOCOL=tcp)(HOST=apdb001.myorg.com) (PORT=1521)) (CONNECT_DATA = (SERVICE_NAME=ebs_TESTPDB)(INSTANCE_NAME=TESTCDB)))';
where stale_stats='YES'and object_type='TABLE'
OWNER TABLE_NAME
Log: /d01/oracle/apps/fs_ne/EBSapps/log/adop/17/20220829_153322/adop.log
Verifying existence of context files in database.
Verifying data dictionary.[UNEXPECTED]Data dictionary corrupted:[UNEXPECTED]Data dictionary corruption - timestamp mismatchXCSCHEM XCSHEMA_ADDRESS_ORG V_20220821_1154 APPS CSHEMA_ADDRESS_ORG V_20220821_1154 TS mismatch: 21-AUG-22 13:14:03 21-AUG-22 13:39:18[UNEXPECTED] Follow the instructions in the "Fix data dictionary corruption"[UNEXPECTED] section of My Oracle Support Knowledge Document 1531121.1 .[UNEXPECTED]Finalize phase has failed.Summary report for current adop session:Node applapp1: Failed- Finalize status: FailedNode applapp2: Completed successfully- Finalize status: RunningNode applapp3: Completed successfully- Finalize status: Running
Solution:
Run below script as apps user as per Doc ID 1531121.1 ( Section 3.1)
a. Verify below entry in tnsnames.ora on RUN FS and PATCH FS in R12.2
TESTCDB =(DESCRIPTION =(ADDRESS = (PROTOCOL=tcp)(HOST=apdb001.myorg.com)(PORT=1521))(CONNECT_DATA = (SERVICE_NAME=ebs_TESTPDB) (INSTANCE_NAME=TESTCDB)))
b. Verify local_listener parameter configured in 19c for R12.2 as
SQL> alter system set local_listener=TESTCDB.myorg.com:1521 scope=both
c. Verify service_names parameter in 19c and must be set to CDB as
Set the parameter as below
SQL> alter system set local_listener=TESTCDB.myorg.com:1521 scope=both
While starting the listerner file, ebs_TESTDB was missing.
Following the below steps, it got resolved
a. Set the database service_name parameter container name as
$ sqlplus "/as sysdba"
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 24-AUG-2022 15:35:02
Copyright (c) 1991, 2022, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=apdb001.myorg.com)(PORT=1521)))
STATUS of the LISTENER------------------------Alias TESTCDBVersion TNSLSNR for Linux: Version 19.0.0.0.0 - ProductionStart Date 22-AUG-2022 16:55:18Uptime 1 days 22 hr. 39 min. 43 secTrace Level offSecurity ON: Local OS AuthenticationSNMP OFFListener Parameter File /d00/oracle/db/tech_st/19c/network/admin/listener.oraListener Log File /d00/oracle/db/tech_st/19c/network/admin/testcdb.logListening Endpoints Summary...(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=apdb001.myorg.com)(PORT=1521)))(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=apdb001.myorg.com)(PORT=5500))(Security=(my_wallet_directory=/d00/oracle/db/tech_st/admin/TESTCDB/xdb_wallet))(Presentation=HTTP)(Session=RAW))Services Summary...Service "TESTCDB" has 1 instance(s).Instance "TESTCDB", status READY, has 1 handler(s) for this service...Service "TESTCDBXDB" has 1 instance(s).Instance "TESTCDB", status READY, has 1 handler(s) for this service...Service "TESTPDB" has 1 instance(s).Instance "TESTCDB", status READY, has 1 handler(s) for this service...Service "TESTPDB_ebs_patch" has 1 instance(s).Instance "TESTCDB", status READY, has 1 handler(s) for this service...Service "ebs_TESTPDB" has 1 instance(s).Instance "TESTCDB", status READY, has 1 handler(s) for this service...Service "f469d0a189c77322e04377baa8c0a71f" has 1 instance(s).Instance "TESTCDB", status READY, has 1 handler(s) for this service...The command completed successfully
f. Check the services in PDB (TESTPDB) as
$ sqlplus "/as sysdba"
SQL> select name from v$active_services;
NAMEebs_TRESTPDBTESTPDBTESTPDB_ebs_patch
SQL> col CPU format a9
SQL> select max(CODELEVEL) "CPU" from AD_TRACKABLE_ENTITIES where ABBREVIATION in ('ebscpu');
CPU
---------
2022.07
[WARNING] adop has detected a configured disaster recovery site.
[WARNING] Follow the instructions in the section "Oracle E-Business Suite
[WARNING] Maintenance with Standby Database" of Business Continuity for
[WARNING] Oracle E-Business Suite Release 12.2 depending on the database version used.
Do you want to continue with the prepare phase [Y/N] ?
Solution :
Continue with Y as init<sid>.ora contains Data Guard setup which is not disabled. There is no harm to continue with "Y" option
Abort the patch cycle and run cleanup mode / prepare then finalize as below
1. adop pahse=abort
2. adop phase=cleanup cleanup_mode=full
3. adop phase=prepare
4. adop phase=finalize finalize_mode=full
5. adop phase=cutover
6. adop phase=cleanup cleanup_mode=full
