With respect to the listener, one listener can listen for multiple
databases. Here's a sample where three instances are ORCL, FC, and CPC on
one machine.
################
# Filename......: listener.ora
# Node..........: local.world
# Date..........: 24-MAY-94 13:23:20
################
LISTENER =
(ADDRESS_LIST =
(ADDRESS=
(PROTOCOL= IPC)
(KEY= oracle.world)
)
(ADDRESS=
(PROTOCOL= IPC)
(KEY= ORCL)
)
(ADDRESS=
(PROTOCOL= IPC)
(KEY= FC)
)
(ADDRESS=
(PROTOCOL= IPC)
(KEY= CPC)
)
(ADDRESS=
(COMMUNITY= TCP.world)
(Host = ibsdatabase)
(PROTOCOL= TCP)
(Port= 1521)
)
(ADDRESS=
(COMMUNITY= TCP.world)
(Host = ibsdatabase)
(PROTOCOL= TCP)
(Port= 1526)
)
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = ORCL)
)
(SID_DESC =
(SID_NAME = FC)
)
(SID_DESC =
(SID_NAME = CPC)
)
)
PASSWORDS_LISTENER = (oracle)
Joelle Tan wrote in message <6hopam$i5d$1_at_news.tm.net.my>...
>Dear helpers,
>
>Well, is it possible to have more than two database instances on a server?
>For example, 'ORCL' (default), 'instance1' and 'instance2'.
>If yes, how am I supposed to configure the LISTENER.ORA file in order to
>start these instances at once?? I managed to start the default (ORCL) and
>'instance1' by changing the (SID_NAME = SID) in LISTENER.ORA file to
>(SID_NAME =instance1). Then followed on by executing the following command:
>
>LSNRCTL > Start Listener
>
>By doing this, i could only use 'Instance1' as the Service Name in Login
>Information Dialogue Box in order to access any Oracle Enterprise Manager.
>
>Or in another case, leave the 'Service' textbox blank. In this case i am
>logging on to the deafult instance = orcl.
>
>From the documentation, it says we could configure multiple network
>listeners, each for a specific database and all the listeners on a single
>machine share one LISTENER.ORA file. Does this statement mean that there’s
>strictly no two or more LISTENER configuration files in a server?
>
>Thank you
>Jo
>
>
>
>
>
Received on Thu Apr 23 1998 - 21:17:15 CDT
