11203RAC升级到11204RAC
rac
2节点
11.2.0.3
升级到
11.2.0.4
完整步骤
0.步骤总结
0.1升级前检查
环境介绍
[oracle@racdg1 ~]$ cat /etc/hosts
#127.0.0.1 racdg1
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
10.107.174.130 racdg1
10.107.174.131 racdg2
11.11.11.100 racdgpri1
11.11.11.200 racdgpri2
10.107.174.140 racdgvip1
10.107.174.141 racdgvip2
10.107.174.150 racdgscan
SQL> show parameter name;
NAME TYPE VALUE
----------------------- ---------- ------------------------------
db_file_name_convert string +DATA/rac, +DATA/racdg
db_name string rac
db_unique_name string racdg
global_names boolean FALSE
instance_name string racdg1
lock_name_space string
log_file_name_convert string +DATA/rac,+DATA/racdg,+FRA/rac, +FRA/racdg
processor_group_name string
service_names string racdg
数据库状态(都是open
):
SQL> select INST_ID,INSTANCE_NAME,STATUS from gv$instance;
INST_ID INSTANCE_NAME STATUS
---------- ------------------------------------------------ ------------------------------------
1 racdg1 OPEN
2 racdg2 OPEN
查看2个节点存储状态(11204
数据库存放在/home
下),空间是否足够:
现在的grid_home
和oracle_home
都在/home
下(另一个节点也是不粘贴了)
[grid@racdg1 ~]$ echo $ORACLE_BASE
/home/g01/base
[grid@racdg1 ~]$ echo $ORACLE_HOME
[oracle@racdg1 ~]$ echo $ORACLE_BASE
/home/u01/app/oracle
[oracle@racdg1 ~]$ echo $ORACLE_HOME
/home/u01/app/oracle/11.2.0/db_1
/home
空间够,另一个节点不粘贴了
[grid@racdg1 ~]$ df -TH
文件系统 类型 容量 已用 可用 已用%% 挂载点
/dev/mapper/VolGroup-lv_root ext4 36G 9.2G 25G 28% /
tmpfs tmpfs 145G 76G 70G 53% /dev/shm
/dev/xvda1 ext4 508M 52M 431M 11% /boot
/dev/mapper/vg_racdg1-lv_home ext4 476G 287G 165G 64% /home
/dev/mapper/ora_vg-lv_backup ext4 3.3T 2.0T 1.2T 63% /backup
0.2升级准备
所有节点建立目录(升级的软件会安装到新的存储地方):
grid: oracle_home
新目录
oracle: oracle_home
新目录
上传安装介质到节点1:
解压:赋予安装介质解压目录权限,修改目录所用者和属组
建议这个地方做备份
数据库备份 rman
全备
grid: oracle_home
目录备份 ,打包
oracle: oracle_home
目录备份,打包
0.3升级前校验
确定RAC
主节点
[grid@racdg1 cssd]$ ocrconfig -showbackup
racdg1 2021/04/02 09:18:25 /home/g01/grid/11.2.0/cdata/racdg/backup00.ocr
racdg1 2021/04/02 05:18:17 /home/g01/grid/11.2.0/cdata/racdg/backup01.ocr
racdg1 2021/04/02 01:18:08 /home/g01/grid/11.2.0/cdata/racdg/backup02.ocr
racdg1 2021/04/01 01:17:13 /home/g01/grid/11.2.0/cdata/racdg/day.ocr
racdg1 2021/03/19 21:06:22 /home/g01/grid/11.2.0/cdata/racdg/week.ocr
PROT-25: Manual backups for the Oracle Cluster Registry are not available
[grid@racdg2 cssd]$ ocrconfig -showbackup
racdg1 2021/04/02 09:18:25 /home/g01/grid/11.2.0/cdata/racdg/backup00.ocr
racdg1 2021/04/02 05:18:17 /home/g01/grid/11.2.0/cdata/racdg/backup01.ocr
racdg1 2021/04/02 01:18:08 /home/g01/grid/11.2.0/cdata/racdg/backup02.ocr
racdg1 2021/04/01 01:17:13 /home/g01/grid/11.2.0/cdata/racdg/day.ocr
racdg1 2021/03/19 21:06:22 /home/g01/grid/11.2.0/cdata/racdg/week.ocr
PROT-25: Manual backups for the Oracle Cluster Registry are not available
说明racdg1
是主节点
0.4升级集群软件,完成之后所有节点grid
用户修改环境变量(路径有变化 ORACLE_BASE
和ORACLE_HOME
)
0.5升级oracle
软件,更新数据字典 ,完成之后所有节点oracle
用户修改环境变量(路径有变化 ORACLE_BASE
和ORACLE_HOME
,PATH
)
主节点存放升级oracle
和grid
软件,并执行升级
1.升级前检查
数据库状态:
SQL> select INST_ID,INSTANCE_NAME,STATUS from gv$instance;
INST_ID INSTANCE_NAME STATUS
---------- ------------------------------------------------ ------------------------------------
1 racdg1 OPEN
2 racdg2 OPEN
所有节点都一致
2.升级准备
所有个节点建立目录:
root:
mkdir -p /home/11204/app/grid
mkdir -p /home/11204/app/11.2.0/grid
mkdir -p /home/11204/app/oracle
mkdir -p /home/11204/app/oracle/product/11.2.0/db_1
chown -R oracle:oinstall /home/11204/
chown -R grid:oinstall /home/11204/app/grid
chown -R grid:oinstall /home/11204/app/11.2.0
chown -R oracle:oinstall /home/11204/app/oracle
chmod -R 775 /home/11204
上传安装介质到节点1:
[root@racdg1 src]# pwd
/usr/local/src
[root@racdg1 src]# ll
总用量 3664452
-rw-r--r-- 1 root root 1395582860 4月 2 09:55 p13390677_112040_Linux-x86-64_1of7.zip
-rw-r--r-- 1 root root 1151304589 4月 2 09:56 p13390677_112040_Linux-x86-64_2of7.zip
-rw-r--r-- 1 root root 1205251894 4月 2 09:54 p13390677_112040_Linux-x86-64_3of7.zip
drwxrwxrwx 9 500 500 4096 11月 19 2019 rlwrap-0.32
-rw-r--r-- 1 root root 233530 11月 19 2019 rlwrap-0.32.tar.gz
解压:
unzip p13390677_112040_Linux-x86-64_1of7.zip
unzip p13390677_112040_Linux-x86-64_2of7.zip
unzip p13390677_112040_Linux-x86-64_3of7.zip
[root@racdg1 src]# ll
总用量 3664460
drwxr-xr-x 7 root root 4096 8月 27 2013 database
drwxr-xr-x 7 root root 4096 8月 27 2013 grid
-rw-r--r-- 1 root root 1395582860 4月 2 09:55 p13390677_112040_Linux-x86-64_1of7.zip
-rw-r--r-- 1 root root 1151304589 4月 2 09:56 p13390677_112040_Linux-x86-64_2of7.zip
-rw-r--r-- 1 root root 1205251894 4月 2 09:54 p13390677_112040_Linux-x86-64_3of7.zip
drwxrwxrwx 9 500 500 4096 11月 19 2019 rlwrap-0.32
-rw-r--r-- 1 root root 233530 11月 19 2019 rlwrap-0.32.tar.gz
chown -R grid:oinstall grid
chown -R oracle:oinstall database
3.升级前校验
su - grid
cd /usr/local/src/grid/
./runcluvfy.sh stage -pre crsinst -upgrade -n racdg1,racdg2 -src_crshome /home/g01/grid/11.2.0(旧的GRID_HOME) -dest_crshome /home/11204/app/11.2.0/grid(新的GRID_HOME) -dest_version 11.2.0.4.0 -verbose >> verify.log
检查结果还是
WARNING:
PRVF-5640 : Both search and domain entries are present in file "/etc/resolv.conf" on the following nodes: racdg1,racdg2
Checking if domain entry in file "/etc/resolv.conf" is consistent across the nodes...
domain entry in file "/etc/resolv.conf" is consistent across nodes
Checking file "/etc/resolv.conf" to make sure that only one domain entry is defined
All nodes have one domain entry defined in file "/etc/resolv.conf"
Checking all nodes to make sure that domain is "node.com" as found on node "up3"
All nodes of the cluster have same value for 'domain'
Checking if search entry in file "/etc/resolv.conf" is consistent across the nodes...
search entry in file "/etc/resolv.conf" is consistent across nodes
Checking file "/etc/resolv.conf" to make sure that only one search entry is defined
All nodes have one search entry defined in file "/etc/resolv.conf"
Checking all nodes to make sure that search entry is "node.com" as found on node "up3"
All nodes of the cluster have same value for 'search'
Checking DNS response time for an unreachable node
上面是关于dns
解析,可以忽略掉
4.升级grid
集群软件(图形化):
su - grid
cd /usr/local/src/grid/
./runInstaller
跳过软件更新
选择升级
直接下一步
下一步
下面的报错是关于DNS
的,选择忽略
开始安装
按节点顺序以root
执行脚本 时间有点长:
只粘贴一个节点的脚本执行过程
[root@racdg1 ~]# /home/11204/app/11.2.0/grid/rootupgrade.sh
Performing root user operation for Oracle 11g
The following environment variables are set as:
ORACLE_OWNER= grid
ORACLE_HOME= /home/11204/app/11.2.0/grid
Enter the full pathname of the local bin directory: [/usr/local/bin]:
The contents of "dbhome" have not changed. No need to overwrite.
The contents of "oraenv" have not changed. No need to overwrite.
The contents of "coraenv" have not changed. No need to overwrite.
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Using configuration parameter file: /home/11204/app/11.2.0/grid/crs/install/crsconfig_params
Creating trace directory
User ignored Prerequisites during installation
Installing Trace File Analyzer
ASM 升级已在第一个节点上开始。
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'racdg1'
CRS-2673: Attempting to stop 'ora.crsd' on 'racdg1'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'racdg1'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'racdg1'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'racdg1'
CRS-2673: Attempting to stop 'ora.oc4j' on 'racdg1'
CRS-2673: Attempting to stop 'ora.racdg.db' on 'racdg1'
CRS-2673: Attempting to stop 'ora.cvu' on 'racdg1'
CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'racdg1' succeeded
CRS-2673: Attempting to stop 'ora.scan1.vip' on 'racdg1'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'racdg1' succeeded
CRS-2673: Attempting to stop 'ora.racdg1.vip' on 'racdg1'
CRS-2677: Stop of 'ora.scan1.vip' on 'racdg1' succeeded
CRS-2672: Attempting to start 'ora.scan1.vip' on 'racdg2'
CRS-2677: Stop of 'ora.racdg1.vip' on 'racdg1' succeeded
CRS-2672: Attempting to start 'ora.racdg1.vip' on 'racdg2'
CRS-2676: Start of 'ora.scan1.vip' on 'racdg2' succeeded
CRS-2672: Attempting to start 'ora.LISTENER_SCAN1.lsnr' on 'racdg2'
CRS-2676: Start of 'ora.racdg1.vip' on 'racdg2' succeeded
CRS-2676: Start of 'ora.LISTENER_SCAN1.lsnr' on 'racdg2' succeeded
CRS-2677: Stop of 'ora.oc4j' on 'racdg1' succeeded
CRS-2672: Attempting to start 'ora.oc4j' on 'racdg2'
CRS-2677: Stop of 'ora.cvu' on 'racdg1' succeeded
CRS-2672: Attempting to start 'ora.cvu' on 'racdg2'
CRS-2677: Stop of 'ora.racdg.db' on 'racdg1' succeeded
CRS-2673: Attempting to stop 'ora.ARCH.dg' on 'racdg1'
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'racdg1'
CRS-2673: Attempting to stop 'ora.DATA1.dg' on 'racdg1'
CRS-2673: Attempting to stop 'ora.FRA.dg' on 'racdg1'
CRS-2673: Attempting to stop 'ora.OCR.dg' on 'racdg1'
CRS-2677: Stop of 'ora.DATA.dg' on 'racdg1' succeeded
CRS-2677: Stop of 'ora.ARCH.dg' on 'racdg1' succeeded
CRS-2677: Stop of 'ora.FRA.dg' on 'racdg1' succeeded
CRS-2677: Stop of 'ora.DATA1.dg' on 'racdg1' succeeded
CRS-2676: Start of 'ora.cvu' on 'racdg2' succeeded
CRS-2676: Start of 'ora.oc4j' on 'racdg2' succeeded
CRS-2677: Stop of 'ora.OCR.dg' on 'racdg1' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'racdg1'
CRS-2677: Stop of 'ora.asm' on 'racdg1' succeeded
CRS-2673: Attempting to stop 'ora.ons' on 'racdg1'
CRS-2677: Stop of 'ora.ons' on 'racdg1' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'racdg1'
CRS-2677: Stop of 'ora.net1.network' on 'racdg1' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'racdg1' has completed
CRS-2677: Stop of 'ora.crsd' on 'racdg1' succeeded
CRS-2673: Attempting to stop 'ora.crf' on 'racdg1'
CRS-2673: Attempting to stop 'ora.ctssd' on 'racdg1'
CRS-2673: Attempting to stop 'ora.evmd' on 'racdg1'
CRS-2673: Attempting to stop 'ora.asm' on 'racdg1'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'racdg1'
CRS-2677: Stop of 'ora.crf' on 'racdg1' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'racdg1' succeeded
CRS-2677: Stop of 'ora.evmd' on 'racdg1' succeeded
CRS-2677: Stop of 'ora.asm' on 'racdg1' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'racdg1'
CRS-2677: Stop of 'ora.ctssd' on 'racdg1' succeeded
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'racdg1' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'racdg1'
CRS-2677: Stop of 'ora.cssd' on 'racdg1' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'racdg1'
CRS-2677: Stop of 'ora.gipcd' on 'racdg1' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'racdg1'
CRS-2677: Stop of 'ora.gpnpd' on 'racdg1' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'racdg1' has completed
CRS-4133: Oracle High Availability Services has been stopped.
OLR initialization - successful
Replacing Clusterware entries in upstart
clscfg: EXISTING configuration version 5 detected.
clscfg: version 5 is 11g Release 2.
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
Configure Oracle Grid Infrastructure for a Cluster ... succeeded
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
Configure Oracle Grid Infrastructure for a Cluster ... succeeded
每个脚本看到上面的提示就说明脚本执行成功
回到图形化界面点击ok
下面这个报错是因为之前忽略的那个DNS
解析的问题,不用担心,不影响接下来的操作,点ok
之后 点close
所有节点修改grid
环境变量:
实际就修改了2处(ORACLE_BASE
和ORACLE_HOME
):
export ORACLE_BASE=/u01/app/grid
export ORACLE_HOME=/u01/app/11.2.0/grid
退出到root
重新连接grid
(就是重新加载环境变量)
asmca
所有节点的磁盘都mount
成功,说明没问题。
5.升级数据库软件(图形化)
主节点:
[root@racdg1 ~]# su - oracle
[oracle@racdg1 ~]$ cd /usr/local/src/database/
[oracle@racdg1 database]$ ./runInstaller
取消勾选
跳过更新
升级已经存在的数据库
下一步
下一步
下一步
修改 oracle_base
和oracle_home
为新路径
下一步
第一个错误是关于时间同步,因为我们没有配NTP
,使用Oracle
内部的CTSS
,查看一下两个机器时间一致就可以忽略,第二个错误还是因为DNS
,忽略
开始安装
3个节点按顺序以root
执行:(只粘贴一个节点的输出)
节点1:
/home/11204/app/oracle/product/11.2.0/db_1/root.sh
Performing root user operation for Oracle 11g
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /home/11204/app/oracle/product/11.2.0/db_1
Enter the full pathname of the local bin directory: [/usr/local/bin]:
The contents of "dbhome" have not changed. No need to overwrite.
The contents of "oraenv" have not changed. No need to overwrite.
The contents of "coraenv" have not changed. No need to overwrite.
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Finished product-specific root actions.
节点2:
/home/11204/app/oracle/product/11.2.0/db_1/root.sh
Finished product-specific root actions.
每个节点看到上面信息说明脚本执行成功
点击 ok之后跳出图形,升级数据字典,点击下一步
下一步
点击yes
在升级结束时重新编译无效对象,并行度63
下面指的空间不足,这个负数是asmcmd lsdg
中的Usable_file_MB
关于Usable_file_MB
参考
https://blog.csdn.net/w892824196/article/details/94379315
这里选择忽略
[grid@racdg1 ~]$ asmcmd lsdg
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED NORMAL N 512 4096 1048576 202772 129518 0 64759 0 N ARCH/
MOUNTED NORMAL N 512 4096 1048576 4938689 33608 1048570 -507481 0 N DATA/
MOUNTED EXTERN N 512 4096 1048576 1995753 631162 0 631162 0 N DATA1/
MOUNTED EXTERN N 512 4096 1048576 202772 178043 0 178043 0 N FRA/
MOUNTED NORMAL N 512 4096 1048576 15342 14416 5114 4651 0 Y OCR/
点击完成
可以看到从11023升级到11204
可以看到升级有那些升级组件
执行很慢,耐心等待
没有安装EM,所以忽略下面的错误
结果(我这里实例2是inactive
的,后面有处理过程)
是节点二的实例起不来,报错是没有spfileracdg1.ora
这个文件,去节点二看一下
[grid@racdg1 ~]$ srvctl start instance -d racdg -i racdg2
PRCR-1013 : 无法启动资源 ora.racdg.db
PRCR-1064 : 无法在节点 racdg2 上启动资源 ora.racdg.db
CRS-5017: The resource action "ora.racdg.db start" encountered the following error:
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '/home/u01/app/oracle/11.2.0/db_1/dbs/spfileracdg1.ora'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
. For details refer to "(:CLSN00107:)" in "/home/11204/app/11.2.0/grid/log/racdg2/agent/crsd/oraagent_oracle/oraagent_oracle.log".
CRS-2674: Start of 'ora.racdg.db' on 'racdg2' failed
节点二是有spfileracdg2.ora
的,但是没有spfileracdg1.ora
[oracle@racdg2 dbs]$ pwd
/home/u01/app/oracle/11.2.0/db_1/dbs
[oracle@racdg2 dbs]$ ls -lrt
总用量 43184
-rw-r--r-- 1 oracle oinstall 2851 1月 12 2018 init.ora
-rw-r----- 1 oracle oinstall 2073 1月 18 2018 initracdg2.ora.bak
-rw-r--r-- 1 oracle oinstall 1562 12月 31 2019 initracdg1.ora
-rw-r----- 1 root root 37 12月 31 2019 initracdg2.ora.191231
-rw-r----- 1 oracle oinstall 1536 6月 18 2020 orapwracdg2
-rw-r--r-- 1 oracle oinstall 2208 3月 15 17:01 initracdg2.ora.bak.racdg2
-rw-r----- 1 oracle asmadmin 44171264 3月 29 18:29 c-2500179532-20210329-00
-rw-r--r-- 1 oracle oinstall 2118 4月 2 11:42 initracdg2.ora
-rw-rw---- 1 oracle asmadmin 1544 4月 2 13:04 hc_racdg2.dat
-rw-r----- 1 oracle asmadmin 5632 4月 2 14:27 spfileracdg2.ora
我这里的处理办法是吧spfileracdg2.ora
备份一份,然后spfileracdg2.ora
改名成spfileracdg1.ora
,然后实例就能正常起来了,至于为什么我也想不通,有大神知道可以联系我,一定要注意操作的每一步过程,其实这个节点二之前就已经起不来了,我没有管他
所有节点修改oracle
环境变量:
实际就修改了3处(ORACLE_BASE
和ORACLE_HOME
,PATH
):
export ORACLE_BASE=/home/11204/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
export PATH=$ORACLE_HOME/bin:/u01/app/11.2.0/grid/bin:$PATH
建议重新启动数据库
srvctl stop database -d racdg
srvctl start database -d racdg
重启了数据库之后发现spfile
用的居然还是路径下的,并且alert
日志等路径都是原来的路径下,下面处理一下
SQL> show parameter spfile;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string /home/u01/app/oracle/11.2.0/db_1/dbs/spfileracdg1.ora
SQL> show parameter dump;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
background_core_dump string partial
background_dump_dest string /home/u01/app/oracle/diag/rdbms/racdg/racdg2/trace
core_dump_dest string /home/u01/app/oracle/diag/rdbms/racdg/racdg2/cdump
max_dump_file_size string unlimited
shadow_core_dump string partial
user_dump_dest string /home/u01/app/oracle/diag/rdbms/racdg/racdg2/trace
下面的命令发现pfile
生成在了新的ORACLE_HOME/dbs
下
create pfile from spfile
先备份然后把新生成的pfile
中的audit_file_dest
和diagnostic_dest
等所有目录相关的都改成新的路径
shu immediate
startup pfile=新的ORACLE_HOME/dbs/initracdg1.ora
--启动之后
create spfile from pfile
路径都改过来了
SQL> show parameter dump;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
background_core_dump string partial
background_dump_dest string /home/11204/app/oracle/diag/rdbms/racdg/racdg2/trace
core_dump_dest string /home/11204/app/oracle/diag/rdbms/racdg/racdg2/cdump
max_dump_file_size string unlimited
shadow_core_dump string partial
user_dump_dest string /home/11204/app/oracle/diag/rdbms/racdg/racdg2/trace
如果重启数据库失败,就集群层面关闭 root
下运行
/home/app/11.2.0/grid/bin/crsctl stop cluster -all
然后开启集群+数据库
/home/app/11.2.0/grid/bin/crsctl start cluster -all
分别检查racdg1
和racdg2
的数据库状态(全部为open
)
SQL> select INST_ID,INSTANCE_NAME,STATUS from gv$instance;
INST_ID INSTANCE_NAME STATUS
---------- ------------------------------------------------ ------------------------------------
1 racdg1 OPEN
2 racdg2 OPEN
注意:如果重启之后进入rac2
空实例数据库,可能是有延迟,稍等几分钟后重新进入
sqlplus / as sysdba
–查看无效对象(如果还有无效对象就是执行@$ORACLE_HOME/rdbms/admin/utlrp.sql
重新编译一下)
select distinct object_name from dba_invalid_objects;
no rows selected
–查看版本
SQL> select comp_name,version,status from sys.dba_registry;
COMP_NAME VERSION STATUS
---------------------------------- -------------------- ------------------------------------------------------------------
OWB 11.2.0.3.0 VALID
Oracle Application Express 3.2.1.00.12 VALID
Oracle Enterprise Manager 11.2.0.4.0 VALID
OLAP Catalog 11.2.0.4.0 VALID
Spatial 11.2.0.4.0 VALID
Oracle Multimedia 11.2.0.4.0 VALID
Oracle XML Database 11.2.0.4.0 VALID
Oracle Text 11.2.0.4.0 VALID
Oracle Expression Filter 11.2.0.4.0 VALID
Oracle Rules Manager 11.2.0.4.0 VALID
Oracle Workspace Manager 11.2.0.4.0 VALID
Oracle Database Catalog Views 11.2.0.4.0 VALID
Oracle Database Packages and Types 11.2.0.4.0 VALID
JServer JAVA Virtual Machine 11.2.0.4.0 VALID
Oracle XDK 11.2.0.4.0 VALID
Oracle Database Java Packages 11.2.0.4.0 VALID
OLAP Analytic Workspace 11.2.0.4.0 VALID
Oracle OLAP API 11.2.0.4.0 VALID
Oracle Real Application Clusters 11.2.0.4.0 VALID
已选择19行。
SQL> select INST_ID,INSTANCE_NAME,STATUS from gv$instance;
INST_ID INSTANCE_NAME STATUS
---------- ------------------------------------------------ ------------------------------------
2 racdg2 OPEN
1 racdg1 OPEN
下面可选,如果手动升级数据字典的话用的到
cp $ORACLE_HOME/dbs/* $NEW_ORACLE_HOME/dbs/
cp $OLD_ORACLE_HOME/network/admin/* $NEW_ORACLE_HOME/network/admin/
说明:
若在升级数据字典的时候不使用dbua
图形界面的话,可以采用如下的脚本进行数据字典的升级
1.升级模式启动数据库
startup upgrade
如果又下面的报错
ORA-00838:Specified value of MEMORY_TARGET is too small,needs to be at least 1468M
启动前修改pfile
或spfile
修改memory_target=1468M
参数
ORA-00845:MEMORY_TARGET not suppoorted on this system
这里是因为/dev/shm
必须大于MEMORY_TARGET
,如果/dev/shm
比MEMORY_TARGET
小就会报错,解决办法是增加/dev/shm
的大小