ORA-28001 the password has expired error in 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

Comments:

Post a Comment:
  • HTML Syntax: NOT allowed
About

Weblog about Solaris,Linux,Oracle Database,Solaris Cluster

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today