Wednesday 11 January 2017

OVMAPI_6000E Internal Error: Connection refused Connection refused (or) unable to login OVMM through web browser?


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

3 comments:

  1. 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.

    digital marketing course in chennai
    hadoop training in chennai

    ReplyDelete
  2. This comment has been removed by the author.

    ReplyDelete