Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Where is background_dump_dest?

Beauty_and_dBestNov 15 2018 — edited Nov 16 2018

11gR2

OL6

Hi ALL,

Where is background_dump_dest being set to?

Is it in init.ora?

I checked the value in the database and it has.

SQL> show parameter background_dump_dest

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

background_dump_dest                 string      /oracle/ASCP/db/tech_st/11.2.0

                                                 /admin/ASCP_ascpdbdr/diag/rdbm

                                                 s/stby2/ASCP/trace

SQL>

But when I check it in initASCP.ora,  there is no background_dump_dest being set there.

Please help where can I find this parameter.

Kind regards,

jc

This post has been answered by floo_bar on Nov 15 2018
Jump to Answer
Comments
Post Details
Added on Nov 15 2018
13 comments
2,316 views