ORA-01017 Invalid Username Password when connecting to 11g database from 9i client

Question

I m trying to connect to a schema on 11g  v11 2 0 1 0  from a PC with 9i  v9 2 0 1  client  It seems to connect fine to some schemas  but not this one - it comes back with a ORA-01017 Invalid Username Password error every time   The username and password are DEFINITELY correct - can anyone think of a reason why this wouldn t work    Are there any fundamental incompatibilities between 9i and 11g

User · Answer

I am not an expert  If you are getting ORA-01017 while trying to connect HR schema from SQL Developer in Oracle 11g Please try to unlock the  HR as follows  alter user HR identified by hr DEFAULT tablespace users temporary tablespace temp account unlock

User · Answer

Credentials may be correct and something else wrong  I based my pluggable DB connection string on its container DB  Instead of the original parent example com service name the correct appeared to be pluggable example com

User · Answer

I know this post was about 11g  but a bug in the 12c client with how it encrypts passwords may be to blame for this error if you decide to use that one and you   Don t have the password case-sensitivity issue  i e  you tried ALTER SYSTEM SET SEC CASE SENSITIVE LOGON   FALSE and resetting the password and still doesn t work   Put quotes around your password in your connection string and it still doesn t help  You ve verified all of your environmental variables  ORACLE HOME  PATH  TNS ADMIN   and the TNS ADMIN registry string at HKLM Software Oracle KEY OraClient12Home is in place  You ve verified your connection string and user name password combination works in Net Manager  and You can connect using SQL Plus  Oracle SQL Developer using the same credentials   All the basic checks  Fix   Try setting HKLM System CurrentControlSet Control Lsa FIPSAlgorithmPolicy Enabled to 0 in the registry  regedit  to disable FIPS  Oracle ManagedDataAccess and ORA-01017  invalid username password  logon denied ORA-01005 error connecting with ODP Net https   community oracle com thread 2557592 start 0 amp tstart 0 https   dba stackexchange com questions 142085 ora-01017-invalid-username-passwordlogon-denied 142149 142149

User · Answer

I had a similar issue some time ago  You must be careful with quotes and double quotes  It s recommended to reset the user password  using a admin credentials   ALTER USER user name IDENTIFIED BY new password    But don t use double quotes in both parameters

User · Answer

You may connect to Oracle database using sqlplus   sqlplus   as sysdba    Then create new users and assign privileges   grant all privileges to dac

User · Answer

The user and password are DEFINITELY incorrect  Oracle 11g credentials are case sensitive   Try ALTER SYSTEM SET SEC CASE SENSITIVE LOGON   FALSE  and alter password   http   oracle-base com articles 11g case-sensitive-passwords-11gr1 php

User · Answer

I had the same issue and put double quotes around the username and password and it worked  create public database link  opps  identified by  opps  using  TEST

User · Answer

I had the same error  but while I was connected and other previous statements in a script ran fine before   So the connection was already open and some successful statements ran fine in auto-commit mode  The error was reproducable for some minutes  Then it had just disappeared  I don t know if somebody or some internal mechanism did some maintenance work or similar within this time - maybe   Some more facts of my env    11 2 connected as  sys as sysdba operations involved     reading from all tables  all views and granting select on them for another user

User · Answer

I also got the same sql error message when connecting through odp net via a Proxy User    My error was that my user was created with quotation marks  e g   rockerolf   and I then also had to specify my user in the connectionstring as User Id   rockerolf      In the end I ended up deleting the user with the quotation marks and create a new one without     face palm

User · Answer

Oracle 11 G and 12 C versions suggest to use more complex passwords  Although there is no issues during the user creation  The password must be alphanumeric and with special character   Verify the password version and status of the user   select   from dba users where username    lt user name gt     Amend it to be like below in case of 11G 12C   alter user  lt user name gt  identified by Pass2019     Now test connection

User · Answer

If all else fails  try resetting the password to the same thing  I encountered this error and was unable to work around it  but simply resetting the password to the same value resolved the problem

User · Answer

for oracle version 12 2 x users cannot login using case insensitive passwords  even though SEC CASE SENSITIVE LOGON   FALSE if PASSWORD VERSIONS of user is not 10g   following sql should show the PASSWORD VERSIONS for a user   select USERNAME ACCOUNT STATUS PASSWORD VERSIONS from dba users  USERNAME          ACCOUNT STATUS    PASSWORD VERSIONS  ---------------   --------------    ----------------- dummyuser         OPEN              11G 12C   to make PASSWORD VERSIONS compatible with 10g  add modify line in sqlnet ora of database to have SQLNET ALLOWED LOGON VERSION SERVER 8 restart database change expire password for existing user new users created will also have same settings after above steps PASSWORD VERSIONS should be something like this  select USERNAME ACCOUNT STATUS PASSWORD VERSIONS from dba users  USERNAME          ACCOUNT STATUS    PASSWORD VERSIONS  ---------------   --------------    ----------------- dummyuser         OPEN              10G 11G 12C

User · Answer

The tip on Oracle s OTN    Don t type your password in TOAD when you try to connect and let it popup a dialog box for your password  Type the password in there and it will work  Not sure what they ve done in TOAD with passwords but that is a workaround  It has to do with case sensitive passwords in 11g  I think if you change the password to all upper case it will work with TOAD  https   community oracle com thread 908022

User · Answer

I had a similar problem recently with Oracle 12c  I created a new user with a lower case password and was able to login fine from the database server but all clients failed with an ORA-01017  The fix turned out to be simple in the end  reset the password to upper case  but took a lot of frustrating effort to get there

User · Answer

I also had the similar problem recently with Oracle 12c  It got resolved after I changed the version of the ojdbc jar used  Replaced ojdbc14 with ojdbc6 jar

[oracle] ORA-01017 Invalid Username/Password when connecting to 11g database from 9i client

Examples related to oracle

Examples related to oracle11g

Examples related to oracle9i