Re: how can listener list on two ports for the same db?

Yechiel Adar Thu, 30 May 2002 07:29:03 -0700

Title: how can listener list on two ports for the same db?

Hello Helmut

You need to configure the listener to listen on ONE host with 2 ports.

The machine name is the same.

You separate the connections via tnsnames.ora on the client side.

I got a call today that one of our application server

can not connect to a database

after tech people move an application server to another place.

Connected to the database from my PC - OK.

I activated tnsping from the server itself and could not get response.

I changed the tnsnames, on the application server, to access a second

network card and all is well.

I accessed the database via another NIC without any change to the database server.

Yechiel Adar
Mehish

----- Original Message -----

From: Daiminger, Helmut

To: Multiple recipients of list ORACLE-L

Sent: Wednesday, May 29, 2002 11:28 AM

Subject: how can listener list on two ports for the same db?

Hi!

We have a db server (in a cluster) with two NICs and two IP-Adresses (i.e. logical names in the cluster). How do I configure the listener so that it listenes for both logical names of the machine?

LISTCMDB =
(DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = kfplcmdb)(PORT = 1522))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = kfalcmdb)(PORT = 1522))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_CMDB))
      )
    )
)

SID_LIST_LISTCMDB =
(SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc_CMDB)
      (ORACLE_HOME = /cmdb/u0x/u01/app/oracle/product/8.1.7)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = CMDB)
      (ORACLE_HOME = /cmdb/u0x/u01/app/oracle/product/8.1.7)
      (SID_NAME = CMDB)
    )
)

Sitting on our RMAN database machine, pinging kfplcmdb does not work but pinging kfalcmdb works fine.

On th emachine to be backed up: why can't I use kfalcmdb in the listener.ora file? The listener works fine when using kfplcmdb.

This is 8.1.7 on Solaris 8.

Thanks,
Helmut

Re: how can listener list on two ports for the same db?

Reply via email to