-
编辑 删除
ORA-23515: 实体化视图和/或它们的索引存在于表空间中
第 1 行出现错误:ORA-23515: 实体化视图和/或它们的索引存在于表空间中1、查这个表空间有哪些mview的语句：select table_name, tablespace_name from dba_tableswhere tablespace_name='EXAMPLE' &...
-
编辑 删除
rac 缺失本地节点node1的信息
rac 缺失本地节点node1的信息问题原因:public网卡和private网卡设置反了会出现这个问题要修改网卡的优先级，public的高于private的，具体步骤就是：右键网络邻居－》选择属性－》进入后选择windows菜单里面的高级－...
-
编辑 删除
ORA-01287 from a different database incarnation
SQL> execute dbms_logmnr.add_logfile('/opt/oracle/oradata/archive/1_53_724790729.dbf',dbms_logmnr.removefile);PL/SQL procedure successfully completed.SQL> execute dbms_logmnr.add_logfile('/opt/oracle/...
-
编辑 删除
ORA-07445: exception encountered: [Address not mapped to object]
ORA-07445: exception encountered: core dump [krvrdegsFF()+21] [SIGSEGV] [Address not mapped to object] 未解决，记录一下SQL> SELECT sql_redo FROM v$logmnr_contents; SELECT sql_redo FROM v$logmnr_...
-
编辑 删除
ORA-06544: PL/SQL: internal error, arguments: [56319]
数据库恢复后错误：SQL> create user testuser identified by testuser;create user testuser identified by testuser ...
-
编辑 删除
ORA-01031 insufficient privileges
SQL> conn sys/xxxdb@xxxdb as sysdbaERROR:ORA-01031: insufficient privileges原因：没有密码文件orapwd oracle@standby:~/product/10.2/db_1/network/admin> oerr ora 103101031, 00000, "insufficient privilege...
-
编辑 删除
ORA-00314: log 2 of thread 1, expected sequence# 53 doesn't match 2
SQL> host oerr ora 31400314, 00000, "log %s of thread %s, expected sequence# %s doesn't match %s"// *Cause: The online log is corrupted or is an old version.// *Action: Find and install co...
-
编辑 删除
ORA-00600: internal error code, arguments: [4193],
Sun Jul 18 21:47:20 2010Errors in file /opt/oracle/admin/xxxdb/bdump/xxxdb_j000_4337.trc:ORA-00600: internal error code, arguments: [4193], [362], [536], [], [], [], [], []Sun Jul 18 21:47:23 2010Doin...
-
编辑 删除
ORA-00313: open failed for members of log group
ORA-00313: open failed for members of log group 4 of thread 0ORA-00312: online log 4 thread 0: '/opt/oracle/oradata/xxxdb/standbyredo04.log'ORA-27037: unable to obtain file statusLinux Error: 2: No su...
-
编辑 删除
ORA-01552: cannot use system rollback segment
SQL> conn testhotback/testhotback;Connected.SQL> create table test (id number,name varchar2(10));create table test (id number,name varchar2(10))*ERROR at line 1:ORA-01552: cannot use system roll...
