In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.
Solved
Trace files written to $ORACLE_HOME/rdbms/log direcory
Posted on 2006-07-20
Even though background_dump_dest, user_dump_dest and core_dump_dest are defined in the parameter file, some trace files still get written to default destination $ORACLE_HOME/rdbms/log . Permissions on the OS-Level are set up too. What makes oracle to write to all these destinations ?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
2
-
2
7 Comments
Do tkprof <filename.trf> <filename.txt> and check the contents to see what process is writing into rdbms\log
It shows the right folders
background_dump_dest string /u01/app/oracle/admin/PROD
core_dump_dest string /u01/app/oracle/admin/PROD
user_dump_dest string /u01/app/oracle/admin/PROD
I also checked some dates and found out that originally after db was cloned and brought up successufully it did write into proper folders but after the next shutdown started using the default one $ORACLE_HOME/rdbms/log
background_dump_dest string /u01/app/oracle/admin/PROD
core_dump_dest string /u01/app/oracle/admin/PROD
user_dump_dest string /u01/app/oracle/admin/PROD
I also checked some dates and found out that originally after db was cloned and brought up successufully it did write into proper folders but after the next shutdown started using the default one $ORACLE_HOME/rdbms/log
Check whether /u01/app/oracle/admin/PROD
Also see this link
Oracle File Overwrite Security Vulnerability - http://www.ciac.org/ciac/bulletins/m-012.shtml
Check the value of the initialization parameters
SQL> show parameter trace
Using Initialization Parameters to Control Oracle Trace - http://www.pitt.edu/AFShome/h/o/hoffman/public/html/oradoc/server.804/a58246/otrace.htm#1503
Also see this link
Oracle File Overwrite Security Vulnerability - http://www.ciac.org/ciac/bulletins/m-012.shtml
Check the value of the initialization parameters
SQL> show parameter trace
Using Initialization Parameters to Control Oracle Trace - http://www.pitt.edu/AFShome/h/o/hoffman/public/html/oradoc/server.804/a58246/otrace.htm#1503
Thanks for the hints but I checked permissions again and both of the folders whether
/u01/app/oracle/admin/PROD
/u01/app/oracle/admin/PROD
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Truncate is a DDL Command where as Delete is a DML Command.
Both will delete data from table, but what is the difference between these below statements
truncate table <table_name> ??
delete from <table_name> ??
The first command cannot be …
This video shows how to Export data from an Oracle database using the Datapump Export Utility. The corresponding Datapump Import utility is also discussed and demonstrated.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
Suggested Courses
Course of the Month4 days, 14 hours left to enroll
670 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.