-
编辑 删除
几个定位、查找session的sql语句
--long time running sessionSELECT s1.sid,s1.SERIAL# ,s1.username,totalwork,last_update_time,elapsed_seconds,messageFROM v$session s1, v$session_longops s2WHERE s1.serial#=s2.serial# and s1.sid=s2.sid...
-
编辑 删除
遇到10g的bug
/opt/oracle/product/10g/network/log/listener.log出现如下语句:WARNING: Subscription for node down event still pending查证得出是10g的bug验证方法：$ ps -ef | grep tnslsnrora10g 8909 1 0 Sep 15 ? 902:44 ...
-
编辑 删除
ORA-30012: undo tablespace 'UNDO_TBS' does not exist or of wrong type
oracle applications clone不成功导致30012错误，具体原因还未能查明，解决步骤如下：[@more@][oraprod@erp ~]$ sqlplus / as sysdbaSQL*Plus: Release 10.2.0.2.0 - Production on Mon Aug 27 13:56:31 2007Copyright (c) 1982, 2005, Oracle. All Rights Reserved.Connected to an idle instance.SQL> startupORACLE instance started.Total System Global Area 599785472 bytesFixed Size 1262176 bytesVariable Size 427822496 bytesDatabase Buffers 159383552 bytesRedo Buffers
-
编辑 删除
ORA-27300: OS system dependent operation:spcdr:9261:4200 failed with status: 997
Thu Dec 27 22:04:27 2007Process m000 died, see its trace fileThu Dec 27 22:04:27 2007ksvcreate: Process(m000) creation failedThu Dec 27 22:05:27 2007Process startup failed, error stack:Thu Dec 27 22:0...
-
编辑 删除
Rac opatch小补丁之后其中一实例不能启动
Normal 0 7.8 磅 0 2 false false false EN-US ZH-CN X-NONE MicrosoftInternetExplor...
