Re: Oracle 9i - instances on server getting crossed?

From: <Harry_Boswell_at_@deq.state.ms.us>
Date: Mon, 25 Oct 2004 13:48:37 -0500
Message-ID: <ahiqn0tgu4vu9vfe9u9k724hl4pn8i92hl@4ax.com>

On Mon, 25 Oct 2004 19:33:13 +0200, Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl> wrote:

>On Mon, 25 Oct 2004 11:24:16 -0500, Harry_Boswell@@deq.state.ms.us
>wrote:
>
>>Just a bit more info - listener.log shows the connection as being made to
>>TEMPO8.WORLD, but the connected instance ins actually TEST8.WORLD (query
>>from v_$instance).
>>
>>Harry
>
>not surprisingly as you have 2 identical global_dbname variables in
>listener.ora

It turned out to be in my init.ora files - both had TEMPO8.WORLD as the instance_name. The perils of copying a file to configure a new instance.

Harry Received on Mon Oct 25 2004 - 13:48:37 CDT