Memory error in oracle 9i installatin in HP UX, while connecting from websphere 5

[Anil kumar P]

hi
I am getting the following memory error in HP(64bit), while trying to connect from websphere 5. The issue is occuring only after creating 15-20 connections...
The application is working fine while connecting to oracle installations in AIX 4.2 and windows from the same Application server.

[11/13/03 20:00:11:460 IST] 2a869b5 SystemErr R java.sql.SQLException:
Io exception: Connection
refused(DESCRIPTION=(TMP=)(VSNNUM=135295744)(ERR=12500)(ERROR_STACK=(ERROR=(CODE=12500)(EMFI=4))(ERROR=(CODE=12540)(EMFI=4))(ERROR=(CODE=12560)(EMFI=4))(ERROR=(CODE=510)(EMFI=4))(ERROR=(BUF='HPUX

Error: 12: Not enough space'))))

[11/13/03 20:00:11:460 IST] 2a869b5 SystemErr R at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)

[11/13/03 20:00:11:460 IST] 2a869b5 SystemErr R at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)

[11/13/03 20:00:11:460 IST] 2a869b5 SystemErr R at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:333)

[11/13/03 20:00:11:460 IST] 2a869b5 SystemErr R at
oracle.jdbc.driver.OracleConnection.(OracleConnection.java:404)

pls help...
thanks in advance
Anil kumar P

[Graham Cameron_1]

Error 12 = ENOMEM.

I suspect you don't have correct kernel settings for your shared memory parameters
shmmax
shmmni
shmseg
check against the recommended settings.

-- Graham

[RAC_1]

Try increasing maxssiz (maxssiz_64bit if oracle is 64 bit)

Also check vmstat 5 5 after doing 10-20 connections.

[T G Manikandan]

Any problems I would first suggest to look at the trace file or alert log for the instance.

That might help in resolve the problem quickly.

check the kernel parameters

maxdsiz_64
shmmax

[T G Manikandan]

Also revert with your swap and memory usage!