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
MYSQL
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
(5)
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
How to create host configuration report using ansible-cmdb
Automate oracle client installation using ansible
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
BLOG
(6)
What is the Future Possibility of a Career in MS SQL Server?
Automation Testing in CI/CD
Oracle Data Guard vs. Oracle GoldenGate
How to Choose the Right Mobile App Database for Your App
Real Interview questions for experienced DBAs – 1
Real DBA interview questions -2
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
(28)
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)
Multinode Hadoop installation steps
Hive Installation with derby
Hive installation with mysql database
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
(11)
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
postgres DBA Interview questions
Real DBA interview questions -2
Real DBA interview questions -3
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 18C
(5)
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
Recover standby database from primary using service in oracle 18c
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
(59)
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
(29)
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
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
(152)
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
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
109065
16
Upgrade database from 12.1.0.2 to 12.2.0.1
81360
9
ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT
80102
3
Prerequisite check “CheckActiveFilesAndExecutables” failed
69204
3
install oracle goldengate 12c on linux 7
66970
0
Recent Comments
Ed
on
POSTGRES DB SCRIPTS
Allan Sun
on
POSTGRES DB SCRIPTS
Ilya Tebelev
on
_optimizer_ignore_hint
Vimal Rathinasamy
on
Oracle 12c multitenant architecture
Amin Adatia
on
ORA-14404: partitioned table contains partitions in a different tablespace
Recent Comments