If you get the following error in your java+jsp+oracle application, then you probably need to increase your maximum session/process limits (Default process and sessions limit in Oracle 9i are 150 and 170 respectively)

java.lang.Exception: SQL Error : java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(TMP=)

Instructions for Increasing session, process and open_cursors max limits to 500 each are:

1. Login to SQL Plus as a normal user.

2. Run this query on SQL Plus (Replace xxxxxxxxxxxxx with your sys user password)

connect sys/xxxxxxxxxxxxx as sysdba

ALTER SYSTEM SET open_cursors=500 SCOPE=SPFILE;

3. Then run the below query on SQL Plus (Replace xxxxxxxxxxxxx with your sys user password)

connect sys/xxxxxxxxxxxx as sysdba

ALTER SYSTEM SET sessions=500 SCOPE=SPFILE;

4. Then run the below query on SQL Plus (Replace xxxxxxxxxxxxx with your sys user password)

connect sys/xxxxxxxxxxxxx as sysdba

ALTER SYSTEM SET processes=500 SCOPE=SPFILE;

5. Then run the below query on SQL Plus

commit;

6. Open Control Panel > Administrative Tools >  Services

7. Restart all the oracle services that are running.

That’s it. Now the open_cursors, session and process limits will be set to 500 each.

If you want to check the current value of session and process maximum limit you can run the below query any time.

SELECT name, value FROM v$parameter WHERE name = ‘sessions’;

and

SELECT name, value FROM v$parameter WHERE name = ‘processes’;

If you want to check the process & session current utilization, maximum utilization and maximum limit you can run the below query:

select
resource_name,
current_utilization,
max_utilization,
limit_value
from
v$resource_limit
where
resource_name in ( ‘sessions’, ‘processes’);

Hope instructions are clear. Please let me know if you need any more info.

VN:F [1.9.12_1141]
Rating: 1.0/10 (1 vote cast)
VN:F [1.9.12_1141]
Rating: +1 (from 1 vote)
java.lang.Exception: SQL Error : java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(TMP=), 1.0 out of 10 based on 1 rating