• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

I think I killed my Oracle

Deeko

Deeko

Lifer
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
 
Did she say you were the one before you broke her? 😉. Try doing a tnsping from the command line to see if it responds.
 
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.
 
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?
 
Nevermind, I got it. A dash of files from the original + a pinch of the fresh install and voila! A working database!
 
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.
Click to expand...

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.
 
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.
Click to expand...

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.
Click to expand...

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.
 
You must log in or register to reply here.
Back
Top