Oracle parameters

[Former Member]

Hello,

I'm checking  Oracle parameters, and the deprecated parameters not appear on initSID.ora, but If I execute the show parameter background_dump_dest, I can see the result og this parameter. Is it the parameter set?

[Reagan]

Hello

Please read Oracle documentation to understand how the BACKGROUND_DUMP_DEST parameter works.

Troubleshooting

BACKGROUND_DUMP_DEST

The trace files will still be created whether the parameter BACKGROUND_DUMP_DEST is set or not.

If you set the parameter BACKGROUND_DUMP_DEST with a specific directory value then the database will use that directory for the trace files.

If the parameter BACKGROUND_DUMP_DEST is not set then the database will use this:

$ORACLE_HOME/admin/db_name/bdump on UNIX operating systems
%ORACLE_HOME%\admin\db_name\bdump on Windows NT and Windows 2000 operating systems

The logs will be created under the base directory and the base directory is based on the parameter DIAGNOSTIC_DEST

Query the v$diag_info view to find the details.

Regards

RB

[former_member188883]

Hi Ruben,

If you have not set the parameter in initSID.ora, sql command show parameter shows default value .

It implies parameters is active with default value which may or may not suit the environment.

Hope this helps.

Regards,

Deepak Kori

[Former Member]

Thanks Deepak,

Then I need to reset or remove the parameter?

I must to user alter system reset <parameter>scope=spfile;  ??

[former_member188883]

Hi Ruben,

No need to execute any command for these parameters . Do you face any problem with the database ?

Regards,

Deepak Kori

[Former Member]

I'm following the note 1431798.

For this parameter says Deprecated. Do not set this parameter!

On initSID.ora doesn't appear but you've said that the parameter is active with the default value. Then I should remove them, shouldn't?

[former_member188883]

Hi Ruben,

Show parameter command will display the parameter values that are currently in effect.

Even if you use "alter system reset" to remove a parameter from a server parameter file, this will cause the default value to take effect the next time you start an instance of the database.

As currently default value already exists , there is no need to execute reset command.

Since these parameters exists with default value you may get information message while starting the database. You may ignore these messages.

Hope this helps.

Regards,

Deepak Kori

[Former Member]

I'm a bit confused.

Then If I the parameter doesn't appear in initSID.ora then is not active in the current DB? Then Doesn't matter that the parameter exists with its default value?

[former_member188883]

Hi Ruben,

If the parameter does not exist in initSID.ora as well as SPfile, no need to bother much.

Regards,

Deepak Kori

[Former Member]

Then is the correct process way? the active parameters on the db instance must be on initSID.ora and SPFILE?

[former_member188883]

Hi Ruben,

You need to define the parameters using which you want to start the Oracle database in initSID.ora file. You need to create an Spfile from pFile.

Once the oracle starts it will read contents from Spfile and start the database.

Hope this helps.

Regards,

Deepak Kori