Home > Oracle in general > Creating a Oracle 10g Release 2 or 11g Release 1 database on a 11g Release 2 Cluster

Creating a Oracle 10g Release 2 or 11g Release 1 database on a 11g Release 2 Cluster

Today i installed a Oracle 11g Release 2 cluster on Solaris SPARC. Installation went smooth – except installation was not able to set up SSH equivalency automatically so i had to configure it myself.

After installing Oracle 11g R2 grid infrastructure i installed a Oracle 10g Release 2 database binary. Went perfectly fine.

After that i tried to create a database but dbca was unable to recognize the RAC cluster; instead dbca wanted to create a single node database.

This issue can be observed when running a 10.2.0.4.0 or 11.1.0.6.0 or 11.1.0.7.0 database with 11g R2 clusterware. The configuration itself IS supported; but it does not work “out-of-the-box”. This post is about how to fix this error.

When tracing DBCA the following errors were appeared in the log files:

[main] [14:17:25:946] [has.HASContextNative.Native]  prsr_trace: Native: prsr_freeCLSS
[main] [14:17:25:946] [has.HASContextNative.Native]  prsr_trace: prsr_throwException: oracle/ops/mgmt/has/HASContextException[OCR Error--Native: prsr_initCLSS]
[main] [14:17:25:946] [ClusterLock.<init>:56]  ClusterLock Instance Allocation Failed: oracle.ops.mgmt.has.HASContextException: OCR Error(Native: prsr_initCLSS:[21])
[main] [14:17:25:950] [Cluster.isCluster:206]  oracle.ops.mgmt.cluster.Cluster.isCluster(Cluster.java:260)
oracle.ops.mgmt.cluster.Cluster.isCluster(Cluster.java:197)
oracle.sysman.assistants.util.ClusterUtils.<init>(ClusterUtils.java:185)
oracle.sysman.assistants.util.ClusterUtils.getInstance(ClusterUtils.java:236)
oracle.sysman.assistants.dbca.backend.Host.checkOPS(Host.java:2070)
oracle.sysman.assistants.dbca.backend.Host.startOperation(Host.java:2303)
oracle.sysman.assistants.dbca.Dbca.execute(Dbca.java:115)
oracle.sysman.assistants.dbca.Dbca.main(Dbca.java:180)
[main] [14:17:25:950] [Host.checkOPS:2073]  cluster existence:false
[main] [14:17:25:951] [Host.checkOPS:2111]  Cluster installed=false
[Finalizer] [14:17:26:132] [ClusterLock.finalize:88]  ClusterLock: finalized called for oracle.ops.mgmt.has.ClusterLock@1fc3c84

The error itself is know at Oracle but the solution is quite hidden. So this post summarizes it:

1. You need to PIN the CSS service on all of your nodes, e.g.

root@node1:# crsctl pin css -n node1
CRS-4664: Node node1 successfully pinned.
...
[on the other node]
...
root@node2:# crsctl pin css -n node2
CRS-4664: Node node2 successfully pinned.

2. You need to apply Patch 8288940 to your 10g R2 or 11g R1 oracle home

The abstract says: “11106 DBCA TRY TO START 11.2 ASM WHICH IS ALREADY UP, AND REPORT FAILURE”. Altough the abstract says “111060″ the patch is available for 10.2.0.4.0, 11.1.0.6.0 and 11.1.0.7.0.

Without this patch DBCA is unable to detect running 11.2 ASM instance:

DBCA could not startup the ASM instance configured on this node.
To processd with database creation using ASM you need the ASM instance
to be up and running. Do you want to recreate the ASM instance on this node?

3. Creating the pre-11gR2 database instance might fail with:

Encountered file error when copying listeners from home=/u01/app/11.2.0/grid (aka. the Grid Home)

Digging the log file it turned our dbca tries to copy some files in $GRID_HOME/network/admin. Due to tight permissions a user other than the grid infrastructure owner is able to read these files but not able to create new ones:

java.lang.Thread.run(Thread.java:534)
[Thread-392] [14:38:17:942] [NetworkUtilsOPS.copyListeners:725]  Copy /u01/app/11.2.0/grid/network/
admin/endpoints_listener.ora to /u01/app/11.2.0/grid/network/admin/endpoints_listener.ora.node1

Setting $GRID_HOME/network/admin to “775″ permission fixed the problem.

Categories: Oracle in general Tags:
  1. Alex
    May 7th, 2010 at 17:23 | #1

    Hi Ronny

    i have followed the steps and getting further , however im still having issues with the dbca

    below is the error.

    alert.log says

    Errors in file /u01/app/oracle/admin/test/bdump/test1_rbal_26519.trc:
    ORA-15183: ASMLIB initialization error [driver/agent not installed]
    Fri May 7 15:49:35 2010
    Errors in file /u01/app/oracle/admin/test/bdump/test1_rbal_26519.trc:
    ORA-15183: ASMLIB initialization error [/opt/oracle/extapi/64/asm/orcl/1/libasm.so]
    ORA-15183: ASMLIB initialization error [driver/agent not installed]
    Fri May 7 15:49:35 2010
    Errors in file /u01/app/oracle/admin/test/bdump/test1_psp0_26483.trc:
    ORA-00600: internal error code, arguments: [kfkLoadByNum03], [0x06000C4B0], [], [], [], [], [], []
    Fri May 7 15:49:36 2010
    Errors in file /u01/app/oracle/admin/test/bdump/test1_psp0_26483.trc:
    ORA-00600: internal error code, arguments: [kfkLoadByNum03], [0x06000C4B0], [], [], [], [], [], []

    FYI: 11.2 dbca works fine! so it cant be user related

  2. Ronny Egner
    May 10th, 2010 at 16:40 | #2

    Hi Alex,

    interesting problem.

    What does the mentioned file contains?

    Errors in file /u01/app/oracle/admin/test/bdump/test1_rbal_26519.trc:
    ORA-15183: ASMLIB initialization error [driver/agent not installed]

    From the message line i´d start by checking the all required ASM RPMs are installed. You need THREE (two kernel-independ and one kernel-depend which must match your currently running kernel). I suspect you lack these kernel-depended modules….

  3. Mausumi Moharar
    August 3rd, 2010 at 04:08 | #3

    While running dbca from 10.2.0.4 DB HOME on 11GR2 Clusterware( ASM HOME) I was getting this error. Here is what I did to solve the issue.

    1>To run older databases on 11gR2 ASM and Clusterware you need to create a persistent configuration for the nodes on which these databases are meant to run. This is called pinning a node.

    To pin a node in preparation for installing an older Oracle Database version, use /bin/crsctl with the following command syntax, where nodes is a space-delimited list of one or more nodes in the cluster whose configuration you want to pin:

    crsctl pin css -n nodes
    To list all pinned nodes:

    olsnodes -t -n

    2> Create a link for 10G_DB_HOME/network/admin/listener.ora to 11G_GRID_HOME/ network/admin/endpoints_listener.ora

    cd 10G_DB_HOME/network/admin
    ln –s /network/admin/endpoints_listener.ora listener.ora

    3> export TNS_ADMIN=/network/admin

  4. Dennis Flinn
    December 25th, 2010 at 03:40 | #4

    I have installed the V10.2.0.4 software on the V11.2.0.2 clusterware without a issue. When I attempt to use DBCA I can pass all the ASM areas but I get the:

    Encountered file error when copying listeners from home=/u01/app/11.2.0/grid

    And I changed the GRID_HOME/network/admin to 775 but I’m still getting the error and I simply can’t get dbca to work. However, I wanted to ask when you installed the V10.2 software where you the same userid as the installation of the V11.2.0.2 database software? I used a userid of oracle for the V11.2.0.4 database software and grid for the clusterware 11.2.0.4 but a different id for the V10.2.0.4 software. I did however, chech the group memebership is the same for both oracle and the other userid.

    Dennis

  1. March 11th, 2010 at 17:06 | #1
  2. June 6th, 2012 at 20:41 | #2