This discussion is archived
13 Replies Latest reply: Apr 28, 2011 10:15 PM by 822558 RSS

10gR2 database with 11gR2 Grid infrastructure

user130040 Newbie
user130040 Jun 24, 2010 11:17 AM
Currently Being Moderated
I have upgraded the CRS and ASM to 11gR2, but database is still in 10gR2 release. I have removed the database from crs and re-register again with the 10g Oracle home, but unable to start the database using srvctl. But I can start the database using sqlplus.

I have even tried setting LD_LIBRARY_PATH,SHLIB_PATH and TNS_ADMIN pointing to 10g home using "srvctl setene database" command, but no change in the result.


Details:

$ srvctl config database -d racdb
Database unique name: racdb
Database name:
Oracle home: /u03/app/oracle/product/102/db
Oracle user: oracle
Spfile:
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: racdb
Database instances: racdb1,racdb2
Disk Groups:
Services:
Database is administrator managed


$ srvctl start database -d racdb
PRCR-1079 : Failed to start resource ora.racdb.db
CRS-5011: Check of resource "racdb" failed: details at "(:CLSN00007:)" in "/u02/app/oracle/product/11.2.0/grid/log/sf2-db1a/agent/crsd/oraagent_oracle/oraagent_oracle.log"
CRS-2674: Start of 'ora.racdb.db' on 'sf2-db1a' failed
CRS-2632: There are no more servers to try to place resource 'ora.racdb.db' on that would satisfy its placement policy
CRS-5011: Check of resource "racdb" failed: details at "(:CLSN00007:)" in "/u02/app/oracle/product/11.2.0/grid/log/sf2-db2a/agent/crsd/oraagent_oracle/oraagent_oracle.log"

Alert log is not showing any error message, but shutdown about was initiated.

Thu Jun 24 11:03:44 2010
Completed: ALTER DATABASE OPEN
Thu Jun 24 11:03:44 2010
db_recovery_file_dest_size of 5120 MB is 0.50% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Thu Jun 24 11:03:45 2010
Shutting down instance (abort)
License high water mark = 17
Instance terminated by USER, pid = 26322


Same issue with the instance start

$ srvctl start instance -d racdb -i racdb1
PRCR-1013 : Failed to start resource ora.racdb.db
PRCR-1064 : Failed to start resource ora.racdb.db on node sf2-db1a
CRS-5011: Check of resource "racdb" failed: details at "(:CLSN00007:)" in "/u02/app/oracle/product/11.2.0/grid/log/sf2-db1a/agent/crsd/oraagent_oracle/oraagent_oracle.log"
CRS-2674: Start of 'ora.racdb.db' on 'sf2-db1a' failed


Regards
Siva
  • 1. Re: 10gR2 database with 11gR2 Grid infrastructure
    743344 Newbie
    743344 Jun 24, 2010 6:30 PM (in response to user130040)
    Currently Being Moderated
    Fisrt of all, ORACLE_HOME 10g R2 worked fine for me using clusterware 11.2 on RH4,5 and OEL 5, it's a supported configuration too. I'm not sure about the steps you applied and suspect about permissions problems, are you using the some unix user to register and start the database?, I don't remember exactly but I had a problem registering and starting when they were different oracle owners, clusterware (grid) and oracle10(ORACLE_HOME 10gR2). Hope this helps.
  • 2. Re: 10gR2 database with 11gR2 Grid infrastructure
    402451 Newbie
    402451 Jul 8, 2010 5:53 AM (in response to 743344)
    Currently Being Moderated
    Fix for unpublished Bug 8262786 will be included in the 10.2.0.5 patchset, 10.2.0.4.4 CRS PSU, 11.1.0.7.4 CRS PSU, patch 9556796 and Windows Patch 36 for 10.2.0.4. Until the patch is made available, the workaround is to use sqlplus to start the database instead of srvctl
  • 3. Re: 10gR2 database with 11gR2 Grid infrastructure
    user130040 Newbie
    user130040 Jul 8, 2010 9:23 AM (in response to 402451)
    Currently Being Moderated
    Thanks for the details.
  • 4. Re: 10gR2 database with 11gR2 Grid infrastructure
    user130040 Newbie
    user130040 Jul 8, 2010 9:25 AM (in response to 402451)
    Currently Being Moderated
    Thanks for the details.
  • 5. Re: 10gR2 database with 11gR2 Grid infrastructure
    784107 Newbie
    784107 Jul 9, 2010 7:17 AM (in response to user130040)
    Currently Being Moderated
    Siva,

    I will need to do the same as you did. Do you have any detail notes to complete the task such as:

    Step 1: de-register DB and Listerner from Oracle 10gR2 Clusterware;
    Step 2: install Oracle 11gR2 ASM and Clusterware;
    Step 3: re-gister DB and Listerner with Oracle 11gR2;

    If you have, would you mind to provide me? Otherwise, do you have documents or whitepaper for detail instructions? I will really appreciate your help.

    Thanks.

    Ju Jin
  • 6. Re: 10gR2 database with 11gR2 Grid infrastructure
    user130040 Newbie
    user130040 Jul 12, 2010 10:41 AM (in response to 784107)
    Currently Being Moderated
    Hi,

    I have used Oracle documentation and the following Metalink Notes for upgrade.

    Oracle 11gR2 Upgrade Companion [ID 785351.1]
    Complete Checklist for Manual Upgrades to 11gR2 [ID 837570.1]

    When you install 11g Grid infrastructure, it automatically detects the 10g cluster configuration and upgrades the same to 11gR2.

    Then follow the Note 837570.1 for manually upgrading the database to 11gR2.

    To de-register listener and database resources

    crs_stat | grep lsnr

    -- Delete the listener with force option
    crsctl delete resource <listener_resource_name> -f

    Delete the 10g Instance and Database resources from crs

    crs_stat | grep inst
    crsctl delete resource <resource_name>

    To register the database resources again with the new 11g ORACLE_HOME

    srvctl add database -d <db_name> -o <ORACLE_HOME path>

    srvctl add instance -d <db_name> -i <instance_name> -n <node_name>

    Regards
    Siva
  • 7. Re: 10gR2 database with 11gR2 Grid infrastructure
    784107 Newbie
    784107 Jul 13, 2010 10:28 AM (in response to user130040)
    Currently Being Moderated
    Siva - thanks for your responding!

    My situation is:
    1) 10gR2 DB and CRS;
    2) plan to upgrade 11gR2 CRS only, no DB upgrade;

    What's your recommendation? Upgrade or new installation?

    We plan to put GRID home, OCR and Voting Disk on NFS, do you see any issue?

    I am looking forwarding to hearing from you.

    J.J
  • 8. Re: 10gR2 database with 11gR2 Grid infrastructure
    user130040 Newbie
    user130040 Jul 20, 2010 10:22 AM (in response to 784107)
    Currently Being Moderated
    Hi J.J,

    Currently I am upgrading 10g crs to 11g and plan to continue the database in 10g release and test for any issues. Will update you once I have done the upgrade.

    Regards
    Siva
  • 9. Re: 10gR2 database with 11gR2 Grid infrastructure
    726896 Newbie
    726896 Jul 22, 2010 12:50 PM (in response to user130040)
    Currently Being Moderated
    Hi,
    I currently have:
    10gR2 on SLES 9 and planning to move to 11gR2 on SLES 11.
    We wanted to do OS and DB upgrade separately. So, we are doing 11gR2 install and upgrade 10g clusterware and ASM and continue 10gR2 db. In the second phase, we've planned to upgrade the db. So, as part of this I've been trying several things for the past 1 month and looks like the oracle documentation is not clear as to how to upgrade to 11g clusterware considering that they've merged ASM and clusterware into one piece called grid infrastructure, moving ocr and voting disks to ASM or other shared file system.
    To upgrade the clusterware, do I have to:
    1. Keep the 10g Clusterware and ASM up and running
    2. Install Grid infrastrucutre software only
    3. Run ASMCA or DBUA(does not exist in grid infrastrucutre home) to upgrade 10g clusterware and ASM
    4. Install 11gr2 db and then run DBUA

    Are those above steps correct? If not, could you please modify them?
    --> I have tried Install Grid infrastrucutre software only and it does not ask me for clustered or non-clsutered, etc..so it installs on only 1 node.
    --> Is upgrading to 11gR1 clsuterware different than upgrading to 11gR2 clsuterware?
    --> If I have the 10g clsuterware and ASM up and running, and I select Install and configure Grid infrastrucutre for Cluster, it says /etc/oracle/ocr.loc needs to be deleted.
    How do I get this thing done? Please help.
  • 10. Re: 10gR2 database with 11gR2 Grid infrastructure
    user130040 Newbie
    user130040 Jul 22, 2010 1:42 PM (in response to 726896)
    Currently Being Moderated
    Hi,

    I have performed the following steps to upgrade the cluster:

    1. Keep the 10g Clusterware and ASM up and running
    2. Select "Upgrade Grid Infrastructure" option
    3. It will detect the Existing ASM instance and prompt you an alert
    4. Shutdown the DB and then ASM instance.
    5. In Node selection screen, select all the nodes, and make sure "Upgrade ASM" check box is selected.

    Provide the necessary details on further screens, which will upgrade the Cluster and ASM to 11.2.
    Now the ASM instance will be running from 11g GRID_HOME.

    2) Yes, upgrading to 11gR1 clsuterware different than upgrading to 11gR2 clsuterware. In 11gR2, the ASM is part of Grid infrastructure.
    3) You can't have multiple version of clusterware running on the same servers. You have to select "Upgrade Grid Infrastructure" option.

    But after the CRS and ASM upgrade, I couldn't start the 10g database with the 11g cluster, and I am working on it.

    Regards
    Siva
  • 11. Re: 10gR2 database with 11gR2 Grid infrastructure
    user130040 Newbie
    user130040 Jul 30, 2010 1:42 PM (in response to user130040)
    Currently Being Moderated
    This time the 10g database is running fine with 11g grid. I have upgraded 10g crs and asm to 11gR2 grid and started the 10g database using 10g srvctl, which is working fine.

    Not sure, what I have missed on my previous attempt.

    Thanks all for your valuable response.

    Regards
    Siva
  • 12. Re: 10gR2 database with 11gR2 Grid infrastructure
    793396 Newbie
    793396 Sep 27, 2010 11:25 PM (in response to user130040)
    Currently Being Moderated
    hi all,

    I need to install 10.2.0.4(10gr2) with 11gr2 grid infrastructure.Already i installed 11gr2 grid successfully in Windows 2008 R2 Server.

    This is my case:

    OS:Windows Server 2008 R2(64bit-intel)

    In my case there are two application support only 10gr2 and rest of three application support 11g and above.

    I try to install 10gr2 with 11gr2 grid home. while in middle of the installation the error like ASM instance already running.only one ASM instance per system.

    How can resolve this.

    Kindly suggest how to install 10.2.0.4 with 11gr2 grid in windows server 2008 R2 .


    advanced thanks,

    Karthik
  • 13. Re: 10gR2 database with 11gR2 Grid infrastructure
    822558 Newbie
    822558 Apr 28, 2011 10:15 PM (in response to 793396)
    Currently Being Moderated
    Dear Karthik
    More than one ASM in a node is not possible.
    But u have an option to use the 10g and 11g databases.
    which means use the 11g ASM for both the databases.
    Because the 10g ASM will not support the 11g database. But the 11g ASM will support the 10g database and 11g database.
    So better u try in this and let me to know the result.

Actions

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points