Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Upgrade from Oracle 12C to 18C

2025-01-16 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

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

Upgrade from Oracle 12C to 18C

One: version check

Two: prepare the 18C 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 12.2.0.1.0 to Oracle 18.3.0.0

One: version testing Oracle DB 18c-complete checklist for manual upgrade to Non-CDB Oracle Database 18c (Doc ID 2469647.1)

Two: prepare the 18C installation package

-LINUX.X64_180000_db_home.zip

[root@cjcos package] # pwd

/ package

[root@cjcos package] # ll-rth

Total 7.5G

Drwxr-xr-x. 2 oracle oinstall 42 Jan 16 12:05 Oracle_1903_for_Linux

-rw-r--r-- 1 oracle oinstall 3.3G Jan 19 10:36 linuxx64_12201_database.zip

-rw-r--r-- 1 oracle oinstall 4.3G Jan 19 10:55 LINUX.X64_180000_db_home.zip

Three: create a directory

[root@cjcos yum.repos.d] # mkdir-p / u01/app/oracle 18

[root@cjcos yum.repos.d] # chown-R oracle:oinstall / u01/app/oracle 18

[root@cjcos yum.repos.d] # chmod-R 775 / u01/app

[root@cjcos yum.repos.d] # su-oracle

[oracle@cjcos] $mkdir-p / u01/app/oracle 18 / product/1 8.0.0 / dbhome_1

[oracle@cjcos ~] $cd / u01/app/oracle 18 / product/1 8.0.0 / dbhome_1

Four: install Oracle software

[oracle@cjcos dbhome_1] $pwd

/ u01/app/oracle18/product/18.0.0/dbhome_1

[oracle@cjcos dbhome_1] $unzip-Q / package/LINUX.X64_180000_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/oracle18/product/18.0.0/dbhome_1/root.sh

Five: pre-upgrade check

Stop and expand the memory to 10g

[root@cjcos] # free-m

Total used free shared buff/cache available

Mem: 9740 335 9088 9 317 9318

Swap: 4991 0 4991

[oracle@cjcos ~] $export ORACLE_BASE=/u01/app/oracle12

[oracle@cjcos ~] $export ORACLE_HOME=$ORACLE_BASE/product/12.0.0/dbhome_1

[oracle@cjcos ~] $export ORACLE_SID=cjcdb01

[oracle@cjcos ~] $/ u01/app/oracle18/product/18.0.0/dbhome_1/jdk/bin/java-jar / u01/app/oracle18/product/18.0.0/dbhome_1/rdbms/admin/preupgrade.jar

=

PREUPGRADE SUMMARY

=

/ u01/app/oracle12/cfgtoollogs/cjcdb01/preupgrade/preupgrade.log

/ u01/app/oracle12/cfgtoollogs/cjcdb01/preupgrade/preupgrade_fixups.sql

/ u01/app/oracle12/cfgtoollogs/cjcdb01/preupgrade/postupgrade_fixups.sql

Execute fixup scripts across the entire CDB:

Before upgrade:

1. Execute preupgrade fixups with the below command

$ORACLE_HOME/perl/bin/perl-I$ORACLE_HOME/perl/lib-I$ORACLE_HOME/rdbms/admin $ORACLE_HOME/rdbms/admin/catcon.pl-1 / u01/app/oracle12/cfgtoollogs/cjcdb01/preupgrade/-b preup_cjcdb01 / u01/app/oracle12/cfgtoollogs/cjcdb01/preupgrade/preupgrade_fixups.sql

2. Review logs under / u01/app/oracle12/cfgtoollogs/cjcdb01/preupgrade/

After the upgrade:

1. Execute postupgrade fixups with the below command

$ORACLE_HOME/perl/bin/perl-I$ORACLE_HOME/perl/lib-I$ORACLE_HOME/rdbms/admin $ORACLE_HOME/rdbms/admin/catcon.pl-1 / u01/app/oracle12/cfgtoollogs/cjcdb01/preupgrade/-b postup_cjcdb01 / u01/app/oracle12/cfgtoollogs/cjcdb01/preupgrade/postupgrade_fixups.sql

2. Review logs under / u01/app/oracle12/cfgtoollogs/cjcdb01/preupgrade/

Preupgrade complete: 2020-01-19T14:58:18

[oracle@cjcos preupgrade] $vi preupgrade.log

[oracle@cjcos preupgrade] $pwd

/ u01/app/oracle12/cfgtoollogs/cjcdb01/preupgrade

[oracle@cjcos preupgrade] $vim preupgrade.log

Six: upgrade

[oracle@cjcos ~] $cd / u01/app/oracle18/product/18.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_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_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/oracle12/product/12.0.0/dbhome_1/network/admin

[oracle@cjcos admin] $vim tnsnames.ora

Eight: question

When upgrading from 11.2.0.4.0 to 12.2.0.1.0 and then from 12.2.0.1.0 to 18.3.0.0.0 on Oracle Linux Server release 6.3system, an error ORA-03114 will be reported when the upgrade task reaches 70%:

Root@cjc cjcdb] # pwd

/ u01/app/oracle18/cfgtoollogs/dbua/upgrade2020-01-16 October 10-06-36AM/cjcdb

[root@cjc cjcdb] # vim catupgrdcjcpdb0.log

Try to manually upgrade PDB:

[oracle@cjc ~] $source .bash _ profile

[oracle@cjc ~] $ORACLE_HOME/bin/dbupgrade-c cjcpdb

The error is as follows:

CJCPDB (3): Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x4] [PC:0x599B586, joevm_invokevirtual () + 1414] [flags: 0x0, count: 1]

2020-01-16T14:49:57.835919+08:00

Errors in file / u01/app/oracle18/diag/rdbms/cjcdb/cjcdb/trace/cjcdb_ora_1102.trc (incident=14465) (PDBNAME=CJCPDB):

ORA-07445: exception encountered: core dump [joevm_invokevirtual () + 1414] [SIGSEGV] [ADDR:0x4] [PC:0x599B586] [Address not mapped to object] []

CJCPDB (3): Incident details in: / u01/app/oracle18/diag/rdbms/cjcdb/cjcdb/incident/incdir_14465/cjcdb_ora_1102_i14465.trc

CJCPDB (3): Use ADRCI or Support Workbench to package the incident.

See Note 411.1 at My Oracle Support for error and packaging details.

2020-01-16T14:50:09.995817+08:00

Dumping diagnostic data in directory= [CDMP _ 20200116145009], requested by (instance=1, osid=1102), summary= [incident=14465].

Try to restart PDB:

Solution:

The same problem occurred in many attempts to install. It is suspected that the operating system version is too low, or the operating system memory is too low. Change the operating system version Red Hat Enterprise Linux Server release 7.5 (Maipo) and adjust the memory from 4G to 10G. The upgrade problem disappears again.

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.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report