Re: Unable to do a normal shutdown or Export

Hi there. I run a dos session CMD

then i run the exp executable associated with the Oracle 816 instance by going directly to the bin directory.

The parfile is use is

FULL=Y
FILE=sa_exp.dat
GRANTS=Y
INDEXES=Y
COMPRESS=y
ROWS=Y
LOG=exp.log

So I am basically running exp from a dos session and it connects ok and runs for ages eventually falling over at the same place every time.

"Telemachus" <telemachus_at_ulysseswillreturn.net> wrote in message news:zH7Z9.5577$V6.7977_at_news.indigo.ie...
> Silly question :
>
> are you SURE that you are using the 817 client against the 817 database
and
> 816 for the 816 database ?
>
>
> and have checked TNS_ADMIN and your PATH variables to make sure ?
> "Tony Rees" <tony_rees_at_stratexnet.com> wrote in message
> news:b12udq$g28$1$830fa7a5_at_news.demon.co.uk...
> > I wander if any one can help with this one. I have two Oracle instances
on
> a
> > Win2k server 816 (Report) and 817(DEV).
> >
> > Since I installed the second instance I am unable to do a full export
from
> > the 816 instance and also am unable to do a normal shutdown as it
results
> in
> > the following error.
> >
> > For the export the following error
> >
> > . . exporting table TOAD_PLAN_TABLE 4179 rows exported
> > . . exporting table TOAD_SECURITY 3 rows exported
> > . exporting referential integrity constraints
> > . exporting synonyms
> > EXP-00008: ORACLE error 4031 encountered
> > ORA-04031: unable to allocate 4032 bytes of shared memory ("shared
> > pool","oracle/jdbc/driver/OracleLogSYS","joxlod: in
> ehe","ioc_allocate_pal")
> > EXP-00000: Export terminated unsuccessfully
> >
> > In the Alert file I see the following
> >
> > Errors in file f:\oracle816\admin\REPORT\udump\ORA01208.TRC:
> > ORA-00604: error occurred at recursive SQL level 1
> > ORA-04031: unable to allocate 4032 bytes of shared memory ("shared
> > pool","unknown object","joxlod: in ehe","ioc_allocate_pal")
> > ORA-06512: at "SYS.DBMS_JAVA", line 0
> > ORA-06512: at line 2
> >
> > The init.ora file for both is very similar
> >
> > Errors in file f:\oracle816\admin\REPORT\udump\ORA01208.TRC:
> > ORA-00604: error occurred at recursive SQL level 1
> > ORA-04031: unable to allocate 4032 bytes of shared memory ("shared
> > pool","unknown object","joxlod: in ehe","ioc_allocate_pal")
> > ORA-06512: at "SYS.DBMS_JAVA", line 0
> > ORA-06512: at line 2
> >
> >
> >
> >
> >
>
>
Received on Mon Jan 27 2003 - 04:32:12 CST