sys用户登录loracle 报错ORA-01031: insufficient privileges

本文主要是介绍sys用户登录loracle 报错ORA-01031: insufficient privileges，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

[oracle@orale admin]$ sqlplus sys/oracle@mypl as sysdba

oracle报错:

ORA-01031: insufficient privileges

解决办法

查看是否是密码文件出问题

[oracle@orale admin]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Fri Nov 15 22:32:33 2013
Copyright (c) 1982, 2009, Oracle.  All rights reserved
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> show parameter pass

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
remote_login_passwordfile            string      EXCLUSIVE

SQL> select * from v$pwfile_users;

no rows selected

这里显示果然是密码文件的问题

[oracle@orale dbs]$ pwd
/u01/app/oracle/product/11.2.0/dbs

[oracle@orale dbs]$ ls
hc_DBUA0.dat  init.ora  peshm_DBUA0_0  spfilemypl.ora
hc_mypl.dat   lkMYPL    peshm_mypl_0   spfileplocp.ora
hc_plocp.dat  orapwm    peshm_plocp_0

-- orapwm和我的实例名不相符 应该是orapwmypl

删掉重建 或者改名就可以啦

[oracle@orale dbs]$  rapwd file=/u01/app/oracle/product/11.2.0/dbs/orapwmypl password=oracle;

[oracle@orale dbs]$ sqlplus sys/oracle@mypl as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Fri Nov 15 22:57:23 2013
Copyright (c) 1982, 2009, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options


SQL> show user
USER is "SYS"

$ORACLE_HOME

这篇关于sys用户登录loracle 报错ORA-01031: insufficient privileges的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！

---