Re: Oracle 9iAS Portal on 9i Database?

From: Holger <h.lausen_at_gmx.de>
Date: 20 Nov 2001 08:34:23 -0800
Message-ID: <7b61a29b.0111200834.2eed2a7d@posting.google.com>

Hi Pete (and anyone else that drives crazy installing 9i and Portal ;)

finally i gave up installing, but here is how far i got:

Problem: Installing Portal 3.0.9 into 9i DB

Facts:
-I red Note 160254.1 (How to Install Portal into an Oracle 9i Database) and followed the instructions. -Due to the fact that ORA-1821 DATE FORMAT NOT RECOGNIZED occured executing launch.sh I followed the intructions in Note Note:163268.1 and updated sqlnet clients.
-trying to acces /pls/portal30/portal30.home leeds to HTTP-503 (Service Temporarily Unavailable)
Apache error_log:

[Tue Nov 20 13:27:07 2001] [error] mod_plsql: /pls/portal30/portal30.home HTTP-503 ORA-604 <B>Client Logon Failed with error : 604</B><BR>

9i database log/trace:
woody_ora_17708.trc:

/www/oracle/app/oracle/admin/woody/udump/woody_ora_17708.trc: Oracle9i Enterprise Edition Release 9.0.1.1.0 - 64bit Production With the Partitioning option
JServer Release 9.0.1.1.0 - Production
ORACLE_HOME = /www/oracle/app/oracle/product/9.0.1 System name: SunOS

Node name:      bello
Release:        5.8
Version:        Generic_108528-08
Machine:        sun4u

Instance name: WOODY
Redo thread mounted by this instance: 1
Oracle process number: 14
Unix process pid: 17708, image: oracle_at_bello (TNS V1-V3)

SESSION ID:(20.26) 2001-11-20 13:27:07.698 Skipped error 604 during the execution of SYSTEM.PORTAL_LOGIN_TRIG
2001-11-20 13:27:07.700 ksedmp: internal or fatal error ORA-00604: Fehler auf rekursiver SQL-Ebene 1 ORA-01031: Unzureichende Berechtigungen ORA-06512: in "SYS.DBMS_SESSION", Zeile 78 ORA-06512: in "SYSTEM.OWA_VPD_CTX", Zeile 5 ORA-06512: in "SYSTEM.PORTAL_LOGIN", Zeile 3 ORA-06512: in Zeile 2 KSTDUMP: In-memory trace dump

SYS.DBMS_SESSION, SYSTEM.OWA_VPD_CTX, SYSTEM.PORTAL_LOGIN all have grant execute to portal30 and i even gave them to public!

So I disabled the SYSTEM.PORTAL_LOGIN_TRIG and login was possible!

Then I got WWC-4149, I tried to run ssodatan but that failed, look into details and recognized that a Object Type is missing and this causes ERRORS

--> droped the users and reinstalled according to Note:135182.1
(Metalink)

a.  PORTAL30
b.  PORTAL30_DEMO
c.  PORTAL30_PUBLIC
d.  PORTAL30_SSO
e.  PORTAL30_SSO_PUBLIC

i tried to reinstall but falied since laun.sh raised a new error: Class not found: oracle.webdb.config.PortalConfigAssistant even if the opca.jar is in the classpath and all other component did load successfull

Finaly at this Point I gave up installing Portal against 9i DB, please let me know if anyone else suceeds...

thx
Holger Received on Tue Nov 20 2001 - 10:34:23 CST