oracle11g insufficient,ORACLE11GORA-01031:insufficientprivileges

广告一下，我专门给大家翻译外文IT参考资料，想学的，可以关注，也可以关注我个人自己建的博客：http://www.1024sky.cn

ORALCE11G打算手工建库，从其它机器拷整个ORACLE目录过来，使用sqlplus "/ as

sysdba"连DB,报错:ORA-01031: insufficient privileges

-bash-4.1$

sqlplus '/as sysdba'

SQL*Plus:

Release 11.2.0.3.0 Production on Thu Oct 29 15:46:33

2015

Copyright (c)

1982, 2011, Oracle.  All rights

reserved.

ERROR:

ORA-01031:

insufficient privileges

Enter

user-name:

ERROR:

ORA-01017:

invalid username/password; logon denied

Enter

user-name:

ERROR:

ORA-01017:

invalid username/password; logon denied

解决过程：

vi /oracle/product/11.2.0.3/db_1//rdbms/lib/config.c

#define

SS_DBA_GRP "oracle"

#define

SS_OPER_GRP "oracle"

#define

SS_ASM_GRP ""

char

*ss_dba_grp[] = {SS_DBA_GRP, SS_OPER_GRP,

SS_ASM_GRP};

说明数据库使用的group是oracle

修改oracle用户为oracle组，即可：

bash-4.1#

usermod  -g oracle -G dba -u 503 -d /oracle oracle

usermod: group

'oracle' does not exist

-bash-4.1#

groupadd oracle

-bash-4.1#

usermod  -g oracle -G dba -u 503 -d /oracle oracle

十佳经典魔幻片推荐

http://www.dabaiw.cn/movie/28903.html

十佳经典爱情片推

http://www.dabaiw.cn/movie/28901.html

十佳经典武侠片推

http://www.dabaiw.cn/movie/28898.html

十佳经典喜剧片推

http://www.dabaiw.cn/movie/28896.html

十佳经典恐怖片推荐

http://www.dabaiw.cn/movie/28894.html

十佳经典战争片推荐

http://www.dabaiw.cn/movie/28890.html

十佳经典剧情片推荐

http://www.dabaiw.cn/movie/28886.html

十佳经典动画片推荐

http://www.dabaiw.cn/movie/28884.html

影史上震撼人心的百部大片

http://www.dabaiw.cn/movie/27328.html

50部值得一看的欧美经典电影

http://www.dabaiw.cn/movie/27326.html

那些年的香港经典电影TOP47

http://www.dabaiw.cn/movie/26140.html

港台经典电影的古装女神经典片段

http://www.dabaiw.cn/movie/19811.html

100部载入影史的经典非英语电影

http://www.dabaiw.cn/movie/19653.html

中国公认最美丽的电影取景地

http://www.dabaiw.cn/movie/17619.html

-bash-4.1# chown

-R oracle:oracle /oracle

-bash-4.1$ sqlplus '/as sysdba'

SQL*Plus: Release 11.2.0.3.0 Production on Thu Oct 29 15:55:21

2015

Copyright (c) 1982, 2011, Oracle.  All rights

reserved.

Connected to an idle instance.

SQL>

再以sysdba的身份就可以连数据库了