Home » RDBMS Server » Server Administration » Oracle Express Server 6.3.0 hang
Oracle Express Server 6.3.0 hang [message #214356] Tue, 16 January 2007 00:32 Go to next message
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
Re: Oracle Express Server 6.3.0 hang [message #214359 is a reply to message #214356] Tue, 16 January 2007 00:39 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
self explanative.
>>WARNING: /tmp: File system full,
Re: Oracle Express Server 6.3.0 hang [message #214373 is a reply to message #214356] Tue, 16 January 2007 02:15 Go to previous messageGo to next message
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
Re: Oracle Express Server 6.3.0 hang [message #214374 is a reply to message #214373] Tue, 16 January 2007 02:19 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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 
Re: Oracle Express Server 6.3.0 hang [message #214375 is a reply to message #214356] Tue, 16 January 2007 02:26 Go to previous message
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
Previous Topic: ora-01681
Next Topic: DBSHUT and shutdown immediate
Goto Forum:
  


Current Time: Thu Dec 08 10:41:29 CST 2016

Total time taken to generate the page: 0.06657 seconds