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.
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