Re: A Mystery - Create pfile and Quotes

I can reproduce the same behavior on 19.9 if one of the parameters has a single-quote, e.g.:
conn / as sysdba

alter system set db_create_file_dest='/tmp/dir''' scope=memory; create pfile='/tmp/pfile.ora' from memory;

!cat /tmp/pfile.ora

• an excerpt from the output core_dump_dest='/u01/app/oracle/diag/rdbms/orcl/orcl/cdump' cpu_count=1 cpu_min_count='1' db_block_size=8192

*db_create_file_dest="/tmp/dir'"db_name="orcl"db_recovery_file_dest="+FRA"* db_recovery_file_dest_size=10G
diagnostic_dest='/u01/app/oracle'

It seems to use double-quotes up to the first path.

On Tue, 9 Nov 2021 at 13:16, Howard Latham <howard.latham_at_gmail.com> wrote:

> We have a job that runs every night that creates a pfile from the database
> for code control purposes.
>
>
> execute immediate 'create pfile=''${shadowdir}/init'||sid||'.memory'' from
> memory';
>
>
>
> There is a bit of ‘post-processing’ to mask fluctuating values in the
> generated file but nothing related to the observation below
>
>
>
> Sunday night it generated a new file almost like the previous except a
> string (all?) quoted values used “ (double-quote) instead of ‘
> (single-quote):
>
> So usually single quotes around values but Sunday Double Quotes
>
> Oracle 19.12 RH 7.9.
>
> Not really worried just very puzzled. Is there a Quote separator parameter
> that can be changed?
>
>

--
http://www.freelists.org/webpage/oracle-l