mod_plsql: Stale Connection due to error 6511
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 220.127.116.11
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
[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.
Also the database version you are connectiong from the 9iAS.
>> Release 18.104.22.168.0 - 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.
It's not what the world does to you that matters. It's how you respond...
Click Here to Expand Forum to Full Width