We are getting page not found on the first page after entering user id and password.
Our server is Sun 9, Oracle 9ias release 10222, Oracle 9i ver

The 9iAS log shows the error below.

The execute on (package)
privilege looks ok for our web user, www_user. The link of the first page:
Apache error log
[Wed Dec 17 11:20:43 2003] [warn] mod_plsql: Stale Connection due to Oracle
error 6511
[Wed Dec 17 11:20:43 2003] [error] mod_plsql: /pls/chi_adsp/twbkwbis.P_ValLogin
ORA-06511: PL/SQL: cursor already open
ORA-06512: at "WTAILOR.TWBKLIBS", line 48
ORA-06512: at "WTAILOR.TWBKWBIS", line 398
ORA-06512: at "WTAILOR.TWBKWBIS", line 1690
ORA-06512: at "WTAILOR.TWBKLOGN", line 1515
ORA-01031: insufficient privileges
ORA-06512: at "WTAILOR.TWBKWBIS", line 3976
ORA-06512: at line 7

See my more answers below.
First I like to know the full 5 digit version of 9iAS Release 1 you are using.
>>v9ias 10222
Also the database version you are connectiong from the 9iAS.
>> Release - 64bit Production
Do you have the same issue with the simple hello world procedure.
>>> I tested it and it worked fine.
Are you providing uername/password in the DAD? Please provide more information
for this issue.
>>> Yes we create a DAD entry using WWW_USER user and password as our web user.

The packages are all valid. We installed this new application and on the new production box and we got this problem. The first test server is running fine with pretty much the same setup.