ARTICLES(78)

• MongoDB

• ORACLE HCM CLOUD

• Steps to recover the standby database’s datafile using backup of primary database’s datafile
• How Select Statement Works
• Upgrade Oracle DBA 11g or 12c to 12c R2 (1Z0-074)
• Oracle 19C Active Data Guard DML Redirection Feature
• Steps to Create,Drop and Flashback Guaranteed restore point in Dataguard

BACKUP AND RECOVERY(80)

• Use of Basic RMAN commands
• Password Based Encryption in RMAN Backup
• Restore spfile
• Recovering database from loss of datafile in NOARCHIVELOG MODE
• Creating backup using recovery catalog

DATAGUARD(72)

• MUST_RENAME_THIS_DATAFILE on RAC Standby
• Upgrading an Oracle Data Guard Broker Configuration
• Creating Data Guard with 2 node RAC Primary and 2 node RAC standby
• Using DBMS_ROLLING to Upgrade the Oracle Database
• Upgrading Oracle Database with a Physical Standby Database

GOLDENGATE(31)

• Performing Initial Load in Oracle Golden Gate
• Commit Sequence Number in Golden Gate
• Golden Gate Process Group
• Editing Configuration Parameters
• Using GGSCI [Golden Gate Software Command Interface ]

ORA-ERRORS(23)

• ORA-00600 [qosdExpStatRead: expcnt mismatch]
• ORA-00600 [KUTYXTTE_TRANSFORM:FAILED]
• ORA-600[KCLANTILOCK_17]
• ORA-600 [KDZA_CHECK_EQ NOT IN DICTIONARY]
• TNS-12547: TNS:lost contact

ORACLE 11G(31)

• ORA-14020: this physical attribute may not be specified for a table partition
• Recreate Database Using Only Datafile and Logfile
• New feature in Oracle 11g database to kill session
• Shrink Lob segment in Oracle
• How to add Datafile in Oracle

ORACLE 12C(102)

• ORACLE 12CR2

• CHM (Cluster Health Monitor)
• LREG New BG Process In 12c
• ora-02097 parameter cannot be modified because specified value is invalid
• Downgrade Oracle Database from 12c to 11gR2
• Connecting PDB in Oracle 12c

Oracle 18c(45)

• Release Upgrade from 18.3 to 18.5 by applying RU
• Installing Oracle Database 18c with GitHub Repos
• Accessing the Oracle 18c Database in Vagrant VM
• Oracle Database 18c installation with Vagrant
• Finally, the wait is over!! Now Oracle 18c is Available for on-Premise

Oracle 19c(16)

• Creating and Configuring an Oracle Database for RPM Based
• ORACLE 19C RPM BASED SOFTWARE INSTALLATION
• Manual upgrading Oracle database 11gR2 to 19c
• Upgrade Database from Oracle 11gR2 to Oracle 19c
• Refreshing Materialized Views (mv_refresh)

ORACLE APPS DBA(5)

• HTML-Based Application Architecture
• 11i and R12 Environment Files/Variables Changes Comparison
• ERP (Enterprise resource planning)
• Oracle Applications R12 Architecture
• Difference between Oracle DBA and Oracle Apps DBA

ORACLE CLOUD(46)

• Autonomous Database

• Oracle Enterprise Manager 13c Release 3 Cloud Control installation
• New Features of Oracle OEM 13c release 3
• Oracle Enterprise Manager Cloud Control 13c Release 3 (13.3)
• How to check the status of OMS and Agent in OEM 13cR2
• Cloud Computing How do I Look

ORACLE DATABASE(124)

• Multitenant

• Explore the Automatic Diagnostic Repository (ADR)
• Oracle Gateway Installation for MSSQL Server on RHEL 7
• Recover From Redo Log File
• Advantage Of RMAN in Oracle
• Feature Enable In Oracle

ORACLE DBAAS(38)

• View All Rules with REST API in Oracle Cloud
• Enable an Access Rule with REST API in Oracle Cloud
• Create a Access Rule with REST API in Oracle Cloud
• Restart a Service Instance with REST API in Oracle Cloud
• View a Service Instance with REST API in Oracle Cloud

ORACLE RAC(113)

• Highly Available VIP (HAVIP)
• Recovering OCR using physical backup
• Evaluation and Prediction in Oracle RAC 12c
• Manually Converting Non-RAC DB to RAC DB
• Server Pools in Oracle RAC

SCRIPTS(39)

• RMAN Backup With Archivelog
• Delete applied archivelog script
• How to Purge Listener Log in Oracle
• MAXDATAFILES and other files in Oracle
• How to Flush Single SQL Plan out of Shared Pool in Oracle