upgrade to ver.20 and ORA-02097
- 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