WebDiscoverer II
15-Sep-08 22:28 Arkiveret i:
erg
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.
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.
|
Web Discoverer
02-Sep-08 10:53 Arkiveret i:
erg
0. Floowed the Meta-link Note: "Using
Discoverer 10.1.2 with Oracle E-Business Suite 11i", Doc ID: Note:
313418.1
1. Copied over the software from the test-server
2. Started on the "Install OracleAS Identity Management Infrastructure 10g" (directory: oim_10411) installation which serves as the
Application Server infrastructure tree....
3. Copied the 6522391 oraparam.ini file over to the "oim_10411/Disk1/install/oraparam.ini" as otherwise HP-UX 11.31 will not be recognized a valid OS.
4. After having changed the ports for E-Business(having defaulted to 1521for SQL*Net which 10G requires), the installer will fail on the "opmn failed to start"
This is caused by the "oim" tree not being relinked at installation time.....
Set the ORACLE_SID, ORACLE_HOME and PATH, and do a "relink all"
5. prereq is 6396555... which is the same problem as 3. above .....
6. Now for the 10G_Biz_Intel install... which in effect is Discoverer.....
7. prereq for the 4960210 is patch 6522391 .... like 3. above
8. patchup of both Application server tree's with patch 4960210
- software tree first!
- have to run "genclntsh" manually
- run the upgrade for the Metadata repository.....
1. Copied over the software from the test-server
2. Started on the "Install OracleAS Identity Management Infrastructure 10g" (directory: oim_10411) installation which serves as the
Application Server infrastructure tree....
3. Copied the 6522391 oraparam.ini file over to the "oim_10411/Disk1/install/oraparam.ini" as otherwise HP-UX 11.31 will not be recognized a valid OS.
4. After having changed the ports for E-Business(having defaulted to 1521for SQL*Net which 10G requires), the installer will fail on the "opmn failed to start"
This is caused by the "oim" tree not being relinked at installation time.....
Set the ORACLE_SID, ORACLE_HOME and PATH, and do a "relink all"
5. prereq is 6396555... which is the same problem as 3. above .....
6. Now for the 10G_Biz_Intel install... which in effect is Discoverer.....
7. prereq for the 4960210 is patch 6522391 .... like 3. above
8. patchup of both Application server tree's with patch 4960210
- software tree first!
- have to run "genclntsh" manually
- run the upgrade for the Metadata repository.....