Posted 6/8/2010 4:51:10 PM
|
|
|
|
| What is oradiag_oracle directory in oracle's home directory in 11.2? This directory is created in the home directory of the oracle user, after making a local connection. Take a look here: oracle->TESTDB1:/u01> ls -ltr total 16 drwxrwxr-x 3 oracle 10101 4096 Jun 8 14:05 downloads drwxr-xr-x 5 oracle oinstall 4096 Jun 8 14:19 app oracle->TESTDB1:/u01> sqlplus '/ as sysdba' SQL*Plus: Release 11.2.0.1.0 Production on Tue Jun 8 16:50:05 2010 Copyright (c) 1982, 2009, Oracle. All rights reserved. SQL> exit; Disconnected oracle->TESTDB1:/u01> ls -ltr total 16 drwxrwxr-x 3 oracle 10101 4096 Jun 8 14:05 downloads drwxr-xr-x 5 oracle oinstall 4096 Jun 8 14:19 app drwxr-xr-x 3 oracle oinstall 4096 Jun 8 14:36 oradiag_oracle
Thanks,
|
|
Posted 6/9/2010 8:19:24 AM
|
|
|
|
| During creation of the 11g Database, I had explicitly specified the DIAGNOSTIC_DEST to a different location. Few days back i've noticed a directory called oradiag_oracle in the $HOME(not $ORACLE_HOME) directory of the oracle user account. Yesterday I removed it. But soon this directory got created automatically. It looks like this is for client tracing. I did not see it in 11.1.0.7.0, but am seeing it in 11.2.0.1.0. The directory gets created in your home directory when you make a client connection.
There is a note that explains how you can revert behavior back, but it requires making changes to several config files (not sure it is worth it). Doc ID: 454927.1 -> It references 11.1.0.6.0 but my 11.1 was 11.1.0.7.0 and I don't have this happening there, only on 11.2.
|
|
|
|