ARTICLES(35)

• ORACLE HCM CLOUD

• Privacy Policy
• Now Unachievable Certificate OCM Cloud
• OCM 12C Journey
• Tip and Tricks to pass OCM exam
• Safe Harbor Statement – Oracle

BACKUP AND RECOVERY(59)

• Control file recovery
• How to recover database without knowing DBID or DB Name
• Archive log delete input and delete all input
• RMAN maxpiecesize command
• Database Cloning without RMAN on windows

DATAGUARD(45)

• Manual Failover in Data Guard
• Manual SwitchOver in Oracle
• Changing Protection Modes in Oracle
• Checking the Standby’s Open Mode & Setup active Data Guard – REAL TIME APPLY
• Setting Protection Modes in Dataguard

GOLDENGATE(9)

• Schema replication using oracle goldengate
• Setting Up Table Replication In Oracle Goldengate
• Enable DDL Replication In Goldengate
• Obey Command In Goldengate
• Defgen Utility In Oracle Goldengate

ORA-ERRORS(11)

• ORA-01144: File size (4194304 blocks) exceeds maximum of 4194303 blocks
• Undo Segment is in Needs Recovery
• ORA-65179 PDB in Oracle 12c
• vipca error in Oracle RAC
• ORA-27300: OS system dependent operation

ORACLE 11G(25)

• Startup Procedure in Oracle
• Fix Invalid Or Unusable Index in Oracle
• Apply Patch without shutting the Database
• Network link in expdp
• ORA-30032: The Suspended (Resumable) Statement Has Timed Out

ORACLE 12C(86)

• ORACLE 12CR2

• ora-02097 parameter cannot be modified because specified value is invalid
• Downgrade Oracle Database from 12c to 11gR2
• Connecting PDB in Oracle 12c
• ASM – (ACFS commands for multiple environments)
• ASM Clients

Oracle 18c(40)

• Oracle Database 18c Client Released
• Export and Import Database link in Oracle 18c
• Creating Schema-Only Accounts in Oracle 18c
• Upgrade Grid Infrastructure to 18.2 by applying RU
• Patching (or Updating) home and database to 18.2 from base release by applying RU

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

• How to check the status of OMS and Agent in OEM 13cR2
• Cloud Computing How do I Look
• Oracle DBaaS Monitor In Oracle Cloud
• Running Oracle on Docker
• Oracle Cloud (DBaaS): Access Oracle Cloud Instance in GUI Mode

ORACLE DATABASE(87)

• Check Materialized View Refresh Schedule in Oracle
• Change User Password in Oracle
• License High Water Mark in Alert Log
• Lock and unlock statistics on a table in Oracle Database
• Bypass the AFTER LOGON trigger in Oracle Database

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

• Evaluation and Prediction in Oracle RAC 12c
• Manually Converting Non-RAC DB to RAC DB
• Server Pools in Oracle RAC
• Plug Single Instance PDB to RAC CDB
• ACFS file system Mount and Dismount Operation

SCRIPTS(35)

• How to Flush Single SQL Plan out of Shared Pool in Oracle
• Progress status of index rebuild in Oracle
• Find users with DBA privilege in Oracle
• Schedule rman backup in windows
• HOW TO CONVERT SCN TO DATE AND DATE INTO SCN