Yes, this can be done, here is an example...
####
# LSNR01
####
LSNR01 =
(ADDRESS_LIST =
(ADDRESS= (PROTOCOL= IPC)(KEY=LSNR01))
(ADDRESS= (PROTOCOL= TCP)(Host=host.domain)(Port= 1521))
)
SID_LIST_LSNR01 =
(SID_LIST =
(SID_DESC =
(SID_NAME = oradb01)
(ORACLE_HOME=/dbms/ora00/app/oracle/product/8.0.6)
(ENVS='EPC_DISABLED=TRUE')
)
(SID_DESC =
(SID_NAME = oradb02)
(ORACLE_HOME=/dbms/ora00/app/oracle/product/8.0.6)
(ENVS='EPC_DISABLED=TRUE')
)
)
STARTUP_WAIT_TIME_LSNR01 = 0
CONNECT_TIMEOUT_LSNR01 = 10
TRACE_LEVEL_LSNR01 = OFF
####
# LSNR02
####
LSNR02 =
(ADDRESS_LIST =
(ADDRESS= (PROTOCOL= IPC)(KEY=LSNR02))
(ADDRESS= (PROTOCOL= TCP)(Host=host.domain)(Port= 1526))
)
SID_LIST_LSNR02 =
(SID_LIST =
(SID_DESC =
(SID_NAME = oradb01)
(ORACLE_HOME=/dbms/ora00/app/oracle/product/8.0.6)
(ENVS='EPC_DISABLED=TRUE')
)
(SID_DESC =
(SID_NAME = oradb02)
(ORACLE_HOME=/dbms/ora00/app/oracle/product/8.0.6)
(ENVS='EPC_DISABLED=TRUE')
)
)
STARTUP_WAIT_TIME_LSNR02 = 0
CONNECT_TIMEOUT_LSNR02 = 10
TRACE_LEVEL_LSNR02 = OFF
> Andrey Bronfin wrote:
>
>
> Dear all !
>
> I'm going to administer an Oracle 8.1.6 DB on Sun 220 machine .
> Most of the SQL statements against the DB will retrieve a values from
> a BLOB or a CLOB column .
> Typical LOB size is ~25 - 50K .
> We expect ~ 700 such queries per second .
>
> The question : someone suggested me to configure more than one
> listener on the DB server in order to balance the load .
> Do U think it's appropriate ? Does anyone have any experience with
> multiple listeners on the same machine and for the SAME INSTANCE ?
> How can i implement multiple listeners ?
> Are there any papers on this
Received on Mon Aug 07 2000 - 08:54:35 CDT
