Vice Admiral Vice Admiral
Vice Admiral
151 views

OMW 8.16 database upgrading

Dear All,

 

I want tp upgrade  OMW 8.16 database from SQL database 2005 ( local)  to SQL 2008 (Remote).

 

Is there any doc describe this process  or any steps ?

0 Likes
7 Replies
Absent Member.
Absent Member.

 
0 Likes
Absent Member.
Absent Member.

Hi, 

 

Please check on the Online help document Page 294 or search Move daatabase in OMW server Online help fordetailed information.

 

 

0 Likes
Vice Admiral Vice Admiral
Vice Admiral

HI HP EXPERT,

 I Followed the steps in the online help but it didn't help the console in not running

 

is there any idea ?

0 Likes
Admiral
Admiral

Hello,

 

Can you confirm you followed the online help section?
What is the status of the OMW services? Please share the output of "vpstat -3 -l" command.

Which error are you getting when starting the console?

HP Support
If you find this or any post resolves your issue, please make sure to mark it as an "Accepted as Solution".
If you liked the reply then please show this with KUDOs.
0 Likes
Micro Focus Frequent Contributor
Micro Focus Frequent Contributor

Problems with lunching OMW MMC Console indeed might indicate database related issues.

 

I would start with checking Windows Application Event Log on OMW server to see if there are any errors for accessing the database.

Make sure that the new database details are reflected in [HKEY_LOCAL_MACHINE\SOFTWARE\Hewlett-Packard\OVEnterprise\Management Server\DBAccess] registry key on the management server.

 

Check the new database to see if logins were created by HP-OVE-User and HP-OVE-Deleg-User account there

with corresponding ovms_adm and ovms_deleg users on the openview database level.

Usually create_WinAuthUser.sql script is responsible for creating those logins and users.

0 Likes
Vice Admiral Vice Admiral
Vice Admiral

HI all,

 

thanks for your replies

 

the vptat -3 -l command output

 

 

C:\Documents and Settings\mstaha>vpstat -3 -l
============================================================
running: C:\Program Files\HP\HP BTO Software\bin\vpstat.exe
version: A.6.0.82.6 on SVRRUHD02OMW01
now:     Thu Mar 26 14:39:28 2015
============================================================

============================================================
==================== Services Information ==================
============================================================

Configuration file: C:\Documents and Settings\All Users\Application Data\HP\HP B
TO Software\conf\vpstat\vpstat.conf
  Ver: 0.8.16.000
  Date: Fri Oct 22 15:34:46 2010
  Remark: HP Operation Manager - Performance.

Services on     : LOCAL MACHINE

(NT Services) :
                SERVICE_RUNNING  : OvAutoDiscovery Server ( OvAutoDiscovery Serv
er )
                SERVICE_RUNNING  : OvCtrl ( HP OpenView Ctrl Service )
                SERVICE_RUNNING  : OvDnsDscr ( OvDnsDiscoveryService )
                SERVICE_RUNNING  : OvEpMessageActionServer ( OvEpMessageActionSe
rver )
                SERVICE_RUNNING  : OvEpStatusEngine ( OvEpStatusEngine )
                SERVICE_RUNNING  : OvMsmAccessManager ( OvMsmAccessManager )
                SERVICE_RUNNING  : OvOWReqCheckSrv ( OvOWReqCheckSrv )
                SERVICE_RUNNING  : OvowWmiPlatProv ( OvowWmiPlatProv )
                SERVICE_RUNNING  : OvPmad ( OvPmad )
                SERVICE_RUNNING  : OvSecurityServer ( OvSecurityServer )
                SERVICE_RUNNING  : OvServerMonitor ( OvServerMonitor )
                SERVICE_RUNNING  : OVServiceLogger ( OVServiceLogger )
                SERVICE_RUNNING  : OvStoreProv ( OvStoreProv )

                OK: All services : SERVICE_ACTIVE


 

 

 

and also i modified the sql script and run it over the remote data base serever

 

the error that i recieve is the console is not opinning and after long time it show me message to check the om service and also the remote database

 

 

I followed online help for OMW9 starting from page 294

0 Likes
Micro Focus Frequent Contributor
Micro Focus Frequent Contributor

One more point to check is to verify that SQL Server Browser service is running on the remote database system.

 

HP-OVE-User and HP-OVE-Deleg-User should be able to connect to the remote database:

 

whoami

<domain>\hp-ove-user

 

osql -E -S <HOST>\<DB_INSTANCE> -d openview -q "EXIT(select getdate())"

 

-----------------------

2014-09-18 11:45:19.930

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.