Hello,

I set the PROCESSES parameter in init.ora file located in ORACLE_HOME/dbs to 9999 where it was set to 50 before.

I ran Forms/Reports application over the Web and still get the logon screen asking me for the username/password/database with the error:

REP-51018: Need database user authentication
-----
Running the suggested queries, these are the results:

SQL> select pa.value as "Max Processes", count(*) as "Actual Processes", pa.value - count(*) as "Process Free", round(count(*)*100/pa.value, 0) as "% Load" from v$process p, (select value from v$parameter where name='processes') pa group by pa.value;

Max Processes
--------------------------------------------------------------------------------
Actual Processes Process Free % Load
---------------- ------------ ----------
150
14 136 9


SQL> select pa.value as "Max Sessions", count(*) as "Actual Sessions", pa.value - count(*) as "Sessions Free", round(count(*)*100/pa.value, 0) as "% Load" from v$session p,(select value from v$parameter where name='sessions') pa group by pa.value;

Max Sessions
--------------------------------------------------------------------------------
Actual Sessions Sessions Free % Load
--------------- ------------- ----------
170
11 159 6


SQL>

------

Your feedback is appreciated ...

PT