Coskan’s Approach to Oracle

September 11, 2010

“DBCA could not startup the ASM instance configured on this node” error for lower versions with 11GR2 GI

Filed under: RAC — coskan @ 9:14 am

Last 3 days ,I have been trying to have the toy environment at home, for 11GR2 upgrade project at work.

The challenge was building exactly same environment on virtual machine. Problem is that I did not built the environment at work so I had no idea about tricks which are not clear in doc.

The environment is;

Oracle 2 node RAC with 11GR2 clusterware July PSU with ASM storage

Database with 10.2.0.4.2  with no local listener.

I installed the grid with some minor problems which are not todays topic. Problems solved and grid was completely healthy.

I then installed 10.2.0.4 binaries pinned the nodes for lower version installation as documented in official installation doc like below from GI home


[root@cosarac1 ~]$
crsctl pin css -n cosarac1,cosarac2
[oracle@cosarac1 ~]$ olsnodes -t -n
cosarac1        1       Pinned
cosarac2        2       Pinned

And I ran dbca from 10.2.0.4  and when I chose storage as ASM I started to get “DBCA could not startup the ASM instance configured on this node. To proceed with the database creation using ASM, ASM instance needs to be up and running. Do you want to recreate ASM instance on this node?”  warning.

Checked if ASM is up and running and it was and also being listened by my default listener. So what was the problem ?

Google+otn forums is again the answer

Basically during the installation you need to link the listener.ora in oracle home to listener.ora in grid home

cd <10G_DB_HOME>/network/admin

ln –s <11G_GRID_HOME>/network/admin/endpoints_listener.ora listener.ora

After you create the link it, please do not expect that  it will  just work , because it won’t:)

You also need to have TNS_ADMIN env setting to make dbca work with ASM. (You don’t need to set it on both nodes you only need to set it in the session of the node you run dbca.)

export TNS_ADMIN=<10G_DB_HOME>/network/admin

There is also a bug and one off patch available (8288940) but because our environment did not have 10.2.0.4 home patched with that one of patch  (At office DB was installed before GI upgrade) I did not bother to install the patch when there is a beautiful easy peasy solution.

What I learnt from this  creating the same toy environment at home practice is that,  building a VM RAC following a guide is just 3-4 hours work (for this particular one I followed Tim Halls 11GR2 RAC installation Guide for RAC on Virtualbox )but once you change some of the things in the tutorial  you follow,  then you invite the trouble which is very teaching practice. I learned hell a lot just with this 2 node RAC installation.  Once you learn how to install a rac I suggest you to try to learn how to break a RAC installation :)

Next challenge is building the DR of the Same environment (not with RAC due to resource problem). Maybe I can find something to write about.

About these ads

3 Comments »

  1. Hi Coskan,

    please be aware of Note 948456.1 if you have a mixed environment with 11gR2 GI and <11gR2 RDBMS.

    Also, when you apply GI PSU patches, for pre 11gR2 RDBMS you should apply RDBMS part of pre 11gR2 CRS as stated in Note 1064804.1.

    When having a mixed environment with 11.2.0.1.2 GI (July PSU) and pre 11gR2 RDBMS, there is a severe bug regarding availability when you loose public LAN on one node. It is fixed in 11.2.0.2 PSU. We´ll see if the fix it will be in Oct PSU for 11.2.0.1.

    Best regards,
    Martin
    OCM 11g
    http://www.ora-solutions.net

    Comment by Martin Decker — October 1, 2010 @ 8:00 am

    • Thanks for this valuable comment Martin, It is somehow found itself in spam folder and now released from spam status.

      Comment by coskan — October 5, 2010 @ 9:25 pm

  2. Hi Coskan,

    Your wording and your link do not match!

    Your wording is “Basically during the installation you need to link the listener.ora in oracle home to listener.ora in grid home”

    your link links back to the endpoints_listener.ora

    I have been having a similar issue with dbca creating a database. Till today I did not know that there exists a file named: endpoints_listener.ora in my 11.2.0.1 grid OH/network/admin

    My issue may be that port 1522 is specified in the endpoints_listener.ora when in reality the only port we are using is 1521. Apparently the install / upgrade process from 11.1.07 built the file with port 1522.

    I have not proved if that is my only issue because I can’t just change endpoints_listener.ora today because we are talking a production environment.

    Comment by Lynn Sattler — October 15, 2010 @ 7:57 pm


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

The Silver is the New Black Theme. Create a free website or blog at WordPress.com.

Follow

Get every new post delivered to your Inbox.

Join 199 other followers

%d bloggers like this: