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>
Subscribe to:
Post Comments (Atom)
How can I remove a URL on my website from the Google Index?
To remove a specific URL (for example, the page http://www.example.com/page4.html) of your own website from Google’s index, there are two ...
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