ORA-27300、ORA-27301、ORA-27302、ORA-27303
数据库启动后，修改了相关目录的属组，普通用户登录失败
-
[oracle@dasong ~]$ sqlplus dasong/dasong
SQL*Plus: Release 11.2.0.1.0 Production on Thu Nov 3 09:47:26 2016
Copyright (c) 1982, 2009, Oracle. All rights reserved.
ERROR:
ORA-27140: attach to post/wait facility failed
ORA-27300: OS system dependent operation:invalid_egid failed with status: 1
ORA-27301: OS failure message: Operation not permitted
ORA-27302: failure occurred at: skgpwinit6
ORA-27303: additional information: startup egid = 509 (asmadmin), current egid = 501 (oinstall)
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
[oracle@dasong ~]$
数据库关闭失败
-
[oracle@dasong /]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Thu Nov 3 09:49:33 2016
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected.
SQL> shutdown immediate
ORA-24324: service handle not initialized
ORA-24323: value not allowed
ORA-27140: attach to post/wait facility failed
ORA-27300: OS system dependent operation:invalid_egid failed with status: 1
ORA-27301: OS failure message: Operation not permitted
ORA-27302: failure occurred at: skgpwinit6
ORA-27303: additional information: startup egid = 509 (asmadmin), current egid = 501 (oinstall)
解决方法（以下3选一）：
shutdown abort，重启数据库；
用chown修改回原来的属组；
修改属组（oinstall）的gid为509
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/7417681/viewspace-2128274/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
字段 与 变量 同名造成的sql问题
下一篇：
区分exp&expdp导出的dmp文件
请登录后发表评论
登录
全部评论
最新文章
- 区分exp&expdp导出的dmp文件
- 字段 与 变量 同名造成的sql问题
- Configuring the Reserved Pool
- char, varchar2, nchar, nvarchar2
- ORA-39714: upgrade script utlmmig.sql failed
- Archive log rejected (thread 1 sequence 2200) at host 'standby'
- 数据文件offline后unusable索引造成的问题
- 物理备库open ORA-10458
- lsnrctl start - Linux Error 29 Illegal seek
- oracle dg相关参数
