os win7旗舰版 oracle11g今天启动服务(OracleServiceORCL OracleOraDb11g_home1TNSListener )后 使用plsqldeveloper正常大概10分钟后 在执行sql语句时 就是一条简单的select语句
然后打开sqlplus连接时也提示
然后我重启OracleServiceORCL 这个服务 重新登录plsqldeveloper时 好像没问题了
然后大概过15分钟 又会出现一模一样的问题初学oracle 谁能帮忙解决下这个问题么。。
然后打开sqlplus连接时也提示
然后我重启OracleServiceORCL 这个服务 重新登录plsqldeveloper时 好像没问题了
然后大概过15分钟 又会出现一模一样的问题初学oracle 谁能帮忙解决下这个问题么。。
alert log 里面有什么错误提示没? 一般出现这个问题,都是SID 或者ORACLE_HOME 不正确造成的..------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
网上资源: http://tianlesoftware.download.csdn.net
相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
DBA1 群:62697716(满); DBA2 群:62697977
然后去上面结果中的目录下找alert_SID.log这里的SID,即你的实例名。看看日志里记录了什么内容。
位置:
$ORACLE_BASE\admin\sid\bdump\alertSID.log
比如:
D:\oracle\product\10.2.0\admin\orcl\bdump\
E:\app\oracle\admin\orcl\adump
这个文件夹下是空的
使用的是oracle 11g
输入这句话提示
ora-00924表或视图不存在
这段时间服务还是好的 只是数据库down掉了
process太多了?
找到了这个log文件了 里面有一大段内容 关注哪些内容?
Errors in file e:\app\oracle\diag\rdbms\orcl\orcl\trace\orcl_smon_6956.trc (incident=25395):
ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], []
Incident details in: e:\app\oracle\diag\rdbms\orcl\orcl\incident\incdir_25395\orcl_smon_6956_i25395.trc
SMON: Parallel transaction recovery slave got internal error
SMON: Downgrading transaction recovery to serial
Trace dumping is performing id=[cdmp_20100420133211]
Tue Apr 20 13:32:25 2010
Errors in file e:\app\oracle\diag\rdbms\orcl\orcl\trace\orcl_smon_6956.trc (incident=25396):
ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], []
ORACLE Instance orcl (pid = 12) - Error 600 encountered while recovering transaction (6, 28) on object 65846.
Errors in file e:\app\oracle\diag\rdbms\orcl\orcl\trace\orcl_smon_6956.trc:
ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], []
Tue Apr 20 13:32:33 2010
Trace dumping is performing id=[cdmp_20100420133233]
Tue Apr 20 13:33:04 2010
Sweep Incident[25396]: completed
Sweep Incident[25395]: completed
Tue Apr 20 13:37:33 2010
SMON: Restarting fast_start parallel rollback
Tue Apr 20 13:37:41 2010
Errors in file e:\app\oracle\diag\rdbms\orcl\orcl\trace\orcl_p000_2772.trc (incident=25455):
ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], []
Errors in file e:\app\oracle\diag\rdbms\orcl\orcl\trace\orcl_smon_6956.trc (incident=25397):
ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], []
Incident details in: e:\app\oracle\diag\rdbms\orcl\orcl\incident\incdir_25397\orcl_smon_6956_i25397.trc
Process debug not enabled via parameter _debug_enable
Tue Apr 20 13:37:49 2010
Sweep Incident[25455]: completed
Tue Apr 20 13:37:49 2010
Errors in file e:\app\oracle\diag\rdbms\orcl\orcl\trace\orcl_pmon_5880.trc:
ORA-00474: SMON process terminated with error
PMON (ospid: 5880): terminating the instance due to error 474
Tue Apr 20 13:37:50 2010
Errors in file e:\app\oracle\diag\rdbms\orcl\orcl\trace\orcl_q001_6988.trc:
ORA-00474: SMON process terminated with error
ORA-1092 : opidrv aborting process Q001 ospid (3208_6988)
Tue Apr 20 13:37:50 2010
ORA-1092 : opidrv aborting process W000 ospid (3208_7700)
Tue Apr 20 13:37:50 2010
Errors in file e:\app\oracle\diag\rdbms\orcl\orcl\trace\orcl_j000_8080.trc:
ORA-00474: SMON 进程因错误而终止
ORA-1092 : opidrv aborting process J000 ospid (3208_8080)
Tue Apr 20 13:37:51 2010
ORA-474 : opidrv aborting process S000 ospid (3208_7200)
Instance terminated by PMON, pid = 5880
select owner, object_name,object_type from dba_objects where object_id=65846;
OWNER
-----------------------------
OBJECT_NAME
-----------------------------------------------------
OBJECT_TYPE
------------------------
SYSMAN
MGMT_JOB_STATE_CHGS_IDX01
INDEX
怎么操作呢。。我刚上手oracle3天。。
执行了这段代码
[sql]alter index MGMT_JOB_STATE_CHGS_IDX01 rebuild ;[/sql]
ora-01418指定的索引不存在
Tue Apr 20 15:33:13 2010
Trace dumping is performing id=[cdmp_20100420153313]
ORACLE Instance orcl (pid = 12) - Error 600 encountered while recovering transaction (6, 28) on object 65846.
Errors in file e:\app\oracle\diag\rdbms\orcl\orcl\trace\orcl_smon_5800.trc:
ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], []
Trace dumping is performing id=[cdmp_20100420153322]
Tue Apr 20 15:33:55 2010
Sweep Incident[29021]: completed
Sweep Incident[29020]: completed
Tue Apr 20 15:38:22 2010
SMON: Restarting fast_start parallel rollback
Tue Apr 20 15:38:31 2010
Errors in file e:\app\oracle\diag\rdbms\orcl\orcl\trace\orcl_p000_8460.trc (incident=29066):
ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], []
Incident details in: e:\app\oracle\diag\rdbms\orcl\orcl\incident\incdir_29066\orcl_p000_8460_i29066.trc
Tue Apr 20 15:38:36 2010
Trace dumping is performing id=[cdmp_20100420153836]
Tue Apr 20 15:38:37 2010
Errors in file e:\app\oracle\diag\rdbms\orcl\orcl\trace\orcl_smon_5800.trc (incident=29022):
ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], []
Incident details in: e:\app\oracle\diag\rdbms\orcl\orcl\incident\incdir_29022\orcl_smon_5800_i29022.trc
Tue Apr 20 15:38:38 2010
Sweep Incident[29066]: completed
SMON: Parallel transaction recovery slave got internal error
SMON: Downgrading transaction recovery to serial
Trace dumping is performing id=[cdmp_20100420153842]
Tue Apr 20 15:38:59 2010
Errors in file e:\app\oracle\diag\rdbms\orcl\orcl\trace\orcl_smon_5800.trc (incident=29023):
ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], []
ORACLE Instance orcl (pid = 12) - Error 600 encountered while recovering transaction (6, 28) on object 65208.
Errors in file e:\app\oracle\diag\rdbms\orcl\orcl\trace\orcl_smon_5800.trc:
ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], []
Tue Apr 20 15:39:06 2010
Trace dumping is performing id=[cdmp_20100420153906]
Tue Apr 20 15:39:38 2010
Sweep Incident[29023]: completed
Sweep Incident[29022]: completed
Tue Apr 20 15:44:06 2010
SMON: Restarting fast_start parallel rollback
Tue Apr 20 15:44:17 2010
Errors in file e:\app\oracle\diag\rdbms\orcl\orcl\trace\orcl_p000_9372.trc (incident=29076):
ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], []
Tue Apr 20 15:44:17 2010
Errors in file e:\app\oracle\diag\rdbms\orcl\orcl\trace\orcl_smon_5800.trc (incident=29024):
ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], []
Incident details in: e:\app\oracle\diag\rdbms\orcl\orcl\incident\incdir_29024\orcl_smon_5800_i29024.trc
Process debug not enabled via parameter _debug_enable
Tue Apr 20 15:44:22 2010
Sweep Incident[29076]: completed
Tue Apr 20 15:44:25 2010
Errors in file e:\app\oracle\diag\rdbms\orcl\orcl\trace\orcl_pmon_7184.trc:
ORA-00474: SMON process terminated with error
PMON (ospid: 7184): terminating the instance due to error 474
Tue Apr 20 15:44:26 2010
Errors in file e:\app\oracle\diag\rdbms\orcl\orcl\trace\orcl_q001_8940.trc:
ORA-00474: SMON process terminated with error
ORA-1092 : opidrv aborting process Q001 ospid (8524_8940)
Tue Apr 20 15:44:26 2010
ORA-1092 : opidrv aborting process W000 ospid (8524_8852)
Instance terminated by PMON, pid = 7184
MGMT_JOB_STATE_CHGS_IDX01
INDEX65208
SYSMAN
PK_MGMT_JOB_ST_CHGS
INDEX
alter index SYSMAN.MGMT_JOB_STATE_CHGS_IDX01 rebuild
alter index SYSMAN.PK_MGMT_JOB_ST_CHGS rebuild
出现了两次?
看起来还有其他原因.
问题很严重, 楼主用的应该是oracle 11g的版本, 可能是Oracle 的bug。 先看下有没有无效对象:-- use sys to run this one
select 'ALTER ' || OBJECT_TYPE || ' '||owner||'.' || OBJECT_NAME || ' COMPILE;'
from all_objects
where status = 'INVALID'
and object_type in ('PACKAGE','FUNCTION','PROCEDURE', 'TABLE', 'VIEW', 'SEQUENCE', 'TRIGGER'); 数据库有没有安装过程有没有异常, 有没有做过升级等操作? 在看看alert log, 有没有其他的错误了数据库down的时候,有没有做什么操作?是否在执行什么SQL? 有可能是某些SQL 触发了某些bug, 导致数据库崩溃.
------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
网上资源: http://tianlesoftware.download.csdn.net
相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
DBA1 群:62697716(满); DBA2 群:62697977
这段代码提示未选定行sql操作只是简单的select
数据库没升级过安装的时候 就是win7都有的问题 操作系统检查不过 改了一个参数就没问题了
你的操作系统也是win7么?
我下载的版本是CNOUG上的推荐的。。如果真是版本问题 那就算了 大不了多重启几次 反正目前也只是学习阶段 没到应用
我以前测试过. 版本问题可能性比较大。 Win7 做实验不太方便,还是XP 兼容性好,买了本本,第一件事,就把WIN7 给格了。
------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
网上资源: http://tianlesoftware.download.csdn.net
相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
DBA1 群:62697716(满); DBA2 群:62697977