今天新创建了一个etl用户,尝试登录数据,提示如下的错误.
[etl@node1 ~]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.1.0 Production on Fri Feb 28 15:30:09 2014
Copyright (c) 1982, 2009, Oracle. All rights reserved.
SQL> connect hxl/hxl
ERROR:
ORA-00604: error occurred at recursive SQL level 1
ORA-01115: IO error reading block from file (block # )
ORA-01110: data file 1: '+DATA/racdb/datafile/system.256.840531607'
ORA-15081: failed to submit an I/O operation to a disk
ORA-02002: error while writing to audit trail
ORA-00604: error occurred at recursive SQL level 1
ORA-01115: IO error reading block from file (block # )
ORA-01110: data file 1: '+DATA/racdb/datafile/system.256.840531607'
ORA-15081: failed to submit an I/O operation to a disk
查看下该用户的所属主情况
[etl@node1 ~]$ id etl
uid=503(etl) gid=503(etl) groups=503(etl)
可以看出etl用户在etl下,我们需要将该用户纳入到组dba和asmdba
gpasswd -a etl dba
gpasswd -a etl asmdba
重新登录后,重新登录数据库,问题解决.
[etl@node1 ~]$ id etl
uid=503(etl) gid=503(etl) groups=503(etl),502(dba),506(asmdba)
[etl@node1 ~]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.1.0 Production on Fri Feb 28 15:34:50 2014
Copyright (c) 1982, 2009, Oracle. All rights reserved.
SQL> connect hxl/hxl
Connected.
SQL> select * from dual;
D
-
X
SQL>
-- The End --
阅读(5371) | 评论(0) | 转发(0) |
