Saturday, June 16, 2007

Refreshing 10g Business Area using Discoverer Admin Edition and adrfseul.sh

Using Discoverer Admin Edition:

1. Connect to the Discoverer Administrator Server

2. Add the TNS Entry to D:\ODisc10g\network\admin\tnsnames.ora

3. Ensure that TNSPING works for the TNS entry made in step 2.

4. Open Discoverer Administrator Tool D:ODisc10g\bin\dis51adm.exe

5. Connect as SYSADMIN (Make sure you check the Box "Oracle Application User")

6. Open all the Business Area

7. Select all the Business Area

8. Select File >> Refresh , this process involves two steps.
The first step validates , it gives a difference report at the end.
If there are differences then the second step refresh continues.

Using adrfseul.sh:
1. Mount EBSO Application Tier Server Node $AU_TOP/discover to Oracle10gAS Discoverer Instance.

2. Start the Refresh Process by Executing the below command

sh adrfseul.sh
connect=sysadmin/@
resp="System Administrator"
gwyuid=APPLSYSPUB/PUB
fndnam=APPS
secgroup="Standard"
eulschema=EUL5_US
eulpassword=
twotask=
iashome=$ORACLE_BI_HOME
logfile=refresh_eul_us_.log

Popular Posts