ORA-00600: internal error code, arguments
ORA-00600: internal error code, arguments
Errors in file /oracle/app/product/10.2/db/admin/wgysmy/udump/wgysmy1_ora_839840.trc:
ORA-00600: internal error code, arguments:
跟踪文件发现
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments:
Current SQL statement for this session:
UPDATE EW_Action SET Code = :p0, Name = :p1, Parent_Id = :p2, Type_Id = :p3, State = :p4 WHERE Id = :p5
ORA-12542: TNS:address already in use
ORA-12542: TNS:address already in use
Cause: Specified listener address is already being used.
Action: Start your listener with a unique address.
Pls-00302: Component ‘Get_checkpoint_scns’ Must Be Declared
在red hat enterprise linux AS 4.7环境下的 Oracle 10.2.0.1的stream测试环境升级到10.2.0.3后主库报错：
Streams CAPTURE C001 with pid=23, OS id=7442 stopped
Tue Mar 30 14:03:41 2010
Errors in file /data/oracle/admin/source/bdump/source_c001_7442.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-06550: line 1, column 58:
PLS-00302: component ‘GET_CHECKPOINT_SCNS’ must be declared
ORA-06550: line 1, column 37:
PL/SQL: Statement ignored
RMAN-03002: failure of copy command
复制文件时报错：
RMAN-03002: failure of copy command at 09/06/2006 19:31:09
ORA-00235: controlfile fixed table inconsistent due to concurrent update
RMAN-06010: error while looking up datafile: /dev/rdblv_data4_02
ORA-01578: ORACLE data block corrupted
ERROR:
ORA-01578: ORACLE data block corrupted (file # 4, block # 558)
ORA-01110: data file 4: ‘/data/oracle/oradata/primary/users01.dbf’
从实际出发Oracle数据库分配内存的法则真的可行吗？
Oracle数据库分配内存的法则真的实用吗？
首先不管是在网络上或行业里面确实上流传着给Oracle数据库分配内存的一条法则：
把80%的内存分配给Oracle使用，而又将这80%的内存分配80%给Oracle的 SGA，
剩下的20%分给Oracle的PGA。
ogfile被删除如何恢复
ogfile被删除如何恢复
数据库的logfile被rm删除，每个logfile group仅有一个logfile member，当该logfile变为current时发现问题。
数据库仍然可以正常运行，但是LNS进程报错称找不到被删除的logfile。我们使用lgwr async模式传输redo到远端physical standby，physical standby无法得到被删除的logfile。
