11 Configuring Oracle Spatial and Graph Map Visualization Component

This chapter describes how to configure Oracle Spatial and Graph Map Visualization Component for use with Oracle Communications MetaSolv Solution. The Map Visualization Component, which is included with your existing Oracle Database License for MetaSolv Solution, enables you to plot your network systems and inventoried equipment on a geographical map available within the application.

Configuring Map Visualization Component

To configure Oracle Spatial and Graph Map Visualization Component for MSS, perform the following tasks:

  1. Deploying Map Visualization Component
  2. Updating the Database for Maps Visualization Component
  3. Defining the Map Data Source
  4. Defining Base Maps
  5. Setting the Web Browser to Microsoft Edge
  6. Setting Map View Preferences

The Oracle Spatial and Graph Map Visualization Component Developer's Guide contains detailed Map Visualization Component documentation. The following is a link to the library page, where the document is located:

https://docs.oracle.com/en/database/oracle/oracle-database/19/jimpv/index.html

Deploying Map Visualization Component

To deploy Map Visualization Component:
  1. Download Oracle Spatial and Graph Map Visualization Component from the database technologies downloads website:

    https://www.oracle.com/database/technologies/spatial-map-vis-downloads/

    Note:

    Oracle recommends that you install patch 32953251 or higher for Map Visualization Component. You can download the patch from My Oracle Support website: https://support.oracle.com.
  2. Copy the mapviewer.ear file to the MSLV_Home/deploy directory.

    For single server, copy the file to /opt/m63Single/single/deploy.

    For Cluster server, copy the file to /opt/m63Cluster/Cluster/deploy.

  3. Create a new directory in MSLV_Home/MetaSolv/server_name/appserver/maps_directory to copy the configuration files from map viewer,

    where
    • MSLV_Home is the directory location where MSS software is installed.
    • server_name is the MSS server home directory.
    • maps_directory is the directory that you create to copy the WEB-INF/conf files from the mapviewer.ear file.

    Note:

    The default directory for mapviewer configuration files is MSLV_Home/m63domain/Servers/server_name/tmp directory.

    For cluster server with managed servers installed in different machines, you must ensure that the contents of the configurations files are always the same between the managed servers. If you make any changes to the contents of the configuration files in one managed server, ensure that you make the same changes to the contents of the configuration files in all the managed servers.

  4. Copy the contents of the mapviewer.ear/web.war/WEB-INF/conf directory to the newly created directory maps_directory.

  5. Update the application server start up files startMSLVmanaged.sh or startMSLVsingle.sh (for UNIX/Linux) startMSLVmanaged.cmd or startMSLVsingle.cmd (for Windows) to include the following Java options:

    For UNIX/Linux:
    JAVA_OPTIONS="${JAVA_OPTIONS}
        -Doracle.maps.config=${MSLV_Home}/MetaSolv/${server_name}/appserver/maps_directory/mapViewerConfig.xml"
    For Windows:
    Set JAVA_OPTIONS=%JAVA_OPTIONS%
        -Doracle.maps.config=%MSLV_Home%\MetaSolv\%server_name%\appserver\maps_directory\mapViewerConfig.xml
  6. Log in to the WebLogic Server Administration Console to deploy the mapviewer.

  7. From the Domain Structure tree, click Deployments.

    The Summary of Deployments pane appears.

  8. In the Change Center pane, click Lock & Edit.

  9. In the Configuration tab, Click Install.

    The Install Application Assistant pane appears.

  10. Navigate to the directory where you copied the mapviewer.ear file.

  11. Select mapviewer.ear and click Next.

  12. In the Install Application Assistant pane, verify the settings and click Next.

  13. (Optional) For a clustered server:

    1. In the Available targets for mapviewer section, select the cluster. For example, select mslvcluster. Select All servers in the cluster.

    2. Click Next.

  14. In the Optional Settings pane, verify the default settings and click Finish.

    The Summary of Deployments pane appears.

  15. In the Change Center pane, Click Activate Changes.

  16. (Optional) If the mapviewer application is in the Prepared state:

    • Click the Control tab, select mapviewer.

    • From the Start list, select Servicing all requests.

      The Start Application Assistant pane appears.

    • Click Yes to start the application.

  17. Ensure that the mapviewer application is in the Active state.

  18. Restart the application server.

Updating the Database for Maps Visualization Component

You must update the database for maps visualization component by running the MapsInstall.sql located in prodfixsql/maps directory.

To update the database:
  1. Change your Start in: directory to the location where you want the audit logs to appear and connect (from that location) to SQL*Plus using the ASAP user ID.

  2. At the prompt, enter:

    @driveletter:installation_directory/prodfixsql/maps/MapsInstall.sql

    The SQL scripts run against the database and make the appropriate changes for the Maps Visualization Component. When the prompt reappears, the contents of the maps directory where the SQL files were stored have been applied.

  3. Verify that the contents of the maps directory have been applied to your database correctly, review the log file for each maps file that was applied. The log files reside in the Start in: directory. Search the files in the directory for ORA-. Contact Oracle Global Customer Support if any of the files are not run or failed.

Defining the Map Data Source

You can predefine available map data sources in the Map Visualization Component Configuration page.

To define the map data source:

  1. Log in to Map Visualization Component Administration Console by entering the following URL in a Web browser:

    http://ServerName:PortNumber/mapviewer

    where ServerName is the application server and PortNumber is the port used by MSS.

    The Log In page is displayed.

  2. Enter the user name and password that you used for installing the WebLogic Server and then click Log In.

    The Map Visualization Component Home page is displayed.

  3. Click the Configuration tab.

    The mapViewerConfig.xml file is displayed.

  4. Scroll down to the Predefined Data Sources section within the file.

  5. Copy the contents starting from the map_data_source element to the end and paste the copied information after the existing predefined data source information within the Predefined Data Sources section.

  6. (Optional) If you are using any user other than ASAP, do the following:
    1. Locate the grants.sql in the prodfixsql directory.

    2. Modify the grants.sql and replace user_id with the user ID other than ASAP user to connect to the data source.

    3. Run the updated grants.sql using sysdba privileges.

    4. Run the load_user_sdo_tables.sql in the prodfixsql directory using the user ID that you replaced in grants.sql.

  7. Enter the details according to your settings to map the Map Visualization Component data source to the data source that MSS appserver is pointing to. For example:

    <!--***************************************************************************-->
    <!--**************************Predefined Data Sources**************************-->
    <!--***************************************************************************-->
    <map_data_source name="MSSDATA"               
          jdbc_host="db.example.com"                  
          jdbc_sid="orcl"                  
          jdbc_port="1521"                  
          jdbc_user="user"                  
          jdbc_password="!password"                   
          jdbc_mode="thin"                  
          number_of_mappers="3"                  
          allow_jdbc_theme_based_foi="false"                  
          editable="false"/>
  8. Find <mds_config> element under Map Data Server Configs section and add the following datasource within the <mds_config> element:

    <!-- ****************************************************************** -->
      <!-- ******************** Map Data Server configs  ******************** -->
      <!-- ****************************************************************** -->
    <data_source name="MSSDATA"> 
           <allow_predefined_themes>true</allow_predefined_themes> 
           <allow_dynamic_themes>true</allow_dynamic_themes>   
        </data_source>
  9. Click Save & Restart.

    The File mapViewerConfig.xml has been saved and MapViewer has been restarted messages are displayed above the Config area. The encrypted jdbc_password is displayed.

  10. Select Admin tab.

    The MSSDATA data source that is configured in step 6 should appear in the existing Data Sources table.

  11. Select Datasources and verify if the corresponding value (for example, MSSDATA) is displayed in the Existing data sources table.

Defining Base Maps

You can use an existing world map as the base map.

To define base maps:

  1. In the Map Visualization Component Administration Console, click the Admin tab.

  2. Click Create tile layer link.

  3. From Tile layer type, select Oracle Maps and click Next.

    The Tile Layer Properties page appears.

  4. Under the External tile layer section, enter the Name as ELOCATION_MAP.

  5. From Data source, select MSSDATA and click Next.

    The Tile Layer XML page appears.

  6. Click Submit.

    The system saves the configuration changes.

  7. Verify that the map is set up with the changes from the Existing map tile layers section in the Manage tile layers page.

The map tile layer is the link between MSS and Map Visualization Component.

There is no limit to the number of map tile layers that you can set up.

Setting the Web Browser to Microsoft Edge

MSS uses Oracle Maps APIs to display and use map operations such as the initial center, zoom levels, and map controls. Oracle Maps applications require HTML5 support. To emulate the web browser to Microsoft Edge which supports HTML5, edit the Windows Registry settings for MSS.

To set up the web browser to Microsoft Edge:

  1. Open the Windows Registry Editor.

  2. Navigate to

    HKEY_CURRENT_USER\SOFTWARE\Microsoft\Internet Explorer\Main\FeatureControl\FEATURE_BROWSER_EMULATION
  3. Create a new DWORD(32-bit) value entry. Enter the value as tbs.exe and Value Data as 2ee0 with base Hexadecimal.

    The entered value is saved for tbs.exe

  4. Navigate to

    HKEY_CURRENT_USER\SOFTWARE\Microsoft\Internet Explorer\BrowserEmulation
  5. Edit the IntranetCompatibilityMode DWORD and modify the Value Data to 1.

    Note:

    Modify IntranetCompatibilityMode DWORD to 1 only if it is already displayed and the value data is 0. Do not add a new DWORD value entry.
  6. Close the Windows Registry Editor.

Setting Map View Preferences

To set up map view preferences in MSS:

  1. Log in to MSS Application.
  2. Navigate to Preferences and expand System Information folder.
  3. Double-click the system preference named Engineering Maps View.
  4. In the System Preference - Engineering Maps View window, enter the environment details specified in Table 11-1.

Table 11-1 Engineering Maps View Preferences

Preference Description Example value

Base Map

Name of the Base Map that you set up in Map Viewer

ELOCATION_MAP

Application Datasource

The datasource name that you created in Map Visualization Component Map tile layer

MSSDATA

Base Map URL

The URL of the map visualization component

http://ServerName:PortNumber/mapviewer where ServerName is the application server and PortNumber is the port used by MSS.

Zoom Level

The zoom level for the map view

1

Map Center Latitude

Latitude value. The map view is centered with the latitude and longitude value entered based on the zoom level.

37.6402

Map Center Longitude

Longitude value. The map view is centered with the latitude and longitude value entered based on the zoom level

-97.2104

Uninstalling Map Visualization Component

To uninstall Map Visualization Component:
  1. Log in to the WebLogic Server Administration Console.
  2. From the Domain Structure tree, click Deployments.
  3. In the Change Center pane, click Lock & Edit.
  4. From the Summary of Deployments pane, click the Control tab and click the check box for mapviewer.
  5. Click Stop and select Force Stop Now.
  6. Click Delete.
  7. Click Yes.
  8. In the Change Center pane, click Activate Changes.

Note:

When you upgrade MSS, you need not uninstall or upgrade Map Visualization Component.

Upgrading Map Visualization Component

To upgrade Map Visualization Component:

  1. Uninstall Map Visualization Component using the WebLogic Server Administration Console. See "Uninstalling Map Visualization Component" for information about uninstalling the Map Visualization Component application.

  2. Deploy Map Visualization Component by performing the following procedures:

    1. Deploying Map Visualization Component
    2. Defining the Map Data Source
    3. Defining Base Maps