数据库版本:Release 11.2.0.2.0
以非 oracle 用户执行sqlpuls 登录数据库(ps admin 用户是oracle 创建的外部用户,直接执行sqlpus / 便可以登录数据库)
admin@sf1:/home/admin>sqlplus /
SQL*Plus: Release 11.2.0.2.0 Production on Tue Oct 11 10:06:31 2011
Copyright (c) 1982, 2010, Oracle. All rights reserved.
期间 界面hang住 ,中断连接
Last login: Sat Oct 8 14:11:44 2011 from 10.1.165.6
重新登录后,再次执行sqlplus / 遇到如下错误!
admin@sf1:/opt/11202/oracle/products/11.2.0/bin>sqlplus /
SQL*Plus: Release 11.2.0.2.0 Production on Tue Oct 11 10:15:12 2011
Copyright (c) 1982, 2010, Oracle. All rights reserved.
ERROR:
ORA-09945: Unable to initialize the audit trail file
Linux-x86_64 Error: 28: No space left on device
ORA-01013: user requested cancel of current operation
admin@sf1:/opt/11202/oracle/products/11.2.0/bin>df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda2 19G 6.3G 12G 35% /
/dev/sda6 1.1T 111G 875G 12% /home
/dev/sda3 19G 18G 0 100% /opt --系统空间短时间内爆满!
原因 触发oracle 的一个bug:
Bug 11827204: NON-OSDBA USERS WITH LOCAL CONNECTIONS: ORA-15025 ORA-27041
=== ODM Issue Clarification ===
PreProduction: non-RAC - 112020 (asm) - 112020 (db) - Linux x86-64
(2.6.18-164.15.1.el5) - No asmlib
Problem occurs when making a sqlplus local connection from a unix id other
than the oracle id, ie with a personal or application unix id.
当使用非oracle 用户组成员登录数据库时,会触发此bug!
------------------------------------------------------------------------
$ . oraenv
ORACLE_SID = [PRLMCD01] ? PRLMCD01
ORACLE_BASE environment variable is not being set since this
information is not available for the current user ID llavoie.
You can set ORACLE_BASE manually if it is required.
$ sqlplus ismdba@PRLMCD01
SQL*Plus: Release 11.2.0.2.0 Production on Fri Feb 18 15:04:10 2011
Copyright (c) 1982, 2010, Oracle. All rights reserved.
------------------------------------------------------------------------
At this point it hangs. Checking the alert log show continuous stream of
error messages:
登录界面hang住,大量如下错误写入alertlog 日志文件中和trace 文件中!
ORA-15025: could not open disk "/dev/mapper/asm-pn02"
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
最终会导致系统空间被上述的错误信息使用的空间占用,导致数据库hang住!
如何暂时的解决:Problem can be stopped by killing the LOCAL process.
当非oracle 用户进行操作时可以使用TNS名来访问数据库!如:
sqlplus user/pwd@TNSNAME
时,并不会发送这样的错误!
The /dev/mapper/asm-* devices are under asmdba group
Additional information:
~~~~~~~~~~~~~~~~~~~~~~~~~
* Job role separation:
asm=oraasm oinstall,asmdba,asmadmin,asmoper,dbalmdb
db=oralmdb oinstall,ddba to these users. However the asm disks are also
partbalmdb,asmdba
* Workaround: Grant asm
of this group, so they do not feel safe with this WA
* file system is 20Gb .. usually 14Gb can be used by the alert log
* This was never a 112010 and is their first ever ASM implementation.
* Pre-production. Go-live is scheduled for end of March.
DIAGNOSTIC ANALYSIS:
--------------------
* OS job separation is proper.
* Non-OSDBA users should be granted access to the database.
WORKAROUND:
-----------
* Grant asmdba to these users. However the asm disks are also part of this
group, so they do not feel safe with this WA
bug 相关属性:
类型 B - Defect 已在产品版本中修复 -
严重性 2 - Severe Loss of Service 产品版本 11.2.0.2.0
状态 33 - Suspended, Req'd Info not Avail 平台 226 - Linux x86-64
创建时间 02-Mar-2011 平台版本 NO DATA
更新时间 22-Jul-2011 基本 Bug -
数据库版本 11.2.0.2.0
影响平台 Generic
产品源 Oracle
####敬畏流程,正确做事####