Overview: In this article we explain the process of  how to De-Register DBV on RAC DB. Oracle Database Vault is a security product which is being accessed by privileged database users like DBAs. Application data can be protected with policies that control access by setting up the rules. Environment Details Hostname Node1 : db01 Node 2: db02 Database version 11.2.0.4 Database Environment OMFDB Disable DB vault  Login with DBVOWNER to DB and disable the Rules $sqlplus -s / as sysdba SQL>set lines 200 SQL>set pages 0 SQL>set feed off SQL>select status fromSEE DETAILS

Overview: In this article we explain the process of  how to Update the existing Database Vault settings. Oracle Database Vault is a security product which is being accessed by privileged database users like DBAs.Application data can be protected with policies that control access by setting up the rules. Environment Details Hostname Node1 : db01 Node 2: db02 Database version 11.2.0.4 Database Environment OMFDB Login to Database and check the current DBV Rule $sqlplus / as sysdba Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production With the Partitioning,SEE DETAILS

Overview: In this article we explain the process of  how to register RAC DB in Database Vault Oracle Database Vault is a security product which is being accessed by privileged database users like DBAs.  Application data can be protected with policies that control access by setting up the rules. Environment Details Hostname Node1 : db01 Node 2: db02 Database version 11.2.0.4 Database Environment OMFDB Register Database in Database Vault. $export PATH=$PATH:$ORACLE_HOME/bin $dbca -silent -configureDatabase -sourceDB omfdb -sysDBAUserName sys -sysDBAPassword ******* -addDBOption OMS,DV -dvUserName dbvowner -dvUserPassword ******* -dvAccountManagerName dbvacctmgr -dvAccountManagerPassword ******** Preparing<a class="more-link" href="https://netsoftmate.com/enable-database-vault-...

Overview: In this article we explain the process of  how to create RAC DB on Exadata Machine using DBCA DBCA is the oracle utility which provide the easy and fast way to create the DB. Environment Details Hostname Node1 : db01 Node 2: db02 Database version 11.2.0.4 Database Environment OMFDB  Login to Exadata Machine node1 and initate DB creation using DBCA. $export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db $dbca DBCA launched db creation window. select oracle Real appliction clusters(RAC) database option than next Select create database option then Next Select General purpose and click next SelectSEE DETAILS </s...

Overview: In this article we explain the process of  Data guard Broker setup DG Broker maintains, manage, and monitor one or more standby databases to enable production Oracle databases to survive disasters and data corruptions Environment Details Hostname Primary server :–Primary Standby Server :– Standby Operating system Linux Database Environment NSMPRD and NSMDR Ensure that both the primary and standby databases are up and running as shown in the following query NSMPRD@PRIMARY SQL> select db_unique_name,open_mode,database_role from v$database; DB_UNIQUE_NAME                 OPEN_MODE            DATABASE_ROLE ————&#82...

Overview: In this article we explain the process of  build a physical standby database using RMAN active duplicate. Standby database is exact copy of production in read only mode with apply. In case if the production goes down for any outage. Standby can failover and make as primary.  Environment Details Hostname Primary server :–Primary Standby Server :– Standby Operating system Linux Database Environment NSMPRD and NSMDR NSMPRD@PRIMARY Determine if the FORCE LOGGIN is enabled. SQL> select force_logging from v$database; For —— YES If the output of the query is YES, thenSEE DETAILS

Overview: In this article we performing PSU6 upgrade on Oracle 11.2.0.4 using slient mode on NON RAC. Environment Details Hostname Primary server :–lnx-nsm-prod Operating system Linux Database Environment NSMDB Software requirement: p6880880_112000_Linux-x86-64.zip Latest OPatch utility p20299013_112040_Linux-x86-64.zip PSU6 Download Oracle Opatch and PSU from MOS Copy downloaded softwares to staging area. $ cd /u01/app/oracle/software/ $ mkdir 11204 OPactch upgrade Before applying PSU we need to have latest version of OPatch utility $ cd /u01/app/oracle/software/11204 $ls -ltr -rw-r—–  1 oracle oinstall   71580583 Oct 27 17:11 p20299013_112040_Linux-x86-64.zip -rw-r—–  1 oracle oinstall   98352086<a class="more-link" href="https://netsoftma...

Overview: In this article we performing installaiton of Oracle 11.2.0.4 installation on NON RAC. Environment Details Hostname Primary server :–lnx-nsm-prod Operating system Linux Database Environment NSMDB Software requirement: p13390677_112040_Linux-x86-64_1of7.zip 1.3 GB p13390677_112040_Linux-x86-64_2of7.zip 1.1 GB p13390677_112040_Linux-x86-64_3of7.zip 1.1 GB Download Oracle 11.2.0.4 from MOS 11.2.0.4.0 PATCH SET FOR ORACLE DATABASE SERVER (Patchset) Copy downloaded Oracle 11.2.0.4 software to staging area. http://docs.oracle.com/cd/E11882_01/install.112/e24326/toc.htm $ cd /u01/app/oracle/software/ $ mkdir 11204 Create oracle user and group #/usr/sbin/groupadd -g oinstall #/usr/sbin/groupadd -g dba #/usr/sbin/useradd -u -g oinstall -G dba oracle Create Directories structure and give p...

Overview: This article explain the process of converting Physical Standby which is in Read Only mode to a Snapshot Standby which would be in Read Write mode for the needs of disaster recovery testing.  This is to allow the database in DR site to be accessed by applications and perform tests on how the database could be accessed and application purposes be met during a disaster scenario while the actual primary database is not shutdown completely. Environment Details: Hostname Node1 and Node2 Operating system Linux Environment Production(orcl01 / orcl02) andSEE DETAILS

Overview: This article explain the process of converting Physical Standby in Read Only mode to a Snapshot Standby.Snapshot Standby open DB in Read Write mode for disaster recovery testing.  This is to allow the database in DR site to be accessed by applications and perform tests on how the database could be accessed and application purposes be met during a disaster scenario while the actual primary database is not shutdown completely. Environment Details: Hostname Node1 and Node2 Operating system Linux Environment Production and Standby Oracle Home /u01/app/oracle/product/11.2.0/db Prerequisites for convertingSEE DETAILS </sp...

Overview Don’t want to design or build Oracle GoldenGate architecture from Command line? Oracle GoldenGate Studio is the answer for you. In 2015, Oracle has released a new tool which provides a Graphical User Interface (GUI) for designing and building Oracle GoldenGate Architecture called “Oracle GoldenGate Studio”. Installing Oracle GoldenGate Studio consists of following steps: Ensure Java JDK 1.8 is installed Install Oracle GoldenGate Studio Configure Oracle GoldenGate Studio repository Start and Connect to Oracle GoldenGate Studio  In this artcile I will demonstrate how to Install and Configure Oracle GoldenGateSEE DETAILS <span class="more-...

Overview: In my previous article I have shown you how to rebuild a physical standby database using RMAN full database backup. Please refer below link for same. Rebuild Physical Standby using RMAN full backup   Rolling forward a standby using RMAN full database backup can be time consuming and take several hours based on the size of the database. RMAN offers a flexibility to take the SCN based backup that can be used to incrementally roll forward a standby database. Using RMAN incremental backup to roll forward a standby database isSEE DETAILS

Overview: At times standby database can go out of Sync for many reasons like, accidentally deleting archive log on primary or RMAN backup deleted archive log before shipping to standby database server. When this happens you must rebuild the Standby database using primary database backup. In this article we outline the process of rebuild the Physical Standby which is out of sync from Primary. Environment Details Hostname Primary server :– lnx-nsm-prod01/ lnx-nsm-prod02 Standby Server :–  lnx-nsm-dr01/ lnx-nsm-dr02 Operating system Linux Database Environment NSMDB and NSMDR     Take full RMANSEE DETAILS ...

Overview When you perform power maintenance, data center maintenance or moving servers from one data center to another you need to shutdown the Clusterware/Database/Servers. If you have Exadata Database Machines sitting in your data center then you need to shutdown it as well. The process of shutting down Exadata Database machine is slightly different when compared to servers or cluster. We should follow a sequence of steps to shutdown Exadata components.  In this article, we will demonstrate the steps to shutdown Exadata Database Machine to carry out maintenance task. Environment Exadata X5-2 Full Rack LogSEE DETAILS <span class="more-l...

Overview: Oracle Recovery Manager (RMAN) provides a comprehensive foundation for efficiently backing up and recovering the Oracle databases, it provides a common interface, via command line and Enterprise Manager, for backup tasks across different host operating systems, automates administration of your backup strategies.    In this scenario we have different database name and different directory structure. And we are transforming the directory structure in pfile itself, then no need to give extra parameters in rman duplicate command. Target (source) details Database Name Prod Hostname Netsoftmate Ip Address 172.16.110.18 OS Linux Version x86_64SEE DETAILS <...

Overview:Oracle Golden Gate provides very fast replication of data by reading transaction logs and writing the changes to one or more target databases in a homogeneous and heterogeneous environment. It is useful for High Availability Architectures and especially for Data Warehouse and Decision Support Systems. Thus, the variety of techniques and methods spreads from unidirectional environments for query offloading/reporting to bidirectional or Peer-to-Peer architectures in an active-active fashion. Prerequisites:Oracle Golden Gate Software Installed Database should be in archive log modeSupplemental logging should be enable.Force logging should be set to yes. SEE DETAILS <span class="more-link-image"...

Overview Datapump introduce in 10g which is very powerful utility to perform the both load and unload data using external dump files.Oracle Data Pump technology consists of two components: the Data Pump Export utility, to unload data objects from a database, and the Data Pump Import utility, to load data objects into a database. You access the two Data Pump utilities through a pair of clients called expdp and impdp.As their names indicate, the first of these corresponds to the Data Pump Export utility and the latter to the Data Pump Import utility. YouSEE DETAILS

Overview: In this document we will Upgrade Oracle GoldenGate 11g to 12c Environment Details  Hostname Node1 and Node2 Operating system Linux Environment production Oracle Home /u01/app/oracle/product/11.2.0/db GoldenGate software staging location /u01/app/oracle/software/OGG12c GoldenGate 11g Shared Home /oraggs/app/ggs GoldenGate 12c Shared Home /oraggs/app/ggs12c/ggs Configure Goldengate 12c: Install Oracle GoldenGate 12c software without creating and start manager process in a new home. Look at the steps for installing Oracle GoldenGate 12c at: http://netsoftmate.blogspot.in/2017/01/installing-oracle-goldengate-12c-base.html After installing oracle GoldenGate now the time to upgrade the existing 11g to 12c GoldenGate. Create sub dirs. cd /oraggs/app/gg12c<a class="more-link" href="...

Overview In this document we will perform Upgrade of oracle GoldenGate 12c from 12.1.2.1.0 to 12.1.2.1.10 Environment Details  Hostname Node1 and Node2 Operating system Linux Environment Production Oracle Home /u01/app/oracle/product/11.2.0/db GoldenGate software staging location /u01/app/oracle/software/OGG12c GoldenGate Shared Home /oraggs/app/ggs12c/ggs Software requirement: Download the Oracle GoldenGate 12.1.2.1.10 (p21785294_1212110_Linux-x86-64.zip) patch from My Oracle support by entering the following URL into your web browser: http://support.oracle.com Steps to Upgrade Oracle GoldenGate Software Create staging area for GoldenGate software. $ cd /u01/app/oracle/software/ $ mkdir OGG12c  Copy downloaded Oracle GoldenGate 12c Base software to Node 1 Unzip<a class="mor...

OverviewThe Oracle Database File System (DBFS) creates a file system interface to files stored in the database. DBFS is similar to NFS in that it provides a shared network file system that looks like a local file system. Because the data is stored in the database, the file system inherits all the HA/DR capabilities provided by the database. With DBFS, the server is the Oracle Database. Files are stored as SecureFiles LOBs. PL/SQL procedures implement file system access primitives such as create, open, read, write, and list directory. The implementation ofSEE DETAILS