troubleshooting Question

Help InitSID.ora problem

Avatar of sikyala
sikyalaFlag for United States of America asked on
Oracle Database
14 Comments3 Solutions3109 ViewsLast Modified:
I accidently set a parameter to an invalid directory. I shutdown the database before I realized it. When I tried to start the database again I got an error that the parameter in question has an invalid directory. So I opened the spfileSID.ora and changed the directory of the parameter to a valid directory and saved it. But when I went back to startup the database again I got the following error:

ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/oracle/product/app/10.2.1/dbs/initJoshua.ora'

So I issue the following command:

SQL> startup pfile='/u01/oracle/product/app/10.2.1/dbs/spfileJoshua.ora';

But I get this error:

LRM-00123: invalid character 7 found in the input file
ORA-01078: failure in processing system parameters

Here is the contents of the file:

*.dispatchers='(PROTOCOL=TCP) (SERVICE=JoshuaXDB)'

I don't know what shouldn't be there. How do I fix this?
Join our community to see this answer!
Unlock 3 Answers and 14 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 14 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros