ARTICLES(80)

• MongoDB

• ORACLE HCM CLOUD

• Oracle Database Cloud Service 2019 (1Z0-998)
• List of Cloud Certification (OCI, AWS, GCP, Alibaba, Azure)
• Oracle Cloud Infrastructure Foundations 2020 (1Z0-1085-20)
• Oracle Cloud Infrastructure 2019 (1Z0-1072)
• Oracle Database Administration 2019 Certified Professional (1Z0-083)

BACKUP AND RECOVERY(94)

• ORA-00031: session marked for kill
• RMAN Parallel Backup
• RMAN Script
• RMAN Image Copy And Compressed Backup
• Recover From Redo Log File (After Lost Data File))

DATAGUARD(75)

• Change SYS password in Data Guard environment
• Steps to recover the standby database’s datafile using a backup of the primary database’s data file
• Steps to Create,Drop and Flashback Guaranteed restore point in Dataguard
• MUST_RENAME_THIS_DATAFILE on RAC Standby
• Upgrading an Oracle Data Guard Broker Configuration

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(42)

• Session in killed state
• Background Media Recovery terminated with ORA-1274 after adding a Datafile
• crsctl Error: CLSU-00100 CLSU-00101 CLSU-00103 CLSU-00104
• ORA-19511: Error received from media manager layer
• ORA-16014: log X sequence# XXX not archived in Standby

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(103)

• ORACLE 12CR2

• ASMCMD-8102: no connection to ASM; command requires ASM to run
• 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

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(18)

• Installing Oracle Database 19c with GitHub Repos
• Oracle 19C Active Data Guard DML Redirection Feature
• Creating and Configuring an Oracle Database for RPM Based
• ORACLE 19C RPM BASED SOFTWARE INSTALLATION
• Manual upgrading Oracle database 11gR2 to 19c

Oracle 20c(2)

• Installing Oracle 20c Binary on OEL 7.5
• New Features in Oracle Database 20c

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(69)

• Autonomous Database

• devops

• Infrastructure Identity and Access Management(IAM)
• Networking components in Oracle Cloud Infrastructure(OCI)
• Storage options in Oracle Cloud Infrastructure
• Compute in Oracle Cloud Infrastructure(OCI)
• Oracle Cloud Infrastructure(OCI) Overview

ORACLE DATABASE(154)

• Multitenant

• Apply latest PSU (Jan 2020) on Oracle Home
• Exchange Subpartition in Oracle
• Exchange Partition of *-List and *-Range Partition
• Exchanging a Partition of an Interval Partitioned Table
• Virtual Column Partitioning 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(114)

• Oracleasm configure fails with selinux enable
• Highly Available VIP (HAVIP)
• Recovering OCR using physical backup
• Evaluation and Prediction in Oracle RAC 12c
• Manually Converting Non-RAC DB to RAC DB

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