Home > oracle-install > Create 10gR2( database on 11gR2 ASM and Cluster

Create 10gR2( database on 11gR2 ASM and Cluster

In this article we will look at creating database 10gR2 database on 11gR2 asm and cluster.

Env : Two node Rac 
*racnode1*:/etc=>cat redhat-release
Red Hat Enterprise Linux Server release 5.6 (Tikanga)

Scan-Name : racnode-scan.ukatru.com

Step1:Install 10gr2 database and appy patch set(We don’t get any issues while installation)

To run older database on 11gR2 ASM and clusterware we need to create a persistent configuration for the nodes(pinning a node).Cluster configuration in 11gR2 is dynamic.This dynamic configuration is incompatible with older database releases:
If we don’t pinn nodes dbca will not recognize the rac cluster;instead dbca will create a single node database.

Please check metalin for following article if you face any more issues while creating 10gR2 database.

Pre 11.2 Database Issues in 11gR2 Grid Infrastructure Environment [ID 948456.1]

Pinning nodes:

[root@racnode1 bin]# ./crsctl pin css -h
  crsctl pin css -n […]
 Pin the nodes (make leases non-expiring).

[root@racnode1 bin]# ./crsctl pin css -n racnode1
CRS-4664: Node racnode1 successfully pinned.
[root@racnode1 bin]# ./crsctl pin css -n racnode2
CRS-4664: Node racnode2 successfully pinned.
[root@racnode1 bin]# ./olsnodes -n -t
racnode1        1       Pinned
racnode2        2       Pinned

*racnode1*:/u01/app/oracle1/product/>export ORACLE_HOME=/u01/app/oracle1/product/

export TNS_ADMIN=/u01/app/11.2.0/grid/network/admin
*racnode1*:/u01/app/oracle1/product/>cd bin
*racnode1*:/u01/app/oracle1/product/>./dbca &

now dbca failed with following error:

Encountered file error when copying listeners from home=/u01/app/11.2.0/grid/(The grid home).

sol:Setting $GRID_HOME/network/admin to 775 permisson fixed the problem.

Issues faced:

Solution :

click on Back and select Initialization parameter and changed REMOTE_LISTENER to : racnode-scan.ukatru.com:1521 and set ora10g1.LOCAL_LISTENER and ora10g2.LOCAL_LISTENER to empty values.

 *racnode1*:/u01/app/11.2.0/grid/bin=>/u01/app/oracle1/product/ status database -d ora10g
Instance ora10g1 is running on node racnode1
Instance ora10g2 is running on node racnode2

Advantage : you can use scan name in the tns entries instead of virtual ip from each node.
ORA10G =
    (ADDRESS = (PROTOCOL = TCP)(HOST = racnode-scan.ukatru.com )(PORT = 1521))
      (SERVICE_NAME = ora10g.ukatru.com)

Categories: oracle-install
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: