multiple listener ?

[jlakhani]

Hello
at times my listerner hangs and I dont find out till after 4hrs of downtime. I was thinkin about creating another listner. What did you guys think? so this way if one listener goes down then the other listener doesnt. question is How would I manage both listenrs. shutting them down and starting them up? etc

[aarroyob]

How many users are connected to the database?

[mrvajrala]

Originally posted by aarroyob
How many users are connected to the database?

Do you think , there is a limit of user connections to a Listener ???

Thanks,
Madhu

[aarroyob]

Originally posted by mrvajrala

Do you think , there is a limit of user connections to a Listener ???

Thanks,
Madhu [/B]

Yes I think there is a limit for user connections, at least for the response time. Maybe if there are too many users will think about to configure MTS.

Regards

Angel

[jlakhani]

well the purpose of my quest to have 2 listeners is because one listener listens for 6 databases. at anytime that listener stops for what ever reason. I wanted to have a backup listener#2 listening for the same instances. How can I achieve that?

[aarroyob]

Originally posted by jlakhani
well the purpose of my quest to have 2 listeners is because one listener listens for 6 databases. at anytime that listener stops for what ever reason. I wanted to have a backup listener#2 listening for the same instances. How can I achieve that?

Just copy the same listener, change the listener_name and the port/s which it listen and go

Regards

Angel

[jlakhani]

this is what i did.
lsnrctl start listener
it started succesfully

then i did lsnrctl start listener2 and i received this error.
LSNRCTL> start listener2
Starting /home/oracle/product/8.1.6/bin/tnslsnr: please wait...

TNSLSNR for HPUX: Version 8.1.6.0.0 - Production
System parameter file is /etc/listener.ora
Log messages written to /home/oracle/product/8.1.6/network/log/listener2.log
TNS-01152: All addresses specified for the listener name, listener2, failed

LSNRCTL> exit
LISTENER = (ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = IPC)
(KEY = listener))
(ADDRESS =
(PROTOCOL = IPC)
(KEY = dbat))
(ADDRESS =
(PROTOCOL = IPC)
(KEY = dbap))
(ADDRESS =
(PROTOCOL = IPC)
(KEY = rort))
(ADDRESS =
(PROTOCOL = tcp)
(HOST = chihport)
(PORT = 1521))
)
CONNECT_TIMEOUT_LISTENER = 90
SID_LIST_LISTENER = (SID_LIST =
(SID_DESC =
(SID_NAME = dbat)
(ORACLE_HOME = /home/oracle/product/8.1.6)
)
(SID_DESC =
(SID_NAME = dbap)
(ORACLE_HOME = /home/oracle/product/8.1.6)
)
(SID_DESC =
(SID_NAME = rort)
(ORACLE_HOME = /home/oracle/product/8.1.6)
)
)
LISTENER2 = (ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = IPC)
(KEY = listener2))
(ADDRESS =
(PROTOCOL = IPC)
(KEY = dbat))
(ADDRESS
(PROTOCOL = IPC)
(KEY = dbap))
(ADDRESS =
(PROTOCOL = IPC)
(KEY = rort))
(ADDRESS =
(PROTOCOL = tcp)
(HOST = chihport)
(PORT = 1527))
)
CONNECT_TIMEOUT_LISTENER = 90
SID_LIST_LISTENER = (SID_LIST =
(SID_DESC =
(SID_NAME = dbat)
(ORACLE_HOME = /home/oracle/product/8.1.6)
)
(SID_DESC =
(SID_NAME = dbap)
(ORACLE_HOME = /home/oracle/product/8.1.6)
)
(SID_DESC =
(SID_NAME = rort)
(ORACLE_HOME = /home/oracle/product/8.1.6)
)
)
)

[aarroyob]

Oh! if you want to start multiple listener at the same time take a look at this note : 149628.1 in metalink

Hope that helps

Angel