Re: could i have more than two database instances?

Joelle,

It is possible to run multiple instances on the same server and a single listener serving both. ( Configure address list and sid list for your listener )

If you need to run a second listener you need to configure a second listener port in your services file since no two listeners can listen on the same port.Also you need to put similar configuration settings for the second listener in the same listener.ora file usually at the end of the file.

Best of Luck,

Biju Joseph

In article <6hopam$i5d$1_at_news.tm.net.my>,   "Joelle Tan" <tjoelle_at_tm.net.my> wrote:
>
> Dear helpers,
>
> Well, is it possible to have more than two database instances on a server?
> For example, 'ORCL' (default), 'instance1' and 'instance2'.
> If yes, how am I supposed to configure the LISTENER.ORA file in order to
> start these instances at once?? I managed to start the default (ORCL) and
> 'instance1' by changing the (SID_NAME = SID) in LISTENER.ORA file to
> (SID_NAME =instance1). Then followed on by executing the following command:
>
> LSNRCTL > Start Listener
>
> By doing this, i could only use 'Instance1' as the Service Name in Login
> Information Dialogue Box in order to access any Oracle Enterprise Manager.
>
> Or in another case, leave the 'Service' textbox blank. In this case i am
> logging on to the deafult instance = orcl.
>
> From the documentation, it says we could configure multiple network
> listeners, each for a specific database and all the listeners on a single
> machine share one LISTENER.ORA file. Does this statement mean that there’s
> strictly no two or more LISTENER configuration files in a server?
>
> Thank you
> Jo
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Sun Apr 26 1998 - 04:46:40 CDT