oracle fuser lk,oracle ORA-00205和09968故障的处理

数据迁移重新部署，在新系统中导入旧系统数据后，oracle系统不能正常startup,依次出现00205和09968故障，环境是centos4.6,oracle 9208,处理如下:

1 查看ORACLE_SID是不是一样

2 查看log日志

find /soft/ora9 -name '*.log' -ls

cat /soft/ora9/product/9.2/rdbms/log/alert_oracle.log

cat /soft/ora9/admin/oracle/bdump/alert_oracle.log

ORA-00202: controlfile: 'ora_control1'

ORA-27037: unable to obtain file status  Linux Error: 2: No such file or directory

Additional information: 3

Fri May 23 21:39:28 2008

ORA-205 signalled during: ALTER DATABASE   MOUNT...

3 找一个正确的pfile，修改使其不用坏的controlfile: 'ora_control1'后，以该正确的pfile启动，

startup pfile='/soft/ora9/admin/oracle/pfile/init.ora.423200815338'

shutdown后删除不正常的spfile，

cd /soft/ora9/product/9.2/dbs/

mv spfileoracle.ora spfileoracle.ora.bak

create spfile='/soft/ora9/product/9.2/dbs/spfileoracle.ora' from pfile='/soft/ora9/admin/oracle/pfile/init.ora.423200815338'；

4 再启动oracle出现ORA-01102: cannot mount database in EXCLUSIVE mode

查看其log,发现：

scumnt: failed to lock /soft/ora9/product/9.2/dbs/lkORACLE exclusive

Fri May 23 22:28:46 2008

ORA-09968: scumnt: unable to lock file  Linux Error: 11: Resource temporarily unavailable

Additional information: 29627

Fri May 23 22:28:46 2008

ORA-1102 signalled during: ALTER DATABASE   MOUNT...

处理方法：

fuser -u /soft/ora9/product/9.2/dbs/lkORACLE

fuser -k /soft/ora9/product/9.2/dbs/lkORACLE

fuser -u /soft/ora9/product/9.2/dbs/lkORACLE

5 shutdown;su - oracle -c "lsnrctl start"

startup ok;测试：alter user system identified by 121qaz2k;

6 建立备份pfile

create pfile='/soft/ora9/admin/oracle/pfile/init.ora.20080524' from spfile;

create spfile='/soft/ora9/product/9.2/dbs/spfileoracle.ora' from pfile='/soft/ora9/admin/oracle/pfile/init.ora.20080524';

7 修改其配置，再次建立controlfile中已经坏的file1,

删除坏的controlfile1: rm -rf /soft/ora9/oradata/oracle/control01.ctl

修改/soft/ora9/admin/oracle/pfile/init.ora.20080524，

增加/soft/ora9/oradata/oracle/control01.ctl后存为

/soft/ora9/admin/oracle/pfile/init.ora.20080524h

关闭db b,

cp /soft/ora9/oradata/oracle/control02.ctl /soft/ora9/oradata/oracle/control01.ctl

以新的pfile启动db:

startup pfile="/soft/ora9/admin/oracle/pfile/init.ora.20080524h"

再次建立spfile

create spfile='/soft/ora9/product/9.2/dbs/spfileoracle.ora' from pfile='/soft/ora9/admin/oracle/pfile/init.ora.20080524h';

关闭db后重启动db,测试ok