Tuesday 13 November 2012

Expired OVS account

Recently an unmonitored OVMM machine (OVM 3.03 Manager machine - another VM in this case) ran out of disk on the root volume. Symptoms being exhibited were frozen VMs, and VMs not being able to start with the unhelpful message "Failed to begin a transaction". Otherwise monitored systems were behaving well. Once the source of the incidents was determined, and adequate free diskspace reclaimed, further resolution involved the following steps to unexpire the OVS account and resume the OVM manager to service.
SQL> conn / as sysdba
Connected.
SQL> 
SQL> select username , account_status from dba_users;

USERNAME                       ACCOUNT_STATUS
------------------------------ --------------------------------
ANONYMOUS                      OPEN
SYSTEM                         OPEN
SYS                            OPEN
OVS                            EXPIRED
APEX_040000                    LOCKED
APEX_PUBLIC_USER               LOCKED
HR                             EXPIRED & LOCKED
XDB                            EXPIRED & LOCKED
CTXSYS                         EXPIRED & LOCKED
MDSYS                          EXPIRED & LOCKED
FLOWS_FILES                    EXPIRED & LOCKED

USERNAME                       ACCOUNT_STATUS
------------------------------ --------------------------------
XS$NULL                        EXPIRED & LOCKED
OUTLN                          EXPIRED & LOCKED

13 rows selected.

SQL> select password from sys.user$ where name='OVS';

PASSWORD
------------------------------
855EB008C84C5841

SQL> alter user ovs identified by values '855EB008C84C5841';

User altered.

SQL> select username , account_status from dba_users;

USERNAME                       ACCOUNT_STATUS
------------------------------ --------------------------------
OVS                            OPEN
ANONYMOUS                      OPEN
SYSTEM                         OPEN
SYS                            OPEN
APEX_040000                    LOCKED
APEX_PUBLIC_USER               LOCKED
HR                             EXPIRED & LOCKED
XDB                            EXPIRED & LOCKED
CTXSYS                         EXPIRED & LOCKED
MDSYS                          EXPIRED & LOCKED
FLOWS_FILES                    EXPIRED & LOCKED

USERNAME                       ACCOUNT_STATUS
------------------------------ --------------------------------
XS$NULL                        EXPIRED & LOCKED
OUTLN                          EXPIRED & LOCKED

13 rows selected.

SQL> 
[root@OVMM3 ~]# service ovmm status
Oracle VM Manager is running...
[root@OVMM3 ~]# service ovmm stop
Stopping Oracle VM Manager                                 [  OK  ]
[root@OVMM3 ~]# service ovmm start
Starting Oracle VM Managernohup: ignoring input and redirecting stderr to stdout
                                                           [  OK  ]
[root@OVMM3 ~]#

No comments:

Post a Comment