Monday, April 21, 2008

Password Authentication in Oracle 11g

Normally, when we connect to Oracle, we don’t worry about case sensitivity of our password.

But today, when I was trying to connect Oracle, I was contineously getting following error.
Flashing message

“ORA-01017: invalid username/password; logon denied
Warning: You are no longer connected to ORACLE.”.

I was out of clue why exactly this is happening as I was providing right username and password!
I became little bit irritated, what’s wrong am I doing.

Usually I provide username and password in small case as I know that Oracle is case insensitive.
So for a change I tried the same username and password with upper case and it get connected.
I did little bit more R&D over this and I found that from Oracle 11g onwards, Oracle has decided to be little bit case sensitive.

Let me show you with example.

Illustration:
Connected to:Oracle Database 11g Enterprise Edition Release 11.1.0.6.0
- ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing options
SYSTEM@ orcl>ALTER USER IMERGE IDENTIFIED BY iMERGE;
User altered.
SYSTEM@ orcl>conn
Enter user-name: iMERGE/IMErge@orcl
ERROR:ORA-01017: invalid username/password; logon deniedWarning: You are no longer connected to ORACLE.@ >
Then I tried with…
@ >conn imerge/iMERGE@orcl
Connected.
IMERGE@ orcl>

1 comment:

  1. Your blog keeps getting better and better! Your older articles are not as good as newer ones you have a lot more creativity and originality now keep it up!

    ReplyDelete