How to start an oracle instance

From: sjgrad03 <member35423_at_dbforums.com>
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:

  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!

                                                                       s
                                                                       j
                                                                       g
                                                                       r
                                                                       a
                                                                       d
                                                                       0
                                                                       3

                                                                       1
                                                                       0

-
2 0
-
0 3
--
Posted via http://dbforums.com
Received on Tue Oct 21 2003 - 07:49:38 CEST

Original text of this message