From Brijesh.Gupta@Airliquide.com Mon, 18 Jun 2001 09:48:44 -0700
From: "Gupta, Brijesh" <Brijesh.Gupta@Airliquide.com>
Date: Mon, 18 Jun 2001 09:48:44 -0700
Subject: RE: ORA-09782 & ORA-09783
Message-ID: <F001.0032D40A.20010618090101@fatcity.com>
MIME-Version: 1.0
Content-Type: text/plain



Here 
is the problem . Use SET instead of REUSE
<SPAN 
class=780245515-18062001> 
CREATE CONTROLFILE REUSE DATABASE "PROD" RESETLOGS 
ARCHIVELOG
<FONT face=Arial color=#0000ff 
size=2>instead use
 

CREATE 
CONTROLFILE SET DATABASE "PROD" 
RESETLOGS ARCHIVELOG
<FONT face=Arial color=#0000ff 
size=2> 
<FONT face=Arial color=#0000ff 
size=2>Brijesh

  <FONT face=Tahoma 
  size=2>-----Original Message-----From: Catherine LeBlanc 
  [mailto:cleblan2@abacus.bates.edu]Sent: Sunday, June 17, 2001 9:15 
  PMTo: Multiple recipients of list ORACLE-LSubject: 
  ORA-09782 & ORA-09783<FONT face="Courier, Courier" 
  size=3>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 mountORACLE instance started.Total System Global 
  Area     169900992 bytesFixed 
  Size                       
  50832 bytesVariable 
  Size                 
  80024880 bytesDatabase 
  Buffers              
  89620480 bytesRedo 
  Buffers                    
  204800 bytesORA-00205: error in identifying controlfile 
  '/usr/u17/oradata/dbs/ctrl1PROD.ctl'ORA-09782: sfifi: another instance has 
  the same database mounted.SVRMGR> shutdownORA-01507: database not 
  mountedORACLE 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 bytesFixed 
  Size                       
  50832 bytesVariable 
  Size                 
  80024880 bytesDatabase 
  Buffers              
  89620480 bytesRedo 
  Buffers                    
  204800 bytesCREATE CONTROLFILE REUSE DATABASE "PROD" RESETLOGS 
  ARCHIVELOG*ORA-01503: CREATE CONTROLFILE failedORA-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 directoryALTER DATABASE OPEN 
  RESETLOGS*ORA-01507: database not mountedORA-01507: database not 
  mountedORACLE 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 databasewas 
  shutdown during the copy. This happened before when I tried to change the 
  instance name, but I am notdoing 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 AnalystBates College, 
  Administrative 
  Computingcleblan2@bates.edu         
  (207)786-6431Oracle7 Server Release 7.3.4.3Digital UNIX V4.0G (Rev. 
  1530)