martes, 3 de febrero de 2015

Montar discos ASM de forma manual - ORA-00099: warning: no parameter file specified for ASM instance ASM instance started


Amig@s

Aquí les dejo el siguiente post resultado de un bug que tiene al levantar los discos la ASM

Problema:

bash-4.2$ sqlplus / as sysasm

SQL*Plus: Release 11.2.0.3.0 Production on Fri Jan 30 19:24:09 2015

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORA-00099: warning: no parameter file specified for ASM instance
ASM instance started

Total System Global Area  283930624 bytes
Fixed Size                  2220800 bytes
Variable Size             256544000 bytes
ASM Cache                  25165824 bytes
ORA-15110: no diskgroups mounted

Solución

SQL> select group_number, name, total_mb, free_mb, state from v$asm_diskgroup;

GROUP_NUMBER NAME                             TOTAL_MB    FREE_MB STATE
------------ ------------------------------ ---------- ---------- -----------
           0 DG_FRA_DWHD                             0          0 DISMOUNTED
           0 DG_DATA_INTERD                          0          0 DISMOUNTED
           0 DG_FRA_OLTPD                            0          0 DISMOUNTED
           0 DG_FRA_INTERD                           0          0 DISMOUNTED
           0 DG_DATA_INTERCP                         0          0 DISMOUNTED
           0 DG_DATA_OLTPD                           0          0 DISMOUNTED
           0 DG_DATA_DWHD                            0          0 DISMOUNTED
           0 DG_DATA_OLTPCP                          0          0 DISMOUNTED

8 rows selected.

SQL> alter diskgroup DG_FRA_DWHD mount;

Diskgroup altered.

SQL> alter diskgroup DG_DATA_INTERD mount;

Diskgroup altered.

SQL> alter diskgroup DG_FRA_OLTPD mount;alter diskgroup DG_FRA_OLTPD mount;^C

SQL> alter diskgroup DG_FRA_OLTPD mount;

Diskgroup altered.

SQL> alter diskgroup DG_DATA_INTERCP mount;

Diskgroup altered.

SQL> alter diskgroup DG_DATA_OLTPD mount;

Diskgroup altered.

SQL> alter diskgroup DG_DATA_DWHD mount;

Diskgroup altered.

SQL> alter diskgroup DG_DATA_OLTPCP mount;

Diskgroup altered.

SQL> select * from v$instance;

INSTANCE_NUMBER INSTANCE_NAME
--------------- ----------------
HOST_NAME
----------------------------------------------------------------
VERSION           STARTUP_T STATUS       PAR    THREAD# ARCHIVE LOG_SWITCH_WAIT
----------------- --------- ------------ --- ---------- ------- ---------------
LOGINS     SHU DATABASE_STATUS   INSTANCE_ROLE      ACTIVE_ST BLO
---------- --- ----------------- ------------------ --------- ---
              1 +ASM
Toachi
11.2.0.3.0        30-JAN-15 STARTED      NO           0 STOPPED
ALLOWED    NO  ACTIVE            UNKNOWN            NORMAL    NO


Y ya su ASM ya esta arriba.

No hay comentarios:

Publicar un comentario