By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,197 Members | 977 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,197 IT Pros & Developers. It's quick & easy.

HELP: imp error

P: n/a
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@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
Jul 19 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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@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

Jul 19 '05 #2

P: n/a
Frank van Bortel <fv********@netscape.net> wrote in message news:<c8**********@news1.tilbu1.nb.home.nl>...
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?


-- wat i try to do is bring import the dmp file to the db. Here is my alert.log:
Tue May 18 14:22:01 2004
ALTER DATABASE MOUNT
Tue May 18 14:22:01 2004
scumnt: failed to lock /ora92/oradata/OraHome//dbs/lkabc exclusive
Tue May 18 14:22:01 2004
ORA-09968: scumnt: unable to lock file
Linux-ia64 Error: 11: Resource temporarily unavailable
Additional information: 9296
Tue May 18 14:22:01 2004
ORA-1102 signalled during: ALTER DATABASE MOUNT...
Tue May 18 14:22:49 2004
Restarting dead background process QMN0
QMN0 started with pid=9
Jul 19 '05 #3

P: n/a
tracy wrote:
Frank van Bortel <fv********@netscape.net> wrote in message news:<c8**********@news1.tilbu1.nb.home.nl>...
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?

-- wat i try to do is bring import the dmp file to the db. Here is my alert.log:
Tue May 18 14:22:01 2004
ALTER DATABASE MOUNT
Tue May 18 14:22:01 2004
scumnt: failed to lock /ora92/oradata/OraHome//dbs/lkabc exclusive
Tue May 18 14:22:01 2004
ORA-09968: scumnt: unable to lock file
Linux-ia64 Error: 11: Resource temporarily unavailable
Additional information: 9296
Tue May 18 14:22:01 2004
ORA-1102 signalled during: ALTER DATABASE MOUNT...
Tue May 18 14:22:49 2004
Restarting dead background process QMN0
QMN0 started with pid=9


Who owns /ora92/oradata/OraHome//dbs/lkabc?
Assuming your instance is called abc, your environment
should contain:
ORACLE_SID=abc
ORACLE_BASE=/ora92/???
PATH=/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:.:/ora92/????/bin
PWD=/opt/oracle/920/dbs
LANG=en_US.UTF-8
ORACLE_TERM=xterm
LD_ASSUME_KERNEL=2.4.1
ORA_NLS33=/ora92/????/ocommon/nls/admin/data
ORACLE_HOME=/ora92/??????

My lk file is owned by the owner of the oracle process, oinstall.
You could try a shutdown, and startup again, or shutdown, delete
the abclk file, and startup.
What I find strange is the double // - doubt if it harms, though
--

Regards,
Frank van Bortel

Jul 19 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.