Hi David,

I sympathise with your problems. I don't really know Navigator, but I'll try to give some suggestions.

Remember that Oracle is really a database server. When you use PO you have the server on the same machine as the client. This sometimes makes things confusing because the client config files are in the same place as server config files. Bearing this in mind ...


>2) After doing this, I cannot establish a connection to the database in the navigator. I type in the user names and passwords it provided me at setup, but it won't establish a connection.

What is the error message, by the way?

Try the following:
go to an DOS prompt
type

SET ORACLE_SID=TEST
SVRMGRL
CONNECT SYSTEM/MANAGER (or any other combination of username and password)

If this lets you in, you may be getting somewhere. In this case, check your registry setting under HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/ORACLE_SID. You may find something like ORCL in this key. Change it to TEST.

This means that your default database is now TEST. Oracle uses your default database if it can't find the real database using network settings (which you might not have yet - depends on navigator).

>I realize this is rudimentary stuff. I've order some books, which I'm not sure even get this basic. I'd appreciate any assistance or even direction on what to read to solve these problems. I've tried the Oracle documentation, but I'm finding it circuitous - not geared towards someone at such a basic level

Stick with it. One day it will suddenly all make sense

Les
---