Cannot perform full database in Oracle9i under Linux

Hi,

I have problem performing full backup of Oracle9i 9.2.0.1.0 under redhat Linux 8.0 kernel 2.4.18-14 on Pentium 4 with 1280 MB RAM.

Symptom:
1. I can do individual backup for each individual user/schema. 2. I can do full backup as "system" user on the server without using @

    i.e.

        exp system/password

3. I cannot do full backup as "system" user on the server with @

    i.e.

        exp system/password_at_tnsname

4. on any other machine, I cannot do backup of the database.

on the alert-xxx.log,

Errors in file /home/oracle/OraHome/admin/devdb1/bdump/devdb1_s001_10212.trc: ORA-07445: exception encountered: core dump [xsiofmgrMTSOpen()+35] [SIGSEGV]   [Address not mapped to object] [0x18] [] [] ORA-04031: unable to allocate 16364 bytes of shared memory
("large pool","unknown object","OLAP Alloc hea","xspgmgr const: OLAP PAGE POOL")

I have increased the /proc/sys/kernel/shmmax to 671088640
(640MB, half of physical memory) and the /proc/sys/kernel/sem values to

        250 32000 100 256

I have a another Oracle9i server 9.0.1.0.0 on redhat linux 7.2 kernel 2.4.7-10 where we have no such problem.

Can anyone offer some help?

Thanks in advance

Shing Received on Fri Dec 06 2002 - 04:07:35 CST