Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> 2 instances, 1 listener, services summary

2 instances, 1 listener, services summary

From: yls177 <yls177_at_hotmail.com>
Date: 21 Nov 2004 18:48:41 -0800
Message-ID: <c06e4d68.0411211848.4b173103@posting.google.com>


i have an oracle user who has 2 instances and they have the same oracle home from "env". Therefore, 2 instances are having the same listener, tnsnames configuration.

Of course, the initsid.ora are different.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = myhost)(PORT = 1521))

)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = instance_1)
(ORACLE_HOME = /oracle/product/8.1.7)
(SID_NAME = idea)

)
)

  1. status of lisenter gives the below Services Summary... instance_1 has 2 service handler(s) instance_2 has 2 service handler(s) instance_1 has 1 service handler(s) instance_1 has 2 service handler(s) instance_1 has 2 service handler(s) instance_2 has 2 service handler(s) instance_2 has 2 service handler(s)
  2. both instances has the same port number.
  3. in my listener configuration, i have only the instance_1 configuration.
  4. both instances share the same oracle user

Questions
i) I am puzzled by the list of services summary as shown above.What does it mean?
ii) in my listener configuration, i have only the entry for instance 1. And i have checked that when i su to the oracle user , the instance is instance_1. Received on Sun Nov 21 2004 - 20:48:41 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US