Posts Tagged ‘oracle’
笔记本上安装的 oracle 9208数据库在演示RMAN备份时发现system01.dbf有一坏块，用dbv检查如下：
C:\Documents and Settings\bwen>dbv file=D:\ oracle \oradata\bright\system01.dbf blocksize=8192
DBVERIFY: Release 9.2.0.8.0 - Production on 星期二 11月 17 15:15:25 2009
Copyright (c) 1982, 2002, oracle Corporation. All rights reserved
DBVERIFY - 验证正在开始 : FILE = D:\ oracle \oradata\bright\system01.dbf
汇入的页23523 - 可能是介质损坏
***
Corrupt block relative dba: 0×00405be3 (file 1, block 23523)
Fractured block found during dbv:
Data in bad block [...]
一客户报RAC一节点的CRS无法启动，通过VPN远端连过去检查crs，如下：
# crsctl check crs
Failure 1 contacting CSS daemon
Cannot communicate with CRS
Cannot communicate with EVM
检查crs进程：
# ps -ef | grep css
root 6929 1 0 19:56 ? 00:00:00 /bin/sh /etc/init.d/init.cssd fatal
root 6960 6928 0 19:56 ? 00:00:00 /bin/sh /etc/init.d/init.cssd startcheck
root 6963 6929 0 19:56 [...]
一客户在用TSM备份 oracle 时经常报如下错误：
04/09/2009 07:45:43 PM
ANE4994S (Session: 836, Node: SZ-DB-SRV) TDPO LinuxAMD64
ANU0599 TDP for oracle : (12823): =>(SZ-DB-SRV)
ANU2602E The object /sz-db//c-3379378948-20090409-00 was not found on the TSM Server (SESSION: 836)
04/09/2009 09:11:17 PM
ANE4991I (Session: 837, Node: SZ-DB-SRV) TDPO LinuxAMD64
ANU0599 TDP for oracle : (12823): =>(SZ-DB-SRV)
ANU2535I File /sz-db//c-3379378948-20090409-00 = 56623104 bytes sent (SESSION: 837)
同事在测NBU调用RMAN进行备份时，出现如下错误：
Both single and double quotes(’ or ”) are accepted for a quoted-string.
Quotes are not required unless the string contains embedded white-space.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00552: syntax error in command line arguments
RMAN-01009: syntax error: found “dot”: expecting one of: “double-quoted-string, equal, identifier, single-quoted-string”
RMAN-01007: at line 2 column 1 file: command line arguments
Script [...]
客户数据库报如下错误：
Fri Feb 6 22:00:16 2009
Errors in file / oracle /admin/pnbrw/bdump/pnbrw2_j000_14187.trc:
ORA-12012: error on auto execute of job 8887
ORA-20000: ORA-20000: Content of the tablespace specified is not permanent or tablespace name is invalid
ORA-06512: at “SYS.PRVT_ADVISOR”, line 1624
ORA-06512: at “SYS.DBMS_ADVISOR”, line 186
ORA-06512: at “SYS.DBMS_SPACE”, line 1344
ORA-06512: at “SYS.DBMS_SPACE”, line 1560
Fri Feb 6 22:06:48 2009
一客户RAC两节点报如下错误：
ORA-00600: 内部错误代码, 参数: [17285], [0x2A97446380], [4294967295], [0x1DD7B1238], [], [], [], []
ORA-02055: 分布式更新作业失败; 必须执行回退作业
ORA-02055: 分布式更新作业失败; 必须执行回退作业
ORA-00604: 递归 SQL 层次 1 发生错误
ORA-03113: 通讯信道上出现 EOF
oracle RAC出问题时我们往往需要查看其log和trace文件，那么这些log及trace存在哪里呢？下图就是一个log目录结构示意图，较直观的显示了log存放的地方：
客户环境：Linux+ oracle 10.2.0.2+RAC
现象：客户端用sqlplus连接统一服务名时报ORA-12545错误。
－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－
我们先看ORA-12545错误是什么：
[ oracle @orac1 udump]$ oerr ora 12545
12545, 00000, “Connect failed because target host or object does not exist”
// *Cause: The address specified is not valid, or the program being
// connected to does not exist.
// *Action: Ensure the ADDRESS parameters have been entered correctly; the
// most likely incorrect parameter is the node name. [...]
今年6月Gartner公司发布了2007年主流数据库市场分析报告，根据该报告(见下图)，我们可以看到 oracle 继续以48.6%的份额遥遥领先。
Note: Others include InterSystems (0.82%), Hitachi (0.81%), Fujitsu (0.68%), MySQL (0.33%), Ingres (0.23%), Pervasive Software (0.15%) and EnterpriseDB (0.05%).
