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

古城微笑少年丶 2022-01-26 11:59 87阅读 0赞

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

期间 界面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

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

\------------------------------------------------------------------------

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

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

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

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关本地oracle重启后ORA-00119: LOCAL_LISTENER ORA-00132: LISTENER_ORCL

相关 ORA-16038 ORA-19809 ORA-00312 错误解决

相关 listener.ora 、sqlnet.ora 、tnsnames.ora

相关 ORA-01186/ORA-01122/ORA-01110/ORA-01206

相关 ora-19510/ora-27037

相关 07 ORA系列：ORA-01747 或列说明无效 user.table.column, table.column

相关 ORA-01940: cannot drop a user that is currently connected 问题解析

相关 ora-01031:insufficient privileges/ v$pwfile_users

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

相关 ORA-00603 ORA-27504 ORA-27300 ORA-27301 ORA-27302