Database Solutions

 In this blog, we will list down the steps to uninstall oracle database binary.  Step 1) Login as Oracle binary owner. <Oracle home>/oui/bin/runInstaller -detachHome -local ORACLE_HOME=<Oracle home> Step 2) Make sure Home get deleted from Inventory. <Oracle Home>/OPatch/optach lsinv |grep -i <Oracle Home> Step 3) Remove Binaries  cd <Base directory for Oracle Home> ls -lrt <version> rm -rf <version> ls -lrt <version> You can learn more about oracle RAC using below books: Oracle Database 12c Release 2 Real Application Clusters Handbook: Concepts, Administration, Tuning & Troubleshooting Expert Oracle RAC 12c  ==========================================================      Please check our other blogs for Oracle                        

 As part of database security, DBA need to enable encryption for the database. In this blog, we will go through the steps for encryption at rest in oracle database.  Step 1) Add following entry in sqlnet.ora on all node of RAC cluster.  Step 2) Create TDE directory on all the nodes on the cluster.  mkdir -p $ORACLE_BASE/tde/$ORACLE_SID Step 3) Create Wallet and Encrption key.   SQL> prompt Creating the Password based Key Store prompt administer key management create keystore '$ORACLE_BASE/tde/$ORACLE_SID' identified by "<Master Key>; prompt Opening the Password based Key Store prompt administer key management set keystore open identified by "<Master Key>"; prompt Creating and Setting the Master Encryption Key prompt administer key management set key identified by "<Master Key>" with backup using 'TDE'; prompt Creating the auto-login for Key Store prompt administer key management create auto_login keystore from keystore ...

In this blog, We are sharing some basic commands for maintenance and monitoring.  Basic OGG Commands Login to the servers as Goglengate user, cd ./ggate, run ./ggsci, this will bring you to the GGS interface. Then you can perform the following example commands. For a complete list of all GGS commands and detailed descriptions, please refer to the Reference Guide. 1. Help  --  This is the most important GGSCI command. All uses for GGSCI are listed.        GGSCI (GGserver) 7> help (help alter extract, help add replicat, etc)  2. Info all -- Gives a high level overview of all the OGG processes and their current status.   GGSCI (GGserver) 1> info all Program                     Status             Group           Lag         Time Since Chkpt MANAGER     RUNNING EXTRACT  ...

 In this blog, we will show G logical architecture and brief about GG processes. Manager The Manager process must be running on both the source as well as target systems before the Extract or Replicat process can be started and performs a number of functions including monitoring and starting other GoldenGate processes, managing the trail files and also reporting. Extract The Extract process runs on the source system and is the data caoture mechanism of GoldenGate. It can be configured both for initial loading of the source data as well as to synchronize the changed data on the source with the target. This can be configued to also propagate any DDL changes on those databases where DDL change support is available. Replicat The Replicat process runs on the target system and reads transactional data changes as well as DDL changes and replicates then to the target database. Like the Extract process, the Replicat process can also be configured for Initial Load as well as Change Synchroni...

 In this blog, We are going to show some general recommendation for Goldengate. DBLOGREADER   A new DBLOGREADER option was added to TRANLOGOPTIONS to enable Extract to use a newer API for capturing from an Oracle instance using ASM storage. This feature is available as of Oracle 10.2.0.5. The API enables extract to use a read buffer size of up to 4 MB in size and uses the database server to access the redo and archive logs, so that the extract doesn’t have to access the logs via ASM. A larger buffer may improve the performance of extract when redo rate is high. You can use the new DBLOGREADERBUFSIZE option of TRANLOGOPTIONS to specify a buffer size.  Supplemental Logging  To extract the committed transactions from the source Oracle database's online redo logs, as a minimum the database must be configured for supplemental logging on Primary Key columns. Enabling Supplemental logging at the source database side at the table level is required to ensure tha...

  Exadata  DMA sometime come across a situation where a shared mount point needed to be created. To solve this problem oracle have come up with DBFS mount point concept. In this blog we will show DBFS architecture and details.          DBFS Architecture   You can learn in detail on Exadata from book   Expert Oracle Exadata   Pro Oracle GoldenGate for the DBA Oracle Security Tools Installation and Configuration Expert Oracle Exadata   Oracle Database 12c Release 2 Real Application Clusters Handbook: Concepts, Administration, Tuning & Troubleshooting Expert Oracle RAC 12c   ========================================================== Please check our other blogs for  Exadata .