Este artigo tem como objetivo explicar o motivo do erro após aplicar o Patch PSU 10.2.0.5.4 para o Banco de Dados Oracle 10.2.0.5.0 ao subir a instância ASM.
Estou usando um Banco de Dados Single Instance com ASM, ou seja, non-RAC.
Após o Patch Aplicado continuei o processo de aplicação do Patch no Banco de Dados. Subi os serviços do Banco de Dados e no momento de subir a instância ASM ocorreu o erro.
Subindo o Listener.
[oracle@serveroracle 12419392]$ lsnrctl start LSNRCTL for Linux: Version 10.2.0.5.0 - Production on 15-MAR-2012 17:52:43 Copyright (c) 1991, 2010, Oracle. All rights reserved. Starting /oraprd01/app/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait... TNSLSNR for Linux: Version 10.2.0.5.0 - Production System parameter file is /oraprd01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora Log messages written to /oraprd01/app/oracle/product/10.2.0/db_1/network/log/listener.log Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.104)(PORT=1521))) Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0))) Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.56.104)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 10.2.0.5.0 - Production Start Date 15-MAR-2012 17:52:43 Uptime 0 days 0 hr. 0 min. 0 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /oraprd01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora Listener Log File /oraprd01/app/oracle/product/10.2.0/db_1/network/log/listener.log Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.104)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0))) Services Summary... Service "PLSExtProc" has 1 instance(s). Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service... Service "dbprod" has 1 instance(s). Instance "dbprod", status UNKNOWN, has 1 handler(s) for this service... The command completed successfully [oracle@serveroracle 12419392]$
Vamos subir a Instância ASM.
[oracle@serveroracle 12419392]$ export ORACLE_SID=+ASM [oracle@serveroracle 12419392]$ sqlplus sys/***** as sysdba SQL*Plus: Release 10.2.0.5.0 - Production on Thu Mar 15 17:53:01 2012 Copyright (c) 1982, 2010, Oracle. All Rights Reserved. Connected to an idle instance. SQL> startup mount ORA-29701: unable to connect to Cluster Manager SQL> shutdown immediate ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Linux Error: 2: No such file or directory SQL> exit Disconnected [oracle@serveroracle 12419392]$
Ao tentar subir a Instância ASM, ocorreu um problema no Cluster Manager, no qual, não foi possível conectar ao mesmo.
Para resolver o problema, devemos remover o css com o usuário “root” e acessar o diretório “$ORACLE_HOME/bin” e executar os seguintes comandos:
– localconfig delete
– localconfig add
Com estes comandos removerá o CSS e o configurará o mesmo novamente.
Vamos executar os mesmos com o usuário “root”.
[oracle@serveroracle 12419392]$ su -
Password:
[root@serveroracle ~]# /oraprd01/app/oracle/product/10.2.0/db_1/bin/localconfig delete
Stopping CSSD.
Shutting down CSS daemon.
Shutdown request successfully issued.
Shutdown has begun. The daemons should exit soon.
[root@serveroracle ~]# /oraprd01/app/oracle/product/10.2.0/db_1/bin/localconfig add
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
Configuration for local CSS has been initialized
Adding to inittab
Startup will be queued to init within 30 seconds.
Checking the status of new Oracle init process...
Expecting the CRS daemons to be up within 600 seconds.
CSS is active on these nodes.
serveroracle
CSS is active on all nodes.
Oracle CSS service is installed and running under init(1M)
[root@serveroracle ~]# exit
logout
[oracle@serveroracle 12419392]$
Com o usuário Oracle vamos subir a instância ASM.
[oracle@serveroracle 12419392]$ sqlplus sys/***** as sysdba SQL*Plus: Release 10.2.0.5.0 - Production on Thu Mar 15 17:55:10 2012 Copyright (c) 1982, 2010, Oracle. All Rights Reserved. Connected to an idle instance. SQL> startup mount ASM instance started Total System Global Area 83886080 bytes Fixed Size 1272120 bytes Variable Size 57448136 bytes ASM Cache 25165824 bytes ASM diskgroups mounted SQL> exit Disconnected from Oracle Database 10g Release 10.2.0.5.0 - Production [oracle@serveroracle 12419392]$
Pronto, basta subir o Banco de Dados e terminar o processo de aplicação do Patch 12419392.
Veja o artigo da Aplicação do Patch 12419392 acessando Aplicando Patch PSU 10.2.0.5.4 no Banco de Dados Oracle 10.2.0.5.0 non-RAC.
Autor: Maycon Tomiasi
Formado em Tecnologia da Informação na FIPP (Faculdade de Informática de Presidente Prudente), Analista DBA Oracle pela Teiko Soluções em Tecnologia da Informação, residente em Blumenau/ SC, Certificado OCP 10g/11g/12c, OCS 11g Implementation, OCE 11g Performance Tuning, OCE 11g RAC & GRID e OPN Specialist. Conhecimentos em PHP.
