Mir Sayeed Hassan – Oracle Blog

Oracle DBA – Tips & Techniques | Learn with real-time examples

Restrict a user to drop from sys user

Posted by Mir Sayeed Hassan on October 3rd, 2017

Restrict a user to drop from sys user

Find the below tested & verified method

SQL> Create user mir identified by mir;
SQL> Grant connect, resource to mir;

Now user have the privilege to connect & perform DDL,DML Etc Operation

SQL> SHO USER
USER is "SYS"

Create...
Read more..

Posted in DBA Administration | Comments Off on Restrict a user to drop from sys user

Install SQL Instant client on Ubuntu

Posted by Mir Sayeed Hassan on October 3rd, 2017

Install SQL Instant client on Ubuntu

Directly we don’t have the RPM/Zip Packages to install the instant client on Ubuntu, as we need to download the Linux Packages/Zip Files from the Oracle Site (http://www.oracle.com/technetwork/database/features/instant-client/index…)  And convert...

Read more..

Posted in DB Install & Create | Comments Off on Install SQL Instant client on Ubuntu

Oracle GoldenGate (OGG), Configuration & Simple Test

Posted by Mir Sayeed Hassan on October 2nd, 2017

 Oracle GoldenGate (OGG), Configuration & Simple Test in our Test ENV

Step by Step Procedure to Setup of the OGG Configuration & Tested with simple table in our test ENV, I Have used the below two machine in single instance Oracle DB 11g (11.2.0.4)

In the following configuration I have used the following Hosts and Databases Server:

Source DB:
SID: oggtest1

Read more..

Posted in Oracle Goldengate (OGG) | Comments Off on Oracle GoldenGate (OGG), Configuration & Simple Test

Restore database step by step procedure

Posted by Mir Sayeed Hassan on October 2nd, 2017

Restore the Oracle database Procedure

  • Copy the datafiles, archivelog files and controlfile to restore backup location

  • Set the SID of the restore database in .bash_profile and run the bash profile — $. .bash_profile

  • Crosscheck the existing backup restore, if any expired, delete those backup...
    Read more..

Posted in RMAN | Comments Off on Restore database step by step procedure

Data Guard Broker Configuration (DGMGRL Utility)

Posted by Mir Sayeed Hassan on October 2nd, 2017

Data Guard Broker Configuration (DGMGRL Utility)

Data Guard broker configuration using the command line dgmgrl interface,  Below are the step by step procedure tested & verified in our Test ENV

Primary Database: PR

Standby Database: STD

Set the below parameter as on both...
Read more..

Posted in DataGuard (DR) | Comments Off on Data Guard Broker Configuration (DGMGRL Utility)

Perform the Switchover

Posted by Mir Sayeed Hassan on October 2nd, 2017

Perform the Switchover in our Test DB ENV

Primary database – IP (10.0.0.1)

=====================================

Before Switchover from primary to standby

=====================================

SQL> select name,open_mode,database_role from v$database;

NAME      OPEN_MODE            DATABASE_ROLE
---------... 
Read more..

Posted in DataGuard (DR) | Comments Off on Perform the Switchover

« Previous Entries
Next Entries »