IO Exception: Not Enough Space

From: HARI OM <hari_om_at_hotmail.com>
Date: 6 Jul 2004 13:03:08 -0700
Message-ID: <d1d5ebe4.0407061203.9e45262@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 Received on Tue Jul 06 2004 - 15:03:08 CDT