1、环境
|
|
当前环境 | 目标环境 |
| 数据库版本 | 11.2.0.4 | 19.3.0.0 |
| ORACLE_HOME | /u01/app/oracle/product/11.2.0/dbhome_1 | /u02/app/oracle/product/19c/dbhome_1 |
| ORACLE_BASE | /u01/app/oracle/ | /u02/app/oracle/ |
2、停11g数据库实例，停监听，备份，后来测试发现，不停也没关系，升级过程会自动停，但是备份要做好。
升级前
SQL> col comp_id format a20 SQL> col comp_name format a35 SQL> set linesize 999 SQL> set pagesize 999 SQL> SELECT COMP_ID,comp_name,version,STATUS FROM dba_registry; COMP_ID COMP_NAME VERSION STATUS -------------------- ----------------------------------- --------------- ---------------------- OWB OWB 11.2.0.4.0 VALID APEX Oracle Application Express 3.2.1.00.12 VALID EM Oracle Enterprise Manager 11.2.0.4.0 VALID AMD OLAP Catalog 11.2.0.4.0 VALID SDO Spatial 11.2.0.4.0 VALID ORDIM Oracle Multimedia 11.2.0.4.0 VALID XDB Oracle XML Database 11.2.0.4.0 VALID CONTEXT Oracle Text 11.2.0.4.0 VALID EXF Oracle Expression Filter 11.2.0.4.0 VALID RUL Oracle Rules Manager 11.2.0.4.0 VALID OWM Oracle Workspace Manager 11.2.0.4.0 VALID CATALOG Oracle Database Catalog Views 11.2.0.4.0 VALID CATPROC Oracle Database Packages and Types 11.2.0.4.0 VALID JAVAVM JServer JAVA Virtual Machine 11.2.0.4.0 VALID XML Oracle XDK 11.2.0.4.0 VALID CATJAVA Oracle Database Java Packages 11.2.0.4.0 VALID APS OLAP Analytic Workspace 11.2.0.4.0 VALID XOQ Oracle OLAP API 11.2.0.4.0 VALID 18 rows selected.
3、同一台机器上，安装新版19c数据库
创建目标环境目录，权限，上传19c数据库，解压到目标环境home目录
mkdir -p /u02/app/oracle/product/19c/dbhome_1 chown -R oracle:oinstall /u02 chmod -R 775 /u02/
[root@dbserver ~]# mv LINUX.X64_193000_db_home.zip /u02/app/oracle/product/19c/dbhome_1/ [root@dbserver ~]# cd /u02/app/oracle/product/19c/dbhome_1/ [root@dbserver dbhome_1]# ls LINUX.X64_193000_db_home.zip [root@dbserver dbhome_1]# chown oracle:oinstall LINUX.X64_193000_db_home.zip [root@dbserver dbhome_1]# ll total 2987996 -rwxr-xr-x. 1 oracle oinstall 3059705302 Jan 11 11:54 LINUX.X64_193000_db_home.zip [root@dbserver dbhome_1]# su - oracle 切换用户 [oracle@dbserver ~]$ cd /u02/app/oracle/product/19c/dbhome_1/ [oracle@dbserver dbhome_1]$ ls LINUX.X64_193000_db_home.zip [oracle@dbserver dbhome_1]$ unzip LINUX.X64_193000_db_home.zip
vnc安装19c数据库，记得手动指定19C的ORACLE_BASE 和ORACLE_HOME
登录root执行修复脚本
[root@dbserver tmp]# /tmp/InstallActions2022-01-11_05-02-04PM/CVU_19.0.0.0.0_oracle/runfixup.sh All Fix-up operations were completed successfully. [root@dbserver tmp]#
备份
继续执行
[root@dbserver tmp]# /u02/app/oracle/product/19c/dbhome_1/root.sh Performing root user operation. The following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= /u02/app/oracle/product/19c/dbhome_1 Enter the full pathname of the local bin directory: [/usr/local/bin]: The file "dbhome" already exists in /usr/local/bin. Overwrite it? (y/n) [n]: y
4、VNC dbua升级
注意启动的是19c的dbua
[oracle@dbserver bin]$ pwd /u02/app/oracle/product/19c/dbhome_1/bin [oracle@dbserver bin]$ ./dbua
具体的三个组件
SQL> @?/olap/admin/catnoamd.sql
这个也可以等升级到19c，手动再删除一样。
[oracle@dbserver ~]$ cd /u02/app/oracle/product/19c/dbhome_1/rdbms/admin/ [oracle@dbserver admin]$ pwd /u02/app/oracle/product/19c/dbhome_1/rdbms/admin [oracle@dbserver admin]$ cp emremove.sql $ORACLE_HOME/ [oracle@dbserver admin]$ emctl stop dbconsole Environment variable ORACLE_UNQNAME not defined. Please set ORACLE_UNQNAME to database unique name. [oracle@dbserver admin]$ SQL> SET ECHO ON; SQL> SET SERVEROUTPUT ON; SQL> @?/emremove.sql ........... ........... Finished phase 6 The Oracle Enterprise Manager related schemas and objects are dropped. Do the manual steps to studown the DB Control if not done before running this script and then delete the DB Control configuration files PL/SQL procedure successfully completed. SQL>
最后这个APEX我没有手动升级，直接进行dbua的升级
再次查询，只剩下APEX的warning
SQL> SELECT COMP_ID,comp_name,version,STATUS FROM dba_registry; COMP_ID COMP_NAME VERSION STATUS -------------------- ----------------------------------- ------------------------------------------------------------ ---------------------- OWB OWB 11.2.0.4.0 VALID APEX Oracle Application Express 3.2.1.00.12 VALID SDO Spatial 11.2.0.4.0 VALID ORDIM Oracle Multimedia 11.2.0.4.0 VALID XDB Oracle XML Database 11.2.0.4.0 VALID CONTEXT Oracle Text 11.2.0.4.0 VALID EXF Oracle Expression Filter 11.2.0.4.0 VALID RUL Oracle Rules Manager 11.2.0.4.0 VALID OWM Oracle Workspace Manager 11.2.0.4.0 VALID CATALOG Oracle Database Catalog Views 11.2.0.4.0 VALID CATPROC Oracle Database Packages and Types 11.2.0.4.0 VALID JAVAVM JServer JAVA Virtual Machine 11.2.0.4.0 VALID XML Oracle XDK 11.2.0.4.0 VALID CATJAVA Oracle Database Java Packages 11.2.0.4.0 VALID APS OLAP Analytic Workspace 11.2.0.4.0 VALID XOQ Oracle OLAP API 11.2.0.4.0 VALID 16 rows selected.
这里我原数据库没关闭，测试发现关闭与否好像都可以，升级过程会自动关闭。
注意： EXF RUL OWB
从Oracle 12c版本开始，表达过滤器（EXF）和数据库规则管理器（RUL）特性被取消，并在升级的过程中被删除。
从Oracle Database 12c开始，Oracle Warehouse Builder（OWB）未作为Oracle数据库软件的一部分安装。
必须单独安装Oracle Warehouse Builder。
可以从 Oracle Technology Network 下载。早期版本中可能存在的OWB组件未作为Oracle数据库升级过程的一部分进行升级。
升级完成查看oracle还有哪些组件
SQL> col comp_id format a20 col comp_name format a35 set linesize 999 set pagesize 999 SQL> SELECT COMP_ID,comp_name,version,STATUS FROM dba_registry; COMP_ID COMP_NAME VERSION STATUS -------------------- ----------------------------------- ------------------------------------------------------------ ---------------------- CATALOG Oracle Database Catalog Views 19.0.0.0.0 VALID CATPROC Oracle Database Packages and Types 19.0.0.0.0 VALID JAVAVM JServer JAVA Virtual Machine 19.0.0.0.0 VALID XML Oracle XDK 19.0.0.0.0 VALID CATJAVA Oracle Database Java Packages 19.0.0.0.0 VALID APS OLAP Analytic Workspace 19.0.0.0.0 VALID RAC Oracle Real Application Clusters 19.0.0.0.0 OPTION OFF OWM Oracle Workspace Manager 19.0.0.0.0 VALID CONTEXT Oracle Text 19.0.0.0.0 VALID XDB Oracle XML Database 19.0.0.0.0 VALID ORDIM Oracle Multimedia 19.0.0.0.0 VALID SDO Spatial 19.0.0.0.0 VALID XOQ Oracle OLAP API 19.0.0.0.0 VALID APEX Oracle Application Express 3.2.1.00.12 VALID 14 rows selected.
综上：少了以下几个，多了个rac组件
SQL> SELECT COMP_ID,comp_name,version,STATUS FROM dba_registry; COMP_ID COMP_NAME VERSION STATUS -------------------- ----------------------------------- ------------------------------------------------------------ ---------------------- CATALOG Oracle Database Catalog Views 19.0.0.0.0 VALID CATPROC Oracle Database Packages and Types 19.0.0.0.0 VALID JAVAVM JServer JAVA Virtual Machine 19.0.0.0.0 VALID XML Oracle XDK 19.0.0.0.0 VALID CATJAVA Oracle Database Java Packages 19.0.0.0.0 VALID APS OLAP Analytic Workspace 19.0.0.0.0 VALID RAC Oracle Real Application Clusters 19.0.0.0.0 OPTION OFF OWM Oracle Workspace Manager 19.0.0.0.0 VALID CONTEXT Oracle Text 19.0.0.0.0 VALID XDB Oracle XML Database 19.0.0.0.0 VALID ORDIM Oracle Multimedia 19.0.0.0.0 VALID SDO Spatial 19.0.0.0.0 VALID XOQ Oracle OLAP API 19.0.0.0.0 VALID APEX Oracle Application Express 3.2.1.00.12 VALID 14 rows selected.
更改oracle的环境变量，为新的19c的
[oracle@dbserver ~]$ cat .bash_profile # .bash_profile # Get the aliases and functions if [ -f ~/.bashrc ]; then . ~/.bashrc fi # User specific environment and startup programs PATH=$PATH:$HOME/.local/bin:$HOME/bin export PATH # Oracle Settings oracle TMP=/tmp; export TMP TMPDIR=$TMP; export TMPDIR export #ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE #ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1; export ORACLE_HOME ORACLE_BASE=/u02/app/oracle; export ORACLE_BASE ORACLE_HOME=$ORACLE_BASE/product/19c/dbhome_1; export ORACLE_HOME ORACLE_SID=prod; export ORACLE_SID ORACLE_TERM=xterm; export ORACLE_TERM PATH=/usr/sbin:$PATH; export PATH PATH=$ORACLE_HOME/bin:$PATH; export PATH LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH NLS_DATE_FORMAT="yyyy-mm-dd HH24:MI:SS"; export NLS_DATE_FORMAT NLS_LANG=AMERICAN_AMERICA.ZHS16GBK;export NLS_LANG alias sqlplus='rlwrap sqlplus' alias rman='rlwrap rman' [oracle@dbserver ~]$ source .bash_profile
重启数据库，监听，查看监听，数据库等是否正常。