Re: How to create a second Oracle Instance on NT server?

Hi Cathy
You need to start listener listening for your new instance.

Its been a while since I have done it - so forgive me if this isn't 100 % correct :o) - but try editing Listener.ora in the network\admin directory and adding the second instance name.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = orcl)
    )
    (SID_DESC =
      (SID_NAME = test)
    )
  )

When you have done this - you will need to restart listener. Of course you will need to configure all your tnsnames.ora for the new instance.

Hope this helps

regards

Matt

Matt Griffiths
Manufacturing Systems Analyst
The Document Company, Xerox Ltd (UK)

On Fri, 29 May 1998 13:12:58 -0400, George Nagy <gnagy_at_rim.net> wrote:

>Hi,
>I created a oracle instance (SID: ORCL) successfully and I can login
>Instance Manager.
>Then I created the second oracle instance (SID: TEST) in the same NT
>machine successfully, but I can't login Instance Manager for this
>database alias.
>Oracle Instance Manager returns a error:
>ORA-12505: TNS: listener could not resolve SID given in connect
>descriptor.
>
>Need help.
>
>Thanks.
>
>Cathy
>
Received on Mon Jun 01 1998 - 11:09:05 CDT