Home > TroubleShooting > ORA-01017: invalid username/password; logon denied (via database link)

ORA-01017: invalid username/password; logon denied (via database link)

September 1, 2010 Leave a comment Go to comments

Symptoms

Today, I create a database link from 10g to 11g database as the following

SQL> create database link vodcms connect to vod identified by vod using ‘vodcms’;

When I test the database link connectivity,

SQL> select tname from tab@vodcms;
select tname from tab@vodcms
*
ERROR at line 1:
ORA-01017: invalid username/password; logon denied
ORA-02063: preceding line from VODCMS

Causes

The target database 11g has enabled the case sensitive logon.

SQL> show parameter sec_case_sensitive_logon

NAME                                 TYPE
———————————— ——————————–
VALUE
——————————
sec_case_sensitive_logon             boolean
TRUE

Fix

Recreate the database link by using double quotes to enclose lower cases for username and password

SQL> create database link vodcms connect to “vod” identified by “vod” using ‘vodcms’;

Test the connectivity

SQL> select tname from tab@vodcms;

TNAME
——————————
AQUA_EXPLAIN_990744
PF_VOD_SCHED_PROD_STATUS
TEMP_VI_VODTEMPLATE_MAP_T
TEMP_VOD_APPLIED_IMAGE_T
VI_CONTENT_PROVIDER_CATEGORY_T
VI_CONTENT_PROVIDER_DESC_T
VI_CONTENT_PROVIDER_GP_MAP_T
VI_CONTENT_PROVIDER_GP_T
VI_CONTENT_PROVIDER_T
VI_CONTENT_PROVIDER_TYPE_T
VI_CONTENT_TAG_MASTER_T

Advertisements
Categories: TroubleShooting
  1. madhu
    November 10, 2010 at 2:59 pm

    Good Catch buddy. Thank you very much.

  2. Ali
    December 8, 2011 at 10:30 pm

    Good one mate
    Ali

  3. Indian
    December 23, 2011 at 11:20 am

    Thanks Buddy, really simple but unpredictable mistake….

  4. April 26, 2012 at 11:51 am

    Thanks a lot mate..This is very helpful..

  5. May 12, 2013 at 1:51 pm

    I constantly emailed this blog post page to all my associates, since
    if like to read it next my friends will too.

    • May 14, 2013 at 1:38 am

      Thank you

  6. May 30, 2013 at 10:47 am

    Definitely believe that which you stated. Your favorite reason seemed to be on the net the simplest thing to be aware of.
    I say to you, I definitely get irked while people
    consider worries that they just do not know about. You managed to hit the nail upon the top
    and also defined out the whole thing without having
    side effect , people can take a signal. Will likely be back to get more.

    Thanks

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: