|
  
- UID
- 5005
- 帖子
- 562
- 精华
- 20
- 积分
- 439
- 人气值
- 55 点
- 努力值
- 1074 点
- 推广注册人数
- 0 个人
- 阅读权限
- 100
- 在线时间
- 170 小时
- 注册时间
- 2006-9-11
- 最后登录
- 2008-11-29
  
|
楼主
发表于 2006-11-7 09:10
| 只看该作者
ORA-09817 和文件系统不能写解决全过程. 这是没办法的办法,一般不建议这样操作..
test:/SoftInst$> sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Nov 6 16:27:52 2006
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-09817: Write to audit file failed.
IBM AIX RISC System/6000 Error: 89: Invalid file system control data detected
ORA-01075: you are currently logged on
主题: OERR: ORA-9945 Unable to initialize the audit trail file
文档 ID: 注释:21093.1 类型: REFERENCE
上次修订日期: 08-JUN-1999 状态: PUBLISHED
Error: ORA-9945
Text: Unable to initialize the audit trail file
---------------------------------------------------------------------------
Cause: ORACLE unable to write header information to the file being used as
the audit trail.
Action: Check the UNIX error number for a possible operating system error. If
there is no error, contact ORACLE customer support.
rd_cp1:/app/oracle/OraHome1$> errpt | more
IDENTIFIER TIMESTAMP T C RESOURCE_NAME DESCRIPTION
EA88F829 1106143006 I O SYSJ2 USER DATA I/O ERROR
EA88F829 1106142906 I O SYSJ2 USER DATA I/O ERROR
EA88F829 1106142806 I O SYSJ2 USER DATA I/O ERROR
EA88F829 1106142706 I O SYSJ2 USER DATA I/O ERROR
EA88F829 1106142606 I O SYSJ2 USER DATA I/O ERROR
EA88F829 1106142506 I O SYSJ2 USER DATA I/O ERROR
EA88F829 1106142406 I O SYSJ2 USER DATA I/O ERROR
EA88F829 1106142306 I O SYSJ2 USER DATA I/O ERROR
EA88F829 1106142206 I O SYSJ2 USER DATA I/O ERROR
EA88F829 1106142106 I O SYSJ2 USER DATA I/O ERROR
---------------------------------------------------------------------------
LABEL: J2_USERDATA_EIO
IDENTIFIER: EA88F829
Date/Time: Mon Nov 6 15:19:49 BEIST 2006
Sequence Number: 695
Machine Id: 00CE489B4C00
Node Id: test
Class: O
Type: INFO
Resource Name: SYSJ2
Description
USER DATA I/O ERROR
Probable Causes
ADAPTER HARDWARE OR MICROCODE
DISK DRIVE HARDWARE OR MICROCODE
SOFTWARE DEVICE DRIVER
STORAGE CABLE LOOSE, DEFECTIVE, OR UNTERMINATED
Recommended Actions
CHECK CABLES AND THEIR CONNECTIONS
INSTALL LATEST ADAPTER AND DRIVE MICROCODE
INSTALL LATEST STORAGE DEVICE DRIVERS
IF PROBLEM PERSISTS, CONTACT APPROPRIATE SERVICE REPRESENTATIVE
Detail Data
JFS2 MAJOR/MINOR DEVICE NUMBER
0028 0002
FILE SYSTEM DEVICE AND MOUNT POINT
/dev/fslv00, /app
---------------------------------------------------------------------------
由于无法正常关闭DB ，只有采取最危险的方法去DOWN DB
lsnrctl stop LISTENER
ps -ef | grep ora_
kill -9 1036396
kill -9 1097756
kill -9 1134714
kill -9 1146960
kill -9 1159362
kill -9 1167500
kill -9 1269822
kill -9 1339446
kill -9 1343564
kill -9 1359994
kill -9 1437892
kill -9 1454140
kill -9 1646626
kill -9 1650726
kill -9 1700070
kill -9 2035866
kill -9 2089192
kill -9 2117820
kill -9 2142426
kill -9 2187426
kill -9 2224166
kill -9 2232320
kill -9 2293818
fuser -uc /app
fuser -kuc /app
umount /app/oracle/OraHome1/oradata/testdb
umount /app/oracle/OraHome1/flash_recovery_area
fsck -y /app
The current volume is: /dev/fslv00
Primary superblock is valid.
*** Phase 1 - Initial inode scan
*** Phase 2 - Process remaining directories
*** Phase 3 - Process remaining files
*** Phase 4 - Check and repair inode allocation map
*** Phase 5 - Check and repair block allocation map
Block allocation map is corrupt (FIXED)
Superblock marked dirty because repairs are about to be written.
File system is clean.
Superblock is marked dirty (FIXED)
All observed inconsistencies have been repaired.
test:/#> mount /app
test:/#> df -k
test:/#> mount /app/oracle/OraHome1/oradata/testdb
test:/#> mount /app/oracle/OraHome1/flash_recovery_area
su - oracle
sqlplus "/as syusdba"
sql>startup
lsnrctl start LISTENER
[ 本帖最后由 laozhu 于 2007-1-17 17:50 编辑 ] |
提供Oracle ERP(EBS 11i/R12)高性能系统架构方案,实施和优化以及Oracle DBA优化和培训
msn:zlc158@hotmail.com |
|
发表于 2006-11-9 15:00
|