Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Urgent..Oracle Recover from Crashed OS

Re: Urgent..Oracle Recover from Crashed OS

From: <pauljmcclure_at_gmail.com>
Date: 11 Feb 2005 04:39:33 -0800
Message-ID: <1108125573.307998.79010@f14g2000cwb.googlegroups.com> 





2b) find the SID of the database - you could search for the
tnsnames.ora file that was on the server when the db was up. lets
assume SID = sid1


2c) find the initsid1.ora file


3.Through oradim create service.


   (ex. ORADIM -NEW -SID sid1 -INTPWD oracle -STARTMODE auto -PFILE
c:\path_to_init_file\initsid1.ora)


4.Start that service


5.Startup Database.


    cmd prompt>sqlplus /nolog

                      conn sys/oracle_at_sid1 as sysdba
                      startup





good luck!
Received on Fri Feb 11 2005 - 06:39:33 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US