Re: Creating New 10G DB With DBCA in 11g Grid Can't Find ASM Instance

There are two things to pay attention to if using 10gR2 in GI 11:

1. A solution for Bug 8288940, when DBCA fails to create a database if ASM is used, is in patch 8288940 included with 10.2.0.5 (MOS Note 948456.1).
2. In order to create a 10g database the servers in the cluster need to be pinned.

Ex. After fresh 11.2 install pin for 10Gr2 install and db create

[grid_at_raclinux1 stage10g]$ olsnodes -t

raclinux1 Unpinned
raclinux2 Unpinned

[grid_at_raclinux1 stage10g]$

[root_at_raclinux1 bin]# ./crsctl pin css -n raclinux1

CRS-4664: Node raclinux1 successfully pinned.

[root_at_raclinux1 bin]#

[root_at_raclinux2 bin]# ./crsctl pin css -n raclinux2

CRS-4664: Node raclinux2 successfully pinned.

[root_at_raclinux2 bin]#

[grid_at_raclinux1 stage10g]$ olsnodes -t

raclinux1 Pinned

raclinux2 Pinned

[grid_at_raclinux1 stage10g]$

Regards,

Guenadi Jilevski

On Wed, Aug 24, 2011 at 4:09 AM, Rajeev Prabhakar <rprabha01_at_gmail.com>wrote:

> Hello Chris,
>
> I had encountered a similar issue
> more than a year back. In our case,
> it turned out that clusterware didn't
> have correct/upgraded OH details.
>
> Updating and removing old OH information via srvctl resolved it.
>
> ocrdump could give you some
> insight.
>
> Thanks,
> Rajeev
>
> On Aug 23, 2011, at 4:51 PM, "Langston, Chris" <Chris.Langston_at_aa.com>
> wrote:
>
> List Guru's,
>>
>> I'm trying to create a 10g database on an upgraded 11g grid using DBCA (to
>> replicate the steps done previously when both DB and Grid were 10g) and on
>> Step 7, after selecting "Automatic Storage Management" and clicking "Next",
>> I get:
>>
>> DBCA could not startup the ASM instance configured on
>> this node. To proceed 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?
>>
>> I click "No" because ASM (11g) is running on that node: there are several
>> existing 10g databases currently using it.
>>
>> Details:
>> 1) Trying to create a 10g 2 node RAC database on HP-UX B.11.31 using an
>> ASM instance attached to SAN storage.
>> 2) Grid and ASM have been recently upgraded to 11g. Plans to do the
>> databases are in the works but I need this one up now.
>> 3) There are existing 10g databases on the same nodes that have no
>> problem seeing the 11g ASM instance.
>> 4) The existing 10g databases were created when ASM/grid were at 10g
>> version.
>> 5) Tried setting ORACLE_HOME to the 10g DB and 11g grid/ASM locations to
>> no avail.
>>
>> I've searched the Internet and Oracle Support (metalink) but the closest
>> information I can find deals with existing 10g databases that need to
>> connect after ASM is upgraded to 11g. Can't seem to locate information for
>> creating a new 10g database to an 11g grid.
>>
>> As you might infer by my job title, I'm not a pure DBA; just a programmer
>> with some DBA training. If someone could point me in the right direction or
>> the location of some documentation on the subject, I'd greatly appreciate
>> it.
>>
>> Thanks,
>> Chris Langston |Sr. Object Oriented Programmer| American Airlines® |
>> 817-963-9659 | chris.langston_at_aa.com
>>
>>
>> --
>> http://www.freelists.org/**webpage/oracle-l<http://www.freelists.org/webpage/oracle-l>
>>
>>
>> --
> http://www.freelists.org/**webpage/oracle-l<http://www.freelists.org/webpage/oracle-l>
>
>
>

--
http://www.freelists.org/webpage/oracle-l