Compartir el conocimiento es deber de todos, si puedes aportar con ideas es mejor darlas al mundo. << Donde hay soberbia, allí habrá ignorancia; pero donde hay humildad para aprender, habrá sabiduría. >>
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.
Suscribirse a:
Enviar comentarios (Atom)
No hay comentarios:
Publicar un comentario