LINUX下手工建库,数据库启动一切正常,只有sys用户无法登录,提示用户名密码错误。其余用户包括system都访问正常。上网查了一下,说是remote_login_passwordfile参数问题,查询了一下自己的remote_login_passwordfile参数,参数值也是exclusive,没有问题。最后发现是自己手工创建口令文件的时候把文件名创建错了,oracle默认的口令名的命名规则是orapw$SID,我手工创建时把文件名写成了orapwd$SID。重新创建口令文件:
[oracle@ora11g dbs]$ orapwd file=orapworcl
Enter password for SYS:
输入sys密码,再次使用sys用户登录,问题解决:(口令文件的路径是$ORACLE_HOME/dbs)
[oracle@ora11g dbs]$ sqlplus sys/oracle@orcl as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Sat Dec 10 03:53:14 2016
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> show user
USER is "SYS"
[oracle@ora11g dbs]$ orapwd file=orapworcl
Enter password for SYS:
输入sys密码,再次使用sys用户登录,问题解决:(口令文件的路径是$ORACLE_HOME/dbs)
[oracle@ora11g dbs]$ sqlplus sys/oracle@orcl as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Sat Dec 10 03:53:14 2016
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> show user
USER is "SYS"
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/30207872/viewspace-2130200/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/30207872/viewspace-2130200/