Database Blog

ORA-02304: invalid object identifier literal

ORA-02304: invalid object identifier literal Cause: An attempt was made to enter an object identifier literal for CREATE TYPEthat is either: – not a string of 32 hexadecimal characters –…

Read More

ORA-02266: unique/primary keys in table referenced by enabled foreign key

ORA-02266: unique/primary keys in table referenced by enabled foreign key Cause: An attempt was made to truncate a table with unique or primary keysreferenced by foreign keys enabled in another…

Read More

Untitled

Extended Data Type in Oracle 12c Extended Data Type in Oracle 12c Oracle 12c introduced extended data types, in which, VARCHAR2, NVARCHAR2, and RAW  data types can store more data.…

Read More

Untitled

How to Plug non-CDB database to CDB database? How to Plug non-CDB database oracle11g to CDB database? This article is in continuation of my previous article i.e. Upgrade Oracle Database 11g…

Read More

Untitled

ORA-39142: incompatible version number 5.1 in dump file ORA-39142: incompatible version number 5.1 in dump file. Recently I came across one issue while importing schema dump in 12c database.My Scenario.Schema…

Read More

Untitled

Active transactions in oracle database:- col name format a10 col username format a8 col osuser format a8 col start_time format a17 col status format a12 tti ‘Active transactions’ select s.sid,username,t.start_time,…

Read More

How to Resolve “ORA-29548: Java system class reported” in 12c?

After applying PSU to 12.1.0.2.0, the application gets following error. [Error] Execution (1: 1): ORA-29548: Java system class reported: release of classes.bin in the database does not match that of…

Read More

EBS R12 Login Page Is Not Coming Up – java.lang.RuntimeException: Guest user/pwd does not exist or match: GUEST/ORACLE

Acual Behavior E-Business Suite (EBS) Production Instance Login page is not coming up, Instead a blank page is being displayed. The issue can be reproduced at will with the following…

Read More

How to attach ebs 10.1.2 oracle home to central inventory

This post is to define “How to attach ebs 10.1.2 oracle home to central inventory” bash-3.2$ opatch apply Oracle Interim Patch Installer version 1.0.0.0.64 Copyright (c) 2011 Oracle Corporation. All…

Read More

How To Create An OCM Response File.

During patching, Opatch tool may ask for an OCM (Oracle configuration manager) response file. OCM can collect the configuration of your servers and send it to Oracle support.  Oracle support…

Read More