Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Multiple listener on RAC 11.2

RTunitnOct 14 2009 — edited Oct 24 2009
Hi all,
I'm planning to migrate my RAC to a brand new 11.2 on rhel 5.4 64 bit

This the situation:
- grid installed on 2 node rac
- 2 vip with standard listener on 1521
- 2 scan vip (I know ... 3 is better, but for a 2 node installation I cant throw away another ip...) with correspective scan listener on 1521
- rac database DB1,which register with standard listener on port 1521

Now I need to create a 2nd rac database "DB2" so it register with only a 2nd listener on port, let's say, 1522.
This would permit me to create acl on firewall: connection to DB1->port 1521, connection to DB2->port 1522

Here's come the problem: how can I add a second listener on a different port?

I've added a listener with

srvctl add listener -l LISTENER_2 -p 1522

now I have to add a scan listener which listen on port 1522:

srvctl add scan_listener -l LISTENER2_ -p 1522
PRCS-1028 : Single Client Access Name listeners already exist


What I'm missing?
I'm lost in 11.2 doc, and also on metalink I cant find anything that helps me...

Regards,
Roberto

Comments

Satishbabu Gunukula
See links

http://www.ardentperf.com/2007/02/28/rac-listener-best-practices/
http://cs.felk.cvut.cz/10gr2/install.102/b25414/rac_cfg.htm#i1033049

Hope this should help.

Regards
Click here to see [Connect by nocycle query gives wrong results|http://www.oracleracexpert.com/2009/08/connect-by-nocycle-query-wrong-results.html]
Click here to learn [Upgrade 8i to 10g|http://www.oracleracexpert.com/2009/08/upgrade-oracle-8i-to-10g.html]
http://www.oracleracexpert.com
RTunitn
Satishbabu Gunukula wrote:
See links

http://www.ardentperf.com/2007/02/28/rac-listener-best-practices/
http://cs.felk.cvut.cz/10gr2/install.102/b25414/rac_cfg.htm#i1033049

Hope this should help.

Regards
Click here to see [Connect by nocycle query gives wrong results|http://www.oracleracexpert.com/2009/08/connect-by-nocycle-query-wrong-results.html]
Click here to learn [Upgrade 8i to 10g|http://www.oracleracexpert.com/2009/08/upgrade-oracle-8i-to-10g.html]
http://www.oracleracexpert.com
Thank you Satishbabu,
but your link points to 10.2 installation.

On 10.2 and also on 11.1 I've been able to create two different listener, listening on different ports and make two databases register with only one listener:

listener_a, port 1521 -> db A register with it
listener_b port 1522 -> db B register with it

So, I can define firewall ACL to grant access on listener_a (db A) and/or listener_b (db B).

On RAC 11.2 things are quite different: clients access the db through scan listener:

sqlplus scott/tiger@cluster-scan:1521/servicename

For a brief explanation see:
http://www.oracle.com/technology/products/database/clustering/pdf/scan.pdf
http://download.oracle.com/docs/cd/E11882_01/rac.112/e10717/intro.htm#BABDIHAD

It seem that I could not add different scan listener on different port on the same subnet, so I can't define any acl.
A client that have access to port 1521 could specify the servicename of db_a or db_b...

I tried also to modify the standard scan listener to add a second port, but it's not supported.

Regards
R.
RTunitn
Solved.
See

http://sites.google.com/site/connectassysdba/oracle-rac-11-2-multiple-listener

Cheers
Roberto
1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 21 2009
Added on Oct 14 2009
#performance-availability, #real-application-clusters
3 comments
6,622 views