cancel
Showing results for 
Search instead for 
Did you mean: 

2 Netlsnr for a single Oracle instance

Foo_Bar_BLN
Level 3

Hello,

if it possible to have 2 listener running for 1 Oracle SID. I be able to do that fromm commandline, but dont know how to configure it in VCS. I could not find a appropriate attribute for startup parameters.

lsncrctl start l1 
lsncrctl start l2

I think monitoring should not be the the problem, I can modify a second LsnrTest.pl.

any hints are verry welcome - THX!

Thomas

 

 

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

frankgfan
Level 6
   VIP   

do not edit agent ArgList.

there is an attribute called Listener for Netlsnr agent

this attribute is for "Name of Listener. The name for Listener is considered case-insensitive by
the Netlsnr agent and the Oracle database server.
Default is LISTENER."

Example of two listener configuration (VCS 6.2 for Linux)

Listener 1

Netlsnr LSNR_oramktg_lsnr (
Owner = oramktg
Home = "/orahome/Oracle"
TnsAdmin = "/orahome/Oracle/network/admin"
Listener = LISTENER_MKTG
MonScript = "./bin/Netlsnr/LsnrTest.pl"
LsnrPwd = xxxxxxxx
)

Listener 2

Netlsnr LSNR_oraprod_lsnr (
Owner = oraprod
Home = "/orahome/Oracle"
TnsAdmin = "/orahome/Oracle/network/admin"
Listener = LISTENER_PROD
MonScript = "./bin/Netlsnr/LsnrTest.pl"
LsnrPwd = xxxxxxxx
)

please consult with the VCS admin guide and VCS Oracle agent guide (for your version of VCS as each version of the guide contains some version specific info which is not appicapble to other versions) for more details.

View solution in original post

8 REPLIES 8

RiaanBadenhorst
Moderator
Moderator
Partner    VIP    Accredited Certified

Just copy the existing listener resource and change the attributes so it looks at the second listener. Then link the new listener.

yes, that was my first idea, but I couldn't find a attribute to set the different startup parameters!

frankgfan
Level 6
   VIP   

to find out the Netlsnr related parameters, run the command below

hatype -display Netlsnr

you may also consullt with an oracle dba about needed settings in listener.ora and tnsnames.ora

you can find sample oracle and Oracle listener configuration in VCS Admin guide or in /etc/VRTSvcs/conf/sample_configure folder

as I wrote, I be able to start the two listener from the command line.
I only want to know how can I configure it in VCS.
It seems there is a ArgList attribute, where maybe I can set the listener name, but I'm not sure how to set this exactly.

tunix2k
Level 5
Partner Accredited

Hi,

 

the property is Listener. It is the name of the listener. Oracle default is Listener I mean, in your example l1 and l2.

 

ciao

tunix2k

frankgfan
Level 6
   VIP   

do not edit agent ArgList.

there is an attribute called Listener for Netlsnr agent

this attribute is for "Name of Listener. The name for Listener is considered case-insensitive by
the Netlsnr agent and the Oracle database server.
Default is LISTENER."

Example of two listener configuration (VCS 6.2 for Linux)

Listener 1

Netlsnr LSNR_oramktg_lsnr (
Owner = oramktg
Home = "/orahome/Oracle"
TnsAdmin = "/orahome/Oracle/network/admin"
Listener = LISTENER_MKTG
MonScript = "./bin/Netlsnr/LsnrTest.pl"
LsnrPwd = xxxxxxxx
)

Listener 2

Netlsnr LSNR_oraprod_lsnr (
Owner = oraprod
Home = "/orahome/Oracle"
TnsAdmin = "/orahome/Oracle/network/admin"
Listener = LISTENER_PROD
MonScript = "./bin/Netlsnr/LsnrTest.pl"
LsnrPwd = xxxxxxxx
)

please consult with the VCS admin guide and VCS Oracle agent guide (for your version of VCS as each version of the guide contains some version specific info which is not appicapble to other versions) for more details.

View solution in original post

@frankgfan awesome, thats what I'm looking for!

Thank you!

RB-Infinitely
Level 4

Hi,

You don't need to modify the script. It takes the parameters from the resource configuration. Below is an example of a lsnrclt resource. 

Netlsnr LSNR_oracle (
        Owner = oracle
        Home = "/orahome/Oracle"
        TnsAdmin = "/orahome/Oracle/network/admin"
        Listener = LISTENER_ORACLE
        MonScript = "./bin/Netlsnr/LsnrTest.pl"

 You can see here that the Listener is monitoring is called LISTENER_ORACLE

If you want to make another LISTENER in Oracle and call it LISTENER2 then you need to create another resource and use the following parameters.

Netlsnr LSNR_oracle (
        Owner = oracle
        Home = "/orahome/Oracle"
        TnsAdmin = "/orahome/Oracle/network/admin"
        Listener = LISTENER2
        MonScript = "./bin/Netlsnr/LsnrTest.pl"