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@news3.tilbu1.nb.home.nl>

tracy wrote:
> Frank van Bortel <fvanbortel_at_netscape.net> wrote in message news:<c8ge3p$a88$1_at_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

Received on Thu May 20 2004 - 06:37:51 CDT