The most recent version of AutoUpgrade can be downloaded via myoracle support - 2485457.1
Copy autoupgrade.jar to any location as per your convenience
[oracle@kolkata02 auto_upgrade]$ cp /u01/app/oracle/product/19.0.0.0/dbhome_1/rdbms/admin/autoupgrade.jar /home/oracle/auto_upgrade
Create a sample config file using :
[oracle@kolkata02 auto_upgrade]$ java -jar /home/oracle/auto_upgrade/autoupgrade.jar -create_sample_file config
Created sample configuration file /home/oracle/auto_upgrade/sample_config.cfg
Now create your own config file using sample_config.cfg
[oracle@kolkata02 ~]$ vi /home/oracle/config_zamdbtdb.cfg
global.autoupg_log_dir=/u01/app/oracle/cfgtoollogs/autoupgrade/zamdbtdb1
upg1.log_dir=/home/oracle/auto_upgrade/logs/zamdbtdb1
upg1.sid=zamdbtdb1
upg1.source_home=/u01/app/oracle/product/12.2.0.1/dbhome_1
upg1.target_cdb=CNTESTDB1
upg1.target_pdb_name=zamdbtdbx -->for prechecks remove this target_pdb_name
upg1.target_pdb_copy_option=file_name_convert=('+DATA1/ZAMDBTDB','+DATA1','+RECO1/ZAMDBTDB','+RECO1','+FRA/ZAMDBTDB','+FRA') -->If you want to upgrade with copy use this option, otherwise remove this option
upg1.target_home=/u01/app/oracle/product/19.0.0.0/dbhome_1
upg1.start_time=now
upg1.upgrade_node=kolkata02.localdomain
upg1.run_utlrp=yes
upg1.timezone_upg=yes
And save it, now run the prechecks
nohup java -jar /home/oracle/auto_upgrade/autoupgrade.jar -config /home/oracle/config_zamdbtdb.cfg -mode analyze -noconsole >> /home/oracle/zamdbtdb_upg.log 2>&1 &
Otherwise you can run it in console mode as below: (PRECHECKS)
java -jar /home/oracle/auto_upgrade/autoupgrade.jar -config /home/oracle/config_zamdbtdb.cfg -mode analyze
Prechecks are succeeded , you can check in the html file
[oracle@kolkata02 prechecks]$ pwd
/home/oracle/auto_upgrade/logs/zamdbtdb1/zamdbtdb1/102/prechecks
[oracle@kolkata02 prechecks]$ firefox zamdbtdb_preupgrade.html
Now start the actual upgrade in console mode:
nohup java -jar /u01/app/oracle/product/19.0.0.0/dbhome_1/rdbms/admin/autoupgrade.jar -config /home/oracle/config_zamdbtdb.cfg -mode deploy -noconsole >> /home/oracle/zamdbtdb_upg.log 2>&1 & ---->This is noconsole mode
java -jar /home/oracle/auto_upgrade/autoupgrade.jar -config /home/oracle/config_zamdbtdb.cfg -mode deploy -->This is console mode
upg> status -job 103
Progress
-----------------------------------
Start time: 21/08/22 13:00
Elapsed (min): 2
End time: N/A
Last update: 2021-08-22T13:01:35.143
Stage: PRECHECKS
Operation: PREPARING
Status: RUNNING
Pending stages: 8
Stage summary:
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 1 min (IN PROGRESS)
Job Logs Locations
-----------------------------------
Logs Base: /home/oracle/auto_upgrade/logs/zamdbtdb1/zamdbtdb1
Job logs: /home/oracle/auto_upgrade/logs/zamdbtdb1/zamdbtdb1/103
Stage logs: /home/oracle/auto_upgrade/logs/zamdbtdb1/zamdbtdb1/103/prechecks
TimeZone: /home/oracle/auto_upgrade/logs/zamdbtdb1/zamdbtdb1/temp
Additional information
-----------------------------------
Details:
Checks
Error Details:
None
upg> status -job 103
Progress
-----------------------------------
Start time: 21/08/22 13:00
Elapsed (min): 136
End time: N/A
Last update: 2021-08-22T15:14:45.923
Stage: POSTFIXUPS
Operation: EXECUTING
Status: RUNNING
Pending stages: 3
Stage summary:
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 2 min
PREFIXUPS 16 min
DRAIN 1 min
DBUPGRADE 112 min
POSTCHECKS <1 min
POSTFIXUPS 2 min (IN PROGRESS)
Job Logs Locations
-----------------------------------
Logs Base: /home/oracle/auto_upgrade/logs/zamdbtdb1/zamdbtdb1
Job logs: /home/oracle/auto_upgrade/logs/zamdbtdb1/zamdbtdb1/103
Stage logs: /home/oracle/auto_upgrade/logs/zamdbtdb1/zamdbtdb1/103/postfixups
TimeZone: /home/oracle/auto_upgrade/logs/zamdbtdb1/zamdbtdb1/temp
Additional information
-----------------------------------
Details:
+---------+---------------+-------+
| DATABASE| FIXUP| STATUS|
+---------+---------------+-------+
|zamdbtdb1|POST_DICTIONARY|STARTED|
+---------+---------------+-------+
Error Details:
None
upg> status -job 103
Progress
-----------------------------------
Start time: 21/08/22 13:00
Elapsed (min): 177
End time: N/A
Last update: 2021-08-22T15:57:39.973
Stage: NONCDBTOPDB
Operation: EXECUTING
Status: RUNNING
Pending stages: 1
Stage summary:
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 2 min
PREFIXUPS 16 min
DRAIN 1 min
DBUPGRADE 112 min
POSTCHECKS <1 min
POSTFIXUPS 16 min
POSTUPGRADE <1 min
NONCDBTOPDB 26 min (IN PROGRESS)
Job Logs Locations
-----------------------------------
Logs Base: /home/oracle/auto_upgrade/logs/zamdbtdb1/zamdbtdb1
Job logs: /home/oracle/auto_upgrade/logs/zamdbtdb1/zamdbtdb1/103
Stage logs: /home/oracle/auto_upgrade/logs/zamdbtdb1/zamdbtdb1/103/noncdbtopdb
TimeZone: /home/oracle/auto_upgrade/logs/zamdbtdb1/zamdbtdb1/temp
Additional information
-----------------------------------
Details:
Executing noncdb_to_pdb.sql
Error Details:
None
Currently noncdb_to_pdb conversion is running and it is on last stage where utlrp.sql is running
/home/oracle/auto_upgrade/logs/zamdbtdb1/zamdbtdb1/103/noncdbtopdb
[oracle@kolkata02 noncdbtopdb]$ ls -ltr
total 444
-rwx------. 1 oracle oinstall 0 Aug 22 15:31 noncdb_to_pdb_zamdbtdb.log.lck
-rwx------. 1 oracle dba 8292 Aug 22 15:32 zamdbtdbx.xml
-rwx------. 1 oracle oinstall 702 Aug 22 15:33 createpdb_zamdbtdb.log
-rwx------. 1 oracle oinstall 376832 Aug 22 15:44 noncdbtopdb_zamdbtdb.log
-rwx------. 1 oracle oinstall 60924 Aug 22 16:54 noncdb_to_pdb_zamdbtdb.log
[oracle@kolkata02 noncdbtopdb]$ tail -100f noncdb_to_pdb_zamdbtdb.log
2021-08-22 16:54:12.033 INFO [(SQLPATH=/home/oracle/auto_upgrade/logs/zamdbtdb1/zamdbtdb1/103/noncdbtopdb), (ORACLE_SID=CNTESTDB1), (ORACLE_UNQNAME=zamdbtdb), (ORACLE_PATH=/home/oracle/auto_upgrade/logs/zamdbtdb1/zamdbtdb1/103/noncdbtopdb), (ORACLE_BASE=/u01/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/u01/app/oracle/product/19.0.0.0/dbhome_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A), (WORKDIR=/home/oracle/auto_upgrade/logs/zamdbtdb1/zamdbtdb1/103/noncdbtopdb)] - ExecutionEnv.addEnvToProcess
2021-08-22 16:54:12.034 INFO Starting - ExecuteProcess.setLibsForSqlplus
2021-08-22 16:54:12.034 INFO Finished - ExecuteProcess.setLibsForSqlplus
2021-08-22 16:54:12.036 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-08-22 16:54:12.036 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess
2021-08-22 16:54:12.109 INFO End Creating process - ExecuteProcess.startSqlPlusProcess
2021-08-22 16:54:12.109 INFO Executing SQL [SELECT COUNT(*) FROM sys.obj$ WHERE status IN (4, 5, 6);] in [CNTESTDB1, container:zamdbtdbx] - ExecuteSql$SQLClient.run
2021-08-22 16:54:12.628 INFO Progress was detected in noncdb_to_pdb.sql script execution due to fewer invalid objects[10] present in the pdb - NonCDBToPDBSQL$CheckProgress.run
Errors in database [zamdbtdb1]
Stage [NONCDBTOPDB]
Operation [STOPPED]
Status [ERROR]
Info [
Error: UPG-1699
[Unexpected exception error]
Cause: Error finding error definition, contact Oracle Support
For further details, see the log file located at /home/oracle/auto_upgrade/logs/zamdbtdb1/zamdbtdb1/103/autoupgrade_20210822_user.log]
-------------------------------------------------
Logs: [/home/oracle/auto_upgrade/logs/zamdbtdb1/zamdbtdb1/103/autoupgrade_20210822_user.log]
-------------------------------------------------
upg>
upg> lsj
+----+---------+-----------+---------+------+--------------+--------+--------+
|Job#| DB_NAME| STAGE|OPERATION|STATUS| START_TIME| UPDATED| MESSAGE|
+----+---------+-----------+---------+------+--------------+--------+--------+
| 103|zamdbtdb1|NONCDBTOPDB| STOPPED| ERROR|21/08/22 13:00|17:06:27|UPG-1699|
+----+---------+-----------+---------+------+--------------+--------+--------+
Total jobs 1
At this step we found that upgrade completed successfully and PDB plugin also done successfully. But due to PDB plug-in violations , the PDB is in RESTRICTED STATE , not coming to OPEN state.
So , found the PDB plugin violations and resolving them , results in successfully opening the PDB in OPEN state
2021-08-22 15:13:58.793 INFO [Upgrading] is [100%] completed for [zamdbtdb]
+---------+--------------------------------+
|CONTAINER| PERCENTAGE|
+---------+--------------------------------+
| zamdbtdb|SUCCESSFULLY UPGRADED [zamdbtdb]|
+---------+--------------------------------+
2021-08-22 15:13:58.940 INFO Error opening file [/u01/app/oracle/product/19.0.0.0/dbhome_1/dbs/initzamdbtdb1.ora] for reading
2021-08-22 15:14:01.626 INFO Creating spfile completed with success
2021-08-22 15:14:01.627 INFO SUCCESSFULLY UPGRADED [zamdbtdb]
2021-08-22 15:14:01.755 INFO zamdbtdb Return status is SUCCESS
2021-08-22 15:14:24.484 INFO Analyzing zamdbtdb1, 11 checks will run using 2 threads
2021-08-22 15:14:42.616 INFO Using /home/oracle/auto_upgrade/logs/zamdbtdb1/zamdbtdb1/103/prechecks/zamdbtdb_checklist.cfg to identify required fixups
2021-08-22 15:14:42.714 INFO Content of the checklist /home/oracle/auto_upgrade/logs/zamdbtdb1/zamdbtdb1/103/prechecks/zamdbtdb_checklist.cfg is:
2021-08-22 15:31:21.106 INFO Guarantee Restore Point (GRP) successfully removed [ZAMDBTDB][AUTOUPGRADE_9212_ZAMDBTDB1122010]
2021-08-22 15:33:38.901 INFO No entry was found for [zamdbtdb1:/u01/app/oracle/product/19.0.0.0/dbhome_1] in /etc/oratab
2021-08-22 17:06:16.137 INFO /home/oracle/auto_upgrade/logs/zamdbtdb1/zamdbtdb1/temp/after_upgrade_pfile_zamdbtdb1.ora
2021-08-22 17:06:26.615 ERROR Dispatcher failed: AutoUpgException [ERROR3007#Errors executing [CREATE SPFILE='+DATAC1' FROM PFILE='/home/oracle/auto_upgrade/logs/zamdbtdb1/zamdbtdb1/temp/after_upgrade_pfile_zamdbtdb1.ora';
CREATE SPFILE='+DATAC1' FROM PFILE='/home/oracle/auto_upgrade/logs/zamdbtdb1/zamdbtdb1/temp/after_upgrade_pfile_zamdbtdb1.ora'
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 0
Session ID: 0 Serial number: 0
] [zamdbtdb1]]
select name, cause, type, status,action,message,time from pdb_plug_in_violations; --->ran this command with connection to CDB(CNTESTDB) and found the below action plan
Some Interim patches are installed in PDB but not in CDB, because when I have applied 32904851;Database Release Update : 19.12.0.0.210720 (32904851) , i have not ran the DATAPATCH at CDB level, so the PDB which is upgraded and plugged-in to CDB it got automatically installed all the interim patches so, the violation came like this "Not installed in the CDB but installed in the PDB"
And now i have ran the datapatch command at CDB level resolved the issues and now the PDB came in OPEN state
The error details are placed in location "E:\zameer_workspace\AutomationScripts\DBUpgrade\database_upgrade_steps"
SQL> alter pluggable database ZAMDBTDBX close instances=all;
Pluggable database altered.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
4 ZAMDBTDBX MOUNTED
SQL>
SQL>
SQL> alter pluggable database ZAMDBTDBX open instances=all;
Pluggable database altered.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
4 ZAMDBTDBX READ WRITE NO
SQL> alter pluggable database ZAMDBTDBX save state instances=all;
Pluggable database altered.
[oracle@kolkata02 ~]$ srvctl status database -d cntestdb -v -f
Instance CNTESTDB1 is running on node kolkata02 with online services TESTPDB.localdomain,zamdbtdb.localdomain. Instance status: Open.
Instance CNTESTDB2 is running on node kolkata03 with online services TESTPDB.localdomain,zamdbtdb.localdomain. Instance status: Open.
