Re: Local Oracle installation

On Mon, 09 Feb 2004 20:32:45 +0200, Luis <andyza_at_webmail.co.za> 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...).
>
>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?
>
>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"...
>
>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

Oracle 8.1.6 has been desupported a long time ago, especially because it was a complete can of worms. Likely you are trying to install Oracle on a platform for which it was never certified. 8.1.6 was the first release to be certified for Win2k, if you have XP you are on your own. Oracle only certifies for XP Pro.

You would do better to upgrade to something recent, preferable 9i release 2, or 8.1.7.4 at the least.

There is a 'Getting Started Manual' online at http://otn.oracle.com but usually you don't need: just follow the prompts.

You could make a "copy" using export, without exporting data, but import requires you have a database running, as exp/imp are used for "logical" copies, not for physical ones.

--
Sybrand Bakker, Senior Oracle DBA