求救,数据库连接不上了

[复制链接]
查看11 | 回复2 | 2015-3-4 14:19:44 | 显示全部楼层 |阅读模式
H80 Aix4.3 +hacmp+7133raid +oracle9i
启动数据库的时候A机是好的,B机出现入下错误:
SQL> startup
ORACLE instance started.
Total System Global Area353305832 bytes
Fixed Size
451816 bytes
Variable Size
285212672 bytes
Database Buffers 67108864 bytes
Redo Buffers
532480 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 9 - see DBWR trace file
ORA-01110: data file 9:
'/oracle/app/oracle/product/9.0.1/dbs/D:ORANTDATABASERBS1BYPS.ORA'
同时我发现在A机的'/oracle/app/oracle/product/9.0.1/dbs/
D:ORANTDATABASERBS1BYPS.ORA'文件是存在的。而B机没有
连接数据库时出错:
ora-12571:TNS:包写入程序失败
是何原因,怎样解决。
谢谢!
回复

使用道具 举报

千问 | 2015-3-4 14:19:44 | 显示全部楼层
oerr ora 1157
01157, 00000, "cannot identify/lock data file %s - see DBWR trace file"
// *Cause:The background process was either unable to find one of the data
// files or failed to lock it because the file was already in use.
// The database will prohibit access to this file but other files will
// be unaffected. However the first instance to open the database will
// need to access all online data files. Accompanying error from the
// operating system describes why the file could not be identified.
// *Action: Have operating system make file available to database. Then either
// open the database or do ALTER SYSTEM CHECK DATAFILES.
回复

使用道具 举报

千问 | 2015-3-4 14:19:44 | 显示全部楼层
现在我可以用sqlplus在本机登录,但是具体的应该怎样做,请说的详细一点,非常感谢!
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

主题

0

回帖

4882万

积分

论坛元老

Rank: 8Rank: 8

积分
48824836
热门排行