Oracle 12c- Dataguard Failover Using DGMGRL Utility
Dataguard Failover Using DGMGRL Failover is an irreversible transition of a standby database to the primary role. This is only done in the event of a catastrophic failure of the…
Read MoreOracle 19c-Performing Dataguard Switchover Using DGMGRL Utility
Dataguard Switchover Using DGMGRL A switchover is a role reversal between the primary database and one of its standby databases. A switchover guarantees no data loss. This is typically done…
Read MoreExternal tables & tkprof in DBA
EXTERNAL TABLES External tables are the tables which access the data present in external source This table has the data that is stored in outside database We can query this…
Read MoreHow To Setup Dataguard Broker Configuration (DG Broker) In 19c
Dataguard Broker Configuration Description : Dataguard broker is used to automate monitoring and controlling standby setups. It is very much useful, when the organization has multiple standby sites. Broker keeps…
Read MoreDBA Auditing database
DBA Auditing: It is used to audit all the operations performed by the user on schema objects, gor this we need to enable auditing for a database, to enable it…
Read MoreFlashback Database
Flashback Drop: Recovering the table for the recycle bin, once a table is dropped it will be stored in recycle bin.Hence recovering the table from recycle bin. To perform flashback…
Read MoreCLOUD INSTANCE RESOPONSE FILE AND SILENT DB
CREATING A 12C DATABASE IN CLOUD INSTANCE: Create a instance in oracle cloud account Download the oracle 12c software using wget Edit the response file with ORACLE_HOME, ORACLE_BASE and groups…
Read MoreOracle 19c Database Upgrade From 12.2.0.1.0 to 19.3.0.0 Using Manual Method
Oracle 19c Database Upgrade DETAILS SOURCE TARGET OS_VERSION OEL 6.4 OEL 6.4 DB_VERSION 12.2.0.1 19.3.0.0 DB_NAME PROD PROD ORACLE_HOME /u01/app/oracle/product/12.2.0.1/db_1 /u01/app/oracle/product/19.0.0/dbhome_1 INSTALL THE 19C BINARIES CREATE THE REQIRED DIRECTORIES &…
Read MoreInstallation and Configuration of Oracle Application Express with Oracle REST Data Services and Apache Tomcat
Installation and Configuration of Oracle Application Express with Oracle REST Data Services and Apache Tomcat Installed Softwares (requirement may vary) Oracle Application Express 5.1.4 Apache Tomcat 7.0.96 Oracle Rest Data Service ORDS…
Read MoreOEM Installation on 11g database
OEM installation on oracle 11g database 1)emctl start dbconsole [oracle@sakthi admin]$ emctl start dbconsole The following exception occurred: java.net.UnknownHostException: ol6-112.localdomain: ol6-112.localdomain at java.net.InetAddress.getAllByName0(InetAddress.java:1174) at java.net.InetAddress.getAllByName(InetAddress.java:1101) at java.net.InetAddress.getAllByName(InetAddress.java:1037) at java.net.InetAddress.getByName(InetAddress.java:987)…
Read More