Setting up Oracle 10g & Oracle Spatial / MapViewer for learning single PC

I have been wanting to learn Oracle Spatial for some time now. I
purchased the book "Pro Oracle Spatial"
http://www.apress.com/book/bookDisplay.html?bID=315
several months ago and have read & understood the material.
However my attempts to download & install the software from Oracle
TechNet to actually perform the exercises / labs has not met with any
success whatsoever. Everytime I try I get TNSListener related errors.

I've had experience in Oracle 8i some years ago (2000-02), but it
seems that the whole installation / configuration and
client tools supplied for the Windows Platform has changed
significantly in 10g. Has anyone got this to work on a single PC ?


Here is what I have and need to do...


1) DELL Dimension PC Running Windows XP Pro with enough disk space
2) Oracle 10g Software Enterprise Edition (downloaded from Oracle
Technet for learning purposes)


I need to


1) Install Oracle 10g & Configure it to be able to load data into a
Spatial Database.
2) Install & Configure Map Viewer to be able to look at the data I load



Is this even possible using only my PC? Is the architecture of 10g now
set up so a real network (more than 1 machine) is required ?


Feedback much appreciated

spatialdba wrote:

That comes by default on Oracles of every size (One, Standard,
Enterprise): Locator is a base componente and lets you manipulate
geometry data at will (only shp2sdo is given to load them, though).



MapViewer needs Oracle Application Server to work, since it is a J2EE
web-applicazion: make sure to have Oracel AS up and running first.



Yes, my single Linux box churns out maps made from data stored in Oracle
Spatial, not to mention having AutoCAD Map and uDUG as clients (I'm not
using MapViewer, but another J2EE application called Geoserver, though)



I'd be *very* surprised if this turned out to be the case.

Regards,

--------------------
Luca Morandini
www.lucamorandini.it
--------------------

I've managed to enable the MDSYS account & implement other measures
needed to set up spatial no problem. The problem is that the Oracle
Enterprise Manager sees the database as being "shutdown". And the
instructed measures in the documentation to start it up don't work.





Glad to hear. At least I am attempting something that the software is
able to accommodate.



Well your previous answer makes my second question moot.
I think I may just wipe the instance and start over. (Or perhaps I
should get Linux as a second OS)


Thanks for your information...

spatialdba wrote:

Hmmm... after installation you have run the "configuration database
assistant" to set up the instance, haven't you ?

Regards,

--------------------
Luca Morandini
www.lucamorandini.it
--------------------

I honestly don't remember. I had the Oracle Installation documentation
in front of me at the time. So I would think yes.
I'm definately leaning towards starting over from step 1. It is a
learning process after working with ArcSDE/SQLServer for so long.