paul_y3k Posted January 24, 2005 Share Posted January 24, 2005 i've just managed to trash an Oracle 9.2.0.5 install. the first time I've ever used 9i. Tried to modify the spfile directly and it seems to have corrupted it. Now when i try to restart Oracle it moands that theres no pfile ... which there isnt but i didnt think I needed one in Ora 9. I seem to get the impression I need to rebuild the SP file ??? Quote Link to comment Share on other sites More sharing options...
JustGav Posted January 24, 2005 Share Posted January 24, 2005 I'm no DBA, but I've just had one assigned to my project at work, I can ask her if you wish...if you don't come right. Gav Quote Link to comment Share on other sites More sharing options...
Bobbeh Posted January 24, 2005 Share Posted January 24, 2005 The spfile is an extension of the init.ora file thats used to store database parameters. It allows you to modify some parameters on the fly without having to stop/start the database. Theres loads of stuff on Google if you ask the right questions Quote Link to comment Share on other sites More sharing options...
paul_y3k Posted January 24, 2005 Author Share Posted January 24, 2005 Gav, that would be ace as I'm chasing my tail here thank to google. bobbeh .. that cant be right, i've just read you arnt allowed to edit the file ! Quote Link to comment Share on other sites More sharing options...
Bobbeh Posted January 24, 2005 Share Posted January 24, 2005 Well you dont edit the file, but it contains the parameters that you can change via the 'alter system' command. So you can do it on the fly. Quote Link to comment Share on other sites More sharing options...
Bobbeh Posted January 24, 2005 Share Posted January 24, 2005 Paul try this link. Change the names depending on how you created your instance. http://www.psoug.org/reference/init_dot_ora.html I think what you've done is configured your DB to use SPfile.. screwed it up by trying to edit it manually so Oralce doesnt recognise it, and its looking for a pfile (usual param file) that may not exist for your set up. If you dont want to use SPfile, try the following to restore your db to use pfile only, but you need to connect as sysdba or something, you should be able to do this if the database hasnt started properly or if its still in unmounted state etc. SQL> create pfile from spfile; Quote Link to comment Share on other sites More sharing options...
paul_y3k Posted January 24, 2005 Author Share Posted January 24, 2005 yep you've got it right ... the initSID.ora doesnt exist. So i've tried to build one myself using the init.ora. have just tried to create the spfile form it and now get : ORA-00209: control file blocksize mismatch, check alert log for more info but no alert log created !?! Quote Link to comment Share on other sites More sharing options...
Bobbeh Posted January 24, 2005 Share Posted January 24, 2005 Sounds like the blocksize defined in that init.ora is a different size to that when you created it? Try 4k or 8k values for your block size, they're usually the most common. Quote Link to comment Share on other sites More sharing options...
paul_y3k Posted January 24, 2005 Author Share Posted January 24, 2005 hmm thats the problem I didnt create it. The original installer has since left the company and i herited this server a few hours ago lol. ok i'll give it a shoot in the initsid.ora Quote Link to comment Share on other sites More sharing options...
Bobbeh Posted January 24, 2005 Share Posted January 24, 2005 Oh Doh What are you doing working at this godforsaken hour man! Quote Link to comment Share on other sites More sharing options...
paul_y3k Posted January 24, 2005 Author Share Posted January 24, 2005 lol I'm in Texas ! so it's only just packing up time. still cant get it to work, and its not appearing to generate any alert files like its telling me - but I'm going to give up now as I want to try and get over to MVP before they close. Quote Link to comment Share on other sites More sharing options...
Bobbeh Posted January 24, 2005 Share Posted January 24, 2005 Are you sure you've checked all the Udump, Cdump etc directories for the instance... they usually kick off error messages in there. Quote Link to comment Share on other sites More sharing options...
paul_y3k Posted January 25, 2005 Author Share Posted January 25, 2005 yep that was my first place to look. The last aleart was from 4 weeks ago ! I'm tempted to just trash it and reinstall it all, but on the toher want to try to get this going again as part of the learning curve... still it helps justify the need for OCP training Quote Link to comment Share on other sites More sharing options...
Bobbeh Posted January 25, 2005 Share Posted January 25, 2005 Yeah, I see what you're saying though, would be a shame to lose what was there. Try just re-pointing Oracle to use your pfile with the SQL> pfile = '/u01/oracle/etc/initSID.ora' If that doesnt work, your file may need changing. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.