In P for Oracle, how to resolve CollAvailability collector in alarm with ORA-00942: table or view does not exist?

Version 4
    Share:|

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    PATROL for Oracle


    COMPONENT:

    PATROL for Oracle


    APPLIES TO:

    PATROL for Oracle KM



    QUESTION:

    Getting the following errors
    BMCPOK8061W - Tue <Date> - [Recovery action: CollAvailability]
    Collector : CollAvailability
    Instance : XXX

    CannotExtend:
    --------------
    Truncate/Insert Failed for P$AUTOEXTTS, P$CANTEXTMAXTBSP, P$CANTEXTFILE with error:
    TRUNCATE TABLE P$AUTOEXTTS
    *
    ERROR at line 1:
    ORA-00942: table or view does not exist


    insert into P$AUTOEXTTS
    *
    ERROR at line 1:
    ORA-00942: table or view does not exist

    TRUNCATE TABLE P$CANTEXTMAXTBSP
    *
    ERROR at line 1:
    ORA-00942: table or view does not exist


    P$AUTOEXTTS c,
    *
    ERROR at line 6:
    ORA-00942: table or view does not exist


    P$AUTOEXTTS c,
    *
    ERROR at line 11:
    ORA-00942: table or view does not exist


    TRUNCATE TABLE P$CANTEXTFILE
    *
    ERROR at line 1:
    ORA-00942: table or view does not exist


    from DBA_DATA_FILES a, P$AUTOEXTTS b, (select file_id, max(bytes) max_free_bytes
    *
    ERROR at line 7:
    ORA-00942: table or view does not exist

    Commit complete.
    Commit complete.

    OR

    Oracle Instance debug log may contain:

    DEBUG:Thu Dec 27 09:15:39 2018:POK_ORACLE_CollAvailability:ORACLE.ORACLE.CollAvailability:During CannotExtend collection, errList = 
    CannotExtend: 
    --------------
    Truncate/Insert Failed for P$AUTOEXTTS, P$CANTEXTMAXTBSP, P$CANTEXTFILE with error:

    DEBUG:Wed Dec 26 15:30:06 2018:POK_ORACLE_CollAvailability:ORACLE.ORACLE.CollAvailability:--- The following error occured --------- 

    DEBUG:Wed Dec 26 15:30:06 2018:POK_ORACLE_CollAvailability:ORACLE.ORACLE.CollAvailability:Truncate/Insert Failed for P$AUTOEXTTS, P$CANTEXTMAXTBSP, P$CANTEXTFILE with error:

    DELETE FROM P$CANTEXTFILE
                *
    ERROR at line 1:
    ORA-00942: table or view does not exist


    ANSWER:

     

    After a successful configuration of Oracle KM, following tables will be created:

      
      P$AUTOEXTTS
      
      P$CANTEXTMAXTBSP
      
      P$CANTEXTFILE
      
      P$CANTEXTMAXFILE
      
      P$AUTOEXTEND
      
      And the agent configuration variable /OracleCantext.".sid.".Tables" is updated with a value of 1.
      
     
      For example:
    0110831112250 "/OracleCantext.<SID>.Tables" = { REPLACE = "1" },
     
      
      
      To re-create the above tables, modify the agent configuration variable value to be NULL and re-initialize the agent.
      
     
      For example:
    0110831112250 "/OracleCantext.<SID>.Tables" = { REPLACE = "" },
      
     
      The KM will run the $PATROL_HOME/../oracle/sql/pautoext.sql file and create the missing P$ tables. 
      

     


    Article Number:

    000028533


    Article Type:

    FAQ/Procedural



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles