To view the database components:- col COMP_ID for a15 col COMP_NAME for a45 col STATUS for a20 set lines 100 pages 100 select COMP_ID,COMP_NAME,STATUS from dba_registry; 1) Remove Oracle ...

step 1:- connect oem database as sysdba and change the password:- sqlplus “/as sysdba” alter user sysman identified by “oem13c_monitor”; step 2:- Stop all OMS processes:- cd ...

set lines 288 col sample_time for a14 col CONFIGURATION head “CONFIG” for 99.99 col ADMINISTRATIVE head “ADMIN” for 99.99 col OTHER for 99.99 SELECT TO_CHAR(SAMPLE_TIME, ...

Description:                        AWS Lambda is a serverless compute service that runs your code in response to events and automatically manages the underlying compute resources for you. You ...

Description: Oracle Multitenant – an Oracle Database 12c Enterprise Edition option – introduces a new architecture that enables customers to easily consolidate multiple databases into a ...

Introduction Customer asks us to generate all the DDL source code for some database objects. So I just found the little piece of code to create DDL source.   Database Objects are,  ...

Databases Our choice of Autonomous Transaction Processing or Autonomous Data Warehouse. 2 databases total, each with 1 OCPU and 20 GB storage. Note:-We need choose Always free while database ...

This Post describes about RMAN is hung or it is very slow / Clearing RMAN repository / Troubleshoot RMAN-06214 error   RMAN> DELETE FORCE NOPROMPT OBSOLETE DEVICE TYPE DISK; If error ...

TO CHECK THE HIGH WATER MARK LEVEL OF TABLES set verify off col table_name for a20; column owner format a10 column alcblks heading ‘Allocated|Blocks’ just c column usdblks heading ...

Posted by : Saravanan   Introduction This Post demonstrates about error ORA-01741 : illegal zero-length identifier Scenario While adding multiple schemas to a single workspace, we get the ...