1)check the logs related to error on ovmm console.
login to ovmm server and check below file
[root@ovmmanager01 logs]# pwd
/u01/app/oracle/ovm-manager-3/machine1/base_adf_domain/servers/AdminServer/logs
[root@ovmmanager01 logs]# ls -l AdminServer-diagnostic.log
-rw-r----- 1 oracle dba 227846 Jan 5 03:32 AdminServer-diagnostic.log
identified ovs user expired.
2)stop oracle vm manager.
[root@ovmmanager01 bin]# /etc/init.d/ovmm stop
Stopping Oracle VM Manager [ OK ]
[root@ovmmanager01 bin]# /etc/init.d/ovmm start
Starting Oracle VM ManagerTime out...
[root@ovmmanager01 bin]# pwd
/u01/app/oracle/ovm-manager-3/bin
[root@ovmmanager01 bin]# ./ovm_admin
Oracle VM Manager Release 3.1.1 Admin tool
Usage: ./ovm_admin [options]
options
--help Shows this message
--createuser Create new Oracle VM Manager admin user
--deleteuser <admin> Delete Oracle VM Manager admin user
--listusers List Oracle VM Manager users
--modifyuser Modify Oracle VM Manager user password
--lockusers <tries> Max login tries before locking account.
This setting is global.
--unlockuser <admin> Unlock user account
--modifyds <SID> <host> <port> Modify Data Store 'OVMDS'
--listconfig List configuration
--rotatelogsdaily <time> Rotate Logs Daily (HH:MM)
--rotatelogsbysize <size> Rotate Logs By Size (KB)
3)check oracle instance & Listener information.
[root@ovmmanager01 bin]# ps -aef|grep pmon
oracle 3824 1 0 15:44 ? 00:00:02 xe_pmon_XE
root 7043 6718 0 19:06 pts/2 00:00:00 grep pmon
4)switch into oracle user & release OVS expired user information.
[root@ovmmanager01 bin]# su - oracle
[oracle@ovmmanager01 ~]$ ps -ef|grep pmon
oracle 3824 1 0 15:44 ? 00:00:02 xe_pmon_XE
oracle 7068 7045 0 19:07 pts/2 00:00:00 grep pmon
[oracle@ovmmanager01 ~]$ ps -ef|grep tns
root 9 2 0 15:42 ? 00:00:00 [netns]
oracle 3699 1 0 15:44 ? 00:00:00 /u01/app/oracle/product/11.2.0/xe/bin/tnslsnr LISTENER -inherit
oracle 7071 7045 0 19:07 pts/2 00:00:00 grep tns
[oracle@ovmmanager01 ~]$ uname -a
Linux ovmmanager01.eu.sony.com 2.6.32-300.10.1.el5uek #1 SMP Wed Feb 22 17:37:40 EST 2012 x86_64 x86_64 x86_64 GNU/Linux
[oracle@ovmmanager01 ~]$ cat /etc/oratab
XE:/u01/app/oracle/product/11.2.0/xe:N
[oracle@ovmmanager01 ~]$ export ORACLE_SID=XE
[oracle@ovmmanager01 ~]$ export ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe
[oracle@ovmmanager01 ~]$ sqlplus / as sysdba
-bash: sqlplus: command not found
[oracle@ovmmanager01 ~]$ export PATH=$ORACLE_HOME/bin:$PATH
[oracle@ovmmanager01 ~]$ sqlplus / as sysdba
Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
SQL> select name,open_mode from v$database;
NAME OPEN_MODE
--------- --------------------
XE READ WRITE
SQL> select username from dba_users where account_status like '%EXPIRED%';
USERNAME
------------------------------
OVS
XDB
HR
OUTLN
CTXSYS
MDSYS
XS$NULL
FLOWS_FILES
SQL> select name,password from sys.user$ where name='OVS';
NAME PASSWORD
------------------------------ ------------------------------
OVS D9854745A6D893F6
SQL> select account_status from dba_users where username='OVS';
ACCOUNT_STATUS
--------------------------------
EXPIRED
SQL> alter user OVS identified by values 'D9854745A6D893F6';
User altered.
SQL> select account_status from dba_users where username='OVS';
ACCOUNT_STATUS
--------------------------------
OPEN
SQL> select username from dba_users where account_status like '%EXPIRED%';
USERNAME
------------------------------
XS$NULL
OUTLN
XDB
CTXSYS
MDSYS
FLOWS_FILES
HR
7 rows selected.
SQL>
5)NOW START OVMM SERVER.
# service ovmm start
6)Now able to login ovmm console
Great post! I am actually getting ready to across this information, It's very helpful for this blog.Also great with all of the valuable information you have Keep up the good work you are doing well.
ReplyDeletedigital marketing course in chennai
hadoop training in chennai
This comment has been removed by the author.
ReplyDeleteAwesome..You have clearly explained …Its very useful for me to know about new things..Keep on blogging..
ReplyDeleteData Science training in chennai
Data Science training in OMR
Data Science training in chennai
Data Science Training in Chennai
Data Science training in Chennai
Data science training in bangalore