Re: Local Oracle installation

Luis wrote:

> I'm trying to install Oracle 8.1.6.0.0 on my home computer so that I
> can learn a bit about the database (I've specifically selected version
> 8.1.6.0.0 because it's the version of a database used at work...).
>

Sigh... Upgrade at work - to 8.1.7 at least, but preferably to 9i Release 2, patched to level 4 (that's version 9.2.0.4)

> When I run the Oracle installer it doesn't give me the option to
> create a new database, and alI the guides setup I've managed go find
> say that the installer will prompt me to create a database. Why don't
> I get this option?
>

Don't know - but there's a Database Creation Assistant in your menu, you could use that.

> I'm using a standalone pc (at home) that doesn't have access to any
> existing Oracle databases on a network, so I need a local database.
>
> Is there a guide that explains how to install a "standalone" instance
> of Oracle and how to configure the various configuration files such as
> the listener.ora and tnsnames.ora files? I'm struggling with error
> messages such as "TNS:No Listener"...

Every instance is standalone, unless your listener is configured correctly, and running. ;-)

Just try to set your SID in the environment, and use sqplus <user>/<passwd>

Should work. By the time you get fed up of typing "set ORACLE_SID=" introduce a regitry entry, called local. It's a string value, containing the SID of your choice.
>
> Is there a way to make a "copy" of the database used at work on my
> home machine (the structure, not the actual data)?
>
> Thanks
>

imp/exp. Rows=n compress=n. Best to take a full export, and import what you need (Murphy, and all that)

-- 

Regards,
Frank van Bortel