Re: New Instance on NT - Connection problems?

Hi Bill

I want to add few lines to the Marc Mazerolle message.

Step 1. Go to control panal Stop Listener

step 2. For safer side copy Listenes.ora file to some temp dir.

Step 3. Fololw waht Marc Mazerolle has written, but careful with the positions

Step 4. Go to contol panal Start Listener (If it does not start you have not edited properly in step 3, if you affraid copy back the listener.ora and and do step 3.)

Step 5. You can check the status Start -> run -> LSNRCTL then just type status it shows how many SID's

Regards

Eswar

In article <36C9B59E.29F1C42A_at_sympatico.ca>,   Marc Mazerolle <informaze_at_sympatico.ca> wrote:
> 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
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Feb 18 1999 - 02:35:56 CST