[oracle@oracle3 ~]$ sqlplus / as sysasm

SQL*Plus: Release 12.1.0.1.0 Production on Sat Dec 20 14:04:39 2014

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

Connected to an idle instance.

SQL> startup
ASM instance started

Total System Global Area 1135747072 bytes
Fixed Size 2297344 bytes
Variable Size 1108283904 bytes
ASM Cache 25165824 bytes
ORA-15110: no diskgroups mounted

Řešení

SQL> select name,state,type from v$asm_diskgroup;

NAME STATE TYPE
------------------------------ ----------- ------
FRA DISMOUNTED
DATA DISMOUNTED

SQL> alter diskgroup data mount;

Diskgroup altered.

SQL> alter diskgroup fra mount;

Diskgroup altered.

Nebo ALTER DISKGROUP ALL MOUNT;
SQL> select name,state,type from v$asm_diskgroup;

NAME STATE TYPE
------------------------------ ----------- ------
FRA MOUNTED EXTERN
DATA MOUNTED EXTERN

Komentáře