Shulou(Shulou.com)06/01 Report--

Today, the customer said that there was an error ora-01017 error when a single instance 11g database of windows system logged in using sqlplus. I did find such an error when I logged in.

I searched a lot of articles on the Internet, but it didn't work even if I tried. Finally, there was a problem with the parameter setting in sqlnet.ora.

Let me tell you how to troubleshoot the problem.

1. The SQLNET.AUTHENTICATION_SERVICES= (NONE) parameter setting in the sqlnet file is correct to SQLNET.AUTHENTICATION_SERVICES= (NTS) in the sqlnet file. This is my problem. After the modification, you can use sqlplus normally.

two。 To reproduce the password file, the database password file command for the oracle database under windows is:

Delete: del D:\ app\ Administrator\ product\ 12.1.0\ dbhome_1\ database\ pwdorcl.ora

Re-establish the password file: orapwd file=D:\ app\ Administrator\ product\ 12.1.0\ dbhome_1\ database\ pwdorcl.ora password=oracle entries=10

If it is the password file of linux or aix system in

$ORACLE_HOME/dbs/

Rebuild command:

Orapwd file=$ORACLE_HOME/dbs/orapsorcl password=oracle entries=10

The value of 3.remote_login_passwordfile, which is NONE, not EXCLUSIVE

For a detailed explanation, see http://blog.itpub.net/31547066/viewspace-2650290/.

4. It may also be because the password is case-sensitive.

In previous versions of oracle, usernames and passwords were case-insensitive, but in 11g, database default passwords were case-sensitive, so we know the fact that when jdbc gives oracle passwords, it becomes uppercase.

Remove the password capitalization sensitive setting for oracle: alter system set sec_case_sensitive_logon=false

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.