Re: HELP: imp error

From: Frank van Bortel <fvanbortel_at_netscape.net>
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 Bortel
Received on Wed May 19 2004 - 21:59:30 CEST

Original text of this message