ORA-04052: error occurred when looking up remote object user_name.package_name@db_link / ORA-28001: the password has expired


Error:

ORA-04052: error occurred when looking up remote object user_name.Package_Name@DB_LINK
 ORA-00604: error occurred at recursive SQL level 1
 ORA-28001: the password has expired  
 Solution:
 bash-3.2$ export ORACLE_SID=ANARDB
 bash-3.2$ echo $ORACLE_SID
 ANARDB
 bash-3.2$ 
 bash-3.2$ sqlplus /nolog SQL*Plus: Release 11.2.0.3.0 Production on Sat Dec 14 18:59:15 2013 Copyright (c) 1982, 2011, Oracle. All rights reserved.

SQL> conn USER_NAME
 Enter password: 
 ERROR:
 ORA-28001: the password has expired 
 Changing password for USER_NAME
 New password: 
 Retype new password: 
 Password changed
 Connected.
 SQL>
Advertisements

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: