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.
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...
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 noticed that the on the patch edition there are lot of patches applied. You did the cutover and now customer wants t...
Wish every one a Happy New Year.
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...
Cleanup Phase Drops now-redundant columns and other objects which are not required after the cutover phase. It is important that we do n...
Scenario You have been asked to apply a patch and you start with the first phase “PREPARE”. Background Customer has recently...
R12.2 Highlights This release is largely focused on providing new technology stack components, new configuration options, and new syst...
Introduction : The following will guide one to take a backup of ASM Enabled Database using RMAN. The following are the steps involved; ...