If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

The only way I can get the database to open is to explicitly issue ....
STARTUP PFILE=G:\ORACLE\ORA81\DATABASE\INITmydb.ORA

Additionally I have recreated the service using ORADIM
ORADIM -new -sid myin -intpwd oracle -startmode a -pfile G:\ORACLE\ORA81\DATABASE\INITmydb.ORA

....but I still get ...
LRM-00109 could not open parameter file 'G:\ORACLE\ORA81\DATABASE\INITmyin.ORA'

Where on earth is it getting this parameter file spec "INITmyin.ORA" when having speced "INITmydb.ORA", I have run out of ideas. Would apprectiate some guidance.

Am also having shutdown problems whereby a shutdown immediate even fails, so have remedied this with a checkpoint followed by an abort, not sure if this could be related. For either problem the Bdump trace file does not help.

Goofed!!

I pretty sure that if i use the same name for the instance, database and service names that it will work. I have had it working using different names for each before and there is no reason why this should not be working now as is so am determined to get to the bottom of this problem.

Is this the entire init.ora? Are you following OFA? Otherwise you have to specify some more parameters.

It was only an extract of the parameter file i presented, why? what other info do you need to see? Am OFA compliant.

"The only way I can get the database to open is to explicitly issue ....
STARTUP PFILE=G:\ORACLE\ORA81\DATABASE\INITmydb.ORA"

Are you not aware that setting the pfile parameter in the registry in WinMS is also an alternative?

"Are you sure that Oracle can find the init.ora on that path? Is the ASCII-file in use maybe? Or corrupt? If Oracle says it can't open the file, it really can't open it. So check the path and check to see if the file is still plain ASCII (don't open it in some editor and save it as MS Word or something like that)."

Oracle can find the correct directory path my problem is that it is looking for the wrong file OOOOHHHH **** just realised I've cocked up big time and have overlooked something very simple AArrrghhh! Init param files having a naming format INITsid.ora and I've not followed this, can't believe I've gone and done this.