Re: IO Exception: Not Enough Space

hari_om_at_hotmail.com (HARI OM) wrote in message news:<d1d5ebe4.0407061203.9e45262_at_posting.google.com>...
> I am using Oracle 9.2.0.4 on IBM AIX 5.1L System. I have 2 instances
> running on the same box - PROD and TEST
>
> When I run my JAVA Web Application to access this database I get
> followin gerror wonder why:
> ------------------------------------------------------------------------------------
> Error message: SQL Error running Report : Io exception: Connection
> refused(DESCRIPTION=(TMP=)(VSNNUM=153093120)(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='IBM/AIX RISC System/6000 Error: 12: Not enough
> space'))))
>
> Stack trace:
>
> com.phx.html.reports.ReportException: SQL Error running Report : Io
> exception: Connection
> refused(DESCRIPTION=(TMP=)(VSNNUM=153093120)(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='IBM/AIX
> RISC System/6000 Error: 12: Not enough space'))))
> ------------------------------------------------------------------------------------
>
> Here is my TROUBLESHOOTING INformation:
> #df -k
> cks Free %Used Iused %Iused Mounted on
> /dev/hd4 65536 47492 28% 1817 15% /
> /dev/hd2 3080192 600488 81% 21001 14% /usr
> /dev/hd9var 32768 20548 38% 422 9% /var
> /dev/hd3 262144 257636 2% 369 1% /tmp
> /dev/hd1 32768 32248 2% 52 1% /home
> /proc - - - - - /proc
> /dev/hd10opt 262144 71084 73% 9873 38% /opt
> /dev/downloads 524288 522812 1% 32 1% /downloads
> /dev/oracle 6684672 1614060 76% 66270 16% /oracle
> /dev/archive 524288 523808 1% 9 1% /archive
> /dev/dict 35454976 32754284 8% 47 1% /dict
> /dev/redo 35454976 34117820 4% 36 1% /redo
> /dev/data 35127296 28733384 19% 369 1% /data
>
> # lsps -a
> Page Space Physical Volume Volume Group Size %Used Active
> Auto Type
> paging00 hdisk0 rootvg 224MB 1 yes
> yes lv
> hd6 hdisk1 rootvg 288MB 2 yes
> yes lv
>
> # lsps -s
> Total Paging Space Percent Used
> 512MB 1%
> #
> SQL> conn sys/****@prod as sysdba
> SQL> startup;
> ORACLE instance started.
> Total System Global Area 404194808 bytes
> Fixed Size 742904 bytes
> Variable Size 369098752 bytes
> Database Buffers 33554432 bytes
> Redo Buffers 798720 bytes
> Database mounted.
> Database opened.
> SQL>
>
> SQL> conn sys/****@test as sysdba
> Connected to an idle instance.
> SQL> startup;
> ORACLE instance started.
> Total System Global Area 404194808 bytes
> Fixed Size 742904 bytes
> Variable Size 369098752 bytes
> Database Buffers 33554432 bytes
> Redo Buffers 798720 bytes
> Database mounted.
> Database opened.
> SQL>
>
> I have following TBLSPCS:
> NAME SIZE(M) USED(M) USED (%)
> CWMLITE 20 17.5 87.5
> DRSYS 20 9 48
> EXAMPLE 147 0 0
> INDX 25 0 0
> ODM 20 9 46
> OEM_REPOSIT 68 32 46
> APPLICATION 200 81 40
> APP_TEMP 30 19 63
> SYSTEM 500 424 84
> TEMP 41 0 0
> TOOLS 10 0 0
> UNDOTBS1 660 11 1
> USERS 25 0 0
> XDB 46 44 95
>
>
> I have all the ABOVE TBLSPC
> "Automatically extend datafile when full (AUTOEXTEND)
> Increment 10240 KB
> Maximum Value 32767 MB"
>
> My MEMORY Spec for this instance are:
> SGA
> Shared Pool 160MB
> Buffer Cache 32MB
> Large Pool 16MB
> Java Pool 160MB
> Total SGA 369.208 MB
> SGA Max Size: 385.470MB
>
> # vmstat
> kthr memory page faults cpu
> ----- ----------- ------------------------ ------------ -----------
> r b avm fre re pi po fr sr cy in sy cs us sy id wa
> 1 1 227124 168 0 0 0 0 0 0 280 1844 385 2 1 95 2
>
>
> My Memory is 1GB.
>
> Also when I get this ERROR MESSAGE my DB Server (IBM AIX) m/s simply
> FREEZES and HANGS and so I have to restart the Database.
>
> I wonder where the problem could be - could anyone give some
> hints/troubleshooting tips etc to solve this problem?
> Any related inforamtion is appreciated....
>
> HARI OM
Hi, Hari,

I'm not very familiar with AIX. But the error 12500 and 12540 TNS errors tell us your listener process (tnslsnr) can't spawn any more processes. The OS Error: 12: Not enough space probably means you run out of memory or swap space. Check it *after*, not before, you startup the instance. You may see a corresponding error in your listener.log and possibly OS system log file.

Yong Huang Received on Wed Jul 07 2004 - 11:26:12 CDT