oracle 48101 block,I can't use the adrci of oracle11g to execute some command

bidynamo wrote:

thank you,Aman

when I execute :Select * from v$diag_info; I found that the column of Diag Enabled is FAlSE,I don't know where and how to modify the argument,and I found that these *.ams file is exists in the directory diag/rdbms/orcl/orcl/metadata/

Edited by: bidynamo on 24-Jan-2010 07:17I must say thanks to you since you asked it and I tried to search about it by doing a little deep dive in Oracle params. The value of Diag being Enabled as True/False is determined by an undocumented parameter, diagadr_enabled which can be set to both of the values. I haven't spend much time for searching out all the details but a quick scan over the x$ksppi and x$ksppcv2 gave the results taht the parameter is supposed to be true be default. So what I did that I changed the parameter value in the parameter file of my db running over OEL5.4, 11.2.0.1 and yes, it did change the message in the V$diag_info.

SQL> startup force

ORACLE instance started.

Total System Global Area 221294592 bytes

Fixed Size 2212048 bytes

Variable Size 138415920 bytes

Database Buffers 75497472 bytes

Redo Buffers 5169152 bytes

Database mounted.

select * from V$diagDatabase opened.

SQL> _info;

INST_ID NAME VALUE

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

1 Diag Enabled TRUE

1 ADR Base /u01/app/oracle

1 ADR Home /u01/app/oracle/diag

/rdbms/orcl/orcl

1 Diag Trace /u01/app/oracle/diag

/rdbms/orcl/orcl/tra

ce

1 Diag Alert /u01/app/oracle/diag

/rdbms/orcl/orcl/ale

rt

1 Diag Incident /u01/app/oracle/diag

/rdbms/orcl/orcl/inc

ident

1 Diag Cdump /u01/app/oracle/diag

/rdbms/orcl/orcl/cdu

mp

1 Health Monitor /u01/app/oracle/diag

/rdbms/orcl/orcl/hm

1 Default Trace File /u01/app/oracle/diag

/rdbms/orcl/orcl/tra

ce/orcl_ora_25956.tr

c

1 Active Problem Count 0

1 Active Incident Count 0

11 rows selected.

SQL> select * from V$version;

BANNER

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

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

PL/SQL Release 11.2.0.1.0 - Production

CORE 11.2.0.1.0 Production

TNS for Linux: Version 11.2.0.1.0 - Production

NLSRTL Version 11.2.0.1.0 - Production

SQL>Now, let's change the parameter and see if it works. I did bounce my db of course before I ran the command again.

SQL> /

INST_ID NAME VALUE

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

1 Diag Enabled FALSE

1 ADR Base

1 ADR Home

1 Diag Trace /u01/app/oracle/prod

uct/11.2.0/db_1/rdbm

s/log

1 Diag Alert /u01/app/oracle/prod

uct/11.2.0/db_1/rdbm

s/log

1 Diag Incident

1 Diag Cdump /u01/app/oracle/prod

uct/11.2.0/db_1/dbs

1 Health Monitor

1 Default Trace File

1 Active Problem Count

1 Active Incident Count

11 rows selected.I am not sure that you shoudl really touch this parameter since it is undocumented and any hidden parameter must be tempered only with the consent of OSS. So better would be to check back with support and see if there can be any other way around for this or not? I shall also try to find some other legal way to do so. But for the mean time, that's what I have got for you!

HTH

Aman.....