473,326 Members | 2,148 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

trouble shooting oracle instance


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
1 7911
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
by: NTidd | last post by:
Since we have upgraded to oracle 9i every day or so we have to go in and shutdown oracle and restart it, here is what we do: sqlplus /nolog connect sys as sysdba password: connected to an idle...
5
by: Michael Rudolph | last post by:
Hi newsgroup, I have an issue with the configuration of a DB2 federated database (WebSphere Information Integrator) in conjunction with the relational wrapper for Oracle on AIX. DB2 seems to not...
42
by: Paul | last post by:
Anyone know where I can find some good resources to help us choose between SQL and Oracle ( Progress Openedge as well ) . Any comments on what you would choose ?? We are creating a new Warehouse...
0
by: haritha | last post by:
HI Friends This blog is very useful to all sections of people. For Pc trouble shooting skills,Linux,Html Webdesigning,Free softwares,Networking skills,Gaming news and For Tips visit the blog:...
0
by: takveen | last post by:
The Topics Covered In This Book Are: Understanding the Oracle Environment; Understanding the Oracle Instance; Understanding the working of Oracle Instance; Understanding the Oracle Database; Oracle...
1
by: takveen | last post by:
The Topics Covered In This Book Are: Understanding the Oracle Environment; Understanding the Oracle Instance; Understanding the working of Oracle Instance; Understanding the Oracle Database; Oracle...
1
by: sjgrad03 | last post by:
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:
2
by: Ruslan A Dautkhanov | last post by:
Hello ! I'm about to install O9i on FreeBSD box. uname -a: FreeBSD stat2.scn.ru 5.2.1-RELEASE-p3 FreeBSD 5.2.1-RELEASE-p3 #2: Fri Apr 23 19:19:43 KRAST 2004...
5
by: Martin Solveig | last post by:
Hello, SLES9 SP1 is on PIII with two 800MHz procesors and 2GB RAM, on four SATA 156GBhard disks are created two RAID1 arays, on one RAID is OS with 1GB swap and Oracle 10.1.0.4 enterprise edition,...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.