Oracle Database Discussions

So, does this Listener port information provided during the Grid Infrastructure have anything to do with the (tns) Listener port # of the databases on the cluster? If so, do all databases (not 'instance') require to have the same Listener port #?

Can you direct me to a clear document on installing SCAN IP on the dns server and/or can you please explain a bit further on how SCAN IP resolves the address to the VIPs of the servers.

Thank you so much for your previous response and many more in advance!

Satish...

http://download.oracle.com/docs/cd/E11882_01/install.112/e10812/concepts.htm#sthref790

Please provide a link that indicates a single cluster can have two or more databases.

Multiple instances is one thing. I would appreciate a link showing a single cluster with multiple system tablespaces.

Why should a cluster not support multiple databases ?
Is there a catch in 11gR2 ?

No Real Application Cluster technology has ever supported more than one database.

RAC is always 1 database with multiple instances.

If you have a second database then you have a second cluster.

Quite untrue.

I know that both you and Tom Kyte take the stand that a cluster should have only 1 instance per node.
That doesn't mean that it is not possible to have more than one database in a cluster -- i.e more than one instance in a node.

That doesn't mean that it must always be so. Installing a separate cluster and additional EE + RAC licences for a separate database can be quite expensive. Of course, your reply is "consolidate". That is another debate that has been going on for years.


A discussion on multiple databases on RAC is also at
http://www.freelists.org/post/oracle-l/multiple-databases-in-a-single-RAC-cluster


Hemant K Chitale

Edited by: Hemant K Chitale on Jan 12, 2010 11:15 AM

I've created multiple databases under 10g RAC, but not on 11g. It's definitely possible, but I had my doubts on whether I should provide the same Listener port (e.g., 1521) to all the databases that run under the 11.2 cluster when I give that port # during the SCAN IP configuration in Grid Infrastructure install.

I haven't done 11g RAC.

However I found this link :
http://sites.google.com/site/connectassysdba/oracle-rac-11-2-multiple-listener

referenced from this thread :
974062


Hemant K Chitale

Thank you very much Hemanth! The link you posted [http://sites.google.com/site/connectassysdba/oracle-rac-11-2-multiple-listener|http://sites.google.com/site/connectassysdba/oracle-rac-11-2-multiple-listener] and the ones before were very helpful!

Satish...

I will give you an example:

Setup: 2 Nodes in the 11gR2 RAC on RHEL4

-- db1, db1 nodes

Install 11gR2 Grid and define SCAN name (which should be registered in DNS with 2 IPs as I have 2 nodes RAC) & port 1521

Install 11gR2 Database server.

Create Instance1 ( e.g. elevenone) using DBCA where ASM storage is used. - This will create a service with database name e.g. elevenone.localdomain

Create Instance2 (e.g. eleventwo) using DBCA where same ASM storage is used. - This will create another service eleventwo.localdomain

Now both instances can be accessed as:

sqlplus user/pwd@scan:1521/elevenone.localdomain

sqlplus usr/pwd@eleventwo.localdomain