Installation and deployment of Oracle MapViewer11g

 

Oracle MapViewer runs as a JavaEE application in the JavaEE container. There are multiple ways to install and deploy Oracle MapViewer In The Complete Oracle Fusion middleware environment or an independent version of the Solaris. The deployment of Oracle MapViewer11g can be implemented as follows:

1. deployed on Weblogic Server 10 or later;

2. Deployed in Oracle Fusion middleware;

3. deployed in the independent version of the Enterprise Edition;

4. Deploy the Quick Start package (the Independent edition of The MapViewer has been built in ).

Download

Secret, which:

Http://www.oracle.com/technetwork/middleware/mapviewer/downloads/index.html

Unzip and install

The decompressed directory structure is as follows:

<Oc4j_dir>

/Ant

/Bin

/Diagnostics

/J2ee

/Home

/Applications

/Mapviewer

/Javacache

/Javavm

/Jdbc

/Jlib

/Lib

/Opmn

/Rdbms

/Sqlj

/Toplink

/Webservices

/Xqs

Test

Make sure that the two environment variables ORACLE_HOME and JAVA_HOME have been added. For details about the deployment process, refer to the "Overview of the Linux independent edition" in the blog post and run the following command on the command line:

> Cd <oc4j_dir> \ bin

> Solaris-start

In the initial startup process, after setting the password for the Administrator oc4jadmin, start the test:

1. Test the installation of the Linux kernel (shown in the figure below)

Http: // localhost: 8888/

2. Test the installation of MapViewer.

Http: // localhost: 8888/mapviewer

 

3. Test the installation of peek (Figure omitted)

Http: // localhost: 8888/peek

4. Test the application control console (Figure omitted)

Http: // localhost: 8888/em

Run the SQL script

After the installation is successful, you also need to manually create several views required for MapViewer running in the Oracle database, as shown below:

USER_SDO_MAPS

USER_SDO_THEMES

USER_SDO_STYLES

USER_SDO_CACHED_MAPS

Here, USER_SDO_CACHED_MAPS needs to be manually created by the SYS user (I don't know if it will be automatically created after 11 GB), and its SQL file is:

<Oc4j_dir> \ j2ee \ home \ applications \ mapviewer \ web \ WEB-INF \ admin \ mcsdefinition. SQL

The other three views have been automatically created in the oracle database version> = 9.2. In the oracle database version <9.2, the MDSYS user needs to manually complete the operation. The SQL file is:

<Oc4j_dir> \ j2ee \ home \ applications \ mapviewer \ web \ WEB-INF \ admin \ mapdefinition. SQL

<Oc4j_dir> \ j2ee \ home \ applications \ mapviewer \ web \ WEB-INF \ admin \ defastystyles. SQL

Create an array

When MapViewer is running, it checks whether the following SQL array types exist in the connected Oracle database to support array binding to some predefined thematic variables:

MV_STRINGLIST

MV_NUMBERLIST

MV_DATELIST

If the MapViewer database connection user does not have sufficient permissions, You need to manually create the database. The SQL statement is as follows:

CREATE or REPLACE type MV_STRINGLIST as TABLE of VARCHAR2 (1000 );

CREATE or REPLACE type MV_NUMBERLIST as TABLE of NUMBER;

CREATE or REPLACE type MV_DATELIST as TABLE of DATE;

This article is from the blog "Excellent by focus-Peng Jinhua"