Skip to main content
ExLibris
  • Subscribe by RSS
    • Back
    Aleph
    Ex Libris Knowledge Center

    upgrade to ver.20 and ORA-02097

    1. Last updated
    2. Save as PDF
    • Article Type: General
    • Product: Aleph
    • Product Version: 20

    Description:
    Yesterday around 3pm Oracle shutdown while some indexing jobs were running. When I looked into the alert log
    "ORA-02097: parameter cannot be modified because specified value is invalid
    Mon Jul 11 15:00:16 2011
    Instance terminated by CKPT, pid = 25581"
    I also looked into the some trace files from around that time and here is what I see:

    "
    Trace file /exlibris/app/oracle/diag/rdbms/aleph20/aleph20/trace/aleph20_fbda_25663.trc
    Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
    With the Partitioning, OLAP, Data Mining and Real Application Testing options
    ORACLE_HOME = /exlibris/app/oracle/product/11
    System name: Linux
    Node name: aleph18.abc.org
    Release: 2.6.9-55.ELsmp
    Version: #1 SMP Fri Apr 20 17:03:35 EDT 2007
    Machine: i686
    Instance name: aleph20
    Redo thread mounted by this instance: 1
    Oracle process number: 24
    Unix process pid: 25663, image: oracle@aleph18.abc.org (FBDA)


    *** 2011-07-11 15:00:11.514
    *** SESSION ID:(422.3) 2011-07-11 15:00:11.514
    *** CLIENT ID:() 2011-07-11 15:00:11.514
    *** SERVICE NAME:(SYS$BACKGROUND) 2011-07-11 15:00:11.514
    *** MODULE NAME:() 2011-07-11 15:00:11.514
    *** ACTION NAME:() 2011-07-11 15:00:11.514

    error 2097 detected in background process
    OPIRIP: Uncaught error 447. Error stack:
    ORA-00447: fatal error in background process
    ORA-02097: parameter cannot be modified because specified value is invalid"

    "race file /exlibris/app/oracle/diag/rdbms/aleph20/aleph20/trace/aleph20_mmon_25587.trc
    Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
    With the Partitioning, OLAP, Data Mining and Real Application Testing options
    ORACLE_HOME = /exlibris/app/oracle/product/11
    System name: Linux
    Node name: aleph18.abc.org
    Release: 2.6.9-55.ELsmp
    Version: #1 SMP Fri Apr 20 17:03:35 EDT 2007
    Machine: i686
    Instance name: aleph20
    Redo thread mounted by this instance: 0 <none>
    Oracle process number: 0
    Unix process pid: 25587, image: oracle@aleph18.abc.org


    *** 2011-07-11 15:00:13.122
    OPIRIP: Uncaught error 447. Error stack:
    ORA-00447: fatal error in background process
    ORA-02097: parameter cannot be modified because specified value is invalid
    ~"

    I did a query for sgadle> connect /as sysdba
    Connected.
    idle> show parameter sga_target;
    **** Hit return to continue ****

    NAME TYPE
    ------------------------------------ -----------
    VALUE
    ------------------------------
    sga_target big integer
    0

    [More:] It looks like there is some problem with the indexing. Some of the jobs ran, but nothing is running right now. I went to the batch queue to try to start it, but it says its already running. Any reason why this would have stalled?
    Heres the error from that first indexing job in ABC01. This was at the end of the Log file: abc01_p_manage_07.00210 log file:

    Oracle error: handle_connection
    ORA-01034: Message 1034 not found; No message file for product=RDBMS,
    ***************************************************
    * No ORACLE connection - process is terminated... *
    ***************************************************
    Can't make pipe.

    Resolution:
    util a/8 shows that you have analyzed tables/indexes.

    You need to follow KB 8192-3980 and correct this.

    Output from util a/8:

    This list should be empty
    if not please use util a 9 to delete statistics

    List of tables and indexes analyzed
    =================================================
    <etc.>

    [From site:] the problem is gone now. Oracle did not shut down since I cleaned the statistics table.

    • Article last edited: 10/8/2013