Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Editing pfile created from spfile

Re: Editing pfile created from spfile

From: Michael Ray <topshot.rhit_at_gmail.com>
Date: Wed, 5 Apr 2006 17:09:19 -0400
Message-ID: <286664910604051409k11809242n79b0aa3992580d97@mail.gmail.com>


It's Win 2003 server and WinXP client.

From my sql*plus session (this will likely wrap): SQL> ALTER SYSTEM SET
LOG_FILE_NAME_CONVERT=('c:\oracle\product\10.2.0\oradata\cssprod','c:\oracle\product\10.2.0\oradata\cssprod','e:\oracle\oradata\cssprod','e:\oracle\oradata\cssprod') SCOPE=SPFILE;

                 *

ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified

The * should be right under the L of LOG. Even though the file names are not different, I need to add this to get rid of some other errors from a 10gR2 dataguard "enhancement".

On 4/5/06, Bobak, Mark <Mark.Bobak_at_il.proquest.com> wrote:
> Also, regarding the 2095 error, what parameter did you try to change,
> and exactly what was the syntax? Please cut and paste the command and
> the error text received.

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Apr 05 2006 - 16:09:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US