Re: 10g RAC SPFILE in ASM / db won't start / need suggestions
From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Fri, 11 Jan 2013 11:13:04 -0600
Message-ID: <CAJvnOJYD7JdiJr+J9RseTOhxhxaYZq6wB2N7M+LjBoQG6F3DGg_at_mail.gmail.com>
You might look at the alert log, copy out parameters from that (it should show the non default parameters), use that to create a pfile and start it with that. Alternatively, i think you can copy the spfile out using rman, copy out the text with a text editor and and create an spfile that way. Then you set the spfile using the alter system set spfile= command, reset your sga using scope=spfile and restart. On Fri, Jan 11, 2013 at 11:04 AM, <Christopher.Taylor2_at_parallon.net> wrote:
Date: Fri, 11 Jan 2013 11:13:04 -0600
Message-ID: <CAJvnOJYD7JdiJr+J9RseTOhxhxaYZq6wB2N7M+LjBoQG6F3DGg_at_mail.gmail.com>
You might look at the alert log, copy out parameters from that (it should show the non default parameters), use that to create a pfile and start it with that. Alternatively, i think you can copy the spfile out using rman, copy out the text with a text editor and and create an spfile that way. Then you set the spfile using the alter system set spfile= command, reset your sga using scope=spfile and restart. On Fri, Jan 11, 2013 at 11:04 AM, <Christopher.Taylor2_at_parallon.net> wrote:
> I have a pfile available - SPFILE is in ASM but db won't start because I
> wasn't thinking when I resized SGA MAX size and made it too small.
> Any suggestions?
>
> Chris Taylor
> Oracle DBA
> Parallon IT&S
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.' -- http://www.freelists.org/webpage/oracle-lReceived on Fri Jan 11 2013 - 18:13:04 CET