Home -> Usenet -> comp.databases.oracle -> trouble shooting oracle instance

trouble shooting oracle instance

From: sjgrad03 <member35423_at_dbforums.com>
Date: Wed, 22 Oct 2003 00:39:50 -0400
Message-ID: <3508974.1066797590_at_dbforums.com> 







Dear members:





I have trouble to logon sqlplus. one dbforum member said that my oralce
instance doesn't start.





I used following command in the command line prompt:





    
  
  1.   c:\oracle\ora92\bin sqlplus / nolog



  
  2.   sql> conn sys/change_on_install as sysdba ( it showed a message








"connected to an idle instance")





c) sql> startup





then the following error message showed up



ORA-01078: failure in processing system parameters



LRM-00109: could not open parameter file 'C:\ORACLE\ORA92
\DATABASE\INITJSHU03.ORA'




jshu03 is the name i gave to database (global)





In the ORAdim log it has following error recorded



ORA-01078: failure in processing system parameters



LRM-00109: could not open parameter file
'C:\ORACLE\ORA92\DATABASE\INITJSHU03.ORA'




Could someone give me some ideas how to fix this problem? The bad thing
is that I forget the password for my database jshu03. Do i need to
reinstall Oracle9i from the begining??





If you have time please help me, Thanks!





sjgrad03



10-20-03



--
Posted via http://dbforums.com


Received on Wed Oct 22 2003 - 06:39:50 CEST












Original text of this message