Re: Challenge: Rename a database

From: Dave Weeks <dweeks_at_nospam.gnseurope.com>
Date: Mon, 30 Apr 2001 15:22:04 +0100
Message-ID: <9cjt7h$2du$1_at_reader-00.news.insnet.cw.net>


Myself <dweeks_at_nospam.gnseurope.com> wrote in message news:9cjkva$t96$1_at_reader-00.news.insnet.cw.net...
>
> 3) What's the command to startup a second instance on the same machine
> without getting an error about the first instance already being there
 (using
> a different SID + database name of course).

Cheers Nuno for the sqlplus heads-up. I've also realised about the various environment variables needing to be changed to run a second instance (as stated here only 6 years ago):

> From: Louis POTY (louisp_at_sdv.fr)
> Subject: Re: Multiple Instances
> Newsgroups: comp.databases.oracle
> Date: 1995/08/04
>
> > Does anyone know how it is possible to start more than one instance on a
 machine.
>
> Sure, it is possible.
> Our development staff works on a single machine with at least three
 instances running.
> What you have to do is to correctly set ORACLE_HOME and ORACLE_SID before
 creating your
> new database. Each instance has its own SID, init<SID>.ora file, and all
works fine. Received on Mon Apr 30 2001 - 16:22:04 CEST

Original text of this message