RAC|ASM

Directory Index Full Today I encountered with short system hang in my 2 node RAC database.When I investigate the cause of the problem a saw “Kernel: EXT4-fs warning (device sda1): ext4_dx_add_entry:2021: Directory index full!” warning in the /var/log/messages file. Jan 22 14:45:09 mydb1 kernel: EXT4-fs warning (device sda1): ext4_dx_add_entry:2021: Directory index full! Jan 22 14:45:09 mydb1 kernel:…

Migrating an Oracle 11g Database to an 11g Database in the Oracle Cloud via Data Pump Conventional Export/Import

Before You Begin Purpose In this tutorial, you learn how to migrate on-premises Oracle 11g database schemas to an 11g database in Oracle Database Cloud Service, using Data Pump conventional export and import. Last Updated March 2016, Release 16.1.5 Please note that Oracle develops its cloud services in an agile manner and makes rapid changes…

Dataguard commands and SQL scripts

Physical Standby Commands To start redo apply in foreground: SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE; To stop redo apply process on the Standby database (to stop MRP): SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL; To start real-time redo apply: SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION; To…

Oracle 12.1.0.2 silent install and de-install

After Oracle Enterprise Linux setup we must set up some settings shown below: Edit “/etc/hosts” file and add fully qualified name of your server. [root@presplaycloud Desktop]# vi /etc/hosts 127.0.0.1 localhost localhost.localdomain 192.168.8.157 presplaycloud presplaycloud.localdomain Then install oracle-rdbms-server-12cR1-preinstall package to perform all your prerequisite setup [root@presplaycloud Desktop]# yum install oracle-rdbms-server-12cR1-preinstall -y Add lines bellow to the /etc/security/limits.conf  file. oracle soft nofile 1024 oracle…

Steps to Install Oracle Database 12c Release 2 in Redhat Linux 7.5

A quick Guide on How to Install the Oracle Database 12c Release 2 in Redhat Enterprise Linux 7.5 Server. To Download the Oracle Database Installer, Visit the below URL: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html Prerequiste for Installation: Download the Oracle Database 12c installer package. The Swap Space size should be 16GB . Enable X11 Forwarding to “yes” in sshd…

Creating automated Full and Incremental backups with RMAN

Create a scripts folder to store our scripts cd /home/oracle/ mkdir Scripts 2) Then go to that folder and write the rman_full.sh file and write the following FULL backup scrip to the file vi rman_full.sh ORACLE_SID=DB11G ORACLE_HOME=/u01/app/oracle/product/11.2/db_1 PATH=$ORACLE_HOME/bin:$PATH export ORACLE_SID ORACLE_HOME PATH $ORACLE_HOME/bin/./rman target sys/db11g@$ORACLE_SID log /tmp/rman.log <<EOF set encryption on identified by ‘db11g_rman’ only;…