ansible(3)
BACKUP & RECOVERY(47)
- 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
- RMAN-06429: TARGET database is not compatible version
- Cluster parameter in oracle RAC database
- Rman backup in multitenant database oracle 12c
- How to recover a dropped user using flashback oracle
- ENCRYPTION in expdp impdp
- How to enable and disable flashback in oracle database
CLOUD(16)
- 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
- Blackout targets in OEM 12c cloud control
- Add database as target oracle 12c cloud control
DATABASE(57)
- 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
- How to enable/disable archive log mode in oracle database
- ORA-01940: cannot drop a user that is currently connected
- resumable_timeout parameter in oracle database
- How to move controlfile to a new location in oracle
- How to create synonym for a schema
- How to move lob segment to another tablespace
DATABASE SCRIPTS(40)
- 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
- How to find the locks present in oracle database
- Tablespace monitoring in oracle 12c multitenant database.
- How to find cpu and memory information of oracle database server
- How to find the session using lot of undo
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(24)
- 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
- How to recover standby database when archive logs are missing in primary
- How to setup dataguard broker configuration (DG broker) in 12c
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)
- 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:
- OGG-01028 Formatting error on: table name
- OGG-01031 There is a problem in network communication
HADOOP(3)
HOW TO(43)
- 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
- How to install oracle client in silent mode using response file
- How to get the size of an oracle database
- How to deinstall oracle client
- How to change spfile in Oracle RAC.
- How to rename or move a datafile in oracle
ORACLE 12C(61)
- Upgrade database from 11g to 12c manually
- Oracle 12c multitenant architecture
- Datapump New features in Oracle 12.2
- IN-MEMORY in oracle 12c
- how to use DBMS_PRIVILEGE_CAPTURE to capture privs in oracle 12c
- Tablespace monitoring in oracle 12c multitenant database.
- Upgrade database from 12.1.0.2 to 12.2.0.1
- Row limiting clause in oracle 12c
- How to archive table rows in oracle 12c
- How to apply JVM patch in oracle 12c database
ORACLE 18C(4)
ORACLE 19C(4)
ORACLE RAC(46)
- oracle RAC 12c setup using virtual box
- Move datafile from file system to ASM disk in 11g
- Oracle local registry(OLR) in RAC
- How to change RAC database name
- RMAN active cloning from RAC TO RAC
- How to change spfile in Oracle RAC.
- How to convert a non ASM instance to ASM instance
- Asmcmd new features in oracle 12c
- How to move spfile from file system to ASM in RAC
- How to move voting disk to another ASM disk
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)
- 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
- Get explain plans of a sql query from AWR using DBMS_XPLAN.DISPLAY_AWR
- What is colored sql_id in dba_hist_colored_sql
POSTGRES(10)
- How to install postgres database on mac os/linux
- How to drop a database in postgres
- ERROR: permission denied for schema in postgres
- How to move a tablespace to new directory in postgres
- How to enable and disable archive mode in postgres
- How to make a postgres database readonly
- How to access csv files on file system using file_fdw in postgres
- How to create a database in postgres
- How to clone a postgres database to remote server
- psql: error: could not connect to server: FATAL: no pg_hba.conf entry for host
R-STUDIO(4)
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(147)
- MRP0: Background Media Recovery terminated with error 1274
- ORA-31637 ORA-06512 ORA-39062 error while doing impdp
- RMAN-07539: insufficient privileges to create or upgrade the catalog schema
- ORA-24247: network access denied by access control list (ACL)
- ORA-29280: invalid directory path ORA-06512:”SYS.UTL_FILE”
- ORA-38760: This database instance failed to turn on flashback database
- ORA-12985: tablespace ‘USERS’ is read only, cannot drop column
- ORA-28040: No matching authentication protocol
- ORA-00257:archiver error, connect internal only until freed
- ORA-14024: number of partitions of LOCAL index must equal that of the
Recent Comments