Database Blog

JQUERY AUTOCOMPLETE FOR TEXT FIELD ITEM IN ORACLE APEX

Introduction his process helps to enable the users to quickly find and select from a  list of values as they type, searching and filtering without Native text with auto-complete in APEX.…

Read More

USING APEX_ERROR NOTIFICATIONS TO MANAGE CUSTOM ERROR MESSAGES

Introduction: The Users can customize the Error Messages in Apex Error Notifications  Default Messages: Procedures: Steps in APEX : Step 1 : Create a text field item P11_ENAME.   Step 2 : Create a…

Read More

How to Rename constraints

Posted by : Mahe    This Post demonstrates how to Renaming a constraints   Renaming a constraints SQL> show user; USER is “MAHE” SQL> select dbms_metadata.get_ddl(‘TABLE’, ‘T1’) from dual; DBMS_METADATA.GET_DDL(‘TABLE’,’T1′) ———————————————————…

Read More

Block change tracking for faster Incremental RMAN backups

Posted by : Unknown   Introduction  This Post demonstrates about the Block change tracking for faster Incremental RMAN backups   Block Change Tracking The details of changes in the blocks…

Read More

Solaris EM12c Agent Unreachable with Error “peer not authenticated”

Posted by : Mahe    Introduction This Post demonstrates about the Solaris EM12c Agent Unreachable with Error “peer not authenticated” Issue : ./emctl status agent Oracle Enterprise Manager Cloud Control 12c Release…

Read More

ORA-10873: file 1 needs to be either taken out of backup mode or media recovered

Posted by : Saravanan   Introduction This Post demonstrates about ORA-10873 , the file 1 needs to be either taken out of backup mode or media recovered Scenario : Database went…

Read More

12c introduces the Parallel Upgrade Utility

Posted by : Unknown   Introduction  This post demonstrates the parallel upgrade utility in 12c . Note : Oracle Database 12c introduces the Parallel Upgrade Utility (catctl.pl), which enables components…

Read More

How to determine if an index needs to be rebuilt.

Posted by : Unknown   This Post demonstrates to determine if an index needs to be rebuilt. We can get an idea of the current state of the index by…

Read More

RMAN-06613: Connect identifier for DB_UNIQUE_NAME DBNAME_DGS not configured

Posted by : Sundaravel Ramasubbu   RMAN-06613: Connect identifier for DB_UNIQUE_NAME DBNAME_DGS not configured   This Post demonstrates the Rman backup is failed with the error RMAN-06613: Connect identifier for…

Read More

OPATCH FAILED WITH ERROR CODE 73

Posted by : Gangainathan   This Post demonstrates about the Opatch failure SQL> select name,open_mode from v$database; NAME      OPEN_MODE ——— ——————– DOYEYDB  READ WRITE SQL> shut immediate; Database closed. Database…

Read More