Configure and Install MVDEMO Sample Data Set in Oracle Databse XE 11g

In this post we are going to configure and install MVDEMO Sample Data Set for Oracle MapViewer in Oracle Databse XE 11g on windows 7.
 
Pre-requisite for MVDEMO Sample Data Set
 
1) Oracle Java Development Kit (JDK 7).
2) Oracle Database Express Edition (XE 11g).
3) Oracle MapViewer QuickStart Kit 11g ps5.
4) Oracle SQL Developer 11g

Installation

Download MVDEMO Sample Data Set for MapViewer Demo from OTN. This Demo contains MapViewer sample data and instructions for use with Oracle Fusion Middleware Mapviewer 11g.
1) Unzip mvdemo files in your desire location. I am unzipping it under D:\OPT (this will create a new directory called mvdemo11R1).

2) In the database, login as sysdba or system by using Oracle SQL Developer and create the mvdemo user.


3) Import the mvdemo data as follow:-
> imp mvdemo/mvdemo@XE file=mvdemo.dmp full=y ignore=y log=mvdemo.log
mvdome.dmp file is located in mvdemo11R1 folder

4) Login as mvdemo through Oracle SQL Developer and execute the mvdemo.sql. Press F5 to run the script.


5) Login as system through Oracle SQL Developer and execute the mcsdefinition.sql script. Press F5 to run the script.


6) Launch 'start.bat' file that is located in D:\mapviewer11p5_quickstart in my case. This will start the oc4j server.

7) Launch your browser, and login to the MapViewer Home Page. http://localhost:8888/mapviewer

8) Select the “Admin” option, login as oc4jadmin/oc4jadmin.

9) Select Configuration, and under “Predefined Data Sources”, enter the shown setting.
-->

10) Save the above entry.

11) Close your Map Viewer Home Page (the browser), shutdown (Control-C), and restart start.bat the oc4j server again.

12) Launch again your browser, enter into MapViewer Home Page, and ensure that your data source is available. Login to the admin page, and select DataSources. If you don’t see your data source then manually, enter the datasource information and press Submit.




13) Go back to “Manage MapViewer”, and select “Geometry Cache” and select mvdemo as Data Source from drop down list.


14) Go back to “Home”, click on Oracle Maps Tutorial than Running the demos to test the demos.

Comments

Post a Comment

Popular posts from this blog

What is Oracle Integration Cloud Service - ICS?

Image
Oracle Integration Cloud Service (ICS) is a solution that enables you to simplify integrations between cloud applications, and between cloud and on premises applications. It helps you create connections to well-known and less-known SaaS and PaaS applications, using the available cloud adapters, publish or subscribe to the Messaging Cloud Service, or use industry standards such as SOAP, REST, FTP, File, and JMS. For more information watch this Oracle video.
Read more

How to Create Packages in Oracle Database using TOAD for Oracle

Image
What are Packages in Oracle Database A package is a group of procedures, functions, variables and SQL statements created as a single unit. It is used to store together related objects. A package has two parts, Package Specification and Package Body. Package Specification Package Specification acts as an interface to the package. Declaration of types, variables, constants, exceptions, cursors and subprograms is done in Package specifications. Package specification does not contain any code. Package Body Package body is used to provide implementation for the subprograms, queries for the cursors declared in the package specification.
Read more

How to create a Simple Scheduler Job in Oracle Database using Toad

Image
Scheduler is a process which runs programmed jobs at scheduled times. This process wakes up at the specified time and runs automatically. The basic elements of the scheduler are: Jobs Schedules Programs A job specifies what needs to be executed and when. A program is a collection of metadata that will be executed by the scheduler. It contains the name of the program (a procedure or an executable, the type of the program (pl/sql block, shell script etc). A schedule specifies when and how many times a job is executed. 1. Login to the database using Toad, and create a Scheduler Job as follows;
Read more