ARTICLES(73)

• MongoDB

• ORACLE HCM CLOUD

• How Delete Statement Works
• How Update Statement Works
• How Insert Statement Works
• Oracle Cloud Platform Systems Management 2018 Associate (1Z0-930)
• Upgrade Oracle DBA 11g or 12c to 12c R2 (1Z0-074)

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

• ORA-14652: reference partitioning foreign key is not supported
• OCR create keys failed for root with OCR error 27
• Execution failed: Can’t locate Env.pm in @INC (Perl script (roothas.pl))
• $GRID_HOME/bin/ocrconfig.bin: error while loading shared libraries: libaio.so.1:
• ORA-02291

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

• 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
• Upgrade Database from Oracle 11gR2 to Oracle 19c

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

• Autonomous Database

• Steps to recover WebLogic Credential [OEM 12cR5]
• OEM Management Agent Installation Using Silent Method
• Agent Blocked (Bounce Counter Mismatch) OEM 12C/13C
• Basic Commands For Controlling OEM 12C/13C Cloud Control
• Oracle Enterprise Manager 13c Release 3 Cloud Control installation

ORACLE DATABASE(132)

• Multitenant

• Partition Pruning with Example
• Partition Pruning in Oracle
• Types of Index Partitions
• Composite Partitioning in Oracle
• Types of Table Partitions 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