trouble shooting
文章平均质量分 73
Ora-onway
Follow your dreams and transform your life----Walking on the way oracle.
展开
-
SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled
平常都用sys,system用户使用autotrace,今天使用其他用户执行set autotrace 的时候报错:SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabledSP2-0611: Error enabling STATISTICS report是该用户没有授予PLUS原创 2013-11-19 16:28:41 · 5146 阅读 · 0 评论 -
备库重新编译导致的ora-16000 :database open for read-only access
今天,一个开发来找我,说是备库的一个用户执行存储过程报错(我们的备库是ora11.2.0.3的active standby)。错误信息如下: ora-00604:error occurred at recursive SQL level 1 ora-16000 :database open for read-only access 看到这个错误,作为一个ora菜鸟,原创 2013-11-11 14:32:18 · 9349 阅读 · 1 评论 -
lots of invalid username/password lead to login hang(library cache lock)
很早之前就遇到过ji转载 2014-04-17 21:06:42 · 2325 阅读 · 0 评论 -
ORA-31693, ORA-02354 and ORA-01555 with Export Datapump
SymptomsORA-31693: Table data object "YXFUND"."MF_NOTTEXTANNOUNCEMENT" failed to load/unload and is being skipped due to error:ORA-02354: error in exporting/importing dataORA-01555: snapshot t原创 2014-08-12 12:32:43 · 3270 阅读 · 0 评论 -
BUG:mysql 5.6 Invalid use of GRANT/REVOKE command breaks replication
bug描述:当使用revoke,grant命令收回,授予权限出错时(语法错误除外),会导致主从同步异常终止。如:mysql> revoke select on *.* from aaa;ERROR 1141 (42000): There is no such grant defined for user 'aaa' on host '%' 该用户没有该权限却执行了回收该权限原创 2015-01-09 14:37:19 · 1423 阅读 · 0 评论 -
Scan IP relocate/failover后其他网段无法ping通
集群单节点在重启或者手动srvctl relocate scan_listener后,集群所在网段ping IP,VIP,SCAN IP正常,其他网段ping SCAN IP 不通。原因是路由的ARP表没有随之而跟新。需要手动更新。 /sbin/arping -U -c 3 -I my oracle support说明如下:Bug 134409原创 2014-12-24 11:03:46 · 1243 阅读 · 0 评论 -
oracle11.2.0.3中ORACLE_OCM用户报错12012和29280错误的解决
1. 问题描述Alertlog 出现如下错误:Errorsin file/oracle/11.2.0.3/oracle/diag/rdbms/fssms/fssms2/trace/fssms2_j002_17105234.trc:ORA-12012:error on auto execute of job"ORACLE_OCM"."MGMT_CONFIG_JOB_2_2转载 2014-12-31 09:40:23 · 1437 阅读 · 0 评论