Initial WebReports Start-Up Errors
Hello,
What I find funny about this particular problem, is that I have is that these errors occurs mostly when the WebReports are called from WebForms for the first time (using a arameter Form).
PT
PS: Any comments about that ?
Query Results + REP-51018
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
Re: Query Results + REP-51018
Quote:
Originally posted by ptreves
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
yeah, read the manuals and do it properly. Works every time