Create 10gR2(10.2.0.5) 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 
OS
*racnode1*<oracle:>:/etc=>cat redhat-release
Red Hat Enterprise Linux Server release 5.6 (Tikanga)

Node1:racnode1.ukatru.com
Node2:racnode2.ukatru.com
Scan-Name : racnode-scan.ukatru.com


Step1:Install 10gr2 database and appy 10.2.0.5 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
Usage:
  crsctl pin css -n <node1>[...]
 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*<oracle:onedv1_1>:/u01/app/oracle1/product/10.2.0.5/db_1=>export ORACLE_HOME=/u01/app/oracle1/product/10.2.0.5/db_1
export TNS_ADMIN=/u01/app/11.2.0/grid/network/admin
*racnode1*<oracle:onedv1_1>:/u01/app/oracle1/product/10.2.0.5/db_1=>cd bin
*racnode1*<oracle:onedv1_1>:/u01/app/oracle1/product/10.2.0.5/db_1/bin=>./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*<oracle:ora10g1>:/u01/app/11.2.0/grid/bin=>/u01/app/oracle1/product/10.2.0.5/db_1/bin/srvctl 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 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = racnode-scan.ukatru.com )(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ora10g.ukatru.com)
    )
  )