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
The error message returned suggests it's an OS issue. Have you
checked the error log:
errpt -a | pg
HTH,
Pete's
Received on Wed Jul 07 2004 - 07:42:37 CDT
