Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 2 instances, 1 listener, services summary
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)
)
)
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