-
编辑 删除
如何诊断oracle数据库运行缓慢或hang住的问题
为了诊断oracle运行缓慢的问题首先要决定收集哪些论断信息,可以采取下面的诊断方法:1.数据库运行缓慢这个问题是常见还是在特定时间出现如果数据库运行缓慢是一个常见的问题那么可以在问题出现的时候收集这个时期的awr或者statspack报告(通常收集时间间隔是一个小时).生成awr报告的方法如下:awr是通过sys用户来收集持久...
-
编辑 删除
ORA-14452:attempt to create,alter or drop an index on temporary table already in
背景:今天删除用户时提示以下错误：SQL> drop user MDSYS cascade; drop user MDSYS cascade*ERROR at line 1:ORA-00604: error occurred at recursive SQL level 1ORA-14452: attempt to create, alter or drop an index on temporary table already in use
-
编辑 删除
ORA-27125: unable to create shared memory segment
环境：OS:RHEL 6.5DB:oracle 10.2.0.1ORA-27125: unable to create shared memory segmentLinux-x86_64 Error: 1: Operation not permitted
-
编辑 删除
ORA-01157: cannot identify/lock data file 201 ORA-01110: data file 201:
错误现象：查询表空间使用情况的时候提示如下信息：ORA-01157: cannot identify/lock data file 201 - see DBWR trace fileORA-01110: data file 201: '/oradata/outdb/temp01.dbf'
-
编辑 删除
ORA-01092: ORACLE instance terminated. Disconnection forced
错误现象：在做数据库从单机到RAC恢复的过程中，1节点正常启动，2节点无法open，提示如下错误：SQL> alter database open;alter database open*ERROR at line 1:ORA-01092: ORACLE instance terminated. Disconnection forced
-
编辑 删除
ORA-01618: redo thread 2 is not enabled - cannot mount
错误现象：在做数据库从单机到RAC恢复的过程中，1节点正常启动，2节点无法mount，提示如下错误：SQL> alter database mount;alter database mount*ERROR at line 1:ORA-01618: redo thread 2 is not enabled - cannot mount
-
编辑 删除
Fatal NI connect error 12170
巡检系统发现alert日志非常大，都已经好几G，打开一看，里面如下的错误：Fatal NI connect error 12170. VERSION INFORMATION: TNS for Linux: Version 11.2.0.4.0 - Production Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - ...
-
编辑 删除
ORA-01940: cannot drop a user that is currently connected
oracle删除用户时有如下提示：错误提示 SQL> DROP USER TMSTEST cascade ;DROP USER TMSTEST cascade*ERROR at line 1:ORA-01940: cannot drop a user that is currently connected这个说明有seesion连接到了这个用户...
