ASM

How to Resolve SPFILE in DB_UNKNOWN

Posted on
SPFILE in DB_UNKNOWN When I tried to restore SPFILE to the default location at nomount state, I found that SPFILE was restored to a DB_UNKNOWN in ASM. Is it a bug dedicated to Oracle 10g RAC (Bug 5370663)? No, I saw it too in 12c R1 RAC restoration. Let’s reproduce the problem. First, check what […]
ACFS

How to Create Database on ACFS

Posted on
Assuming that you have created a ACFS file system for the database creation. Then you can go on reading this post. Create a Database on ACFS First of all, make sure everything is ready including ACFS mount point which is /u02/oradata1 in this case. [grid@primary01 ~]$ crsctl status resource ora.data.oradata1.acfs -t ——————————————————————————– Name      […]
ASM

How to Create a ASM Disk Group

Posted on
To isolate non-crucial backups from crucial data in the current disk group DATA, a separate new disk group with new disks is needed to put all backups. For meeting our new requirement, we plan to create a disk group called FRA, i.e. Fast Recovery Area, by ourselves. The utility that we are going to use […]
ACFS

How to Create a ACFS File System on 18c

Posted on
Create ACFS File System First of all, make sure everything is ready on grid-level. [root@primary01 ~]# su – grid [grid@primary01 ~]$ crsctl check crs [grid@primary01 ~]$ crsctl status resource -t Create a Volume In this case, We allocate 80GB for the new volume ORADATA1 from a ASM disk group, DATA. [grid@primary01 ~]$ asmcmd volcreate -G […]
ASM

How to Resolve Grid Installation OUI Discovers No Disk

Posted on
Requirements for Disk Discovery There’re several requirements for disks to be discovered: 1. Right Device Type For 11g or later, only block devices leading by letter b in permission notation are acceptable, any others device types, such as character devices, symbolic links (leading by letter l) and pseudo devices are not ASM candidates. Please see […]
ASMLib

How to Resolve ASMLib Scanned No Disks on Boot

Posted on
ASMLib Scanned Nothing on Boot-Time ASMLib seems to be started too soon to scan iSCSI disks which may not be ready on boot in Enterprise Linux 7. [root@primary01 ~]# oracleasm listdisks [root@primary01 ~]# oracleasm-discover Using ASMLib from /opt/oracle/extapi/64/asm/orcl/1/libasm.so [ASM Library – Generic Linux, version 2.0.12 (KABI_V2)] Nothing was found there when we tried to list […]
ASM

How to Resolve ASMLib Fails to Open Disk Candidates

Posted on
ASMLib Seems Good In my grid installation plan for 18c database, I use ASMLib to make device path persistent for ASM candidate disks. As a result, oracleasm should be able to recognize those disks as expected. [root@primary01 ~]# oracleasm listdisks ASMDISK01 ASMDISK02 [root@primary01 ~]# oracleasm-discover Using ASMLib from /opt/oracle/extapi/64/asm/orcl/1/libasm.so [ASM Library – Generic Linux, version […]
ASM

How to Resolve INS-30502 No ASM disk group found

Posted on
This error is quite strange and thrown during grid infrastructure installation.INS-30502 No ASM disk group found.Why can not oracle access any ASM disk groups? How can it be? I tried several ways to solve the problem, only the last solution worked.Switching the group of owner of ASM disks from asmadmin to oinstall whcih is oracle default group. Not […]