SQL> startup
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3这样的.本来我的机子启动得满正常的.后来由于一个错误.早上一起来就挂了,怎么也启动不了oracle实例,.
大家有没有碰到过这个问题?
lsnrctl stat 下查看,没有启动监听.lsnrctl start 命令后,启动失败, 信息如下Starting /u01/app/oracle/product/9201/bin/tnslsnr: please wait...TNSLSNR for IBM/AIX RISC System/6000: Version 9.2.0.7.0 - Production
System parameter file is /u01/app/oracle/product/9201/network/admin/listener.ora
Log messages written to /u01/app/oracle/product/9201/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.2.47)(PORT=1521)))
TNS-12545: Connect failed because target host or object does not exist
TNS-12560: TNS:protocol adapter error
TNS-00515: Connect failed because target host or object does not exist
IBM/AIX RISC System/6000 Error: 68: Can't assign requested addressListener failed to start. See the error message(s) above...
因为192.168.2.47为服务地址.这个不懂怎么来的.
后来.我改了listener.ora 为127.0.0.1本机地址,
这样启动成功了.可是当去启动实例时.还是如上面的错一样SQL> startup
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3
所以请教各位能者,帮下忙.小弟在这谢过了......
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3这样的.本来我的机子启动得满正常的.后来由于一个错误.早上一起来就挂了,怎么也启动不了oracle实例,.
大家有没有碰到过这个问题?
lsnrctl stat 下查看,没有启动监听.lsnrctl start 命令后,启动失败, 信息如下Starting /u01/app/oracle/product/9201/bin/tnslsnr: please wait...TNSLSNR for IBM/AIX RISC System/6000: Version 9.2.0.7.0 - Production
System parameter file is /u01/app/oracle/product/9201/network/admin/listener.ora
Log messages written to /u01/app/oracle/product/9201/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.2.47)(PORT=1521)))
TNS-12545: Connect failed because target host or object does not exist
TNS-12560: TNS:protocol adapter error
TNS-00515: Connect failed because target host or object does not exist
IBM/AIX RISC System/6000 Error: 68: Can't assign requested addressListener failed to start. See the error message(s) above...
因为192.168.2.47为服务地址.这个不懂怎么来的.
后来.我改了listener.ora 为127.0.0.1本机地址,
这样启动成功了.可是当去启动实例时.还是如上面的错一样SQL> startup
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3
所以请教各位能者,帮下忙.小弟在这谢过了......
起没有起都可以进去,所以这里你修改listener.ora对这个错误都是没有作用的。这里可能是数据库mount和open的时候,有问题,先看看alter<SID>.log有没有什么信息对排错有帮助的。==================================================================
Inthirties关注Oracle数据库 维护 优化,安全,备份,恢复,迁移,故障处理如果你需要帮助或想和我一起学习的请联系
联系方式QQ:370140387
QQ群: 85837884(注明:数据库)
电子邮件:[email protected]
网站: http://www.inthirties.com
==================================================================
alter.ora 找找,看是哪个文件或目录没找到。
TNS-12545: Connect failed because target host or object does not exist
=========================================================================================
ifconfig 看一下你的本机 IP 地址还是不是 192.168.2.47
host是有问题,不过这里的startup的错误和listener并没有直接的关系,还是先看看alter<SID>.log在排查了。
ORA-00202: controlfile: '/oradata/orcl/control01.ctl'
ORA-27063: skgfospo: number of bytes read/written is incorrect
IBM AIX RISC System/6000 Error: 5: I/O error
Additional information: -1
Additional information: 8192
Sat May 16 16:49:08 2009
Errors in file /u01/app/oracle/product/9201/admin/orcl/bdump/orcl_ckpt_303212.trc:
ORA-00221: error on write to controlfile
ORA-00206: error in writing (block 3, # blocks 1) of controlfile
ORA-00202: controlfile: '/oradata/orcl/control03.ctl'
ORA-27063: skgfospo: number of bytes read/written is incorrect
IBM AIX RISC System/6000 Error: 5: I/O error
Additional information: -1
Additional information: 8192
ORA-00206: error in writing (block 3, # blocks 1) of controlfile
ORA-00202: controlfile: '/oradata/orcl/control02.ctl'
ORA-27063: skgfospo: number of bytes read/written is incorrect
IBM AIX RISC System/6000 Error: 5: I/O error
Additional information: -1
Additional information: 8192
ORA-00206: error in writing (block 3, # blocks 1) of controlfile
ORA-00202: controlfile: '/oradata/orcl/control01.ctl'
ORA-27063: skgfospo: number of bytes read/written is incorrect
IBM AIX RISC System/6000 Error: 5: I/O error
Additional information: -1
Additional information: 8192
Sat May 16 16:49:08 2009
CKPT: terminating instance due to error 221
Sat May 16 16:49:08 2009
Errors in file /u01/app/oracle/product/9201/admin/orcl/bdump/orcl_lgwr_221344.trc:
ORA-00345: redo log write error block 184878 count 2
ORA-00312: online log 3 thread 1: '/oradata/orcl/redo03.log'
ORA-27063: skgfospo: number of bytes read/written is incorrect
IBM AIX RISC System/6000 Error: 5: I/O error
Additional information: -1
Additional information: 1024
Instance terminated by CKPT, pid = 303212alert_orcl.log中的错误是这样子的
你是做了什么错误的操作还记得么,报的是有关控制文件的问题,顺便看看存放控制文件的磁盘空间够不够。==================================================================
Inthirties关注Oracle数据库 维护 优化,安全,备份,恢复,迁移,故障处理如果你需要帮助或想和我一起学习的请联系
联系方式QQ:370140387
QQ群: 85837884(注明:数据库)
电子邮件:[email protected]
网站: http://www.inthirties.com