I think I killed my Oracle

[Deeko]

So in trying to fix a configuration problem I was having, I think Windows saved the spfilexe.ora file in the wrong file format, or something of that nature. At any rate, no matter what I do, I can't get the service to run properly now (it claims to start, but I can't access the web tools or connect to it via my application). Is there a way to fix this, without having to reinstall it? I'd rather not lose my data...

thanks

 

[KLin]

Did she say you were the one before you broke her? . Try doing a tnsping from the command line to see if it responds.

 

[Deeko]

TNS-12541: TNS:no listener

 

[lozina]

Why do you think Windows screwed up the file format?

Was it renamed with a .txt at the end?

 

[Deeko]

No - I don't know the exact terminology, but when I first opened the file in notepad, it didn't have line breaks - so I opened it in wordpad, which showed the line breaks, made the edit I needed, and saved it. This is when it stopped working. When I opened it back up in notepad, the line breaks were there, which tells me that wordpad changed something.

 

[Deeko]

Ok, so I can't seem to get this to work. I went as far as to track down the default copy of spfilexe.ora, but it still doesn't load properly. I backed up the oracle directory and reinstalled it, and now its working - but obviously without my database. I still have all the data files from the original database - is there a way to import this data into the fresh install?

 

[Deeko]

Nevermind, I got it. A dash of files from the original + a pinch of the fresh install and voila! A working database!

 

[mugs]

Originally posted by: Deeko
No - I don't know the exact terminology, but when I first opened the file in notepad, it didn't have line breaks - so I opened it in wordpad, which showed the line breaks, made the edit I needed, and saved it. This is when it stopped working. When I opened it back up in notepad, the line breaks were there, which tells me that wordpad changed something.

Oi... you need to get yourself a real text editor.

I'm going to guess that the file had Unix line endings, and Wordpad changed it to Windows line endings.

 

[Deeko]

Originally posted by: mugs

Originally posted by: Deeko
No - I don't know the exact terminology, but when I first opened the file in notepad, it didn't have line breaks - so I opened it in wordpad, which showed the line breaks, made the edit I needed, and saved it. This is when it stopped working. When I opened it back up in notepad, the line breaks were there, which tells me that wordpad changed something.

Oi... you need to get yourself a real text editor.

I'm going to guess that the file had Unix line endings, and Wordpad changed it to Windows line endings.

Yea. I didn't really know the exact terminology for that, hence the vague description, haha...

And this server is running windows 2003 and doesn't really have much of anything installed on it, let alone a text editor. Meh. At least through my research on this issue I found an easier way of altering the parameter I need to change - straight through SQL.