Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
to make thing clearer
1 listener for more than 1 Oracle Installation (different Oracle_Home) =
possible (use higher oracle version for listener)
1 listener for 1 Oracle Installation with more than 1 DB Schema (different
SID) = possible
hence 1 port only is needed (to be used by listener)
example below are taken from google
example of listener.ora
LISTENER =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = <hostname>)
(Port = 1521)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = SID1.world)
(SID_NAME = SID1)
(ORACLE_HOME = <ORACLE HOME1>)
)
(SID_DESC =
(GLOBAL_DBNAME = SID2.world)
(SID_NAME = SID2)
(ORACLE_HOME = <ORACLE HOME2>)
)
)
example of tnsnames.ora
SID1.WORLD =
(DESCRIPTION =
(ADDRESS = (COMMUNITY=tcp.world)(PROTOCOL = TCP)(HOST = <hostname>)(PORT
= 1521))
(CONNECT_DATA =
(SID = SID1)
(GLOBAL_NAME = SID1.world)
)
)
SID2.WORLD =
(DESCRIPTION =
(ADDRESS = (COMMUNITY=tcp.world)(PROTOCOL = TCP)(HOST = <hostname>)(PORT
= 1521))
(CONNECT_DATA =
(SID = SID2)
(GLOBAL_NAME = SID2.world)
)
)
On Tue, Nov 30, 2010 at 5:46 PM, Didik Gunawan email@removed wrote:
> you can use 1 listener to serve 2 or more DB service
>
> It is been awhile for me not to use oracle as DB but I think you can get
> the information about MCOD from installation guide
>
>
| __.____._ Copyright © 2010 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
| |  Didik Bhudi
SAP Basis Enthusiast
Contributed 100 posts in a group to earn a Bronze Achievement Related Content Most Popular White Papers
In the Spotlight  _.____.__ |
Mark as helpful
