Applicable: The following instruction is applicable only to customers who are having Discoverer4i and looks for 10g migration.
Summary: Existing End User Layer EUL4_US will be backed up using Operating System Export Command and Imported back to the same database as EUL5_US Schema.This will help in preserving the Old End User Layer and create a new Schema for the 10g Discoverer.
Pre-Upgrade Step:
1. Backup the Existing End User Layer.
exp eul4_us/xxxxxx file=pre_10g_upgrade_eul4_backup.dmp
Move the file to $AU_TOP/discoverer
2. Create a new tablespace as DISCOVERE10G
3. Create a new user EUL5_US with the default tablespace as DISCOVERER10G
4. Grant connect , resource to eul5_us; & Grant select any table to eul5_us
5. Import the dump as EUL5_US.
imp eul5_us/eul5_us file=pre_10g_upgrade_eul4_backup.dmp fromuser=eul4_us touser=eul5_us
6. Lock the EUL4_US User.
Upgrade Steps:
1. Log in as Operating System Discoverer User on the Unix Box.
2. Make sure that the tnsping for the EBSO Instance works.
3. Run the command EULAPI to upgrade the End User Layer from EUL4 to EUL5.
$ORACLE_HOME/bin/eulapi -CONNECT <EUL User>/<Password>@<db> -AUTO_UPGRADE
Eg:$ORACLE_HOME/bin/eulapi -CONNECT EUL5_US/EUL5_US@EBSO -AUTO_UPGRADE
Testing the Upgrade:
Connect to 10g EM of Discoverer Instance and Create a Public Connection
Connection Name : EUL_UPGRADE
Connect To : Oracle Applications
User Name SYSADMIN
Connection Type Public
Database EBSO
End User Layer EUL5_US
Locale English (United States)
Responsibility System Administrator
Access the below url and confirm if you are able to see the EBSO Workbooks.
http://r12bi.r12.com:7777/discoverer/viewer
http://r12bi.r12.com:7777/discoverer/plus
The voice in my head may not be real , but they have some good ideas !!!
Fail Fast, Fail Forward, Fail Often, Fail Better , Standup Every Time
Every problem has at least one solution. Only some solutions are harder to find.
Popular Posts
-
FS_CLONE Phase It is a stand-alone command used for file system cloning. Standard cloning (using adcfgclone.pl) cannot be used to synch...
-
[oracle@testebsop3app01 ~]$ perl /u01/install/APPS/fs1/EBSapps/comn/clone/bin/adcfgclone.pl appltop /u01/install/APPS/fs1/inst/apps/SATURN_...
-
Abort Phase If for some reason either the prepare or apply phase failed or gave problems, you can abort the patching cycle. After runnin...
-
As a green field expert in data science, you would be responsible for designing and implementing data science projects from scratch. This i...
-
PRVG-2031 : Owner of file "/u01/app/oracle/diag/crs/rac01/crs/lck" did not match the expected value on node "HOST1". [Ex...
-
Suddenly all production reports in BI Publisher failed with message " ORA-01017: invalid username/password; logon denied" The da...
-
If you are an EBS administrator the first thing some asks you to do a health check of an environment , you return to him with a Request ID o...
-
EBS 12.2 ADOP Cycle Errors During Validation Cannot open XML file for load ADOP cycle will have validation errors in some cases. *****...
-
ADOP patching on a downtime mode with [ERROR] Patch service is not exist or running Please note , if you get ADOP issues on PROD ple...
-
Let me start telling a story , "Once upon a time there lived a great ♚EBS 12.2 instance , it was very kind to the DBAs and one fine day...