Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Cannot perform full database in Oracle9i under Linux

Re: Cannot perform full database in Oracle9i under Linux

From: Yuri Zelenski <aser_at_pbcards.dp.ua>
Date: Fri, 6 Dec 2002 16:05:14 +0200
Message-ID: <asqamd$cqi$1@pandora.alkar.net>


Can you show an explain plan.

"lamshing" <lamshingNOSPAM_at_yahoo.com> wrote in message news:aspstr$f22$1_at_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_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 - 08:05:14 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US