Issue: Unable to Compile custom database schema objects after upgrade to EBS12.2
Error: SQL Error: ORA-38818: illegal reference to editioned object
Solution: The reason was that this owner of these objects was missing ENABLE EDITIONS privilege. I granted the required privilege to user by executing below command.
alter user <USER/SCHEMA_NAME> enable editions;
Example: alter user KRAPEX enable editions;
Reader ModeUpgrade from 8.1.7.0.0 to 9i release 2 (9.2.0.8.0) We can use three methods to upgrade our oracle database. Export / Import Database Upgrade Assistant…
Reader Mode1. Backup all data file and Control file by using following commands on every Sunday. (BACKUP SCRIPTS) host ocopy C:OracleRDBMS*.001 e:temphost del C:OracleRDBMS*.001 /qset…
Reader Mode Step 1. Create directory structure in $APPL_TOP $ cd $APPL_TOP $ mkdir xxfc $ cd xxfc $ mkdir 12.0.0 $ cd 12.0.0 $…
Reader ModeWe get invalid objects in oracle database, if a dependent object is changed. We try to understand from an example, suppose we rebuild a…
Reader ModeFirst Task to Upgrade CRS Database Name: PROD Instances: PROD1 Node name: racnode1 Instances: PROD2 Node name: racnode2 Oracle Database Home and ASM Home:…
Please confirm you want to block this member.
You will no longer be able to:
Please note: This action will also remove this member from your connections and send a report to the site admin. Please allow a few minutes for this process to complete.
Responses