BACKUP & RECOVERY(46)
- ORA-31623: a job is not attached to this session via the specified handle
- How to restore lost spfile in oracle
- ESTIMATE REQUIRED DISK SPACE FOR EXPORT USING estimate_only
- RMAN-07539: insufficient privileges to create or upgrade the catalog schema
- How to enable flash recovery area in oracle database
- SAMPLE parameter in EXPDP to export subset of data
- delete old archive logs using RMAN
- How to change flash recovery area location
- REUSE_DUMPFILES parameter in EXPDP
- point in time Restoring RMAN backup from tape
CLOUD(16)
- Deinstall Management Agents Oracle 12c cloud control
- Upgrade database using OEM 12C cloud control
- Change dbsnmp password for target db in oem 12c
- EMCLI command – OEM 12C
- Apply database patch from OEM Cloud control
- Generate custom report from OEM cloud control
- Agent Clone Failed Exit Code:1
- ORA-06512: at “SYSMAN.EM_SELF_UPDATE” while installation 12c cloud control
- How to deploy agents oracle 12c cloud control
- How to restart OMS in oracle 12c cloud
DATABASE(53)
- How to deinstall oracle client
- Expdp Impdp Tutorial
- Hash partitioning in oracle
- How to Enable Trace for a listener
- Clone a RAC database to Standalone database using RMAN backup
- GLOBAL_NAMES parameter and database link in oracle
- Create Incident package using ADRCI utility
- Cloning Oracle home from one server to another server
- SETUP ORACLE 18C DATABASE – STEP BY STEP
- How to apply JVM patch in oracle 12c database
DATABASE SCRIPTS(40)
- How to get ddl of all tablespaces in oracle
- Get hourly database growth report
- scripts to monitor standby database
- Find utilization of redo logs
- Query to get child table and foreign key status
- Create sql baseline from cursor cache
- How to get the size of an oracle database
- Get ospid from sid
- How to find active sessions in oracle database
- Get sid from ospid
Database-Wiki(9)
- resumable_timeout parameter in oracle database
- oracleasm utility for ASMLIB
- _optimizer_ignore_hint
- LREG Background Process in oracle
- _use_adaptive_log_file_sync parameter in oracle
- WHAT IS SQL PROFILE IN ORACLE
- DBMS_PARALLEL_EXECUTE in oracle PL/SQL
- LOG_CHECKPOINTS_TO_ALERT parameter in oracle
- DEFERRED_SEGMENT_CREATION parameter in oracle
DATAGUARD(21)
- How to open standby database when primary database is lost
- Remove dataguard configuration from Primary database:
- ORA-01274: cannot add data file that was originally created as
- ORA-01665: control file is not a standby control file
- Flashback primary database in dataguard environment
- How to recreate physical standby controlfile
- scripts to monitor standby database
- How to enable active dataguard in physical standby database
- Oracle data guard concepts
- How to use expdp to export data from physical standby database
DB TOOLS(6)
GOLDENGATE(18)
- Defgen utility in Oracle goldengate
- OGG-01028 partial record at sequence extract abended
- Obey command in goldengate
- Setting up Table replication in oracle goldengate
- Enable DDL replication in goldengate
- Schema replication using oracle goldengate
- install oracle goldengate 12c on linux 7
- COLS & COLSEXCEPT FILTER in goldengate
- install oracle goldengate 11g
- Shell script to monitor goldengate process
HOW TO(38)
- How to find sql text from a sid
- How to generate AWR report in oracle
- How to find long running queries
- How to create awr snapshot manually
- How to drop and recreate temp tablespace in oracle
- How to modify awr snapshot interval setting
- How to make a table read only in oracle
- How to get the DDL of an dbms scheduler job
- How to move AUD$ table to another tablespace using DBMS_AUDIT_MGMT
- How to drop SQL baselines in oracle
ORACLE 12C(60)
- How to create a pluggable database in oracle 12c
- Rolling forward standby database when archives missing in primary in 12c
- Move table online in Oracle 12.2
- How to create encrypted tablespace in PDB( oracle 12c)
- How to clone a pluggable database for existing PDB
- Restore missing datafile in standby database oracle 12c
- Read only Partition in Oracle 12.2
- How to flashback a Pluggable database ( PDB) in oracle 12.2
- How to rename a pluggable database ( PDB)
- RMAN active cloning in oracle 12C
ORACLE RAC(35)
- failed jdk version is incompatible.please use a jdk version with opatchauto
- oracleasm utility for ASMLIB
- Multiplex controlfile in Oracle RAC
- OPATCHAUTO-72046: No wallet option provided
- ORA-15073: diskgroup mounted by another instance
- ASM_POWER_LIMIT in oracle ASM
- Drop database in oracle RAC
- Create password files for database in ASM diskgroup
- How to rename ASM diskgroup with RAC database
- How to create ACFS file system in RAC using command line:
ORACLE SECURITY(12)
- PDB Lockdown Profiles in Oracle 12.2
- orapwd tool for password file in oracle
- Transparent Data Encryption (TDE) in oracle 12c
- Disable TDE in oracle 12c
- Open wallet automatically after starting the database
- how to send mail using utl_mail in oracle 11g
- how to use DBMS_PRIVILEGE_CAPTURE to capture privs in oracle 12c
- How to move AUD$ table to another tablespace using DBMS_AUDIT_MGMT
- ENABLE_DDL_LOGGING in oracle 12c
- Purge AUD$ table using DBMS_AUDIT_MGMT
PERFORMANCE TUNING(26)
- Migrating sql baselines from one database to another
- How to flush a sql statement from shared pool
- IN-MEMORY in oracle 12c
- log file switch (checkpoint incomplete) Waits event
- Monitor Index usage to find unused index
- How to find fragmentation in oracle table
- change the execution plan without changing the sql query
- _use_adaptive_log_file_sync parameter in oracle
- How to use result cache for queries in 11g
- WHAT IS SQL PROFILE IN ORACLE
SHELL SCRIPT(12)
- Shell script to delete old archives using RMAN
- Shell script to monitor goldengate process
- expdp backup using shell script
- Kill snipped sessions in oracle db
- RMAN backup using shell script
- Shell script for monitoring Alert log
- Tablespace monitoring shell script
- Alert log rotation script in oracle
- shell script for file system alert
- Shell script to report failed login attempt in oracle
TROUBLESHOOTING(142)
- Find objects that are making catalog and catproc invalid
- ERROR OGG-01841 CACHESIZE TOO SMALL:
- Prereq check failed – The database must be in upgrade mode
- ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
- ORA-39174: Encryption password must be supplied
- ORA-12841: Cannot alter the session parallel DML state within a transaction
- ORA-01466: unable to read data – table definition has changed during flashback
- ORA-12850: Could not allocate slaves on all specified instances: 2 needed
- ORA-32773: operation not supported for smallfile tablespace
- ORA-04063: package body “SYS.DBMS_CUBE_EXP” while expdp
Recent Comments