OraFAQ Forum: Backup & Recovery » Server crash when exporting database

Home » RDBMS Server » Backup & Recovery » Server crash when exporting database

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

Server crash when exporting database [message #192655]

Wed, 13 September 2006 03:00

aline
Messages: 92
Registered: February 2002

Member

Hi,

My configuration:
2 server (production and standby) with 8GB of RAM
linux rh4
oracle9.2.0.7

My problem
all night, I run an export of the production database on my standby site. Sometimes (maybe one per week) my server crash when I run the export.

The command of the export is very simple:

Code: [Select all] [Show/ hide]

$EXP user/PWD FILE=$SAVELOCALDIR/${USER}1.$BACKUPFILENAME,$SAVELOCALDIR/${USER}2.$BACKUPFILENAME,$SAVELOCALDIR/${USER}3.$BACKUPFILENAME,$SAVELOCALDIR/${USER}4.$BACKUPFILENAME,$SAVELOCALDIR/${USER}5.$BACKUPFILENAME,$SAVELOCALDIR/${USER}6.$BACKUPFILENAME,$SAVELOCALDIR/${USER}7.$BACKUPFILENAME,$SAVELOCALDIR/${USER}8.$BACKUPFILENAME,$SAVELOCALDIR/${USER}9.$BACKUPFILENAME,$SAVELOCALDIR/${USER}10.$BACKUPFILENAME,$SAVELOCALDIR/${USER}11.$BACKUPFILENAME,$SAVELOCALDIR/${USER}12.$BACKUPFILENAME,$SAVELOCALDIR/${USER}13.$BACKUPFILENAME ,$SAVELOCALDIR/${USER}14.$BACKUPFILENAME,$SAVELOCALDIR/${USER}15.$BACKUPFILENAME,$SAVELOCALDIR/${USER}16.$BACKUPFILENAME,$SAVELOCALDIR/${USER}17.$BACKUPFILENAME,$SAVELOCALDIR/${USER}18.$BACKUPFILENAME  LOG=$DIRSAVELOG/$USER.$BACKUPNAMELOG FILESIZE=1900MB owner=$USER consistent=Y direct=Y statistics = none

The server crashed with this message:
kernel panic: out of memory and no killable processes.

The size of the sga on the standby site is about 4Gb

Code: [Select all] [Show/ hide]

SQL> show sga

Total System Global Area 4816866536 bytes
Fixed Size                   748776 bytes
Variable Size             301989888 bytes
Database Buffers         4513071104 bytes
Redo Buffers                1056768 bytes

and of course, on this server, their is nothing else than those processes.

I asked metalink with this problem but they have no idea about. So you are my last chance!

Report message to a moderator

Re: Server crash when exporting database [message #192666 is a reply to message #192655]

Wed, 13 September 2006 03:48

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

Senior Member
Account Moderator

please post your semaphore settings.

Report message to a moderator

Re: Server crash when exporting database [message #192679 is a reply to message #192655]

Wed, 13 September 2006 04:25

aline
Messages: 92
Registered: February 2002

Member

hi,

Thk for your answer

Code: [Select all] [Show/ hide]

ipcs -ls

------ Semaphore Limits --------
max number of arrays = 128
max semaphores per array = 250
max semaphores system wide = 32000
max ops per semop call = 32
semaphore max value = 32767


cat /proc/sys/kernel/sem
250     32000   32      128

Report message to a moderator

Re: Server crash when exporting database [message #192683 is a reply to message #192679]

Wed, 13 September 2006 04:41

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

Senior Member
Account Moderator

You may need to change a few.
Please look here.
http://download-east.oracle.com/docs/html/A96167_01/pre.htm#CHDHDABJ

Do the recomended settings and reboot. Talk to your unixadmin Before doing these.

Report message to a moderator

Re: Server crash when exporting database [message #192737 is a reply to message #192655]

Wed, 13 September 2006 07:22

aline
Messages: 92
Registered: February 2002

Member

thk,

I applied new parameters for semaphores
I hope it will be good.
here my new parameters:

Code: [Select all] [Show/ hide]

ipcs -l

------ Shared Memory Limits --------
max number of segments = 4096
max seg size (kbytes) = 6710886
max total shared memory (kbytes) = 8388608
min seg size (bytes) = 1

------ Semaphore Limits --------
max number of arrays = 128
max semaphores per array = 460
max semaphores system wide = 58880
max ops per semop call = 460
semaphore max value = 32767

------ Messages: Limits --------
max queues system wide = 16
max size of message (bytes) = 8192
default max size of queue (bytes) = 16384

Report message to a moderator

Re: Server crash when exporting database [message #192778 is a reply to message #192737]

Wed, 13 September 2006 09:20

aline
Messages: 92
Registered: February 2002

Member

bad news!

I followed the instructions of Werner pushitz to change my semaphores parameters (i.e. 60 58880 460 128).
I test an new export and my server crashed!
The last messages I saw was onto /var/log/messages

Code: [Select all] [Show/ hide]

Sep 13 15:34:12 oracle-reco kernel: warning: many lost ticks.
Sep 13 15:34:12 oracle-reco kernel: Your time source seems to be instable or some driver is hogging interupts
Sep 13 15:34:12 oracle-reco kernel: rip __do_softirq+0x4d/0xd0
Sep 13 15:42:08 oracle-reco kernel: oom-killer: gfp_mask=0x1d2
Sep 13 15:42:08 oracle-reco kernel: Mem-info:
Sep 13 15:42:08 oracle-reco kernel: Node 1 DMA per-cpu: empty
Sep 13 15:42:08 oracle-reco kernel: Node 1 Normal per-cpu:
Sep 13 15:42:08 oracle-reco kernel: cpu 0 hot: low 32, high 96, batch 16
Sep 13 15:42:08 oracle-reco kernel: cpu 0 cold: low 0, high 32, batch 16
Sep 13 15:42:08 oracle-reco kernel: cpu 1 hot: low 32, high 96, batch 16
Sep 13 15:42:08 oracle-reco kernel: cpu 1 cold: low 0, high 32, batch 16
Sep 13 15:42:08 oracle-reco kernel: cpu 2 hot: low 32, high 96, batch 16

Maybe I set wrong semaphores parameters, or something else is wrong, I don't know...

any other idea?

Report message to a moderator

Re: Server crash when exporting database [message #192780 is a reply to message #192778]

Wed, 13 September 2006 09:28

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

Senior Member
Account Moderator

>>Your time source seems to be instable or some driver is hogging interup
this is to do with your OS.
Talk to your Unix folks.

Report message to a moderator

Previous Topic:	is it possible to restore expired backup sets
Next Topic:	SYSTEM GETS HANGED WHEN RUNNING EXP

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 02 15:51:02 CDT 2025