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