RE: [UPDATE] Creating New 10G DB With DBCA in 11g Grid Can't Find ASM Instance

From: Langston, Chris <Chris.Langston_at_aa.com>
Date: Wed, 24 Aug 2011 21:19:13 +0000
Message-ID: <C8E7536604C8B14D8DE3CBF3C5453F9805D1D514_at_020-SN1MPN1-005.020d.mgd.msft.net>

Our databases are at 10.2.0.4 and I've been told not to expect any patching until it's upgraded to 11g - and there isn't a confirmed date for that, yet. Last patch for the grid was, 12419353. So it looks like I'm stuck until they apply the patch or the RDBMS is upgraded to 11g. Thanks, Guenadi, for pointing out the MOS note that explained what error. It's exactly what I'm experiencing but I can't do anything on my own about it because there's more than just our group with databases on these servers.

I'm grateful for the assistance!

Chris Langston

From: Guenadi Jilevski [mailto:gjilevski_at_gmail.com] Sent: Tuesday, August 23, 2011 8:46 PM
To: rprabha01_at_gmail.com
Cc: Langston, Chris; oracle-l_at_freelists.org Subject: Re: Creating New 10G DB With DBCA in 11g Grid Can't Find ASM Instance

Hi,

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<mailto: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<mailto: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(r) |817-963-9659<tel:817-963-9659> | chris.langston_at_aa.com<mailto: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

Received on Wed Aug 24 2011 - 16:19:13 CDT