【出錯表現】
/u/oracle/product/admin/hrm/udump/hrm_ora_31301.trc
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
ORACLE_HOME = /u/oracle/product/9.2.0.4
System name: Linux
Node name: hrmdb
Release: 2.6.9-22.ELsmp
Version: #1 SMP Mon Sep 19 18:32:14 EDT 2005
Machine: i686
Instance name: hrm
Redo thread mounted by this instance: 1
Oracle process number: 21
Unix process pid: 31301, image: oracle@hrmdb (TNS V1-V3)
*** SESSION ID:(72.5120) 2011-12-12 15:08:02.650
*** 2011-12-12 15:08:02.650
ksedmp: internal or fatal error
ORA-00604: 患癹? SQL ?Ω 1 祇ネ岿粇
ORA-00018: 禬筁顶琿?穨计ヘ??
ORA-00018: 禬筁顶琿?穨计ヘ??
ORA-00018: 禬筁顶琿?穨计ヘ??
ORA-06512: ? "HRM.P_GETOVT_ISOVER_SAVE", line 864
ORA-06512: ? line 1
Current SQL statement for this session:
BEGIN P_GETOVT_ISOVER_SAVE(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15); END;
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
Cannot find symbol in /lib/tls/libc.so.6.
ksedmp()+269 call ksedst()+0 0 ? 0 ? 0 ? 0 ? B7BC1402 ?
0 ?
ksupop()+3069 call ksedmp()+0 3 ? 97423640 ? 974A013C ? 0 ?
【分析問題】
SQL> select name,value from v$parameter where name= 'processes';
NAME VALUE
-------------- ----------------------------------------------------------------
processes 250
SQL> show parameter process
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes integer 1
db_writer_processes integer 1
job_queue_processes integer 10
log_archive_max_processes integer 2
processes integer 250
SQL> show parameter session
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
java_max_sessionspace_size integer 0
java_soft_sessionspace_limit integer 0
license_max_sessions integer 0
license_sessions_warning integer 0
logmnr_max_persistent_sessions integer 1
mts_sessions integer 275
session_cached_cursors integer 0
session_max_open_files integer 10
sessions integer 280
shared_server_sessions integer 275
--默認參數sessions＝processes*(1＋10％）＋5
SQL> select count(*) from x$ksuse where bitand(ksspaflg,1) !=0 ;
COUNT(*)
----------
250
【解決方法】
1：修改系統連接最大數
SQL> alter system set processes= 400 scope=spfile;
已更改系統.
SQL> startup force;
ORACLE 執行處理已啟動.
Total System Global Area 497995776 bytes
Fixed Size 1337464 bytes
Variable Size 364906376 bytes
Database Buffers 125829120 bytes
Redo Buffers 5922816 bytes
資料庫已掛載.
資料庫已開啟.
SQL> show parameter processes
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
aq_tm_processes integer 0
db_writer_processes integer 1
gcs_server_processes integer 0
global_txn_processes integer 1
job_queue_processes integer 1000
log_archive_max_processes integer 4
processes integer 400
SQL>
2：停某个连接
SQL> select username,sid,serial# from v$session;
SQL> alter system kill session sid,serial#;