Re: New Instance on NT - Connection problems?

From: Marc Mazerolle <informaze_at_sympatico.ca>
Date: Tue, 16 Feb 1999 13:14:55 -0500
Message-ID: <36C9B59E.29F1C42A@sympatico.ca>

Bill,

Let me try this.

Listener.ora file has to be updated manually. Adding a second instance is usually trivial if you already have one instance setup in there. Just duplicate what is there and change the instance name.

On UNIX (which is what i am used to), you can issue "lsnrctl restart" command to

refresh the listener table. I don't know if this exists on NT, try it. Otherwise, wait for quiet time and bounce the listener. It usually does not kill

any user process (at least on UNIX).

My listener.ora had ORCL configured like so :

.
.
.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = ORCL)
    )
  )

.
.
.

Just duplicate this section like so :

.
.
.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = ORCL)
    )
  )
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = ODEV)
    )
  )

.
.
.

On UNIX, i would however be starting another separate listener for each instances. This gives you the flexibility to shutdown the listener for one instance without affecting both.... Don't know if you can do this on NT.

I am open for comments...

God i hate NT......

Regards,

Marc Mazerolle

Bill Fee wrote:

> Hello!
>
> I created a new instance/database on Windows NT 4.0, Oracle7 Workgroup
> ServerVersion 7.3.4, Oracle Network Products release 2.3.4.
>
> I also went ino 'SQL Net Easy Configuration' and set up a connection to the
> instance/database on NT.
>
> I get the following error when trying to connect to the instance:
> ORA-12505 TNS:Listener could not resolve SID given in connect descriptor.
>
> I want to modify the listerner.ora file to listion for 2 instances. Is there
> a GUI EXE that will help me modify the listerner.ora configuration file? Or
> do I have do modify it manually? All the examples I have seen are only for
> one instance. Also, Do I have to stop and start the listener after modiying
> the listener.ora file?
>
> Any help would be appreciated,
>
> Thanks in advance,
>
> Bill Fee
Received on Tue Feb 16 1999 - 12:14:55 CST