01 2019 档案

plsql developer连接oracle 12.2报错 ora-28040 No matching authentication protocol
摘要：使用plsql连接时，发现报ora-28040 No matching authentication protocol 赶紧查了查MOS，原来在默认情况下Oracle12.2对客户端版本有限制， 解决方法：升级Oracle客户端或者修改sqlnet.ora中的以下两个参数控制： SQLNET.ALL 阅读全文
posted @ 2019-01-12 15:27 子鱼猴 阅读(6720) 评论(0) 推荐(0)
Oracle 12.2 报错：ORA-12012: error on auto execute of job "SYS"."ORA$AT_OS_OPT_SY_7458"
摘要：alert报错2019-01-12T10:10:11.499130+08:00Errors in file /u01/app/oracle/diag/rdbms/rac1/rac112/trace/rac112_j000_119621.trc:ORA-12012: error on auto exe 阅读全文
posted @ 2019-01-12 10:26 子鱼猴 阅读(2373) 评论(0) 推荐(0)
ORA-04021: timeout occurred while waiting to lock object
摘要：ORA-04021: timeout occurred while waiting to lock object 某个应用正在锁定该表或者包表为select b.SID,b.SERIAL#,c.SQL_TEXTfrom v$locked_object a, v$session b, v$sqlare 阅读全文
posted @ 2019-01-10 19:54 子鱼猴 阅读(950) 评论(0) 推荐(0)
记一次 oracle 12.2 RAC : Transaction recovery: lock conflict caught and ignored
摘要：节点一 alert日志： PDB(17):Transaction recovery: lock conflict caught and ignored PDB(17):Transaction recovery: lock conflict caught and ignored PDB(17):Tra 阅读全文
posted @ 2019-01-09 14:12 子鱼猴 阅读(1097) 评论(0) 推荐(0)