12c中报错ORA-28040 No matching authentication protocol 或 ORA-01017 invalid username password
现象在Oracle 12c中，本地sqlplus / as sysdba可以正常登陆，但是SYS用户和普通用户远程都不能登陆，报错“ORA-01017: invalid username/passwo ... 阅读全文
分类： Oracle
Detailed Overview of Connecting Oracle to MySQL Using DG4ODBC Database Link (Doc ID 1320645.1)
APPLIES TOMySQL Connectors - Version 3.51 to 6.8 [Release 3.51 to 6.8Oracle Database - Enterprise ... 阅读全文
大页配置错误导致内存耗尽进而导致PMON (ospid: 12917): terminating the instance due to error 471
现象客户反馈说有一个库不能启动，报错SQL> starORACLE instance started.Total System Global Area 7918845952 byteFixe ... 阅读全文
rman在rac或ASM环境做增量恢复时报错RMAN-06094 datafile 1 must be restored
现象rman先做了全量的resotore+recover操作，然后还原增量的控制文件，然后做增量的recover操作，结果报错了RMAN> recover databaStarting recover at 27-FEB-2 ... 阅读全文
rman全量+增量恢复报错ORA-01152: file 1 was not restored from a sufficiently old backup
现象rman在做完增量恢复操作后，执行“alter database open resetlogs;”，报错：ORA-01152: file 1 was not restored from a suf ... 阅读全文
Oracle创建控制文件时报错ORA-15173
现象创建控制文件时报错RMAN-00571: ==========================================================RMAN-00569: ===== ... 阅读全文
ORA-15040 diskgroup is incomplete错误解决
现象在rac环境中，还原控制文件的时候，报错了RMAN> restore controlfile from '/rman/control_at0m09cl_1_1.ctl'Starting restore at 27-FEB-2 ... 阅读全文
ORA-00904: "WM_CONCAT": invalid identifier错误解决
现象若在创建数据库的时候没有创建WMSYS用户，则在SQL或PL/SQL中有用到WM_CONCAT函数的时候就会报ORA-00904的错误。SYS@lhrsdb> SELECT WM_CONCA ... 阅读全文
ORA-15204: database version 11.2.0.4.0 is incompatible with diskgroup DATA
现象在执行rman还原控制文件时，报错了，“ORA-15204: database version 11.2.0.4.0 is incompatible with diskgroup DATA”RM ... 阅读全文
RMAN-06100: no channel to restore a backup or copy of datafile
现象今天在还原一套rac库的时候，执行restore命令报错了：“RMAN-06100: no channel to restore a backup or copy of datafile”RMAN ... 阅读全文
