【Bug】Bug 11827204: NON-OSDBA USERS WITH LOCAL CONNECTIONS: ORA-15025 ORA-27041

数据库版本：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

####敬畏流程，正确做事####

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

转载于:http://blog.itpub.net/22664653/viewspace-708994/