Sunday, October 29, 2017

ORA-00313 ORA-00312 ORA-17503 ORA-15173 in Standby Alert Log File

Errors in file /u01/app/oracle/diag/rdbms/standby_db/standby_db/trace/standby_db_lgwr_393229.trc:
ORA-00313: open failed for members of log group 12 of thread 2
ORA-00312: online log 12 thread 2: '+FRA_DG/standby_db/redolog12_02.rdo'
ORA-17503: ksfdopn:2 Failed to open file +FRA_DG/standby_db /redolog12_02.rdo

Monday, October 23, 2017

Creating a Real Application Cluster(RAC) 12c database using DBCA

After installing Oracle RAC, next step is to create a RAC database. Following is the process of creating a RAC database using dbca. Same method works on Windows or Unix based platforms.To invoke dbca, open a command line and run command “dbca”. On Windows, DBCA can also be invoked from Program Menu..

Tuesday, October 10, 2017

Oracle Flex Cluster

Oracle Real Application Cluster is a feature that was first introduced in Oracle 9i (Oracle Parallel Servers was a similar feature available before 9i, but not as robust as RAC) and has been an essential part of Oracle’s Maximum Availability Architecture. Since its advent in Oracle 9i, it has evolved a lot. Oracle 9i onward, every new release of Oracle has introduced something new in RAC which made it even more resilient, fault tolerant, and easy to manage architecture.
    

Tuesday, September 5, 2017

Oracle Flex ASM

Starting 12c, Oracle has introduced two very interesting features to add up to MAA (Maximum Availability Architecture), Oracle Flex Cluster and Oracle Flex ASM. In this article I will be explaining and demonstrating about Oracle flex ASM.
In flex ASM, you don’t need ASM instance to be running on each node (the Hub Node) because database instance can communicate with some other ASM instance running on any other node in the cluster.

Tuesday, July 25, 2017

Oracle Patches Types

In Oracle, there are different types of patching available; there are several types of patches released by Oracle that could be applied to the software you are running. There are on-off patches to fix bugs, regularly released patches, and security patches. In the following I will explain about different types of patches that are available to be installed on your RDBMS software.

Saturday, July 15, 2017

Installing Oracle 12c Release 2 RAC on Linux 6 and Linux 7

This article explains how to install a 2 nodes Oracle 12c Release 2 Real Application Cluster (RAC) on Oracle Linux 6 and 7. I did this installation on Oracle Virtual Box by creating 2 virtual machines with shared storage. OS platform I used is Oracle Enterprise Linux 7, and Oracle GI and RDBMS version is 12.2. Same installation guide should work for Linux 6 also as there are only a couple of differences in the steps that I will explain during this installation. There will be no difference in installation steps if there are more than 2 nodes in the RAC setup.

Friday, July 7, 2017

Running cluvfy (Cluster Verification Utility) during 12c R2 RAC installation


Following is the output of cluster verification utility that I executed during 12c R2 RAC installation. You can see 2 examples in the following. Example 1 demonstrated if you don’t have passwordless SSH connectivity configured for “grid” and “oracle” users, so you will need to execute this from each node one by one. Following output is from one node only.

Monday, July 3, 2017

Creating Oracle Database using DBCA in 12c R2

Database Configuration Assistant (dbca) is an Oracle provided tool to create a new database. In this document I would explain how to create a new 12cR1 database using dbca. For database creation steps for Oracle 12cR1, follow this document. Steps and screens are almost same for other Oracle database versions and different OS platforms.

Friday, June 23, 2017

Creating ASM disks using ASM Filter Driver (ASMFD)

Starting 12.1.0.2 we can use ASM Filter Drive (ASMFD) to create ASM disks to be used for ASM diskgroups. I have already explain in this article that how we configure ASMFD during GI installation, and this article for migration from ASMLib to ASMFD. In this article I will show you how to create/add new ASM disks using ASMFD so that we can use them for existing or new diskgroups.

Saturday, June 17, 2017

ASMCMD-9524: AFD configuration failed 'ERROR: ASMLib deconfiguration failed'

While configuring ASMFD (ASM Filer Driver), I was playing around and started facing this error after issuing “afd_configure” command
[[email protected] ~]# /u01/app/12.2.0/grid/bin/asmcmd afd_configure
ASMCMD-9524: AFD configuration failed 'ERROR: ASMLib deconfiguration failed'

I simply stopped oracleasm and acfsload service and after that reissued the “afd_configure” command, and it started working fine.
Point to note is that we need to stop oracleasm and acfsload before configuring ASMFD using “afd_configure”.

Popular Posts - All Times