In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
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.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.