Oracle Database Discussions

Oracle Database 10g Enterprise Edition
Oracle Enterprise Linux


I am trying to learn creating Dataguard configuration on my laptop. Since I am creating both Primary and Standby databases on the same laptop using same Oracle home I need to use db_file_name_convert and Log_file_name_convert. But I just can't change db_file_name_convert parameter. I am using spfile.

I am getting ORA-2096 errors. That this parameter cannot be modified with these options.

Can anyone tell me how to change this parameter.

I have tried various ways,

ALTER SYSTEM SET DB_FILE_NAME_CONVERT=('ABC','XYZ') SCOPE= BOTH;
ALTER SYSTEM SET DB_FILE_NAME_CONVERT=('ABC','XYZ') SCOPE=SPFILE;
ALTER SYSTEM SET DB_FILE_NAME_CONVERT=('ABC','XYZ') SCOPE=BOTH DEFERRED;
ALTER SYSTEM SET DB_FILE_NAME_CONVERT=('ABC','XYZ') SCOPE=SPFILE DEFERRED;

Everytime I am getting 2096 error.