Cannot perform full database in Oracle9i under Linux

[lamshing]

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@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

[Yuri Zelenski]

Can you show an explain plan.


"lamshing" <lamshingNOSPAM@yahoo.com> wrote in message
news:aspstr$f22$1@hfc.pacific.net.hk... 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@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