Database Blog

There are no valid navigations for this responsibility

Introduction Solution to fix There are no valid navigations for this repositry Posted by Venkateshwaran There are no valid navigations for this responsibility USER MANAGEMENT ERROR: SOLUTION: Log into the applications…

Read More

ORA-00600: internal error code, arguments: [1350], [1], [23], [], [], [], [], []

Introduction Steps to fix ORA-00600: internal error code, arguments: [1350], [1], [23], [], [], [], [], [] Posted by Sathiyaseelan Issue : ORA-600 while running gather stats for fixed objects. declare…

Read More

Using Staged Applications System to reduce patching downtime during R12 Upgrade

Introduction Steps to reduce patching downtime during R12 upgrade using staged applications Posted by Sakthi Sethu Perumal Section 1: Overview A Staged Applications system represents an exact copy of your…

Read More

ORA-27211: Failed to load Media Management Library

Posted by Sundaravel Ramasubbu Issue : Rman backup script fails with the below error. But strangely if we run the backup manually it went fine. RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE…

Read More

OBIEE 11g Analytics : Error while logging into application portal “Authentication failed: invalid user/password”

Posted by Narasimha Rao Introduction: When we try to login to OBIEE 11g Analytics after installation, We were not able to login to portal and got the error saying “Authentication failed:…

Read More

Oracle 11g ASM Intelligent Data Placement

Posted by Narasimha Rao Intelligent Data Placement enables you to specify disk regions on Oracle ASM disks for best performance. Using the disk region settings, you can ensure that frequently accessed…

Read More

Oracle 12c New Features – Alter Database Move Datafile

Posted by Abishek Kathiresan Introduction: In previous versions of Oracle when DBAs needed to move datafiles to new storage, or migrate between ASM and filesystem they needed to first take…

Read More

Oracle 12c New Features – SQL*Loader Express

Posted by Abishek Kathiresan Introduction: Oracle 12c introduces Sql*Loader Express features, which allow users to run sqlldr with minimum configuration. The following example shows loading records into table EMPLOYEE from…

Read More

Oracle 12c – startup container AND pluggable databases.

Posted by Abishek Kathiresan In Oracle 12c we start the Container Database (CDB) the same as we started previous database versions. [oracle@rac1 lib]$ sqlplus / as sysdba SQL*Plus: Release 12.1.0.1.0 Production…

Read More

Oracle 12c Common and Local users – ORA-65096 ORA-65049

Posted by Abishek Kathiresan In 12c when you login to a CDB database you default to the CDB$ROOT container.   [oracle@rac1 db_1]$ echo $ORACLE_SID T12 [oracle@rac1 db_1]$ ps -ef |…

Read More