Shulou(Shulou.com)06/01 Report--

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!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.