Re: Connectivity help

From: HansF <News.Hans_at_telus.net>
Date: Thu, 10 Nov 2005 22:52:11 GMT
Message-ID: <pan.2005.11.10.22.52.10.351693@telus.net>

On first glance, it looks like you might be confusing processes ...

The approach I generally use for configuration is:

1. Make sure each listener is configured:

A Listener [generally] only listens for Oracle requests on one machine. It can, however, listen on behalf of any number of database instances on that machine.

When a request comes in, it looks up whether it can respond for that service - either in the listener.ora or in the in-memory copy of the listener.ora which may be modified because of self-registering database instances.

You apparently have a listener and a listener2 on each database server. That doen't make sense. You probably only want one, and only one, listener for each server machine.

My listener.ora ON EACH SERVER would probably be like

listener =
  (description =
(address = (protocol = tcp)(host = server?.me.com)(port = 1521))
  )

sid_list_listener =
  (sid_list =
(sid_desc =

      (global_dbname = ora?)
      (oracle_home = c:\oracle\ora92)
      (sid_name = ora?)

    )

replacing ? with 1,2, or 3 depending on the server 'number'. You could actually use the same sid_name on all three servers, but that might confuse you.

2) For each client, configure the tnsnames.ora

Frequent point of confusion - a database instance runs in 2 modes ... as a server, and as a client in a DBLink & replication config. Also, the database server comes with software such as tnsping, sqlplus, etc tha is client software. Therefore, the tnsnames.ora must be configured as if it was a simple client.

My tnsnames.ora ON EACH SERVER would be like

ora1 =
(description =

(address_list =

      (address = (protocol = tcp)(host = server1.me.com)(port = 1521)))
(connect_data = (service_name = ora1))
)

ora2 =
(description =

(address_list =

      (address = (protocol = tcp)(host = server2.me.com)(port = 1521)))
(connect_data = (service_name = ora2))
)

ora3 =
(description =

(address_list =

      (address = (protocol = tcp)(host = server3.me.com)(port = 1521)))
(connect_data = (service_name = ora3))
)

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** Top posting relies guarantees I won't respond. ***

Received on Thu Nov 10 2005 - 16:52:11 CST