Hendry's "Oracle and SQL Server DBA Stuff"

Oracle and SQL Server Database Solutions for DBA's please visit http://hendrydba.com for the latest posts. Thanks

Failed to connect to database instance: ORA-28001: the password has expired (DBD ERROR: OCISessionBegin).

Posted by Hendry chinnapparaj on June 23, 2010

Oracle Enterprise Manager 10g Grid Control Alert

MessageFailed to connect to database instance: ORA-28001: the password has expired (DBD ERROR: OCISessionBegin).

SQL> select username, account_status from dba_users where username=’DBSNMP’;

USERNAME                       ACCOUNT_STATUS

—————————— ——————————–

DBSNMP                         EXPIRED

SQL> alter user dbsnmp identified by **** account unlock;

User altered.

And also update the dbsnmp password in the Grid control

http://srdu010.subiaco.com:4889/em/console/logon/logon

sysman

********

– click setup

– agents

under search, type the server name and click go

– click the server

– select radio button for the database instance name

– click configure

– change password

– test connection

– should get “The connection test was successful”

– click next

– submit

– fixed

Also restart the Grid Agent if needed

./emctl stop agent

./emctl start agent

Advertisements

2 Responses to “Failed to connect to database instance: ORA-28001: the password has expired (DBD ERROR: OCISessionBegin).”

  1. Paul Yee said

    Very good spot on article!
    Thanks!
    Paul

  2. sdfd said

    thank u ..helped a lot

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: