f



Sun server with Oracle Database crashed

Hi All,

My Sun server which is running Oracle database 10.2.0.3.0 got hung and
the server had also crashed.

The /DBATSTDB01/oracle mount point which is mounted on slice c1t0d0s3
is 100%. It is reflecting /var/adm/messages:

Aug 31 15:40:43 blrtstdba02 ufs: [ID 845546 kern.notice] NOTICE:
alloc: /DBATSTDB01/oracle: file system full

The root slice " / " is occupied 82 %.

After the crash, although the /DBATSTDB01/oracle slice is 100% full,
the system hasn't hung so far. Is the /DBATSTDB01/oracle slice is
causing the system to hang or should I check for hardware issues?

Filesystem            kbytes    used   avail capacity  Mounted on

/dev/dsk/c1t0d0s0    11093692 9000920 1981836    82%    /
/devices                   0       0       0     0%    /devices
ctfs                       0       0       0     0%    /system/
contract
proc                       0       0       0     0%    /proc
mnttab                     0       0       0     0%    /etc/mnttab
swap                 2547944    1088 2546856     1%    /etc/svc/
volatile
objfs                      0       0       0     0%    /system/object
/platform/sun4u-us3/lib/libc_psr/libc_psr_hwcap1.so.1 11093692 9000920
1981836    82%    /platform/sun4u-us3/lib/libc_psr.so.1
/platform/sun4u-us3/lib/sparcv9/libc_psr/libc_psr_hwcap1.so.1 11093692
9000920 1981836    82%    /platform/sun4u-us3/lib/sparcv9/libc_psr.so.
1
/dev/dsk/c1t0d0s5    6050982 1646347 4344126    28%    /var
swap                 2554304    7448 2546856     1%    /tmp
swap                 2546904      48 2546856     1%    /var/run
/dev/dsk/c1t1d0s3    10327132 2730355 7493506    27%    /DBATSTDB01/
sybase
/dev/dsk/c1t1d0s0    8262869 2776798 5403443    34%    /DBATSTDB01/
sybdmp01
/dev/dsk/c1t0d0s3    8262869 8167769   12472   100%    /DBATSTDB01/
oracle
/dev/dsk/c1t0d0s6    5953014 4573376 1320108    78%    /DBATSTDB01/
orabck01
/dev/dsk/c1t0d0s4    37180795 11912591 24896397    33%    /DBATSTDB01/
oradata01
/dev/dsk/c1t1d0s1    51637959 29675283 21446297    59%    /DBATSTDB01/
sybdata01

Regards,
Bruce
0
Bruce
9/3/2009 2:24:54 PM
comp.unix.solaris 26025 articles. 2 followers. Post Follow

2 Replies
1274 Views

Similar Articles

[PageSpeed] 42

Bruce wrote:
> Hi All,
> 
> My Sun server which is running Oracle database 10.2.0.3.0 got hung and
> the server had also crashed.
> 
> The /DBATSTDB01/oracle mount point which is mounted on slice c1t0d0s3
> is 100%. It is reflecting /var/adm/messages:
> 
> Aug 31 15:40:43 blrtstdba02 ufs: [ID 845546 kern.notice] NOTICE:
> alloc: /DBATSTDB01/oracle: file system full
> 
> The root slice " / " is occupied 82 %.
> 
> After the crash, although the /DBATSTDB01/oracle slice is 100% full,
> the system hasn't hung so far. Is the /DBATSTDB01/oracle slice is
> causing the system to hang or should I check for hardware issues?
> 
> Filesystem            kbytes    used   avail capacity  Mounted on
> 
> /dev/dsk/c1t0d0s0    11093692 9000920 1981836    82%    /
> /devices                   0       0       0     0%    /devices
> ctfs                       0       0       0     0%    /system/
> contract
> proc                       0       0       0     0%    /proc
> mnttab                     0       0       0     0%    /etc/mnttab
> swap                 2547944    1088 2546856     1%    /etc/svc/
> volatile
> objfs                      0       0       0     0%    /system/object
> /platform/sun4u-us3/lib/libc_psr/libc_psr_hwcap1.so.1 11093692 9000920
> 1981836    82%    /platform/sun4u-us3/lib/libc_psr.so.1
> /platform/sun4u-us3/lib/sparcv9/libc_psr/libc_psr_hwcap1.so.1 11093692
> 9000920 1981836    82%    /platform/sun4u-us3/lib/sparcv9/libc_psr.so.
> 1
> /dev/dsk/c1t0d0s5    6050982 1646347 4344126    28%    /var
> swap                 2554304    7448 2546856     1%    /tmp
> swap                 2546904      48 2546856     1%    /var/run
> /dev/dsk/c1t1d0s3    10327132 2730355 7493506    27%    /DBATSTDB01/
> sybase
> /dev/dsk/c1t1d0s0    8262869 2776798 5403443    34%    /DBATSTDB01/
> sybdmp01
> /dev/dsk/c1t0d0s3    8262869 8167769   12472   100%    /DBATSTDB01/
> oracle
> /dev/dsk/c1t0d0s6    5953014 4573376 1320108    78%    /DBATSTDB01/
> orabck01
> /dev/dsk/c1t0d0s4    37180795 11912591 24896397    33%    /DBATSTDB01/
> oradata01
> /dev/dsk/c1t1d0s1    51637959 29675283 21446297    59%    /DBATSTDB01/
> sybdata01
> 
> Regards,
> Bruce

If your system crashed, it would have *tried* to write a crash dump. 
Have you configured the system to have, and use, a place to write a 
crash dump?  If not, why not?

If you have a crash dump and a Sun Software Service Contract, you can 
ask Sun to analyze the dump for you.
0
Richard
9/3/2009 2:46:40 PM
In article <42c3481b-0598-4707-98f7-c01371aef74e@i18g2000pro.googlegroups.com>,
Bruce  <brucemcgill.nyc@gmail.com> wrote:
>After the crash, although the /DBATSTDB01/oracle slice is 100% full,
>the system hasn't hung so far. Is the /DBATSTDB01/oracle slice is
>causing the system to hang or should I check for hardware issues?

Is Oracle trying to write new blocks to /DBATSTDB01/oracle?
Are you going to add additional space for /DBATSTDB01/oracle?

John
groenveld@acm.org
0
groenvel
9/3/2009 2:58:21 PM
Reply:

Similar Artilces:

US-TX-Houston: Unix/Oracle System Admin, Oracle DBA, Sun Solaris platforms; (45356832400)
US-TX-Houston: Unix/Oracle System Admin, Oracle DBA, Sun Solaris platforms; (45356832400) ========================================================================================= Position: Unix/Oracle System Admin Reference: ZYD00161 Location: Houston TX Duration: Skills: 5 + years experience as a Unix Systems Administrator including support of Oracle and Oracle data bases. Oracle DBA experience. Sun Solaris platforms. Please send your current resume in confidence to JGoolsby@Eurosoft-Inc.com ..45356...

US-TX-Houston: Unix/Oracle System Admin, Oracle DBA, Sun Solaris platforms; (45357114977)
US-TX-Houston: Unix/Oracle System Admin, Oracle DBA, Sun Solaris platforms; (45357114977) ========================================================================================= Position: Unix/Oracle System Admin Reference: ZYD00161 Location: Houston TX Duration: Skills: 5 + years experience as a Unix Systems Administrator including support of Oracle and Oracle data bases. Oracle DBA experience. Sun Solaris platforms. Please send your current resume in confidence to JGoolsby@Eurosoft-Inc.com ..45357...

US-TX-Houston: Unix/Oracle System Admin, Oracle DBA, Sun Solaris platforms; (45358314411)
US-TX-Houston: Unix/Oracle System Admin, Oracle DBA, Sun Solaris platforms; (45358314411) ========================================================================================= Position: Unix/Oracle System Admin Reference: ZYD00161 Location: Houston TX Duration: Skills: 5 + years experience as a Unix Systems Administrator including support of Oracle and Oracle data bases. Oracle DBA experience. Sun Solaris platforms. Please send your current resume in confidence to JGoolsby@Eurosoft-Inc.com ..45358...

US-TX-Houston: Unix/Oracle System Admin, Oracle DBA, Sun Solaris platforms; (45357757604)
US-TX-Houston: Unix/Oracle System Admin, Oracle DBA, Sun Solaris platforms; (45357757604) ========================================================================================= Position: Unix/Oracle System Admin Reference: ZYD00161 Location: Houston TX Duration: Skills: 5 + years experience as a Unix Systems Administrator including support of Oracle and Oracle data bases. Oracle DBA experience. Sun Solaris platforms. Please send your current resume in confidence to JGoolsby@Eurosoft-Inc.com ..45357757604. ...

US-TX-Houston: Unix/Oracle System Admin, Oracle DBA, Sun Solaris platforms; (45356532408)
US-TX-Houston: Unix/Oracle System Admin, Oracle DBA, Sun Solaris platforms; (45356532408) ========================================================================================= Position: Unix/Oracle System Admin Reference: ZYD00161 Location: Houston TX Duration: Skills: 5 + years experience as a Unix Systems Administrator including support of Oracle and Oracle data bases. Oracle DBA experience. Sun Solaris platforms. Please send your current resume in confidence to JGoolsby@Eurosoft-Inc.com ..45356...

US-TX-Houston: Unix/Oracle System Admin, Oracle DBA, Sun Solaris platforms; (45356232409)
US-TX-Houston: Unix/Oracle System Admin, Oracle DBA, Sun Solaris platforms; (45356232409) ========================================================================================= Position: Unix/Oracle System Admin Reference: ZYD00161 Location: Houston TX Duration: Skills: 5 + years experience as a Unix Systems Administrator including support of Oracle and Oracle data bases. Oracle DBA experience. Sun Solaris platforms. Please send your current resume in confidence to JGoolsby@Eurosoft-Inc.com ..45356...

US-TX-Houston: Unix/Oracle System Admin, Oracle DBA, Sun Solaris platforms; (45357414407)
US-TX-Houston: Unix/Oracle System Admin, Oracle DBA, Sun Solaris platforms; (45357414407) ========================================================================================= Position: Unix/Oracle System Admin Reference: ZYD00161 Location: Houston TX Duration: Skills: 5 + years experience as a Unix Systems Administrator including support of Oracle and Oracle data bases. Oracle DBA experience. Sun Solaris platforms. Please send your current resume in confidence to JGoolsby@Eurosoft-Inc.com ..45357...

US-TX-Houston: Unix/Oracle System Admin, Oracle DBA, Sun Solaris platforms; (45357732407)
US-TX-Houston: Unix/Oracle System Admin, Oracle DBA, Sun Solaris platforms; (45357732407) ========================================================================================= Position: Unix/Oracle System Admin Reference: ZYD00161 Location: Houston TX Duration: Skills: 5 + years experience as a Unix Systems Administrator including support of Oracle and Oracle data bases. Oracle DBA experience. Sun Solaris platforms. Please send your current resume in confidence to JGoolsby@Eurosoft-Inc.com ..45357...

US-TX-Houston: Unix/Oracle System Admin, Oracle DBA, Sun Solaris platforms; (45358314411)
US-TX-Houston: Unix/Oracle System Admin, Oracle DBA, Sun Solaris platforms; (45358314411) ========================================================================================= Position: Unix/Oracle System Admin Reference: ZYD00161 Location: Houston TX Duration: Skills: 5 + years experience as a Unix Systems Administrator including support of Oracle and Oracle data bases. Oracle DBA experience. Sun Solaris platforms. Please send your current resume in confidence to JGoolsby@Eurosoft-Inc.com ..45358...

US-TX-Houston: Unix/Oracle System Admin, Oracle DBA, Sun Solaris platforms; (45357157652)
US-TX-Houston: Unix/Oracle System Admin, Oracle DBA, Sun Solaris platforms; (45357157652) ========================================================================================= Position: Unix/Oracle System Admin Reference: ZYD00161 Location: Houston TX Duration: Skills: 5 + years experience as a Unix Systems Administrator including support of Oracle and Oracle data bases. Oracle DBA experience. Sun Solaris platforms. Please send your current resume in confidence to JGoolsby@Eurosoft-Inc.com ..45357157652. ...

US-TX-Houston: Unix/Oracle System Admin, Oracle DBA, Sun Solaris platforms; (45355957608)
US-TX-Houston: Unix/Oracle System Admin, Oracle DBA, Sun Solaris platforms; (45355957608) ========================================================================================= Position: Unix/Oracle System Admin Reference: ZYD00161 Location: Houston TX Duration: Skills: 5 + years experience as a Unix Systems Administrator including support of Oracle and Oracle data bases. Oracle DBA experience. Sun Solaris platforms. Please send your current resume in confidence to JGoolsby@Eurosoft-Inc.com ..45355...

US-TX-Houston: Unix/Oracle System Admin, Oracle DBA, Sun Solaris platforms; (45358914403)
US-TX-Houston: Unix/Oracle System Admin, Oracle DBA, Sun Solaris platforms; (45358914403) ========================================================================================= Position: Unix/Oracle System Admin Reference: ZYD00161 Location: Houston TX Duration: Skills: 5 + years experience as a Unix Systems Administrator including support of Oracle and Oracle data bases. Oracle DBA experience. Sun Solaris platforms. Please send your current resume in confidence to JGoolsby@Eurosoft-Inc.com ..45358...

US-TX-Houston: Unix/Oracle System Admin, Oracle DBA, Sun Solaris platforms; (45356814410)
US-TX-Houston: Unix/Oracle System Admin, Oracle DBA, Sun Solaris platforms; (45356814410) ========================================================================================= Position: Unix/Oracle System Admin Reference: ZYD00161 Location: Houston TX Duration: Skills: 5 + years experience as a Unix Systems Administrator including support of Oracle and Oracle data bases. Oracle DBA experience. Sun Solaris platforms. Please send your current resume in confidence to JGoolsby@Eurosoft-Inc.com ..45356...

US-TX-Houston: Unix/Oracle System Admin, Oracle DBA, Sun Solaris platforms; (45358014410)
US-TX-Houston: Unix/Oracle System Admin, Oracle DBA, Sun Solaris platforms; (45358014410) ========================================================================================= Position: Unix/Oracle System Admin Reference: ZYD00161 Location: Houston TX Duration: Skills: 5 + years experience as a Unix Systems Administrator including support of Oracle and Oracle data bases. Oracle DBA experience. Sun Solaris platforms. Please send your current resume in confidence to JGoolsby@Eurosoft-Inc.com ..45358...

US-TX-Houston: Unix/Oracle System Admin, Oracle DBA, Sun Solaris platforms; (45358332404)
US-TX-Houston: Unix/Oracle System Admin, Oracle DBA, Sun Solaris platforms; (45358332404) ========================================================================================= Position: Unix/Oracle System Admin Reference: ZYD00161 Location: Houston TX Duration: Skills: 5 + years experience as a Unix Systems Administrator including support of Oracle and Oracle data bases. Oracle DBA experience. Sun Solaris platforms. Please send your current resume in confidence to JGoolsby@Eurosoft-Inc.com ..45358332404. ...

US-TX-Houston: Unix/Oracle System Admin, Oracle DBA, Sun Solaris platforms; (45357757604)
US-TX-Houston: Unix/Oracle System Admin, Oracle DBA, Sun Solaris platforms; (45357757604) ========================================================================================= Position: Unix/Oracle System Admin Reference: ZYD00161 Location: Houston TX Duration: Skills: 5 + years experience as a Unix Systems Administrator including support of Oracle and Oracle data bases. Oracle DBA experience. Sun Solaris platforms. Please send your current resume in confidence to JGoolsby@Eurosoft-Inc.com ..45357...

US-TX-Houston: Unix/Oracle System Admin, Oracle DBA, Sun Solaris platforms; (45357157652)
US-TX-Houston: Unix/Oracle System Admin, Oracle DBA, Sun Solaris platforms; (45357157652) ========================================================================================= Position: Unix/Oracle System Admin Reference: ZYD00161 Location: Houston TX Duration: Skills: 5 + years experience as a Unix Systems Administrator including support of Oracle and Oracle data bases. Oracle DBA experience. Sun Solaris platforms. Please send your current resume in confidence to JGoolsby@Eurosoft-Inc.com ..45357...

US-TX-Houston: Unix/Oracle System Admin, Oracle DBA, Sun Solaris platforms; (45357432402)
US-TX-Houston: Unix/Oracle System Admin, Oracle DBA, Sun Solaris platforms; (45357432402) ========================================================================================= Position: Unix/Oracle System Admin Reference: ZYD00161 Location: Houston TX Duration: Skills: 5 + years experience as a Unix Systems Administrator including support of Oracle and Oracle data bases. Oracle DBA experience. Sun Solaris platforms. Please send your current resume in confidence to JGoolsby@Eurosoft-Inc.com ..45357...

US-TX-Houston: Unix/Oracle System Admin, Oracle DBA, Sun Solaris platforms; (45356532408)
US-TX-Houston: Unix/Oracle System Admin, Oracle DBA, Sun Solaris platforms; (45356532408) ========================================================================================= Position: Unix/Oracle System Admin Reference: ZYD00161 Location: Houston TX Duration: Skills: 5 + years experience as a Unix Systems Administrator including support of Oracle and Oracle data bases. Oracle DBA experience. Sun Solaris platforms. Please send your current resume in confidence to JGoolsby@Eurosoft-Inc.com ..45356...

US-TX-Houston: Unix/Oracle System Admin, Oracle DBA, Sun Solaris platforms; (45358332404)
US-TX-Houston: Unix/Oracle System Admin, Oracle DBA, Sun Solaris platforms; (45358332404) ========================================================================================= Position: Unix/Oracle System Admin Reference: ZYD00161 Location: Houston TX Duration: Skills: 5 + years experience as a Unix Systems Administrator including support of Oracle and Oracle data bases. Oracle DBA experience. Sun Solaris platforms. Please send your current resume in confidence to JGoolsby@Eurosoft-Inc.com ..45358...

US-TX-Houston: Unix/Oracle System Admin, Oracle DBA, Sun Solaris platforms; (45358957609)
US-TX-Houston: Unix/Oracle System Admin, Oracle DBA, Sun Solaris platforms; (45358957609) ========================================================================================= Position: Unix/Oracle System Admin Reference: ZYD00161 Location: Houston TX Duration: Skills: 5 + years experience as a Unix Systems Administrator including support of Oracle and Oracle data bases. Oracle DBA experience. Sun Solaris platforms. Please send your current resume in confidence to JGoolsby@Eurosoft-Inc.com ..45358...

US-TX-Houston: Unix/Oracle System Admin, Oracle DBA, Sun Solaris platforms; (45358657606)
US-TX-Houston: Unix/Oracle System Admin, Oracle DBA, Sun Solaris platforms; (45358657606) ========================================================================================= Position: Unix/Oracle System Admin Reference: ZYD00161 Location: Houston TX Duration: Skills: 5 + years experience as a Unix Systems Administrator including support of Oracle and Oracle data bases. Oracle DBA experience. Sun Solaris platforms. Please send your current resume in confidence to JGoolsby@Eurosoft-Inc.com ..45358...

US-TX-Houston: Unix/Oracle System Admin, Oracle DBA, Sun Solaris platforms; (45356514670)
US-TX-Houston: Unix/Oracle System Admin, Oracle DBA, Sun Solaris platforms; (45356514670) ========================================================================================= Position: Unix/Oracle System Admin Reference: ZYD00161 Location: Houston TX Duration: Skills: 5 + years experience as a Unix Systems Administrator including support of Oracle and Oracle data bases. Oracle DBA experience. Sun Solaris platforms. Please send your current resume in confidence to JGoolsby@Eurosoft-Inc.com ..45356...

US-TX-Houston: Unix/Oracle System Admin, Oracle DBA, Sun Solaris platforms; (45357114977)
US-TX-Houston: Unix/Oracle System Admin, Oracle DBA, Sun Solaris platforms; (45357114977) ========================================================================================= Position: Unix/Oracle System Admin Reference: ZYD00161 Location: Houston TX Duration: Skills: 5 + years experience as a Unix Systems Administrator including support of Oracle and Oracle data bases. Oracle DBA experience. Sun Solaris platforms. Please send your current resume in confidence to JGoolsby@Eurosoft-Inc.com ..45357...

Web resources about - Sun server with Oracle Database crashed - comp.unix.solaris

Database - Wikipedia, the free encyclopedia
A database is an organized collection of data . The data are typically organized to model aspects of reality in a way that supports processes ...

Database - Wikipedia, the free encyclopedia
... requiring information. For example, modelling the availability of rooms in hotels in a way that supports finding a hotel with vacancies. Database ...

Open source database improves protection and performance
Most enterprises rely on databases in some form or another, but they can be vulnerable to attack from people looking to steal information. They ...

Seattle’s Tableau Software snaps up database-computing startup in Germany
Seattle’s Tableau Software has acquired HyPer, a database-computing startup that spun out of research at a university in Munich, Germany. As ...

NTTC's Liquid Products Database making steady progress
NTTC's Liquid Products Database making steady progress Modern Bulk Transporter NTTC is asking carriers to suggest “proprietary blends” for ...

TransGrid Switches Oracle Database Support to Rimini Street
TransGrid Switches Oracle Database Support to Rimini Street

Herbalife sinks on database error report
Herbalife said it had overstated growth in the number of "active new members" in some instances in the past three quarters due to database errors. ...

Taiwan launches database on areas vulnerable to quake damage
BEIJING (AP) — Earthquake-prone Taiwan is launching a database to inform residents which areas might be susceptible to creating potentially catastrophic ...

Microsoft's SQL database software now runs on Linux
Remember when Steve Ballmer likened Linux to cancer, and the notion of Microsoft courting the open source crowd was virtually unimaginable? The ...

Microsoft's SQL Server Database Is Heading to Linux
Next year, Microsoft plans to release a version of its hybrid-cloud-friendly database software for the open-source operating system.

Resources last updated: 3/15/2016 3:38:45 PM