Neste artigo é abordado o processo necessário a ser executado para que seja possível atualizar o Sistema Operacional Oracle Linux com o Oracle Restart.
O procedimento será realizado em um ambiente com Oracle Linux 7, com o Oracle Grid 19c e Database 12.2, onde será atualizado o SO para o Oracle Linux 8. Vale destacar que o primeiro passo antes de atualizar o SO é validar se a versão para a qual será atualizada é compatível com o Oracle Restart e Oracle Database instalados.
Antes de iniciar o processo de atualização do SO é necessário desabilitar e parar e desabilitar os serviços do grid, para que eles não iniciem quando o servidor reiniciar. Para isso deve-se conectar com o usuário root e executar os comandos abaixo.
--Desabilitando os serviços do Grid # cd Grid_home/bin # ./crsctl disable has --Parando os serviços do Grid # ./crsctl stop has --Validando o status do serviços (que devem estar parados) # ./crsctl check has
[oracle@srvlamim01:cdbhmg ~]$ sudo su - Last login: Thu May 18 09:18:22 -03 2023 from spdwvifr008.marfrig-ad.local on pts/0 [root@srvlamim01 ~]# . oraenv ORACLE_SID = [root] ? +ASM The Oracle base has been set to /orabin01/app/grid [root@srvlamim01 ~]# cd $ORACLE_HOME/bin [root@srvlamim01 bin]# ./crsctl disable has CRS-4621: Oracle High Availability Services autostart is disabled. [root@srvlamim01 bin]# [root@srvlamim01 bin]# ./crsctl stop has CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'srvlamim01' CRS-2673: Attempting to stop 'ora.evmd' on 'srvlamim01' CRS-2673: Attempting to stop 'ora.cdbhmga.db' on 'srvlamim01' CRS-2673: Attempting to stop 'ora.cdbhmg.db' on 'srvlamim01' CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'srvlamim01' CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'srvlamim01' succeeded CRS-2677: Stop of 'ora.evmd' on 'srvlamim01' succeeded CRS-2677: Stop of 'ora.cdbhmg.db' on 'srvlamim01' succeeded CRS-2677: Stop of 'ora.cdbhmga.db' on 'srvlamim01' succeeded CRS-2673: Attempting to stop 'ora.DGDATA.dg' on 'srvlamim01' CRS-2673: Attempting to stop 'ora.DGRECO.dg' on 'srvlamim01' CRS-2677: Stop of 'ora.DGDATA.dg' on 'srvlamim01' succeeded CRS-2677: Stop of 'ora.DGRECO.dg' on 'srvlamim01' succeeded CRS-2673: Attempting to stop 'ora.asm' on 'srvlamim01' CRS-2677: Stop of 'ora.asm' on 'srvlamim01' succeeded CRS-2673: Attempting to stop 'ora.cssd' on 'srvlamim01' CRS-2677: Stop of 'ora.cssd' on 'srvlamim01' succeeded CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'srvlamim01' has completed CRS-4133: Oracle High Availability Services has been stopped. [root@srvlamim01 bin]# [root@srvlamim01 bin]# ./crsctl check has CRS-4639: Could not contact Oracle High Availability Services [root@srvlamim01 bin]# [root@srvlamim01 bin]# ps -ef | grep pmon root 25956 24063 0 09:45 pts/2 00:00:00 grep --color=auto pmon [root@srvlamim01 bin]# [root@srvlamim01 bin]#
Concluída a etapa acima, pode ser realizado o processo de upgrade do Sistema Operacional.
Ao término do processo de Upgrade do Sistema Operacional, deve realizar um restart do servidor. Feito isso, podemos seguir com o processo de atualização das bibliotecas do Oracle (relink) e o lock do grid.
--Atualização das bibliotecas (relink) # cd Grid_home/rdbms/install/ # ./rootadd_rdbms.sh --Gerar o lock do Grid # cd Grid_home/crs/install # roothas.sh -lock
Agora basta ativar novamente a inicialização automática dos serviços do grid, iniciar os serviços e validar o status do serviços.
--Habilitar a inicialização automatica dos serviços do grid # cd Grid_home/bin # ./crsctl enable has --Iniciar os serviços do grid # ./crsctl start has --Validar os serviços # ./crsctl stat res -t
[root@srvlamim01 ~]#
[root@srvlamim01 ~]# shutdown -r now
[oracle@srvlamim01:cdbhmg ~]$
[oracle@srvlamim01:cdbhmg ~]$ sudo su -
Last login: Thu May 18 11:49:28 -03 2023 on pts/2
[root@srvlamim01 ~]# . oraenv
ORACLE_SID = [root] ? +ASM
The Oracle base has been set to /orabin01/app/grid
[root@srvlamim01 ~]# cd $ORACLE_HOME/rdbms/install/
[root@srvlamim01 install]#
[root@srvlamim01 install]# ./rootadd_rdbms.sh
[root@srvlamim01 install]#
[root@srvlamim01 install]# cd $ORACLE_HOME/crs/install/
[root@srvlamim01 install]#
[root@srvlamim01 install]#
[root@srvlamim01 install]# ./roothas.sh -lock
Using configuration parameter file: /orabin01/app/19.3/grid/crs/install/crsconfig_params
The log of current session can be found at:
/orabin01/app/grid/crsdata/srvlamim01/crsconfig/halock__2023-05-18_11-53-09AM.log
2023/05/18 11:53:14 CLSRSC-329: Replacing Clusterware entries in file 'oracle-ohasd.service'
[root@srvlamim01 install]# cd $ORACLE_HOME/bin
[root@srvlamim01 bin]# ./crsctl enable has
CRS-4622: Oracle High Availability Services autostart is enabled.
[root@srvlamim01 bin]#
[root@srvlamim01 bin]# ./crsctl start has
CRS-4123: Oracle High Availability Services has been started.
[root@srvlamim01 bin]# ./crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DGDATA.dg
ONLINE ONLINE srvlamim01 STABLE
ora.DGRECO.dg
ONLINE ONLINE srvlamim01 STABLE
ora.LISTENER.lsnr
ONLINE ONLINE srvlamim01 STABLE
ora.asm
ONLINE ONLINE srvlamim01 Started,STABLE
ora.ons
OFFLINE OFFLINE srvlamim01 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cdbhmg.db
1 ONLINE ONLINE srvlamim01 Open,HOME=/orabin01/
app/oracle/product/1
2.2/dbhome_1,STABLE
ora.cdbtsts.db
1 ONLINE ONLINE srvlamim01 Open,HOME=/orabin01/
app/oracle/product/1
2.2/dbhome_1,STABLE
ora.cssd
1 ONLINE ONLINE srvlamim01 STABLE
ora.diskmon
1 OFFLINE OFFLINE STABLE
ora.evmd
1 ONLINE ONLINE srvlamim01 STABLE
--------------------------------------------------------------------------------
[root@srvlamim01 bin]#
https://docs.oracle.com/en/database/oracle/oracle-database/19/upgor/upgrading-os-on-an-oracle-restart-server.html#GUID-E169205F-3E34-49AC-A232-03055F147F14
0 Comentários