topic Failure to Export Database in Operating System - HP-UX

Failure to Export Database

Charles Walton_1 — Tue, 11 Jun 2002 17:46:35 GMT

Our DBA reported a problem when he tries to export the databases.

/usr/lib/dld.sl: Call to mmap() failed - TEXT /Oracle/software/8.1.6/lib//libclntsh.sl.8.0
/usr/lib/dld.sl: Not enough space

# swapinfo -ta
Kb Kb Kb PCT START/ Kb
TYPE AVAIL USED FREE USED LIMIT RESERVE PRI NAME
dev 4194304 0 4194304 0% 0 - 1 /dev/vg00/lvol2
reserve - 2547616 -2547616
memory 6500884 3339280 3161604 51%
total 10695188 5886896 4808292 55% - 0 -

Re: Failure to Export Database

Helen French — Tue, 11 Jun 2002 17:50:31 GMT

This thread may help you:

http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0xae318f960573d611abdb0090277a778c,00.html

Also do a "search" on the old threads, you will find out a solution !

Re: Failure to Export Database

A. Clay Stephenson — Tue, 11 Jun 2002 17:57:21 GMT

This is caused by two things: 1) out of swapspace (not in this case) 2) maxdsiz (or maxdsiz_64bit) limit reached - increase and gen a new kernel.

Re: Failure to Export Database

PIYUSH D. PATEL — Tue, 11 Jun 2002 18:00:17 GMT

Hi,

The space this error message is referring to is memory. There is no memory available on the system to export the database.

You may have to increase the size of maxdsiz kernel parameter.

Piyush

Re: Failure to Export Database

Charles Walton_1 — Tue, 11 Jun 2002 18:04:07 GMT

Thanks for the fast replies, Currently Oracle is running 32bit & the maxdsiz value = 16384 w/ a min-max of 0-655360. Any recommendations on what we should set this to?

Re: Failure to Export Database

A. Clay Stephenson — Tue, 11 Jun 2002 18:13:25 GMT

Sysdef displays in 4k pages so that you are current set to 64MB; that is generally a small value. I suggest that 512MB is generous but still leaves a decent value to keep the wild horses in the corral. I would not exceed 1GB in the 32bit world as a general rule.

This value consumes no resources but is intended to act as a safety valve to prevent a process from grabbing all the resources and bringing a box to its knees.

Re: Failure to Export Database

Kawah Cheung — Tue, 11 Jun 2002 18:22:04 GMT

Hi,
I may be putting the cat among the pigeons here, but could we be barking up the wrong tree. Picked up an oracle case with the exact problems you are getting and the oracle recommendation was to relink all the oracle binaries. Worth a try? See attached file.

Kind Regards,
Kawah

Re: Failure to Export Database

Brian Crabtree — Tue, 11 Jun 2002 23:16:40 GMT

In this case, it is the memory that is the problem. Relinking can help in some cases, but in this case, you need to have the correct sizes in the kernel. The following kernel parameters should be set (values I normally used are attached)

maxdsiz 1g = 0x40000000
maxsize 200m = 0xC000000
maxtsiz 1g = 0x40000000
shmmax 1g = 0x40000000

These set them all to 1g. Oracle 32bit can go to 4g total SGA, and 64bit can go to +1 terabyte. Overkill on these will not hurt you, however you should still monitor the application and sessions still.

Brian