7 Replies Latest reply: Oct 13, 2010 1:56 PM by 747031 RSS

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

    652622
      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....
          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
            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....
              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....
                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
                  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....
                    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
                      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