ASM单实例数据库进入报ORA-09817、ORA-09945

bug:    进入asm 单实例数据库时报错：

SQL> conn /as  sysdba;
ERROR:
ORA-09817: Write to audit file failed.
Linux Error: 28: No space left on device
ORA-09945: Unable to initialize the audit trail file
Linux Error: 28: No space left on device

查看alter日志：

Thu Jul 22 07:10:44 2010
Unexpected communication failure with ASM instance:
ORA-09945: Unable to initialize the audit trail file
Linux Error: 28: No space left on device
Unexpected communication failure with ASM instance:
ORA-09945: Unable to initialize the audit trail file
Linux Error: 28: No space left on device
Thu Jul 22 07:10:45 2010
Errors in file /u01/app/oracle/admin/jestoo/bdump/jestoo_rvwr_21145.trc:
ORA-38701: Flashback database log 67 seq 67 thread 1: "+DATA1/jestoo/flashback/log_67.341.724898901"
ORA-17503: ksfdopn:2 Failed to open file +DATA1/jestoo/flashback/log_67.341.724898901
ORA-09945: Unable to initialize the audit trail file
Linux Error: 28: No space left on device
*************************************
RVWR encountered an error when writing flashback database logs.
See error stack in alert log.  To avoid crashing the instance,
this instance has turned off flashback database.
*************************************
Thu Jul 22 08:30:57 2010
Process m000 died, see its trace file

出现的原因是

（1）：
[oracle@oracle9i ~]$ df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
                       19G   18G    0   100% /
/dev/sda1              99M   12M   82M  13% /boot
tmpfs                 252M     0  252M   0% /dev/shm

（2）：
[oracle@oracle9i ~]$ top

top - 18:29:56 up 2 days, 20:58,  4 users,  load average: 1.29, 1.41, 1.36
Tasks:  89 total,   3 running,  86 sleeping,   0 stopped,   0 zombie
Cpu(s): 50.0%us, 50.0%sy,  0.0%ni,  0.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Mem:    515340k total,   509068k used,     6272k free,     3088k buffers
Swap:  1048568k total,  1048568k used,        0k free,    62792k cached           ----交换分区占有满了，系统应该是哪里卡死的

 

[oracle@oracle9i ~]$ ps -ef|grep rman           --这个rman进程应该卡死的了
oracle    9120     1 81 00:05 ?        14:55:04 rman app/oracle/product/10.2.0/db_1/bin/rman TARGET sys/viewtoo CATALOG rman001/rman001@TESTDB
oracle   30932 30840  0 18:30 pts/4    00:00:00 grep rman
[oracle@oracle9i ~]$ kill  -9   9120              ---直接干掉这个进程
[oracle@oracle9i ~]$ ps -ef|grep rman
oracle   30940 30840  0 18:30 pts/4    00:00:00 grep rman

解决办法：

 2.1  清理磁盘的空间，删除不需要的些文件

 [oracle@oracle9i ~]$ df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
                       19G   11G  7.2G  59% /
/dev/sda1              99M   12M   82M  13% /boot
tmpfs                 252M     0  252M   0% /dev/shm

  2.2  启动实例：

[oracle@oracle9i ~]$ sqlplus  /nolog

SQL*Plus: Release 10.2.0.4.0 - Production on Thu Jul 22 18:31:30 2010

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

SQL> conn /as  sysdba;
Connected to an idle instance.
SQL> startup
ORACLE instance started.

Total System Global Area  167772160 bytes
Fixed Size                  1266392 bytes
Variable Size             104860968 bytes
Database Buffers           58720256 bytes
Redo Buffers                2924544 bytes
ORA-00205: error in identifying control file, check alert log for more info

查看 alter日志：

ALTER DATABASE   MOUNT
Thu Jul 22 18:31:39 2010
ORA-00202: control file: '+DATA1/jestoo/controlfile/current.261.724802661'
ORA-17503: ksfdopn:2 Failed to open file +DATA1/jestoo/controlfile/current.261.724802661
ORA-15001: diskgroup "DATA1" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup

报错，推断出来应该是ASM的数据库有问题，（应该是系统的空间满了，导致ASM实例跟数据库实例都down的，
查看ASM的alter日志

NOTE: ASMB process exiting due to lack of ASM file activity
Thu Jul 22 16:50:33 2010
Errors in file /u01/app/oracle/admin/+ASM/bdump/+asm_gmon_3713.trc:
ORA-29702: error occurred in Cluster Group Service operation
ORA-29702: error occurred in Cluster Group Service operation
Thu Jul 22 16:50:33 2010
GMON: terminating instance due to error 29702
）
那必须先启动 ASM 实例，然后再启动数据库实例

[root@oracle9i ~]# su   - oracle
[oracle@oracle9i ~]$ export  ORACLE_SID=+ASM

[oracle@oracle9i ~]$ sqlplus  /nolog

SQL*Plus: Release 10.2.0.4.0 - Production on Thu Jul 22 18:38:03 2010

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

SQL> conn /as  sysdba;
Connected to an idle instance.
SQL> startup;
ASM instance started

Total System Global Area   83886080 bytes
Fixed Size                  1265912 bytes
Variable Size              57454344 bytes
ASM Cache                  25165824 bytes
ASM diskgroups mounted
SQL> quit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

然后启动数据库实例：

[oracle@oracle9i ~]$ export  ORACLE_SID=jestoo
[oracle@oracle9i ~]$ sqlplus  /nolog

SQL*Plus: Release 10.2.0.4.0 - Production on Thu Jul 22 18:51:59 2010

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

SQL> conn /as  sysdba;
Connected to an idle instance.
SQL> startup
ORACLE instance started.

Total System Global Area  167772160 bytes
Fixed Size                  1266392 bytes
Variable Size             104860968 bytes
Database Buffers           58720256 bytes
Redo Buffers                2924544 bytes
Database mounted.
Database opened.
SQL>

最后启动监听器:

[oracle@oracle9i ~]$ lsnrctl  start

LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 22-JUL-2010 18:56:04

Copyright (c) 1991, 2007, Oracle.  All rights reserved.

Starting /u01/app/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.4.0 - Production
System parameter file is /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle9i)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oracle9i)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.4.0 - Production
Start Date                22-JUL-2010 18:56:04
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle9i)(PORT=1521)))
Services Summary...
Service "jestoo" has 1 instance(s).
  Instance "jestoo", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

搞定。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/15713890/viewspace-668719/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/15713890/viewspace-668719/