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 Only block devices leading by letter b in permission notation are acceptable, any others device types, such as character devices or pseudo devices are not ASM candidates. Neither are symbolic links (leading by letter l). Please see an example […]
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 […]
Listener

How to Prevent Remote Service Register with Listener

Posted on
A vulnerability related to TNS listener has been reported in Oracle Security Alert for CVE-2012-1675, which is disclosed as “TNS Listener Poison Attack”. Attackers may exploit it to manipulate database instances without any authentication. A remote user may exploit it to influence the confidentiality, integrity and availability of database systems. With applying Class of Secure […]
Listener

How to Add Static Service Registered in Listener

Posted on
Static Service Registration Dynamic service is a representative which is registered with the listener when the instance is up and running on the server, whereas static service can be used to service external connections with or without a running instance on the server. According to Oracle 18c Advanced Features of Oracle Net Services, the use […]