ORA-28001 the password has expired error in Solaris Cluster

Posted by Onur Bingul on Oracle Blogs See other posts from Oracle Blogs or by Onur Bingul
Published on Wed, 31 Oct 2012 11:50:46 +0000 Indexed on 2012/10/31 23:10 UTC
Read the original article Hit count: 263

Filed under:

/Solaris Cluster

Solaris Cluster start or stop Oracle database using credentials of a specified user in Oracle Database.

If you have issues with starting of Oracle Database resource and see ORA-28001 error message in /var/adm/messages it means that database user's who is used by Solaris Cluster to start Oracle database, password has expired.

To resolve the issue reset the password of the Oracle database user

SQL> alter user user_name identified by password

and change connection string in Solaris Cluster using following command

-bash-3.2 # /usr/cluster/bin/clresource set -p Connect_string="user/password" oracle_resource

Related posts about /Solaris Cluster

Solaris 11 Launch Blog Carnival Roundup

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Solaris 11 is here! And together with the official launch activities, a lot of Oracle and non-Oracle bloggers contributed helpful and informative blog articles to help your datacenter go to eleven. Here are some notable blog postings, sorted by category for your Solaris 11 blog-reading pleasure: Getting… >>> More
Solaris OS?????????? (??????·SIer????!??????)

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Solaris11???????????????2011?11??????OS????????11.1??????????2012?11???????????????OTN?Solaris11?????????????????????????????????????OTN?????????????????????????????????????????????????????????????????????IT?????????Solaris??????????????????????????????????????????Solaris???????Solaris 11????????… >>> More
????????????????? Oracle Solaris ??? - Solaris 11 ????(??)

as seen on Oracle Blogs - Search for 'Oracle Blogs'
???????????????? OS ????????????????????? 20 ??????????????????? Solaris?????????????????????? OS????????????????????????Solaris ???????????????????? ??????Oracle Solaris ??????????????6??????????????????Oracle Solaris ?????????????????????? [????????????] ?????(????????????? ???)?????(?… >>> More
????????????????? Oracle Solaris ??? - Solaris 11 ????

as seen on Oracle Blogs - Search for 'Oracle Blogs'
???????????????? OS ????????????????????? 20 ??????????????????? Solaris?????????????????????? OS????????????????????????Solaris ???????????????????? ??????Solaris ?????????????? 4 ????????????????????? Oracle Solaris 11 ??????????????? [????????????]???? ?(????????????? ???)???? ?(?????… >>> More
??????????·????????????Oracle Solaris Cluster 4.0?

as seen on Oracle Blogs - Search for 'Oracle Blogs'
??????OS?Oracle Solaris 11???????????????·????????????Oracle Solaris Cluster 4.0???2011?12?6????????????Oracle Solaris 11 ???????????????????????????Oracle Solaris Cluster 4.0 ???????????????????????? Oracle Solaris Cluster 4.0 ?3?????? - Oracle Solaris Cluster… >>> More

Developer IT