What is oradiag_oracle directory in oracle's home directory in 11.2?
FranklinFaces.com
FranklinFaces.com - Oracle & SQL Server Database Forums for all IT Professionals
 Home          Members     Calendar     Who's On

Welcome Guest ( Login | Register )
        



What is oradiag_oracle directory in oracle's... Expand / Collapse
Message
Posted 6/8/2010 4:51:10 PM Post #193
 

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being
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 Post #194
 

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being
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.

« Prev Topic | Next Topic »


Reading This Topic Expand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: silencer

Permissions Expand / Collapse

All times are GMT -5:00, Time now is 6:18am

Powered By InstantForum.NET v4.1.4 © 2012
Execution: 0.082. 9 queries. Compression Disabled.
Contextual Links