ORA-04052: error occurred when looking up remote object AZOCEAN.API_OCEAN@ABS / ORA-28001: the password has expired


Error:

ORA-04052: error occurred when looking up remote object AZOCEAN.API_OCEAN@ABS
ORA-00604: error occurred at recursive SQL level 1
ORA-28001: the password has expired  
Solution:
bash-3.2$ echo $ORACLE_SID
AZKKUAT
bash-3.2$ ps -afe | grep ora_smon
oracle 1605 1 0 Sep 27 ? 6:54 ora_smon_AZKKTST
oracle 6752 1 0 Sep 27 ? 8:06 ora_smon_AZKKDEV
oracle 20836 1 0 Dec 10 ? 1:04 ora_smon_AZKKUAT
oracle 5139 1 0 Nov 22 ? 2:56 ora_smon_AZTEST
oracle 8877 1 0 Nov 02 ? 9:27 ora_smon_ABSTEST
oracle 16373 20081 0 18:58:46 pts/7 0:00 grep ora_smon
bash-3.2$ export ORACLE_SID=AZTEST
bash-3.2$ echo $ORACLE_SID
AZTEST
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 AZOCEAN
Enter password:
ERROR:
ORA-28001: the password has expired
Changing password for AZOCEAN
New password:
Retype new password:
Password changed
Connected.
SQL>

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: