RE: [UPDATE] Creating New 10G DB With DBCA in 11g Grid Can't Find ASM Instance
- From: "Langston, Chris" <Chris.Langston@xxxxxx>
- To: Guenadi Jilevski <gjilevski@xxxxxxxxx>, "rprabha01@xxxxxxxxx" <rprabha01@xxxxxxxxx>
- Date: Wed, 24 Aug 2011 21:19:13 +0000
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@xxxxxxxxx]
Sent: Tuesday, August 23, 2011 8:46 PM
To: rprabha01@xxxxxxxxx
Cc: Langston, Chris; oracle-l@xxxxxxxxxxxxx
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@raclinux1 stage10g]$ olsnodes -t
raclinux1 Unpinned
raclinux2 Unpinned
[grid@raclinux1 stage10g]$
[root@raclinux1 bin]# ./crsctl pin css -n raclinux1
CRS-4664: Node raclinux1 successfully pinned.
[root@raclinux1 bin]#
[root@raclinux2 bin]# ./crsctl pin css -n raclinux2
CRS-4664: Node raclinux2 successfully pinned.
[root@raclinux2 bin]#
[grid@raclinux1 stage10g]$ olsnodes -t
raclinux1 Pinned
raclinux2 Pinned
[grid@raclinux1 stage10g]$
Regards,
Guenadi Jilevski
On Wed, Aug 24, 2011 at 4:09 AM, Rajeev Prabhakar
<rprabha01@xxxxxxxxx<mailto:rprabha01@xxxxxxxxx>> 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@xxxxxx<mailto:Chris.Langston@xxxxxx>> 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@xxxxxx<mailto:chris.langston@xxxxxx>
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » RE: [UPDATE] Creating New 10G DB With DBCA in 11g Grid Can't Find ASM Instance - Langston, Chris
