Online DBA

<<Back to Oracle ASM Main Page What is Oracle ASM Filter Driver (ASMFD) Oracle ASM Filter Driver (ASMFD) is an alternate of ASMLib. It is a kernel module that resides in the I/O path of the Oracle ASM disks. Starting 12.1.0.2, ASMFD can be used instead of ASMLib for the ASM disks management. Oracle ASM Filter Driver (Oracle ASMFD) is installed with an Oracle Grid Infrastructure installation (RAC as well as Standalone). I already have ASMLib configured on my server and I want to move to using ASMFD.In this article I will explain how to migrate from ASMLib to ASMFD.  Migrating from ASMLib to Oracle ASM Filter Driver (ASMFD):GI Standalone Environment Note:- The procedure requires downtime As root user, c heck the current status of oracle ASMLib # oracleasm status Checking if ASM is loaded: yes Checking if /dev/oracleasm is mounted: yes As root user, find out the list of all current disks being used by ASM. # oracleasm listdisks WDTESTDB_DATA WDTESTDB_FRA As

<<Back to Oracle ASM Main Page #asmcmd afd_label WDTESTDB_FRA /dev/xvdd1 --migrate No devices to be labeled. ASMCMD-9513: ASM disk label set operation failed. Solution validate the content of /etc/oracleafd.conf. Should look like below $ cat /etc/oracleafd.conf afd_diskstring='/dev/xvd*' afd_filtering=enable validate the content of  /etc/afd.conf. If file does not exists create it. Should look like below $ cat  /etc/afd.conf afd_diskstring='/dev/xvd*' afd_filtering=enable Manually Run the command as ASM owner  $ asmcmd afd_dsset '/dev/xvd*' Restart acfsload and crs on the node. It should fix the problem. # acfsload stop #acfsload start ACFS-9391: Checking for existing ADVM/ACFS installation. ACFS-9392: Validating ADVM/ACFS installation files for operating system. ACFS-9393: Verifying ASM Administrator setup. ACFS-9308: Loading installed ADVM/ACFS drivers. ACFS-9154: Loading 'oracleoks.ko' driver. ACFS-9154: Loading 'o

<<Back to Oracle ASM Main Page While configuring ASMFD (ASM Filer Driver) , I faced error ASMCMD-9524. I wanted to share with you today how I resolved this # asmcmd afd_configure ASMCMD-9524: AFD configuration failed 'ERROR: ASMLib deconfiguration failed' Cause: acfsload is running. To configure AFD oracleasm and acfsload must be stopped Solution: stop acfsload and rerun  asmcmd afd_configure # acfsload stop And now configuration command completed successfully # asmcmd afd_configure AFD-627: AFD distribution files found. AFD-634: Removing previous AFD installation. AFD-635: Previous AFD components successfully removed. AFD-636: Installing requested AFD software. AFD-637: Loading installed AFD drivers. AFD-9321: Creating udev for AFD. AFD-9323: Creating module dependencies - this may take some time. AFD-9154: Loading 'oracleafd.ko' driver. AFD-649: Verifying AFD devices. AFD-9156: Detecting control device '/dev/oracleafd/admin'. AFD-

<<Back to Oracle DATAPUMP Main Page ORA-39083: Object type TYPE:"TEST_QA01"."LOG_RECORD" failed to create with error: ORA-02304: invalid object identifier literal Import: Release 12.1.0.2.0 - Production on Tue May 29 07:59:12 2018 Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security, OLAP, Advanced Analytics and Real Application Testing options Master table "SYSTEM"."SYS_IMPORT_FULL_01" successfully loaded/unloaded Starting "SYSTEM"."SYS_IMPORT_FULL_01":  system/********@TEST_QA parfile=import_TEST.par Processing object type SCHEMA_EXPORT/USER Processing object type SCHEMA_EXPORT/SYSTEM_GRANT Processing object type SCHEMA_EXPORT/ROLE_GRANT Processing object type SCHEMA_EXPORT/DEFAULT_ROLE Pr

<<Back to Oracle ASM Main Page Using ASM diskgroup for export I was finding it hard to find sufficient space to export a large amount of data, and therefore I thought to take an export on ASM. I faces few difficulties but managed to start the export in next 5 min. Keep on reading to get more understanding on exporting database in ASM diskgroup. Step1> I have created the directory and also created the folder within the ASM diskgroup $ asmcmd -p ASMCMD>  mkdir '+DATAC2/exp' Step2> login to the database and create directory SQL> create directory TEST_EXPORT as '+DATAC2/exp'; Directory created. Step3> Grant read, write permission to the user supposed to perform the export. SQL> grant read,write on directory TEST_EXPORT to admin; Grant succeeded. Step4>$ expdp admin/********@TEST_QA_EXP parfile=export_TEST_EXP.par admin/********@TEST_QA_EXP parfile=export_TEST_EXP.par xport: Release 12.1.0.2.0 - Production on Mon May

<<Back to Oracle Main Page ORACLE_BASE Environment Variable Step1> First Installation attempt with ORACLE_BASE=/u01/oragrid/oraBase ORACLE_HOME=/u01/oragrid/12.2.0.1/grid causing [WARNING] [INS-32018] The selected Oracle home is outside of Oracle base Solution:- Change ORACLE_BASE directory to point to the root directory of your oracle home. Step2> Second Installation attempt. ORACLE_BASE=/u01/oragrid/ ORACLE_HOME=/u01/oragrid/12.2.0.1/grid I modified the configuration parameter like above which I expected to work but it caused PRVF-10015: Clusterware home "{0}" is located under Oracle base directory "{1}" on node "{2}" Cause: Clusterware home directory was found to be located in a subdirectory of ORACLE_BASE. Solution : Choose a Clusterware home directory that is not a subdirectory of the ORACLE_BASE. After Clusterware installation the owner will be changed to root for all of the directories above Clusterware home.

<<Back to Oracle ASM Main Page ASM Supprted Storage Resources To create ASM diskgroup you need valid asm disks. Following are the storage resources supported by ASM for ASM disks to create a diskgroup Disk Partition: A disk partition can be the entire disk drive or a section of a disk drive. It must not be formated (ie should not includes the partition table) Logical Unit Number (LUN): A LUN is a disk presented to a computer system by a storage array. Logical Volume: Although Logical Volumes are supported by ASM it is not recommended by Oracle. Network File System (NFS): An Oracle ASM disk group can be created from NFS files, including Oracle Direct NFS (dNFS). The NFS files that are provisioned to a disk group may be from multiple NFS servers to provide better load balancing and flexible capacity planning. You can use NFS, with or without Direct NFS, to store data files. However, NFS is not supported for Oracle Clusterware files. NFS-based quorum disks (quorum failure gr

<<Back to Oracle ASM Main Page What is Oracle ASM Oracle Automatic Storage Management (ASM) is high-performance database file system and disk manager. Oracle ASM is Oracle's recommended storage management solution that provides an alternative to conventional volume managers, file systems, and raw devices. Oracle ASM uses disk groups to store data files; an Oracle ASM disk group is a collection of disks that Oracle ASM manages as a unit ASM binaries are integrated with oracle clusterware software and therefore to configure ASM you must install oracle Grid infrastructure software ( standalone or in Clusterware mode depending on your requirement). To understand Oracle ASM you first need to understand the following concepts. • Oracle ASM Instances • Oracle ASM Disk Groups • Mirroring and Failure Groups • Oracle ASM Disks • Oracle ASM Allocation Units • Oracle ASM Files • Oracle ASM Striping Oracle ASM Instances ASM is implemented as a special kind of Oracle ins