Re: AS PORTAL 3.0.9 TROUBLESHOOTING WITH INSTALLATION

Well,

you can do 2 things here.

1. connect to the db with sqlplus and do describe dbms_java If you get an error or an empty response, this means JServer option was not properly installed. Then you will definitely have to
2. connect / as sysdba in sqlplus and issue this statement:

create or replace java system;

If this statement will succeed, you can be sure that JServer is correctly installed, otherwise you will probably have to increase java_pool_size and retry. There might also be not enough space in SYSTEM tablespace where JServer stores all classes, so you may have to extend it too.

When you are sure that JServer is ok, you may try to reinstall the Portal software and see if anything changed. The error you are getting actually indicates that Java system is NOT installed properly, otherwise dbms_java package should've been in place.

hope this will help,

    Bob.

"alpitaly" <albertopiazza_at_hotmail.com> wrote in message news:8631e12f.0109060135.74f981a1_at_posting.google.com...
> Hi,
> i have installed oracle 8.1.6.0.0. (second release) enterprise edition
> as a typical installation on a box powered with intel processor e
> windows 2000 server. The seed database named NORACLE work fine and i
> can test my connection via Net8assistant without problem. When i try
> to install Oracle AS9i (minimal installation) with oracle portal 3.0.9
> and the server http, the dos windows for resolution show me line
> errors like the following:
>
> error while computing shortname of oracle/xml/parser/v2/<namefile>
> ORA - 06550 row1 column 13
> PLS -00201 the DBMS_JAVA.SHORTNAME must be declared.
> ORA - 06550 row 1 column 7
> PL/SQ statement ignored
>
> I don't know if my seed database have jserver installed so prior to
> install portal i modified java_pool_size, shared_pool_size entries in
> init.ora e run from SQL plus the script initjwm.sql.
>
> Oracle official documentation tell me the i must change original
> database portal as AS portal install a new listener on the default
> port 1521 but i can't change any ports without error of connection.
>
> GRAZIE (sorry for my bad english).
Received on Thu Sep 06 2001 - 08:14:50 CDT