How to shutdown Oracle database server with Oracle data guard properly

This tutorial shows you how to shutdown Oracle database server with Oracle Data Guard running on it properly.

Stop transport and apply process first

Using broker. Run on standby or primary.

DGMGRLedit database dg10 set state=apply-off;
DGMGRLedit database dg9 set state=transport-off;

Stop listeners

Read the rest “How to shutdown Oracle database server with Oracle data guard properly”

Install Oracle Data Guard on Oracle Database 11GR2 Steps by Steps (physical standby)

This is my post to guide you install and configure Oracle Data Guard with Physical Standby on Oracle Database 11G R2 steps by steps.

In this serries:

Read the rest “Install Oracle Data Guard on Oracle Database 11GR2 Steps by Steps (physical standby)”

Oracle: Create table with examples

This tutorial helps you to create table in Oracle.

Oracle table creating script examples

With tablespace and storage declared.

CREATE TABLE oraerr_users 
( 
    usrno NUMBER(5) PRIMARY KEY, 
    uname VARCHAR2(15) NOT NULL, 
    job VARCHAR2(10), 
    mgr NUMBER(5), 
    regdate DATE DEFAULT (sysdate), 
    photo BLOB, 
    sal NUMBER(7,2), 
    clickrate NUMBER(7,2) 
Read the rest “Oracle: Create table with examples”

Create partition for existing tables in Oracle: complete example

Here is a complete script to create/replace partition for existing table in Oracle database. You just need to modify your table names and run.

We have a TBL_CUSTOMERS table in schema named SCHEMANAME as script:

CREATE TABLE SCHEMANAME.TBL_CUSTOMERS
 (
   ID                 NUMBER(38)                 NOT NULL,
   CUS_NAME           VARCHAR2(255 
Read the rest “Create partition for existing tables in Oracle: complete example”

How to configure X11 forwarding to install Oracle databases

This tutorial helps you configure X11 forwarding properly to install Oracle databases via remote terminal from Windows.

In this series:

Read the rest “How to configure X11 forwarding to install Oracle databases”

Install Oracle Linux 5,6,7 from USB with ISO file

These steps can also applied to install Oracle Linux 5,6, 7 from USB with ISO. Here, I take the Oracle Linux 6 to demonstrate but you can do the same with other versions.

In this serries:

Read the rest “Install Oracle Linux 5,6,7 from USB with ISO file”

Install Oracle 11g R2 Database On Oracle Linux 6 with EM (Enterprise Manager)

Just go through these steps, you will have Oracle 11GR2 database up and running on Oracle Linux 6.10 with Enterprise Manager (EM)

Note on Oracle version support: Starting with Oracle Database 11g Release 2 (11.2.0.3), Oracle Linux 6 and Red Hat Enterprise LinuxRead the rest “Install Oracle 11g R2 Database On Oracle Linux 6 with EM (Enterprise Manager)”

Install Oracle 11g R2 Database On Oracle Linux 7.7 with EM (Enterprise Manager)

Just go through these steps, you will have Oracle 11GR2 database up and running on Oracle Linux 7.7 with Enterprise Manager (EM)

Note on Oracle version support: Starting with Oracle Database 11g Release 2 (11.2.0.3), Oracle Linux 6 and Red Hat Enterprise Linux 6 … Read the rest “Install Oracle 11g R2 Database On Oracle Linux 7.7 with EM (Enterprise Manager)”

How to free Oracle FRA space properly

Oracle Flash Recovery Area is full will made your database stop working for normal user and produce ORA-19815 warnings, ORA-00257: archiver error. Connect internal only, until freed.

So, you need to free up more space for Oracle FRA.

First of all, NEVER try to delete … Read the rest “How to free Oracle FRA space properly”

Understanding Oracle Idle time parameter in Profile

Quick & clear answer:

The idle_time parameter limits the maximum time a session can stay connected without doing anything. By reducing the period of time an inactive session stays connected, the performance of the whole system significant increased.

Why Idle time parameter helps increase

Read the rest “Understanding Oracle Idle time parameter in Profile”