home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.oracle      Overblown overpriced overengineered SHIT      2,288 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 560 of 2,288   
   sjgrad03 to All   
   trouble shooting oracle instance   
   22 Oct 03 00:39:50   
   
   From: member35423@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:   
      
      
      
   a) c:\oracle\ora92\bin sqlplus / nolog   
      
      
      
   b) 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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca