ORA-09782 & ORA-09783

From: Catherine LeBlanc <cleblan2_at_abacus.bates.edu>
Date: Sun, 17 Jun 2001 18:18:38 -0700
Message-ID: <F001.0032CBF1.20010617181526@fatcity.com>

I am attempting to recreate a clone
of our production database on our test machine and I get the following errors when I try to start it up:

---

SVRMGR> startup mount
ORACLE instance started.
Total System Global Area     169900992 bytes Fixed

Size                      

50832 bytes
Variable

Size                

80024880 bytes
Database
Buffers             
89620480 bytes
Redo

Buffers                   

204800 bytes
ORA-00205: error in identifying control
file '/usr/u17/oradata/dbs/ctrl1PROD.ctl' ORA-09782: sfifi: another instance has the same database mounted. SVRMGR> shutdown
ORA-01507: database not mounted
ORACLE instance shut down.

---

I dropped that control file and got the same error, and when I try creating new control files I get:

---

ORACLE instance started.
Total System Global Area     169900992 bytes Fixed

Size                      

50832 bytes
Variable

Size                

80024880 bytes
Database
Buffers             
89620480 bytes
Redo

Buffers                   

204800 bytes
CREATE CONTROLFILE REUSE DATABASE "PROD" RESETLOGS ARCHIVELOG
*

ORA-01503: CREATE CONTROLFILE failed
ORA-01565: error in identifying file
'/usr/u17/oradata/prod/syst_PROD.dbf'
ORA-09783: sfifi: Cannot determine if another instance has mounted the same database.
Digital Unix Error: 20: Not a directory
ALTER DATABASE OPEN RESETLOGS
*

ORA-01507: database not mounted
ORA-01507: database not mounted
ORACLE instance shut down.

---

I tried SET and NORESTLOGS, and rearranging the datafiles in the script,
all with no difference. The files definitely exist, and the source database
was shutdown during the copy.
This happened before when I tried to change the instance name, but I am not
doing that now. I know that this error occurs when cloning on the same machine
with the source database running, but I am on a totally different machine.
Does anyone know what Oracle checks internally that makes it think the

instance is mounted when it is not?

--
Catherine A. LeBlanc, Database Analyst
Bates College, Administrative Computing
cleblan2_at_bates.edu        
(207)786-6431
Oracle7 Server Release 7.3.4.3
Digital UNIX V4.0G (Rev. 1530)

Received on Sun Jun 17 2001 - 20:18:38 CDT