Re: URGENT: ORACLE NOT STARTING !

Erik Manders wrote:
>
> Hi all.
>
> I got a major problem. My Oracle 6 database won't start.
>
> System is: IBM Rs6000 52H with AIX 3.2.5 (128MEG internal)
> Oracle RDBMS 6.0.37.8.1 ORACLE_HOME=/u/oracle SID=prod
>
> When issuing dbstart on the prompt a get the message:
>
> ORACLE instance started.
> ORA-00205: error in identifying control file '?/dbs/cntrl@.dbf'
> ORA-09782: sfifi: another instance has the same database mounted.
> Attempting to shutdown instance........ORACLE instance shut down.
>
> looking at the cntrlprod.dbf file with the strings command, the path is set
> to /u/oracle/
> (notice the / at the end.)
>
> If I change in oratab: prod:/u/oracle:Y to prod:/u/oracle/:Y
> then I get after starting dbstart:
>
> ORACLE instance started.
> Database mounted.
> ORA-00060: deadlock detected while waiting for resource
> Attempting to dismount database........Database dismounted.
> Attempting to shutdown instance........ORACLE instance shut down.
> SQL*DBA complete.
> ORA-00060: deadlock detected while waiting for resource
> Database "prod" NOT started.
>
> So what's happening here? How do I get my database back online?
>
> I talked today to companies in Holland like RAET, K+V van Alphen and
> Oracle, but still no
> solution.....
>
> Some info what happend last week:
>
> The oracle file were located on a filesystem called /u/oracle. This weas a
> seperater volume group called hd10. Furter there was a filesystem called
> /u/kva on logical volume hd11.
>
> We decided to put those two together.
> We copied all files to a seperate HD.
> Unmounted the filesystems, deleeted the logical volumes.
> Created another locical volume.
> Created a new filesystem on the brand new logical volume, called /u.
> Copied directories kva and oracle back to /u.
>
> So the filesystem /u contains directories kva and oracle. Same as before.
>
> According to Oracle this was a valid move.
>
> Furthermore we upgraded the system from 64Mb to 128Mb internal.
>
> Can anybody please please please help me get my oracle back online??
>
> If so please mail me directly to mailto:pwmaner_at_wirehub.nl
> (pwmaner_at_wirehub.nl or pwmaner_at_xs4all.nl or pwmaner_at_tilburg.nl).
> First one takes presedence.
>
> Thanks in advance.
>
> --
> =
> =============== One of "The people of PW Tilburg" ================
>
> Erik Manders
> Publieke Werken Internet: mailto:pwmaner_at_wirehub.nl
> Stadhuisplein 130 http://www.wirehub.nl/~pwmaner/
> Postbus 717 Tel. 013-428793
> 5000 AS Tilburg Fax. 013-321327
> the Netherlands
>
> 'Often users don't know what they want, but when they do,'
> 'they do not need what they want!'
> ==================================================================
> End Transmission.

Do you see Oracle errors explain with 'oerr' utility?

00205, 00000, "error in identifying control file '%s'" // *Cause: The system cannot find a control file of the specified name and
// size
// *Action: Check that ALL control files are online and the same files that
$ oerr ora 9782
09782, 00000, "sfifi: another instance has the same database mounted." // *Cause: In non-shared disk systems, database cannot be mounted shared.
// *Action: Shutdown the other oracle instance and try again. The name // of the other instance was dumped to the trace file.

Look at trace files, but i think that you are using the same files for two database and your files are corrupted. Good luck... Received on Thu Nov 07 1996 - 00:00:00 CST