How to start an oracle instance

[sjgrad03]

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!

s
j
g
r
a
d
0
3

1
0
-
2
0
-
0
3
--
Posted via http://dbforums.com

[osy45]

did you check the existence of the file?

by default the initSID.ora File is located in

$ORACLE_HOME/dbs

you can startup pfile=<pfilefilespec>

or with 92 you can build from an initSID.ora file a spfile

using sqlplus then invoking "create spfile from pfile "

the spfile is then the file Oracle 9i is looking for to startup
--
Posted via http://dbforums.com