| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: ORA-09782 & ORA-09783
--MS_Mac_OE_3075660840_43920_MIME_Part
Content-type: text/plain; charset="US-ASCII"
Content-transfer-encoding: 7bit
Catherine:
I can't find any specific information to confirm my memory right now, but I think there's a file in $ORACLE_HOME/dbs named something like lk_${ORACLE_SID}. If I'm remembering correctly, this file indicates to Oracle that the db is up. You may want to try renaming the file and see if you can start up the instance.
Also, if you're on UNIX, have you tried grepping for pmon and killing the process?
I doubt this has anything to do with your control files.
Hope this helps.
-- Jon Walthour, OCDBA Oracle DBA Computer Horizons Cincinnati, Ohio Organization: Fat City Network Services, San Diego, California Reply-To: ORACLE-L_at_fatcity.com Date: Sun, 17 Jun 2001 18:15:26 -0800 To: Multiple recipients of list ORACLE-L <ORACLE-L_at_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) --MS_Mac_OE_3075660840_43920_MIME_Part Content-type: text/html; charset="US-ASCII" Content-transfer-encoding: quoted-printableReceived on Sun Jun 17 2001 - 21:20:21 CDT
<HTML>
<HEAD>
<TITLE>Re: ORA-09782 & ORA-09783</TITLE>
</HEAD>
<BODY>
Catherine:<BR>
<BR>
I can't find any specific information to confirm my memory right now, but I= think there's a file in $ORACLE_HOME/dbs named something like lk_${ORACLE_S= ID}. If I'm remembering correctly, this file indicates to Oracle that the db= is up. You may want to try renaming the file and see if you can start up th= e instance.<BR>
<BR>
Also, if you're on UNIX, have you tried grepping for pmon and killing the p= rocess?<BR>
<BR>
I doubt this has anything to do with your control files.<BR>
<BR>
Hope this helps.<BR>
<BR>
-- <BR>
<BR>
Jon Walthour, OCDBA<BR> Oracle DBA<BR> Computer Horizons<BR> Cincinnati, Ohio<BR>
<BR>
<BR>
<B>From: </B>Catherine LeBlanc <cleblan2_at_abacus.bates.edu><BR>
<BLOCKQUOTE><B>Organization: </B>Fat City Network Services, San Diego, Cali=
fornia<BR>
<B>Reply-To: </B>ORACLE-L_at_fatcity.com<BR>
<B>Date: </B>Sun, 17 Jun 2001 18:15:26 -0800<BR>
<B>To: </B>Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>=
;<BR>
<B>Subject: </B>ORA-09782 & ORA-09783<BR>
<BR>
</BLOCKQUOTE><BR>
<BLOCKQUOTE>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= :<BR> ----------------------------------------------------------------<BR> SVRMGR> startup mount<BR> ORACLE instance started.<BR> Total System Global Area 169900992 bytes<BR> Fixed Size &nbs= p; 50832 bytes<BR= > Variable Size &= nbsp; 80024880 bytes<BR> Database Buffers &nbs= p; 89620480 bytes<BR> Redo Buffers &n= bsp; 204800 bytes<BR> ORA-00205: error in identifying control<BR> file '/usr/u17/oradata/dbs/ctrl1PROD.ctl'<BR> ORA-09782: sfifi: another instance has the same database mounted.<BR> SVRMGR> shutdown<BR> ORA-01507: database not mounted<BR> ORACLE instance shut down.<BR> -----------------------------------------------------------------<BR>
<BR>
I dropped that control file and got the same error, and when I try creating= new control files I get:<BR> -----------------------------------------------------------------<BR> ORACLE instance started.<BR> Total System Global Area 169900992 bytes<BR> Fixed Size &nbs= p; 50832 bytes<BR= > Variable Size &= nbsp; 80024880 bytes<BR> Database Buffers &nbs= p; 89620480 bytes<BR> Redo Buffers &n= bsp; 204800 bytes<BR> CREATE CONTROLFILE REUSE DATABASE "PROD" RESETLOGS ARCHIVELOG<BR> *<BR> ORA-01503: CREATE CONTROLFILE failed<BR> ORA-01565: error in identifying file '/usr/u17/oradata/prod/syst_PROD.dbf'<= BR> ORA-09783: sfifi: Cannot determine if another instance has mounted the same= database.<BR> Digital Unix Error: 20: Not a directory<BR> ALTER DATABASE OPEN RESETLOGS<BR> *<BR> ORA-01507: database not mounted<BR> ORA-01507: database not mounted<BR> ORACLE instance shut down.<BR> ---------------------------------------------------------------------------=
<BR>
<BR>
I tried SET and NORESTLOGS, and rearranging the datafiles in the script,<BR= > all with no difference. The files definitely exist, and the source database=
<BR>
was shutdown during the copy. <BR> This happened before when I tried to change the instance name, but I am not=
<BR>
doing that now. I know that this error occurs when cloning on the same mach= ine <BR> with the source database running, but I am on a totally different machine.<= BR> Does anyone know what Oracle checks internally that makes it think the <BR> instance is mounted when it is not?<BR>
<BR>
--<BR> Catherine A. LeBlanc, Database Analyst<BR> Bates College, Administrative Computing<BR> cleblan2_at_bates.edu (207)786-6431<= BR> Oracle7 Server Release 7.3.4.3<BR> Digital UNIX V4.0G (Rev. 1530)<BR>
<BR>
</BLOCKQUOTE><BR>
</BODY>
</HTML>
--MS_Mac_OE_3075660840_43920_MIME_Part-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: jwalthour_at_mac.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
 |
 |