Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

HPUX Error: 12: Not enough space

BHEL
Advisor

HPUX Error: 12: Not enough space

We have installed Oracle 11g database on HP-UX 11iv3.Yesterday we were not able to connect to database with the error tns-listener not found.
Below is the error from listener.log
TNS-12518: TNS:listener could not hand off client connection
TNS-12549: TNS:operating system resource quota exceeded
TNS-12560: TNS:protocol adapter error
TNS-00519: Operating system resource quota exceeded
HPUX Error: 12: Not enough space


from error log:
Process startup failed, error stack:
Errors in file /home/oracle/product/diag/rdbms/baps/baps1/trace/baps1_psp0_24175.trc:
ORA-27300: OS system dependent operation:fork failed with status: 12
ORA-27301: OS failure message: Not enough space
ORA-27302: failure occurred at: skgpspawn3


How to overcome this issue
7 REPLIES
Dennis Handly
Acclaimed Contributor

Re: HPUX Error: 12: Not enough space

What are the values of maxdsiz and maxdsiz_64bit?
What is the "swapinfo -tam" output when it fails?
Chandrahasa s
Valued Contributor

Re: HPUX Error: 12: Not enough space

Hi,

Can you verify bdf output may one of file system is full.


Chandra
BHEL
Advisor

Re: HPUX Error: 12: Not enough space

Hi
Swap details
swapinfo -tam
Mb Mb Mb PCT START/ Mb
TYPE AVAIL USED FREE USED LIMIT RESERVE PRI NAME
dev 24576 0 24576 0% 0 - 1 /dev/vg00/lvol2
reserve - 18236 -18236
memory 31206 19283 11923 62%
total 55782 37519 18263 67% - 0 -


I got the below error at the time of booting the server

***********************************STREAMS/UX*******************************@#%
Wed Sep 15 IST 2010 10:19:28 AM.214698ERROR Subsys:STREAMS Loc:00123
29 10:19:28 136584696 1 T.. 2224 24 tl_wput:T_OPTMGMT_REQ:out of state, state=10

***********************************STREAMS/UX*******************************@#%
Wed Sep 15 IST 2010 10:19:34 AM.084982ERROR Subsys:STREAMS Loc:00123
30 10:19:34 136585283 1 T.. 2224 24 tl_wput:T_OPTMGMT_REQ:out of state, state=10




and in nettl.LOG000

6035>:<:consolidatestatus>: Attempt to collect
health status of LAN subsystem failed --
Enumeration of HPUX_EthernetPort class failed

***********************************STREAMS/UX*******************************@#%
Timestamp : Wed Sep 15 IST 2010 10:19:28 AM.214698
Process ID : 20317 Subsystem : STREAMS
User ID ( UID ) : 500 Log Class : ERROR
Device ID : 0 Path ID : 0
Connection ID : 0 Log Instance : 0
Location : 00123
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
29 10:19:28 136584696 1 T.. 2224 24 tl_wput:T_OPTMGMT_REQ:out of state, state=10

***********************************STREAMS/UX*******************************@#%
Timestamp : Wed Sep 15 IST 2010 10:19:34 AM.084982
Process ID : 20317 Subsystem : STREAMS
User ID ( UID ) : 500 Log Class : ERROR
Device ID : 0 Path ID : 0
Connection ID : 0 Log Instance : 0
Location : 00123
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
30 10:19:34 136585283 1 T.. 2224 24 tl_wput:T_OPTMGMT_REQ:out of state, state=10

***********************************STREAMS/UX*******************************@#%
Timestamp : Wed Sep 15 IST 2010 10:19:34 AM.087103
Process ID : 20317 Subsystem : STREAMS
User ID ( UID ) : 500 Log Class : ERROR
Device ID : 0 Path ID : 0
Connection ID : 0 Log Instance : 0
Location : 00123
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
31 10:19:34 136585283 1 T.. 2224 24 tl_wput:T_OPTMGMT_REQ:out of state, state=10

***********************************STREAMS/UX*******************************@#%
Timestamp : Wed Sep 15 IST 2010 10:19:34 AM.088166
Process ID : 20317 Subsystem : STREAMS
User ID ( UID ) : 500 Log Class : ERROR
Device ID : 0 Path ID : 0
Connection ID : 0 Log Instance : 0
Location : 00123
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
32 10:19:34 136585283 1 T.. 2224 24 tl_wput:T_OPTMGMT_REQ:out of state, state=10
BHEL
Advisor

Re: HPUX Error: 12: Not enough space

Hi
The maxdsiz & maxdsiz_64bit values

maxdsiz 6287360 / 1073741824
maxdsiz_64bit 58458112 / 2147483648
Dennis Handly
Acclaimed Contributor

Re: HPUX Error: 12: Not enough space

>total 55782 37519 18263 67%
>maxdsiz 6287360 / 1,073,741,824
>maxdsiz_64bit 58458112 / 2,147,483,648

These values seem fine now, unless the application needs more than 1 Gb, or 2 Gb for 64 bit mode.
BHEL
Advisor

Re: HPUX Error: 12: Not enough space

Hi
Thanks for the reply..But why the below error is coming

***********************************STREAMS/UX*******************************@#%
Wed Sep 15 IST 2010 10:19:28 AM.214698ERROR Subsys:STREAMS Loc:00123
29 10:19:28 136584696 1 T.. 2224 24 tl_wput:T_OPTMGMT_REQ:out of state, state=10
skt_skt
Honored Contributor

Re: HPUX Error: 12: Not enough space

if i have set maxdsiz_64bit to 10GB and if i run multiple instances (more than one number of processes) will those processes compete each other for that 10GB OR will each "invidual process" may get 10GB each??