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) sqlconn sys/change_on_insta ll as sysdba ( it showed a message



"connected to an idle instance")



c) sqlstartup



then the following error message showed up

ORA-01078: failure in processing system parameters

LRM-00109: could not open parameter file 'C:\ORACLE\ORA9 2
\DATABASE\INITJ SHU03.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\ORA9 2\DATABASE\INIT JSHU03.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]

Re: How to start an oracle instance


did you check the existence of the file?

by default the initSID.ora File is located in

$ORACLE_HOME/dbs



you can startup pfile=<pfilefil espec>

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