DisplayAdd1

TechnoTechDB is a platform, which will help to grow your carrier in Information sector. Having 15 years of Experience in Oracle/MongoDB/Postgres/Mysql databases, along with having good expertise level of knowledge in Scripting to automate database task. Our goal to start with zero to hero level expertise in Database. You can access/refer my some blogs on https://mrorcldba.blogspot.com link and post your comments and your suggestion to motive us.

Monday, 12 June 2023

Direct upgrade and Migrate DB from 11.2.0.4 to 19c PDB

 /opt/oracle/product/19c/dbhome_1/jdk/bin/java -jar /opt/oracle/product/19c/dbhome_1/rdbms/admin/autoupgrade.jar -create_sample_file config



cat /home/oracle/autoupg/11204upgrade.cfg

global.autoupg_log_dir=/opt/oracle/cfgtoollogs/autoupgrade

upg1.sid=orcl1

upg1.dbname=orcl1

upg1.start_time=NOW

upg1.source_home=/opt/oracle/product/11g/dbhome_1

upg1.log_dir=/home/oracle/autoupg

upg1.target_home=/opt/oracle/product/19c/dbhome_1

upg1.upgrade_node=oracle11g

upg1.target_version=19.1.0

upg1.run_utlrp=yes

upg1.timezone_upg=yes

upg1.target_cdb=cdb1


/opt/oracle/product/19c/dbhome_1/jdk/bin/java -jar /opt/oracle/product/19c/dbhome_1/rdbms/admin/autoupgrade.jar -config /home/oracle/autoupg/11204upgrade.cfg -mode ANALYZE



/opt/oracle/product/19c/dbhome_1/jdk/bin/java -jar /opt/oracle/product/19c/dbhome_1/rdbms/admin/autoupgrade.jar -config /home/oracle/autoupg/11204upgrade.cfg -mode DEPLOY



















No comments:

Post a Comment

Steps to Rename Host in Oracle RESTART (ASM) in Linux

  oracle@localhost ] asmcmd ASMCMD> lsdg State    Type    Rebal  Sector  Logical_Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_...