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

ORA-01017: invalid username/password; logon denied solution

Environment introduction: operating system RHEL6.4 X64, database: ORACLE 11.2.0.4.0; create the database manually under the existing environment, there is no big problem in the process of manual creation of the database, but after the database is created, the local users can log in to the database, including the administrator account. The following error is reported when the remote end of the client cannot log in:

Passing the test or changing the user account password in the database system can not solve the problem, so I thought of the password file of ORACLE.

[oracle@test11g ~] $cd $ORACLE_HOME/ DBs [Oracle @ test11g dbs] $sqlplus / nologSQL*Plus: Release 11.2.0.4.0 Production on Tue Jul 12 12:11:07 2016Copyright (c) 1982, 2013, Oracle. All rights reserved.SQL > connect sys/sysadmin as sysdba # you can log in to Connected.SQL > quitDisconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing options [oracle@test11g dbs] $sqlplus / nologSQL*Plus: Release 11.2.0.4.0 Production on Tue Jul 12 12:12:00 2016Copyright (c) 1982, 2013, Oracle. All rights reserved.SQL > connect system/sysadmin as sysdba # you can log in to Connected.SQL >! [oracle@test11g dbs] $pwd/u01/app/oracle/product/11.2.0/db_1/ dbs [oracle @ test11g dbs] $ls-latotal 36drwxr-xr-x 2 oracle oinstall 4096 Jul 11 19:07 .drwxr-xr-x 74 oracle oinstall 4096 Jul 7 18:27.-rw-rw---- 1 oracle oinstall 1544 Jul 11 19:07 hc_test11g. Dat-rw-r--r-- 1 oracle oinstall 950 Jul 8 10:29 inito11glen.ora.bak-rw-r--r-- 1 oracle oinstall 2851 May 15 2009 init.ora.org-rw-r--r-- 1 oracle oinstall 578 Jul 8 18:22 inittest11g.ora-rw-r- 1 oracle oinstall 24 Jul 11 18:18 lkTEST11G-rw-r- 1 oracle oinstall 3584 Jul 11 19:01 orapwdtest11g-rw-r- 1 oracle oinstall 3584 Jul 8 17:29 orapwdtest11g.org# found a problem with the password file here The file format of the password file in the LINUX system is orapwORACLE_SID, and in my environment ORACLE#_SID=test11g, so the password file should be orapwtest11g, but the current file is called orapwdtest11g, which should be caused by # carelessness, so regenerate the password file [oracle@test11g dbs] $orapwd file=orapwtest11g entries=20 password=sysadmin force=y

# force=y forces the previous password to be overwritten; the password to be reproduced is tested on the client as follows

As shown in the figure above, users can log in through the client.

# Summary: the cause of this error is carelessness. The original password file and the password file specified by ORACLE went wrong due to carelessness in the production process.

# wasted a day to solve this problem, remember to be careful and careful!

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.