Re: JDBC: Connection refused (BUF='HPUX Error: 12: Not enough space')

The first thing to check for "not enough space" is `swapinfo -tm`. Are you short on swap space (look at total PCT USED).

Could also be...

• Full or fragmented global 32-bit shared memory address space. It sounds like your OS is 64-bit (`getconf KERNEL_BITS`) but is Oracle mapping into 32-bit or 64-bit address space? When you run `ipcs -ma` and total up your SEGSIZ column is the total near 1.75 Gb? The 32-bit global addr space max is around 1.75 to 2.75 Gb depending upon whether your apps support SHMEM_MAGIC executable types that make use of quadrant 2. Note that shared memory segments are not the only thing that use the global addr space.
• Less likely but possible is a data segment issue

Contact the HP Response Center and ask for a copy of the unsupported yet very useful shminfo utility that shows how your 32-bit global addr space is being used.

Regards,

Eric Stahl

"koert54" koert54_at_nospam.com wrote:

>Connection refused (BUF='HPUX Error: 12: Not enough space')

>2GB RAM and 2GB paging space -> make that 4GB to 6GB paging space !
>HPUX != Win NT
>
>
>
>"Huy Vu" <huyv_at_usa.net> wrote in message news:3bffdadb_3_at_aeinews....
>> Hi all,
>>
>> I'm trying to tune up my Oracle database server 8.1.7 64bits on HP-UX 11.0
>> which has 2 GB of RAM and 2GB swap file.
>> The server hung often (cannot telnet to the server neither) without let
>any
>> error messages in syslog except the error found from remote JDBC
>> connections:
>>
>> java.sql.SQLException: Io exception: Connection
>>
>refused(DESCRIPTION=(TMP=)(VSNNUM=135294976)(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'))))
>> jdbc:oracle:thin:@orasvr:1521:O817
>>
>> The Oracle SGA of 'O817' database:
>>
>> SVRMGR> show sga
>> Total System Global Area 756292072 bytes
>> Fixed Size 104936 bytes
>> Variable Size 141709312 bytes
>> Database Buffers 614400000 bytes
>> Redo Buffers 77824 bytes
>>
>> I'm trying to determine how much physical memory and virtual memory
>> currently used by my Oracle database to fix this problem ASAP.
>>
>> Thanks in advance for any help.
>>
>> DH
Received on Sat Dec 01 2001 - 12:13:00 CST