Installation Instructions
Oracle, MapViewer and Geospatial data
Oracle, MapViewer and Geospatial data
- Download Oracle and MapViewer from www.oracle.com
- the database software: oracle10g rel2 standard edition 10.2.0.10 for Microsoft Windows 'a'ena-7
- The application server MapViewer: MapViewer 10.1.2.0.2 kit and Quickstart
- Install the oracle software and create the database
- double click on the setup
- Login to DB: installed in C:\oracle\product\10.2.0\mapdb
(DB installed on machine with static IP preferably) - login as SYS and conect as SYSDBA
- Name: mapdb (this is the sid)
- Passwd: ???
- Create a DB
- Administration tab
- Tablespaces link
- Create button
- Object: maptablespace (name the tablespace)
- Add button
- mapdata (file on disk. created!)
- Reuse same file 4G
- Automatic extend 500MB
- Create a user in DB mapsdb
- Under "Users & Privileges" select:
- Users [link] -> mapuser (<- this is the user name)
- pass l
- Default Tablespace: maptablespace (from above!)
- Temporary Tablespace: temp
- Roles link
- Edit List link
- Move "DBA" to the right (this user is dba)
- Connecting to oracle:
- Admin user name: SYS
- Connect as SYSDBA
- To login to admin oracle: http://localhost:1158/em Username: SYS, Password: ???, Connect As: SYSDBA
- To login to mapsdb (our db) http://localhost:1158/em Username: mapuser, Password: l, Connect as: Normal
- the following I don't use:
- The iSQL*plus URL is: http://localhost:5560/isqlplus
- The iSQL*plus DBA URL is: http://localhost:5560/isqlplus/dba
- MapViewer Installation
- unzip MapViewer QS (read readme file!! and fix the start.bat)
- It is installed!
- To start MapViewer execute the start.bat in the directory where unziped
- To login to MapViewer: http://localhost:8888
- To create a password in Mapviewer, read its readme file
- Configure MapViewer to use the right DB all the time.
- edit the config file in MAPVIEWER_INSTALLATION\oc4j\J2EE\home\applications\mapviewer\Web\WEB-INF\conf
- near the end of the file (see the tags there) place the following:
Note: map_data_source is the name that your app and Mapviewer use to refer to the db
Another note: in the passwd field place a ! so that mapviewer will encrypt the passwd next time MapViewer comes up.
Another note: below the map_data_source is simply a name such as my_dataSource.
<map_data_source name="maptablespace" JDBC_host="localhost" jdbc_sid="mapdb" jdbc_port="1521" jdbc_user="mapuser" jdbc_password="!l" jdbc_mode="thin" number_of_mappers="3" />
- Import Data
some additional notes from Farshad- esri.com search for Census 200 tuger (census)
the exacl URL where we downloaded the files is: http://arcdata.esri.com/data/tiger2000/tiger_download.cfm - Use second pull down menu to select and download (GEORGIA).
- County 2000
- Line Features-Roads
文章整理：西部数码--专业提供域名注册、虚拟主机服务
http://www.west263.com
以上信息与文章正文是不可分割的一部分,如果您要转载本文章,请保留以上信息，谢谢!
- esri.com search for Census 200 tuger (census)
