Re: Database snapshot cloning and lockfiles

From: Mladen Gogala <mgogala_at_yahoo.com>
Date: Tue, 07 Apr 2015 16:14:24 -0400
Message-ID: <55243AA0.5080602_at_yahoo.com>

On 04/07/2015 02:14 PM, Seth Miller wrote:

> I think it uses the SID for the lock file but since you are using a 
> different SID and db_name, my guess is that you are seeing a 
> symptomatic error message being caused by something else.

It uses the SID, you are correct:

[oracle_at_oradb ~]$ ls -l $ORACLE_HOME/dbs total 10248
-rw-rw---- 1 oracle oinstall 1544 Apr 7 16:11 hc_orcl.dat
-rw-rw---- 1 oracle oinstall 1544 Nov 13 2013 hc_rac11.dat
-rw-rw---- 1 oracle oinstall 1544 Dec 20 2013 hc_rst.dat
-rw-r--r-- 1 oracle oinstall 2851 May 15 2009 init.ora
-rw-r----- 1 oracle oinstall 1044 Oct 20 2013 initorcl.ora
-rw-r----- 1 oracle oinstall 954 Nov 12 2013 initrac11.ora
-rw-r--r-- 1 oracle oinstall 1733 Oct 20 2013 initrst.ora
-rw-r----- 1 oracle oinstall 24 Oct 20 2013 lkORCL

---

-rw-r----- 1 oracle oinstall 24 Nov 13 2013 lkRAC11
-rw-r----- 1 oracle oinstall 24 Oct 27 2013 lkRST
-rw-r----- 1 oracle oinstall 1536 Jun 13 2014 orapworcl
-rw-r----- 1 oracle oinstall 1536 Nov 12 2013 orapwrac11
-rw-r----- 1 oracle oinstall 10436608 Apr 6 19:28 snapcf_orcl.f
-rw-r----- 1 oracle oinstall 4608 Apr 7 16:11 spfileorcl.ora

Lock files are usually of the form $ORACLE_HOME/dbs/lk$ORACLE_SID

--

Mladen Gogala
Oracle DBA
http://mgogala.freehostia.com

--

http://www.freelists.org/webpage/oracle-l Received on Tue Apr 07 2015 - 22:14:24 CEST