Upgrade from Oracle 18C to 19C
Upgrade from Oracle 18C to 19C
One: version check
Two: prepare the 19C installation package
Three: create a directory
Four: install Oracle software
Five: pre-upgrade check
Six: upgrade
Seven: verification
Eight: question
Environment description:
OS:Red Hat Enterprise Linux Server release 7.5 (Maipo)
Upgrade from DB:Oracle 18.3.0.0.0 to Oracle 19.3.0.0.0
One: version detection
Oracle 19c-Complete Checklist for Manual Upgrades to Non-CDB Oracle Database 19c (Doc ID 2539778.1)
Two: prepare the 19 C installation package
-LINUX.X64_1 93 000_db_home.zip
[root@cjcos package] # pwd
/ package
[root@cjcos Oracle_1903_for_Linux] # ll-rth
Total 2. 9 G
-rw-r--r-- 1 oracle oinstall 2. 9 G Jan 19 10:55 LINUX.X64_1 9 0000_db_home.zip
Three: create a directory
[root@cjcos yum.repos.d] # mkdir-p / u01/app/oracle 1 9
[root@cjcos yum.repos.d] # chown-R oracle:oinstall / u01/app/oracle 1 9
[root@cjcos yum.repos.d] # chmod-R 775 / u01/app
[root@cjcos yum.repos.d] # su-oracle
[oracle@cjcos] $mkdir-p / u01/app/oracle 19 / product/1 9.0.0 / dbhome_1
[oracle@cjcos ~] $cd / u01/app/oracle 19 / product/1 9.0.0 / dbhome_1
Four: install Oracle software
[oracle@cjcos dbhome_1] $pwd
/ u01/app/oracle1 9 / product/1 9 .0.0 / dbhome_1
[oracle@cjcos dbhome_1] $unzip-Q / package/LINUX.X64_1 9 0000_db_home.zip
[root@cjcos ~] # xhost +
Access control disabled, clients can connect from any host
[oracle@cjcos dbhome_1] $cd / package/database/
[oracle@cjcos database] $. / runInstaller
[root@cjcos] # / u01/app/oracle1 9 / product/1 9.0.0 / dbhome_1/root.sh
Five: pre-upgrade check
[oracle@cjcos ~] $/ u01/app/oracle1 9 / product/1 9.0.0 / dbhome_1/jdk/bin/java-jar / u01/app/oracle1 9 / product/1 9.0.0 / dbhome_1/rdbms/admin/preupgrade.jar
Six: upgrade
[oracle@cjcos ~] $cd / u01/app/oracle1 9 / product/1 9.0.0 / dbhome_1/bin/
[oracle@cjcos bin] $. / dbua
SQL > conn / as sysdba
SQL > EXECUTE DBMS_STATS.GATHER_DICTIONARY_STATS
SQL > EXECUTE DBMS_STATS.GATHER_FIXED_OBJECTS_STATS
SQL > alter session set container=cjcpdb01
SQL > EXECUTE DBMS_STATS.GATHER_DICTIONARY_STATS
SQL > EXECUTE DBMS_STATS.GATHER_FIXED_OBJECTS_STATS
Seven: verification
Set environment variabl
[oracle@cjcos ~] $vi .bash _ profile
Export PATH
# export ORACLE_BASE=/u01/app/oracle
# export ORACLE_BASE=/u01/app/oracle12
# export ORACLE_BASE=/u01/app/oracle18
Export ORACLE_BASE=/u01/app/oracle1 9
# export ORACLE_HOME=$ORACLE_BASE/product/19.0.0/dbhome_1
# export ORACLE_HOME=$ORACLE_BASE/product/12.0.0/dbhome_1
# export ORACLE_HOME=$ORACLE_BASE/product/18.0.0/dbhome_1
Export ORACLE_HOME=$ORACLE_BASE/product/1 9 .0.0 / dbhome_1
# export ORACLE_SID=cjcdb
Export ORACLE_SID=cjcdb01
# export ORACLE_SID=cjcdb02
Export PATH=$ORACLE_HOME/bin:$PATH
Export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
[oracle@cjcos ~] $source .bash _ profile
Monitoring statu
[oracle@cjcos ~] $lsnrctl status
[oracle@cjcos admin] $pwd
/ u01/app/oracle1 9 / product/1 9 .0.0 / dbhome_1/network/admin
[oracle@cjcos admin] $vim tnsnames.ora
Eight: question
None
Welcome to follow my Wechat official account "IT Little Chen" and learn and grow together!
