Re: HELP: imp error
Date: Wed, 19 May 2004 21:59:30 +0200
Message-ID: <c8ge3p$a88$1_at_news1.tilbu1.nb.home.nl>
tracy wrote:
> hi, guys,
> I really need ur guidance.I just installed oracle db in my backup
> server(os is linux) and intent to import an .dmp file to it. I had
> created tablespace, datafiles, users( inclide abc).
>
> Then, i wanna to export an dmp file named test.dmp.so, here is my
> command:
> [root_at_icemsdb root]# su - oracle
> bash-2.05$
> bash-2.05$ imp fromuser=abc touser=abc file=test.dmp
>
> Import: Release 9.2.0.2.0 - Production on Tue May 18 15:10:08 2004
>
> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
>
> Username: system
> Password:
>
> IMP-00058: ORACLE error 1033 encountered
> ORA-01033: ORACLE initialization or shutdown in progressUsername:
>
> what's wrong? Pls help me .
>
> TQ!
>
> regards,
> tracy
Nothing, oracle is shutting downm or still starting up.
Be patient, or -if it takes longer than a couple of
minutes- look in the oracle log files (alert_{SID}.log)
what's going on.
You did *create* the database, did you?
-- Regards, Frank van BortelReceived on Wed May 19 2004 - 21:59:30 CEST