ansible(5)
BACKUP & RECOVERY(48)
- Restoring archivelogs from RMAN tape backup
- How to run expdp in pluggable database(PDB)
- Useful flashback related commands
- ORA-27054: NFS file system where the file is created while expdp
- How to do import using network_link in oracle
- How to duplicate database using RMAN backup set
- How to take expdp of a table to multiple directories in oracle
- RMAN-20035: invalid high RECID in rman catalog
- Datapump export to ASM diskgroup (EXPDP)
- How to export and import statistics in oracle
CLOUD(16)
- 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
- How to restart Agents in oracle 12c cloud control
- Failed to connect to the ASM: ORA-01017: invalid username/password;
- How to change sysman password for oracle 12c cloud control
- Install oracle enterprise manager cloud control 12c
DATABASE(59)
- Enable archive log mode in Oracle RAC
- User Management in Oracle
- Steps to Apply PSU patch on oracle 11g database
- How to find when a table was last modified in oracle
- Scheduler jobs in oracle
- How to install oracle client in silent mode using response file
- Partition an existing table oracle using exchange method
- How to change the oracle database name using nid utility
- Schedule expdp job in dbms_scheduler
- How Recyclebin in oracle database works
DATABASE SCRIPTS(40)
- How to find active sessions in oracle database
- Get sid from ospid
- How to find sql text from a sid
- Find sessions consuming lot of CPU
- How to find the sessions generating lot of logs
- Top 5 cached sql statements by elapsed time in oracle
- Find the active transactions in oracle database
- How to find the sessions using lot of temp
- Realtime monitoring of sql query using v$sql_plan_monitor
- Find user commits per minute in oracle database
Database-Wiki(10)
- 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
- sec_case_sensitive_logon parameter in oracle
DATAGUARD(26)
- 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
- How to create physical standby database
- Standby redologs in oracle dataguard
- Convert physical standby to snapshot standby database
- How to add a tempfile in primary database in dataguard
DB TOOLS(9)
- Oracle database Security Assessment Tool
- SQLCL UTILITY IN ORACLE
- oracleasm utility for ASMLIB
- Oswatcher tool for collecting server diagnostic information
- orapwd tool for password file in oracle
- oraversion utility in oracle 18c – New feature
- How to install trace file analyzer( TFACTL)
- Useful TFACTL commands
- How to use oratop tool for oracle database monitoring
GOLDENGATE(18)
- 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
- Oracle Golden gate fundamentals
- How to configure manager process in golden gate 11g
- Disable DDL replication in goldengate
- ERROR OGG-01841 CACHESIZE TOO SMALL:
HADOOP(3)
HOW TO(47)
- How to move AUD$ table to another tablespace using DBMS_AUDIT_MGMT
- How to drop SQL baselines in oracle
- How to change asm spfile location in oracle RAC
- How to get the character set of a database in oracle
- How to enable flash recovery area in oracle database
- How to generate explain plan in oracle
- How to take expdp of a table to multiple directories in oracle
- How to change flash recovery area location
- How to kill a session in oracle database
- How to enable block change tracking in oracle
INTERVIEW QA(9)
- Oracle dataguard – Interview Questions
- oracle dba interview Questions
- Real Interview questions for experienced DBAs – 1
- RMAN interview QA
- Oracle RAC interview questions
- ASM Interview questions
- Oracle Performance Tuning Interview questions and answers
- Real DBA interview questions -2
- Real DBA Interview questions -4
ORACLE 12C(61)
- Rman backup in multitenant database oracle 12c
- Unified audit trail in Oracle 12c
- Common User vs Local User in 12c Multitenant
- How to unplug and plug in pluggable database in oracle 12c
- Convert non partitioned table to partitioned online Oracle 12.2
- How to setup listener for PDBS in Multitenant database.
- Upgrade database from 11g to 12c manually
- Oracle 12c multitenant architecture
- Datapump New features in Oracle 12.2
- IN-MEMORY in oracle 12c
ORACLE 19C(12)
- Upgrade grid infrastructure to 19C oracle
- Steps for upgrading oracle database to 19c using DBUA
- Clone a database using dbca command in oracle 19c -New feature
- How to Downgrade oracle 19C Grid to 12C GRID
- How to clone oracle home in oracle 19c using gold image
- How to create database using dbca in silent mode – 19C
- How to change cluster name in oracle RAC
- How to add a node in oracle RAC 19c
- How to delete a node from oracle RAC 19C
- How to deinstall oracle 19c grid infrastructure
ORACLE RAC(58)
- How to rename ASM diskgroup with RAC database
- How to create ACFS file system in RAC using command line:
- How to apply JDK patch in oracle database
- Copy asm file from one server to another server
- OLSNODES COMMANDS IN RAC
- How to modify scan name in oracle RAC
- oracle RAC 12c setup using virtual box
- Move datafile from file system to ASM disk in 11g
- Oracle local registry(OLR) in RAC
- OPATCHAUTO-72088: OPatch software version in homes selected for patching are different.
ORACLE SECURITY(13)
- 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
- Unified audit trail in Oracle 12c
- Lock account automatically with INACTIVE_ACCOUNT_TIME
PERFORMANCE TUNING(30)
- 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
- How to use sql tuning advisor for a sql query
- How to create awr snapshot manually
- Realtime monitoring of sql query using v$sql_plan_monitor
- How to modify awr snapshot interval setting
POSTGRES(22)
- Monitor sql queries in postgres using pg_stat_statements
- Trigger file validation failed. Could not start agent as standby
- How to install postgres database on mac os/linux
- How to create tablespace in postgres with streaming replication
- How to drop a database in postgres
- edb efm start failed with authentication failed error on standby
- ERROR: permission denied for schema in postgres
- How to move a database to a new tablespace in postgres
- How to move a tablespace to new directory in postgres
- How to create database link in postgres
SHELL SCRIPT(13)
- 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
- Shell script to monitor asm diskgroup usage
- Shell script for monitoring blocking sessions
TROUBLESHOOTING(151)
- ORA-04063: view “SYS.KU$_RADM_FPTM_VIEW” has errors
- ERROR: No checkpoint table specified for ADD REPLICAT
- ORA-56935: existing datapump jobs are using a different version
- ORA-01274: cannot add data file that was originally created as
- ORA-02095: specified initialization parameter cannot be modified
- ORA-12988: cannot drop column from table owned by SYS
- ORA-12910: cannot specify temporary tablespace as default tablespace
- ORA-28017: The password file is in the legacy format
- ORA-20101: TABLESPACE is not a ASSM (Automatic Segment Space Management) tablespace
- ORA-02030: can only select from fixed tables/views
Recent Comments