Home » RDBMS Server » Server Administration » Ora 28001, ora2063 DB_LINK password expired
Ora 28001, ora2063 DB_LINK password expired [message #58738] Mon, 29 September 2003 04:45 Go to next message
shad
Messages: 50
Registered: October 2000
Member
Hi all

--> I run a query and get teh following errors.
Ora 28001, "the password has expired"
oar 02063, , "preceding %s%s from %s%s"

From DOCS"

28001, 00000, "the password has expired"
// *Cause: The user's account has expired and the password needs to be
// changed
// *Action: change the password or contact the DBA
//
bash-2.03$ oerr ora 2063
02063, 00000, "preceding %s%s from %s%s"
// *Cause: an Oracle error was received from a remote database link.
// *Action: refer to the preceding error message(s)
====================================
--> Now I checked the DB_LINK. It is not active.
--> How do I make it active again?
--> Do I change the password for the DB_LINK and how?

Regards
Shad
Re: Ora 28001, ora2063 DB_LINK password expired [message #58741 is a reply to message #58738] Mon, 29 September 2003 06:18 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
I beleive, the account ( which is used by dblink) password has expired.
validate the user account again ( just create a new pasword, and recompile the dblink)
Previous Topic: Need Help - processes exceeding
Next Topic: Oracle Partitioning
Goto Forum:
  


Current Time: Fri Sep 20 08:25:41 CDT 2024