Re: HELP:IMP-00058 & ORA-01033

From: ANA C. Dent <anacedent_at_hotmail.com>
Date: Tue, 18 May 2004 18:13:45 -0700
Message-ID: <dxyqc.54023$Z%5.12955@okepread01>

LC 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,
>
> LC

Prior to starting the "imp" the database must be up and available. sqlplus
/ as sysdba
startup
exit Received on Tue May 18 2004 - 20:13:45 CDT