ORACLE DBA
DATABASE
ADMINISTRATION
PERFORMANCE TUNING
DATAGUARD
ORACLE SECURITY
Backup & Recovery
TROUBLESHOOT
QUIZ
ORACLE RAC
ORACLE 12c-20c
ORACLE MULTITENANT
OEM 12C/13C
GOLDENGATE
INTERVIEW QA
DBA CHEATSHEET
DBA SCRIPTS
POSTGRES
POSTGRES SCRIPTS
DEVOPS
DBACLASS, KNOWLEDGEBASE FOR DBAS
Search.....
MONITOR YOUR DATABASE
Monitor your database
View all
ONLINE TRAINING
Read more
ORACLE 12C
Check out the oracle 12c features
SEE ARTS
ansible
(3)
how to Print execution time of tasks in ansible
Ansible script to run script on remote server and fetch the output
How to encrypt ansible inventory file using ansible-vault
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)
Multinode Hadoop installation steps
Hive Installation with derby
Hive installation with mysql database
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)
SETUP ORACLE 18C DATABASE – STEP BY STEP
SET ROWLIMIT in oracle 18C – New feature
oraversion utility in oracle 18c – New feature
Display sql_id of the sql, using set feedback in oracle 18C – New feature
ORACLE 19C
(4)
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
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)
How to Read CSV files in R studio
How to rename Columns in R
How to change the case (Lower to Upper and Vice Versa) in R
How to keep or delete columns/Variable of a data frame in R
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
WEBLOGIC
(3)
Exception in thread “main” java.lang.OutOfMemoryError: GC overhead limit exceeded with bsu.sh
Steps for upgrading weblogic 12.1.2 to 12.1.3
How to find weblogic version in oracle weblogic 12
Most Popular
Upgrade database from 11g to 12c manually
79836
16
install oracle goldengate 12c on linux 7
64585
0
How to run SQL tuning advisor for a sql_id
61090
6
Upgrade database from 12.1.0.2 to 12.2.0.1
52569
9
Transparent Data Encryption (TDE) in oracle 12c
52056
2
Recent Comments
Admin
on
Contact Us
satya
on
Contact Us
S V
on
Steps for upgrading weblogic 12.1.2 to 12.1.3
Sahil Verma
on
Steps for upgrading weblogic 12.1.2 to 12.1.3
Dan
on
ORA-20013: DBMS_QOPATCH ran mostly in non install area
Recent Comments