Upgrade WebDB 2.2 to Portal fails

From: Per Sverre Stiansen <per.sverre.stiansen_at_caa.no>
Date: Sun, 25 Feb 2001 09:41:52 +0100
Message-ID: <lz3m6.2980$t21.53764_at_news3.oke.nextra.no>

Hi folks!
Can someone help me out on this? I'm trying to upgrade a WebDB 2.2 to Portal (3.0.6.6.5) for Sun SPARC Solaris (using the Oracle9iAS Portal Upgrade Scripts for Solaris ) and for some reason the result of this is a ORA-06502 error near the end of the upgrade process, at the part where the old WebDB components is to be converted to Portal. Se th following output from wupgrade.log:

begin
 *
 ERROR at line 1:

 ORA-06502: PL/SQL: numeric or value error
 ORA-06512: at "WEBDB.WWV_UTLMOD", line 168
 ORA-06512: at "WEBDB.WWV_LINK_UTILITIES", line 417
 ORA-06512: at "WEBDB.WEBVIEW_UPGRADE", line 5464
 ORA-06512: at line 35

 Failed to generate SCOTT.EXAMPLE_FRAME - ORA-06502: PL/SQL: numeric or value
 Error

Also if I try to access som components from the components page of Portal, I receive a javascript error indicating that the object cannot be found.

Some vital information about the installation: Solaris SPARC 7 (with recomended patches) Oracle 8.1.6 (with 8.1.6.2.0 patch)

The environment before executing the wupgrade script: HOME=/u01/app/oracle
PATH=/bin:/usr/bin:/u01/app/oracle/product/portal30/bin:/usr/ccs/bin:/usr/uc b:/etc:.
LOGNAME=oracle
HZ=100
TZ=GMT+1
TERM=xterm
SHELL=/bin/csh
PWD=/installstage/306upg
USER=oracle

ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/portal30
ORACLE_DOC=/u01/app/oracle/product/portal30/doc

LD_LIBRARY_PATH=/u01/app/oracle/product/portal30/lib:/usr/openwin/lib:/usr/l ib:/usr/dt/lib
ORACLE_TERM=xsun5
EDITOR=/bin/vi

NLS_DATE_FORMAT=DD/MM/YY
NLS_LANG=norwegian_norway.we8iso8859p1
ORA_NLS33=/u01/app/oracle/product/portal30/ocommon/nls/admin/data

ORACLE_SID=NATT
TNS_ADMIN=/u01/app/oracle/product/portal30/network/admin/tnsnames.ora WV_GATEWAY_CFG=/u01/app/oracle/product/webdb/listener/cfg/wdbsvr.app TWO_TASK=NATT
TMP=/usr/tmp

Vitals from wupgrade script:

The following details have been determined:

RDBMS Version: 8.1.6.2.0
WebDB/Portal Version: 2.2.0.0.5 - WEBVIEW Oracle PL/SQL Toolkit Schema: UNKNOWN, version: UNKNOWN Login Server Schema: Create new schema portal30_sso URL prefix for the Portal is http://enosx07:7777/pls/NATT/ URL prefix for Login Server is http://enosx07:7777/pls/NATT_sso/ Upgrade needed on obfuscation and cryptographic toolkits - Y Upgrade needed on Oracle PL/SQL Toolkit - Y

Is this information correct (Y/N):

Please help me to get this WebDB installation upgraded, I'm desperate :-)!!!!

--Peres-- Received on Sun Feb 25 2001 - 09:41:52 CET