OraFAQ Forum: Server Administration » Oracle Express Server 6.3.0 hang

Home » RDBMS Server » Server Administration » Oracle Express Server 6.3.0 hang

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle Express Server 6.3.0 hang [message #214356]

Tue, 16 January 2007 00:32

lovelyzie
Messages: 9
Registered: November 2006
Location: Malaysia

Junior Member

Hi,

I'm running Oracle Express Server 6.3.0 at Unix Sparc 2.6. Few days ago, the Express Server 6.3.0 has a problem to login where it hangs.

It happens after I've used remote from my PC (Windows NT 4.0) to login. Why does it occurs? How to prevent this from being happen again?

Thanks

Diagnostic 1:
#last | more
root console :0 Tue Jan 9 09:09 - 09:09 (00:00)
root console :0 Tue Jan 9 09:09 - 09:09 (00:00)
root console :0 Tue Jan 9 08:53 - 08:54 (00:01)
root pts/5 alice.olap.com Mon Jan 8 15:43 - 15:45 (00:01)
root console :0 Mon Jan 8 15:24 - 18:22 (02:57)
root pts/8 alice.olap.com Mon Jan 8 15:21 - 15:21 (00:00)

Diagnostic 2:
Jan 8 15:21:25 oracle_ofa unix: WARNING: Sorry, no swap space to grow stack for pid 7046 (dtsession)
Jan 8 15:21:25 oracle_ofa last message repeated 7 times
Jan 8 15:24:13 oracle_ofa /usr/dt/bin/ttsession[418]: child (8070) exited due to signal 1
Jan 8 17:41:00 oracle_ofa unix: WARNING: /tmp: File system full, swap space limit exceeded^M
Jan 8 17:41:00 oracle_ofa last message repeated 5 times
Jan 8 18:11:02 oracle_ofa unix: WARNING: /tmp: File system full, swap space limit exceeded^M
Jan 9 04:41:00 oracle_ofa unix: WARNING: Sorry, no swap space to grow stack for pid 26706 (cron)
Jan 9 04:41:00 oracle_ofa last message repeated 18 times
Jan 9 08:52:37 oracle_ofa unix: WARNING: Sorry, no swap space to grow stack for pid 26514 (dtlogin)
Jan 9 08:52:37 oracle_ofa last message repeated 14 times
Jan 9 08:52:38 oracle_ofa unix: WARNING: /tmp: File system full, swap space limit exceeded^M
Jan 9 08:53:46 oracle_ofa last message repeated 9 times
Jan 9 08:54:51 oracle_ofa unix: WARNING: /tmp: File system full, swap space limit exceeded^M
Jan 9 08:54:51 oracle_ofa last message repeated 2 times
Jan 9 09:09:42 oracle_ofa unix: WARNING: /tmp: File system full, swap space limit exceeded^M

Report message to a moderator

Re: Oracle Express Server 6.3.0 hang [message #214359 is a reply to message #214356]

Tue, 16 January 2007 00:39

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

self explanative.
>>WARNING: /tmp: File system full,

Report message to a moderator

Re: Oracle Express Server 6.3.0 hang [message #214373 is a reply to message #214356]

Tue, 16 January 2007 02:15

lovelyzie
Messages: 9
Registered: November 2006
Location: Malaysia

Junior Member

Hi Mahesh,

Where to see the /tmp file is full....

The files contain in the tmp directory:
total 400
-rw------- 1 root other 181824 Jan 10 16:42 dtdbcache_:0
srwxrwxrwx 1 root other 0 Jan 11 00:45 orb_1124_0
srwxrwxrwx 1 oesdba express 0 Jan 11 00:45 orb_1128_0
srwxrwxrwx 1 root other 0 Jan 11 00:46 orb_1135_0
srwxrwxrwx 1 root root 0 Jan 10 16:42 orb_314_0
srwxrwxrwx 1 oesdba express 0 Jan 10 16:42 orb_346_0
srwxrwxrwx 1 root root 0 Jan 10 16:42 orb_460_0
srwxrwxrwx 1 root other 0 Jan 15 06:00 orb_7770_0
srwxrwxrwx 1 root other 0 Jan 15 06:00 orb_7771_0
srwxrwxrwx 1 oesdba express 0 Jan 15 06:00 orb_7782_0
srwxrwxrwx 1 root other 0 Jan 15 06:00 orb_7783_0
srwxrwxrwx 1 root other 0 Jan 10 22:35 orb_897_0
srwxrwxrwx 1 oesdba express 0 Jan 10 22:36 orb_903_0
srwxrwxrwx 1 root other 0 Jan 10 22:36 orb_912_0
srwxrwxrwx 1 root other 0 Jan 10 22:54 orb_978_0
srwxrwxrwx 1 oesdba express 0 Jan 10 22:54 orb_982_0
srwxrwxrwx 1 root other 0 Jan 10 22:54 orb_983_0
-rw-rw-r-- 1 root sys 4936 Jan 10 16:41 ps_data
-rw-r--r-- 1 root other 0 Jan 10 16:42 sdtvolcheck430
-rw-r--r-- 1 root other 4 Jan 10 16:42 speckeysd.lock

Thanks

Report message to a moderator

Re: Oracle Express Server 6.3.0 hang [message #214374 is a reply to message #214373]

Tue, 16 January 2007 02:19

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

df -k should help.

oracle@mutation#df -k
Filesystem            kbytes    used   avail capacity  Mounted on
/dev/dsk/c0t0d0s0    14188906 8365051 5681966    60%    /
/proc                      0       0       0     0%    /proc
fd                         0       0       0     0%    /dev/fd
mnttab                     0       0       0     0%    /etc/mnttab
swap                  330752      24  330728     1%    /var/run
swap                  333168    2440  330728     1%    /tmp

Report message to a moderator

Re: Oracle Express Server 6.3.0 hang [message #214375 is a reply to message #214356]

Tue, 16 January 2007 02:26

lovelyzie
Messages: 9
Registered: November 2006
Location: Malaysia

Junior Member

Hi Manesh,

Currently is:
swap 2514520 200 2514320 1% /tmp

Why causes it to full? How to prevent it?

Thanks

Report message to a moderator

Previous Topic:	ora-01681
Next Topic:	DBSHUT and shutdown immediate

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 03:52:47 CDT 2024