ORA-00604 ORA-00018錯誤處理

【出錯表現】

/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#;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/16381228/viewspace-713268/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/16381228/viewspace-713268/