How to start an oracle instance
Date: Tue, 21 Oct 2003 01:49:38 -0400
Message-ID: <3504304.1066715378_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:
- c:\oracle\ora92\bin sqlplus / nolog
- 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!
s j g r a d 0 3 1 0
-
2 0
-
0 3
-- Posted via http://dbforums.comReceived on Tue Oct 21 2003 - 07:49:38 CEST