Saturday, December 28, 2013

Database Link password Change in 11gR2

Before 11gR2 for changing  database link we have  to be drop and recreated db link  with an updated password.

Sample here is on the database where database link is located:

The password of the database link’s account has just been changed.

SQL> select count(*) from PUMP@DB_LiNK_CUST;
select count(*) from PUMP@DB_LiNK_CUST
*
ERROR at line 1:
ORA-01017: invalid username/password; logon denied
ORA-02063: preceding line from DB_LiNK_CUST

SQL> alter database link DB_LiNK_CUST connect to dblink_source identified by dblink_source;

Database link altered.

SQL> select count(*) from PUMP@DB_LiNK_CUST;

COUNT(1)
----------
18762

This option is not available in the pre-11gR2.

No comments:

Post a Comment