Re: After Creating SPFILE from PFILE startup gives ora-03113

Can you start up using the sp file? Just create the pfile from spfile and modify that, you might see the syntax is slightly different (ie *'s, as though you were RAC). Also, I see you've enabled a bunch of log destinations without defining the destinations? Or maybe I'm just blind because of the wonderful google reformatting.

Not related to your problem, but you might be wanting non-default optimizer_index_caching,
optimizer_index_cost_adj, depending on your circumstances. Open_cursors may be high, you might look into session_cached_cursors, also depending on your apps.

Not sure why you'd have aq problems when it is 0, setting it to 0 is usually the fix to annoying messages in the alert log or shutdown problems when you are not using aq. Makes me wonder if you are not using the pfile you think you are? Be explicit on the startup line.

jg

--
@home.com is bogus.
Corset trade war!
http://www.signonsandiego.com/uniontrib/20050902/news_1b2china.html