Cannot create poolableconnectionfactory (ORA-01017: invalid username/password; logon denied

Source: Internet
Author: User
It is a typical sysdba logon problem. You can try these problems for several reasons: 1. log on to the Oracle database homepage [system/self-built Password] --> Management --> User Management --> set the user to "Unlocked" --> then go to the command line --> connect --> OK! 2. First, check the sqlnet file. Sqlnet. authentication_services = (none) Start Password File verification, and then check whether there is an orapw $ oracle_sid file under $ ORACLE_HOME/dbs. Next, check the value of remote_login_passwordfile. I guess the value of remote_login_passwordfile must be none, instead of exclusive. But how can I determine this inference. Remote_login_passwordfile is the init parameter. You can view it through show parameters remote_login_passwordfile or directly view the spfile file. Although spfile is a binary file, however, the content in the content shows the more $ ORACLE_HOME/dbs/spfile $ SID of the text. ora. finally, whether it is remote_login_passwordfile = none. If it is none, the problem should be fixed, that is, the setting of remote_login_passwordfile. First shield sqlnet. sqlnet. authentication_services = (none) enables the local sqlplus "/As sysdba" to go to SQL> startup Mount SQL> show parameters remote_login_passwordfile; the value is none, change the value to exclusive SQL> alter system set remote_login_passwordfile = exclusive scope = spfile; SQL> shutdown immediate SQL> startup SQL> select * from V $ pwfile_users; check whether the result is OK.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.