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.
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.
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
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.
Happy New Year 2018
Attending Oracle Cloud Conference @Bangalore 2017
Oracle Developers Aggregation of articles from Oracle engineers, Developer Champions, partners, and developer community on all things Oracl...
Options ABANDON and RESTART adop phase=apply patches=10721639 abandon=yes Used to specify whether to restart the previous run of a...
FS_CLONE Phase It is a stand-alone command used for file system cloning. Standard cloning (using adcfgclone.pl) cannot be used to synch...
Wish every one a Happy New Year.
Abort Phase If for some reason either the prepare or apply phase failed or gave problems, you can abort the patching cycle. After runnin...
Scenario You have been asked to apply a patch and you completed the prepare phase and apply phase. Now customer has given a downtime f...
FMW 11g Upgrade Master Index After upgrading Discoverer and Portal to 11g logging on the portal or discoverer results in ORA-7445 in the ...
Scenario You have noticed that the on the patch edition there are lot of patches applied. You did the cutover and now customer wants t...