Re: How to connect 2 instance?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 02 Nov 1998 07:42:50 +0100
Message-ID: <363D5469.1A43BCE6@sybrandb.demon.nl>

Hi Violin,

One listener per node is sufficient, you need to make the existing listener listen for the new database. Three ways to do it:

- use net easy config
- use Oracle Network Manager (for more complex hierarchical database networks)
- quick and dirty

I will describe the quick and dirty here. Edit c:\orant (oracle_home)\network\admin\listener.ora. There already is one block for the current sid, it starts with sid_list_listener, and there are sections in it for each individual sid.
Simply copy and paste, change the sid to ora2 in the second block. Then the tnsnames.ora needs to be changed (this change should be made on all clients) and a similar operation should be done: copy the block for the existing database, change the sid and save. You should now be able to connect to the new instance with eg plus33 scott/tiger_at_ora2.

Hth,
Sybrand Bakker, Oracle DBA

Violin wrote:

> Hello,
> If I have 2 instances on NT with 2 services:OracleServiceORA1,OracleServiceORA2,
> (instances were created by oradim.exe
> and I don't want to set ORACLE_SID in REGEDIT)
>
> should I start 2 Listener Services on control pannel(OracleTNSListener)?
> How to config 2 listener services on listener.ora?
> Is 1 Listener service enough?
> How to config the listener.ora?
>
> And how to start / stop each listener?
> Could you give me any solution?
> Thank you so much :)
>
> Please Cc to: violin.hsiao_at_mail.pouchen.com.tw
> Thank you for your help.
> Violin.
Received on Mon Nov 02 1998 - 00:42:50 CST