Validation script for block corruption
Introduction: The following script is to validate if there are any corrupted rowids in FND_LOBS table Why we need to do this? When we run this validation script it will…
Read MoreConcurrent program stuck in OPP
Issue: Concurrent program stuck in OPP Steps to solve the Issue: Query to check concurrent program stuck in OPP SELECT a.request_id, substr(e.user_concurrent_program_name,1,80) Program,d.sid, d.serial# ,d.status,to_char(d.logon_time,’DD-MON-YY HH24:MI:SS’)logon, round(d.last_call_et/60) LCT FROM…
Read MoreEBS Application patch
Introduction: EBS Application patch is applied to upgrade the version of application files Steps to apply Patch in EBS instance: Patch Upgrade in EBS instance: Step 1:…
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 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 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 MoreSnapshot Standby Database
STEPS TO CREATE SNAPSHOT STANDBY DATABASE PRIMARY: SQL> select name, open_mode, database_role from v$database; NAME OPEN_MODE DATABASE_ROLE ——— ——————– —————- GPROD READ WRITE PRIMARY SQL> STANDBY SQL> select…
Read MoreLogical Standby Database
LOGICAL STANDBY PRIMARY SQL> select name, open_mode, database_role from v$database; NAME OPEN_MODE DATABASE_ROLE ——— ——————– —————- GPROD READ WRITE PRIMARY SQL> STANDBY SQL> select name, open_mode, database_role from v$database;…
Read More