当前位置: 代码迷 >> 综合 >> Oracle集群管理-19.7升级到19.8实践案例1
  详细解决方案

Oracle集群管理-19.7升级到19.8实践案例1

热度:43   发布时间:2024-02-06 09:11:26.0

1 GRU和DRU

AS ORACLE

srvctl stop home -o $ORACLE_HOME -s /home/orcl/123.txt -n orcldb1
(srvctl stop home -o $ORACLE_HOME -s /home/orcl/123.txt -n orcldb2 --操作节点)
AS ROOT
cd /u01/app/19c/grid/crs/install

./rootcrs.sh -prepatch


opatch apply -oh $ORACLE_HOME -local /home/grid/soft/19.8/31305339/31281355/
opatch apply -oh $ORACLE_HOME -local /home/grid/soft/19.8/31305339/31304218/
opatch apply -oh $ORACLE_HOME -local /home/grid/soft/19.8/31305339/31305087/
opatch apply -oh $ORACLE_HOME -local /home/grid/soft/19.8/31305339/31335188/


opatch lspatches
31335188;TOMCAT RELEASE UPDATE 19.0.0.0.0 (31335188)
31305087;OCW RELEASE UPDATE 19.8.0.0.0 (31305087)
31304218;ACFS RELEASE UPDATE 19.8.0.0.0 (31304218)
31281355;Database Release Update : 19.8.0.0.200714 (31281355)

OPatch succeeded.

AS ORACLE

cd /home/orcl/31305339/31305087/custom/scripts
./prepatch.sh -dbhome $ORACLE_HOME
opatch apply -oh $ORACLE_HOME -local /home/orcl/31305339/31281355/
opatch apply -oh $ORACLE_HOME -local /home/orcl/31305339/31305087/
./postpatch.sh -dbhome $ORACLE_HOME

AS ROOT

cd /u01/app/19c/grid/rdbms/install/
./rootadd_rdbms.sh
cd /u01/app/19c/grid/crs/install/
./rootcrs.sh -postpatch

AS ORACLE

srvctl start instance -d orcl -n orcldb1

cd $ORACLE_HOME/OPatch

./datapatch -verbose

1 JVM

AS  ORACLE 
SQL> alter system set cluster_database=false scope=spfile;


cd 31219897
opatch apply
startup upgrade


SQL> alter system set cluster_database=true scope=spfile;
srvctl stop database -d orcl

srvctl start home -o $ORACLE_HOME -s /home/orcl/123.txt -n orcldb1
srvctl start home -o $ORACLE_HOME -s /home/orcl/123.txt -n orcldb2