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 […]
Data Pump

How to Resolve impdp STATISTICS Stuck

Posted on
Importing Stuck at STATISTICS When I imported data via a network link, I found it stuck at STATISTICS. … Import: Release 12.1.0.2.0 – Production on Wed Sep 26 20:47:29 2018 … Starting “SYSTEM”.”SYS_IMPORT_TABLE_01″:  system/******** tables=ERPAPP.BANKS content=all table_exists_action=replace network_link=erp_db_link logfile=imp_table_erpapp.log Estimate in progress using BLOCKS method… Processing object type TABLE_EXPORT/TABLE/TABLE_DATA Total estimation using BLOCKS method: 10 […]
XFS

How to Expand XFS File System

Posted on
Expand XFS File System Initially, I allocated root mount point as 30 GB during OS installation, but now it seems a little small for future growth. So I decide to enlarge the file system that was formatted as XFS. [root@test ~]# df -h / Filesystem           Size  Used Avail Use% Mounted on […]
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 […]
Patching

How to Apply Patch in Oracle

Posted on
Keeping your database running with the newest release of Oracle software might be a critical job for DBA to implement. In this post, I will talk about the steps that we apply patch. Pre-Patching 1. Get the Latest OPatch Before any patching, you have to make sure your OPatch utility is the latest version in […]
Patching

How to Download the Newest OPatch Utility

Posted on
Add OPatch to $PATH If you’re the first time to apply patches, you have to add OPatch to $PATH in order to apply your patches anywhere. If you have done it, you can skip this step. [oracle@test ~]$ vi .bash_profile … export PATH=$PATH:$ORACLE_HOME/OPatch [oracle@test ~]$ . .bash_profile [oracle@test ~]$ which opatch … Newest OPatch Download […]