Re: Several db on the same server

From: <ajitsingh_at_hotmail.com>
Date: 1998/02/01
Message-ID: <886345222.1382613001@dejanews.com>#1/1

Hi,

I worked primarily on Unix boxes so I don't know whether I got your question right. I think on one machine running NT you are trying to create multiple databases. I understand that this process has gone thru successfully.

To access these multiples databases on the same m/c you will require separate listeners. All you need to do is add another listener in your listener.ora file for the 2nd database (mention SID, hostname etc.) and start it using lsnrctl. For example, you defined a new listener by the name listener1, you start it by giving "start listener1" command at the lsnrctl prompt. I think you should be able to connect to the database#2 using the second listener. I hope that I got it right.

If you are unable to configure the second listener, send me a mail. I'll send you a listener.ora with two listeners defined.

I hope this helps.
Ajit

---

In article <34d451f6.7912111_at_news.urz.uni-heidelberg.de>,   guido_schmedding_at_krzmail.krz.uni-heidelberg.de wrote:

>

> I 'd like to run several databases on the same Oracle 7(.3.4)
> Workgroup Server for Windows NT. But neither the Oracle Enterprice
> Manager nor the SQL*Net recognizes the second database although all
> services and instances are running.
> How can I configure tho listener to recognize additional SIDs?

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet

Received on Sun Feb 01 1998 - 00:00:00 CST