Hi all,
Initially i configured ASM disks using raw devices then i created one database to store all files using raw devices.
Later i installed asmlib to provide ASM disks.
$ export ORACLE_SID=+ASM
$ rlsqlplus / as sysdba
..
....
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> ALTER SYSTEM SET asm_diskstring = 'ORCL:VOL*' SCOPE=SPFILE;
System altered.
>>
SQL> startup force;
ASM instance started
Total System Global Area 83886080 bytes
Fixed Size 1272120 bytes
Variable Size 57448136 bytes
ASM Cache 25165824 bytes
ORA-15032: not all alterations performed
ORA-15063: ASM discovered an insufficient number of disks for diskgroup "RECO"
ORA-15063: ASM discovered an insufficient number of disks for diskgroup "FRA"
ORA-15063: ASM discovered an insufficient number of disks for diskgroup "DATA"
>>
SQL> shut immediate;
ORA-15100: invalid or missing diskgroup name
ASM instance shutdown
SQL> startup;
ASM instance started
Total System Global Area 83886080 bytes
Fixed Size 1272120 bytes
Variable Size 57448136 bytes
ASM Cache 25165824 bytes
ORA-15032: not all alterations performed
ORA-15063: ASM discovered an insufficient number of disks for diskgroup "RECO"
ORA-15063: ASM discovered an insufficient number of disks for diskgroup "FRA"
ORA-15063: ASM discovered an insufficient number of disks for diskgroup "DATA"
SQL> SHUT IMMEDIATE;
ASM diskgroups dismounted
ASM instance shutdown
>>
SQL> STARTUP;
ASM instance started
Total System Global Area 83886080 bytes
Fixed Size 1272120 bytes
Variable Size 57448136 bytes
ASM Cache 25165824 bytes
ORA-15032: not all alterations performed
ORA-15063: ASM discovered an insufficient number of disks for diskgroup "RECO"
>>
SQL> select group_number, disk_number, name, path,failgroup from v$asm_disk;
GROUP_NUMBER DISK_NUMBER NAME PATH FAILGROUP
------------ ----------- ------------------------------ ------------ ------------------------------
1 0 VOL1 ORCL:VOL1 VOL1
1 1 VOL2 ORCL:VOL2 VOL2
2 0 VOL3 ORCL:VOL3 VOL3
2 1 VOL4 ORCL:VOL4 VOL4
SQL> select status from v$instance;
STATUS
------------
STARTED
SQL> alter database mount;
alter database mount
*
ERROR at line 1:
ORA-15000: command disallowed by current instance type
>> I am connecting my database instance
$ export ORACLE_SID=asmdb
[oracle@CATALOG ~]$ rlsqlplus / as sysdba
SQL*Plus: Release 10.2.0.5.0 - Production on Wed Aug 9 19:59:15 2017
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
Connected to an idle instance.
SQL> startup;
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA/asmdb/spfileasmdb.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATA/asmdb/spfileasmdb.ora
ORA-15056: additional error message
ORA-17503: ksfdopn:DGOpenFile05 Failed to open file +DATA/asmdb/spfileasmdb.ora
ORA-17503: ksfdopn:2 Failed to open file +DATA/asmdb/spfileasmdb.ora
ORA-15173: entry 'asmdb' does not exist in directory '/'
ORA-06512: at line 4
How can i solve this error ?
REF_LINK : https://oracle-base.com/articles/10g/asm-using-asmlib-and-raw-devices#asmlib_installation
Switching from Raw Devices to ASMLib