Re: Test instance question

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Sat, 14 Aug 1999 07:28:32 +0200
Message-ID: <934608528.11359.0.pluto.d4ee154e@news.demon.nl>

Hi,
In the listener.ora there is a block starting with sid_list_listener. Here you will find the details for the first correctly functioning database. Assuming you used the same ORACLE_HOME, you just need to copy the first block and change the SID.
The normal structure is like
SID_LIST_LISTENER = (
(SID=ORCL)(ORACLE_HOME= ... )

                                         )

Just copy that second line and change it accordingly

Hth,

Sybrand Bakker, Oracle DBA

Roger <rvbaker_at_mindspring.com> wrote in message news:37B4A1DB.79FF53F_at_mindspring.com...
> I'm pretty new to Oracle .... experienced Sybase / SQL Server DBA, so
> excuse the question.
>
> I'm attempting to set up a second instance (on the same server) to test
>
> our applicaton.
> The instance was created using oradim73 (platform is NT) and appears to
> be okay.
> However I cannot connect via Enterprise Manager. Gives me an error about
>
> TNS service name not found.
>
> I've manually added an entry in tsnames.ora and have looked at
> listener.ora, but cannot find how to
> enter details for two instances on one machine.
> Can someone help me with the configuration, or some advice - where to
> look.
>
> Cheers
>
>
>
Received on Sat Aug 14 1999 - 00:28:32 CDT