Re: HELP: imp error
From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Thu, 20 May 2004 13:37:51 +0200
Message-ID: <c8i535$tv8$1_at_news3.tilbu1.nb.home.nl>
>
>
> -- 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
Date: Thu, 20 May 2004 13:37:51 +0200
Message-ID: <c8i535$tv8$1_at_news3.tilbu1.nb.home.nl>
tracy wrote:
> Frank van Bortel <fvanbortel_at_netscape.net> wrote in message news:<c8ge3p$a88$1@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 BortelReceived on Thu May 20 2004 - 13:37:51 CEST