By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,659 Members | 940 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,659 IT Pros & Developers. It's quick & easy.

trouble shooting oracle instance

P: n/a

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
Jul 19 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
sjgrad03 <me*********@dbforums.com> wrote in message news:<35****************@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


Sjgrad03, the message says Oracle is looking for the init.ora file at
the full path indicated. Where did you create the initSID.ora file
at? If it is somewhere else you should copy it to the expected
location and try again or use the pfile= parameter to point to the
actual location.

Also is your SID the same as you DB name. If not you need to set the
ORACLE_SID environment variable so Oracle is looking for the right
instance.

Also, When a newsgroup has subgroups it generally means you should
post in the subgroups and not in the group. Several of the better
posters seem to avoid venturing out of the sub-groups. If you need
more help try posting to the server subgroup.

HTH -- Mark D Powell --
Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.