ORA-01031: insufficient privileges

最新推荐文章于 2024-03-13 13:29:18 发布

原创最新推荐文章于 2024-03-13 13:29:18 发布 · 462 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#oracle #application #database #64bit #c

RAC 专栏收录该内容

47 篇文章

订阅专栏

本文介绍了解决Oracle数据库中ORA-01031错误的方法。通过设置环境变量ORACLE_SID和ORACLE_HOME，成功解决了权限不足的问题，并连接到了数据库。

when you encounter the ORA-01031,you can deal with it by the steps.

cdccrs@node01 trace]$ sqlplus / as sysasm

SQL*Plus: Release 11.2.0.0.2 Beta on Sat Apr 14 22:15:47 2012

Copyright (c) 1982, 2012, Oracle.  All rights reserved.

ERROR:
ORA-01031: insufficient privileges


Enter user-name:

1)export ORACLE_SID=+ASM1

2)export ORACLE_HOME=/u01/app/crshome

[cdccrs@node01 trace]$ sqlplus / as sysasm

SQL*Plus: Release 11.2.0.0.2 Beta on Sat Apr 14 22:30:23 2012

Copyright (c) 1982, 2012, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.0.2 - 64bit Beta
With the Real Application Clusters and Automatic Storage Management options

SQL>