ERROR ORA-01157: cannot identify/lock data file 206 – see DBWR trace file ORA-01110: data file 206: ‘+DATA’ SOLUTION If you are using XML in your database and you are trying …

ERROR ORA-07445: exception encountered: core dump  [kglic0()+756] [SIGSEGV] [ADDR:0x430000010B8AE910] [PC:0x107AB7474] [Address not mapped to object] []   SOLUTION SQL> ALTER SYSTEM SET “_cursor_stats_enabled”=false SCOPE=SPFILE; Caution : This recommendation can be applied …

How to Find and repair Corrupt block in database Step 1: Below query will show if there is any corrupted block SELECT *  FROM   v$database_block_corruption — will show if any corruped block  Step 2: Below query can give you …

RMAN backup and logical backup With Different User Step 1: Create the user CREATE USER bkp_user IDENTIFIED BY bkp_user DEFAULT TABLESPACE users TEMPORARY  TABLESPACE temp PROFILE DEFAULT;  GRANT CONNECT TO bkp_user;  GRANT exp_full_database TO bkp_user;  GRANT imp_full_database TO bkp_user;  GRANT recovery_catalog_owner TO bkp_user;  GRANT select_catalog_role TO bkp_user;  GRANT CREATE SESSION TO bkp_user;  Step 2: Connect RMAN with the Above Created User …

ERROR Solution : ORA-01442: column to be modified to NOT NULL is already NOT NULL sql> alter table HR.employees modify UID not null; ORA-01442: column to be modified to NOT …

How To Move Table to Different TableSpace   SYNTAX ALTER TABLE table_name move TABLESPACE tablespace_name (INITIAL=64k MINEXTENTS=1 MAXEXTENTS=UNLIMITED);   EXAMPLE ALTER TABLE hr.employee_details move TABLESPACE hr; OR ALTER TABLE hr.employee_details move TABLESPACE hr (INITIAL=64k MINEXTENTS=1 MAXEXTENTS=UNLIMITED);  

What’s New in EBS 12.2.7? By: Steven Chan| Senior Director EBS 12.2.7 is the latest update to E-Business Suite 12.2. It includes functionality enhancements, error corrections, and statutory and regulatory updates in a …

What is Oracle E-Business Suite on Oracle Cloud? By: Nadia Bendjedou| Vice President – EBS Strategy You can think of running Oracle E-Business Suite on Oracle Cloud as running exactly the same Oracle E-Business …

Oracle’s Booming Cloud Business Could Rip And Replace SAP As #1 In Apps Bob Evans , CONTRIBUTOR  Opinions expressed by Forbes Contributors are their own. Oracle founder and chairman Larry Ellison believes …

How To Trace Concurrent Programs CASE 1 : Concurrent Program Tracing without bind variables 1)   Follow the following navigation to enable logging for Concurrent Program Goto Sysadmin > Concurrent > …