How To Upgrade Oracle 12c to 19c using DBUA On Linux
Oracle Upgrade step for Oralce 12C version to Oracle 19C using DBUA
1)Check 12c database status.
Select name,open_mode,database_role from v$database;
Select * from v$version;
2)Check files in backup mode:(should return zero rows)
Select * from v$recover_file;
Select * from v$backup WHERE status != ‘NOT ACTIVE’;
3)Check database component status.
set pagesize500
set linesize 100
select substr(comp_name,1,40) comp_name, status, substr(version,1,10) version from dba_registry order by comp_name;
4)Check the timezone version.
select * from v$timezone_file;
5)Check invalid object count.
Select count(1) from dba_objects where status=’INVALID’;
6)compile invalid objects.
$ORACLE_HOME/rdbms/admin/utlrp.sql
7)Purge recycle bin.
purge dba_recyclebin;
8)Install Oracle 19c software
9)Run the pre-upgrade tool, Make sure to run the tool from source ORACLE_HOME.
$ORACLE_BASE/product/12.2.0/db_1/jdk/bin/java -jar$ORACLE_BASE/product/19.3.0/dbhome_1/rdbms/admin/preupgrade.jar TERMINAL TEXT
10)Run the preupgrade_fixups.sql
11) Run DBUA (graphical utility to upgrade database)
12) POST CHECK:-
select * from v$version.
select comp_id,status from dba_registry;
select * from v$timezone_file;13) run postupgrade fixup
/u01/app/oracle/cfgtoollogs/test/preupgrade/postupgrade_fixups.sql
select comp_name,status from dba_registry;
==================================================================================================================================================
What’s Next? We have more deep dives into PLM Tutorials, Teamcenter, and Active Workspace coming your way soon.
We value your feedback! Please share your thoughts in the comment section below.
If you have specific technical questions, feel free to post them in our Forum via the “Add Topics” button, and our team will provide a solution as soon as possible.
Stay Connected:
Follow us on our social media platforms for the latest updates, or
reach out with suggestions at [email protected].