WebDiscoverer II

1. Finally found out the reason why the OID would not start.....
The start-sequence has to be different.... previously the database only got started in the end...
now after installing the ”biz” ORACLE_HOME the sequence has be: database first and then the ”opmnctl startall”
2. Create the new Discoverer tablespace(use the script: create_discoverer_tablespace.sql)
and the new EUL: grant_sysadmin_EUL.sh
is this really necessary ??????
3. Applied the patches as suggested by the document: "Using Discoverer 10.1.2 with Oracle E-Business Suite 11i"
Doc ID: Note: 313418.1

Merged the following into ”Discoverer_merged”:

2921686 CUMULATIVE BUSINESS VIEW GENERATOR PATCH
3133021 Latest OracleOASIS files for runDiscoverer and runReport
- Norwegian
5765314 STANDARD PATCH CONTAINING AD UTILS FOR DISCOVERER 10G
6430269 NEW FND PUB FAILS IN SECURE TICKET CONNECTION FROM 11I.CU2
- Norwegian
6459796 QRMP:ADRFSEUL.SH: FAILED TO FIND FOLDER

4. Failed on the icxwtab.odf driver... see Metalink note 430673.1: Icxwtab.odf Failed Applying Patch 5473858
run the script: sqlplus -s apps/xxxx @$ICX_TOP/sql/ICXDLTMP
and a recurrent program should be started at regular intervals:
The name of the program is "Purge data from temporary table".
Output:
issoap01,oraPROD,~/appl/icx/11.5.0/sql >
sqlplus -s apps/xxxx @ICXDLTMP
70029 rows deleted.
127052 rows deleted.
284613 rows deleted.
125 rows deleted.
0 rows deleted.
0 rows deleted.
0 rows deleted.
0 rows deleted.
Commit complete.
PL/SQL procedure successfully completed.


4. Needs to relink: adrelink.sh force=y "fnd f60webmx" "fnd ar60run" "fnd ar60rund"
and regenerate JAR-files.