This discussion is archived
7 Replies Latest reply: Oct 13, 2010 11:56 AM by 747031 RSS

I can't use the adrci of oracle11g to execute some command

652622 Newbie
Currently Being Moderated
TITLE:
-------------------------------------------------------------------------------------------------
I can't use the adrci of oracle11g to execute some command

ENV:
-------------------------------------------------------------------------------------------------
the production oracle11g(Release 11.2.0.1.0 Red Hat Enterprise Linux AS release 4 x86_64 )

The snapshot of command
-------------------------------------------------------------------------------------------------
adrci> show home
ADR Homes:
diag/rdbms/orcl/orcl
adrci> show control
DIA-48101: error encountered when attempting to read a file [block] [opt/oracle/diag/rdbms/orcl/orcl/metadata/ADR_CONTROL.ams] [0]
DIA-27072: Message 27072 not found; product=RDBMS; facility=DIA
Linux Error: 22: Invalid argument
Additional information: 4
Additional information: 1
Additional information: -1

adrci> show problem

ADR Home = /opt/oracle/diag/rdbms/orcl/orcl:
*************************************************************************
0 rows fetched

adrci> show report hm_run hm_run_1
DIA-48101: error encountered when attempting to read a file [block] [opt/oracle/diag/rdbms/orcl/orcl/metadata/HM_RUN.ams] [0]
DIA-27072: Message 27072 not found; product=RDBMS; facility=DIA
Linux Error: 22: Invalid argument
Additional information: 4
Additional information: 1
Additional information: -1

Edited by: user649619 on 23-Jan-2010 04:46
  • 1. Re: I can't use the adrci of oracle11g to execute some command
    Aman.... Oracle ACE
    Currently Being Moderated
    user649619 wrote:
    TITLE:
    -------------------------------------------------------------------------------------------------
    I can't use the adrci of oracle11g to execute some command

    ENV:
    -------------------------------------------------------------------------------------------------
    the production oracle11g(Release 11.2.0.1.0 Red Hat Enterprise Linux AS release 4 x86_64 )

    The snapshot of command
    -------------------------------------------------------------------------------------------------
    adrci> show home
    ADR Homes:
    diag/rdbms/orcl/orcl
    adrci> show control
    DIA-48101: error encountered when attempting to read a file [block] [opt/oracle/diag/rdbms/orcl/orcl/metadata/ADR_CONTROL.ams] [0]
    DIA-27072: Message 27072 not found; product=RDBMS; facility=DIA
    Linux Error: 22: Invalid argument
    Additional information: 4
    Additional information: 1
    Additional information: -1

    adrci> show problem

    ADR Home = /opt/oracle/diag/rdbms/orcl/orcl:
    *************************************************************************
    0 rows fetched

    adrci> show report hm_run hm_run_1
    DIA-48101: error encountered when attempting to read a file [block] [opt/oracle/diag/rdbms/orcl/orcl/metadata/HM_RUN.ams] [0]
    DIA-27072: Message 27072 not found; product=RDBMS; facility=DIA
    Linux Error: 22: Invalid argument
    Additional information: 4
    Additional information: 1
    Additional information: -1

    Edited by: user649619 on 23-Jan-2010 04:46
    DIA-48101: error encountered when attempting to read a file [%s] [%s] [%s]
    Cause: There was an error encountered when attempting to read a file with the ADR file interface.
    Action: Check the specified arguments to the read interface.

    >

    HTH
    Aman....
  • 2. Re: I can't use the adrci of oracle11g to execute some command
    652622 Newbie
    Currently Being Moderated
    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:17
  • 3. Re: I can't use the adrci of oracle11g to execute some command
    Aman.... Oracle ACE
    Currently Being Moderated
    Interesting! Let me have a look and see if I can come up with something. A fresh 11gR2 installation is going on, so bear with me for some time.

    Cheers
    Aman....
  • 4. Re: I can't use the adrci of oracle11g to execute some command
    Aman.... Oracle ACE
    Currently Being Moderated
    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:17
    I 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.....
  • 5. Re: I can't use the adrci of oracle11g to execute some command
    652622 Newbie
    Currently Being Moderated
    thank you,Aman
    OK,I already resolve the problem,now I can normaly use the adr command

    adrci> show control

    ADR Home = /u02/app/diag/rdbms/orcl/orcl:
    *************************************************************************
    0 rows fetched

    adrci> show problem

    ADR Home = /u02/app/diag/rdbms/orcl/orcl:
    *************************************************************************
    0 rows fetched

    I think install system correctly is a necessary requirement skill for a qualified oracle-dba
  • 6. Re: I can't use the adrci of oracle11g to execute some command
    Aman.... Oracle ACE
    Currently Being Moderated
    So what was the issue and what you did to resolve it?

    Aman....
  • 7. Re: I can't use the adrci of oracle11g to execute some command
    747031 Newbie
    Currently Being Moderated
    Hi Aman,

    Any idea what is the root cause for oracle disabling "Diag Enabled" ? I am also facing the same problem now. Till last day it was true but today after the some maintenence i could see this became false and my alert log is in diffrent location now.

    Thanks

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points