Home » RDBMS Server » Server Administration » Oracle 10g upgrade to 11g with asm non rac (hpux)
Oracle 10g upgrade to 11g with asm non rac [message #644236] Sun, 01 November 2015 06:01 Go to next message
bas_vbs
Messages: 27
Registered: January 2011
Location: india
Junior Member
Hello Folks,



We planned to upgrade Oracle 10g (10.2.0.4.0) to Oracle 11g (11.2.0.4.0),its non rac database running on HPUX with ASM



I want to break upgrade in 2 parts -

- ASM upgrade

-DB upgrade





while upgrade ASM (10.2.0.4.0) facing some challenges,like i followed

installing oracle 11g grid infra,then upgrading asm



but while 11g grid infra its not detecting active running 10.2.0.4.0 asm instance which i need to upgrade

after some attempts it installed oracle 11g grid software(selected upgrade -3rd option),but not upgraded asm

in logs and in gui ,-migrate asm-?false appeared



please let me know if you face this



or better please share steps to upgrade 1og to 11g non rac db instance (no messy oracle document please,i gone through many of them found not helping)



if you done this activity,steps you followed seems may be helpful





Thanks in advance
Re: Oracle 10g upgrade to 11g with asm non rac [message #644240 is a reply to message #644236] Sun, 01 November 2015 06:24 Go to previous messageGo to next message
Michel Cadot
Messages: 65317
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

4 years we wait for your feedback in your previous topic.

Re: Oracle 10g upgrade to 11g with asm non rac [message #644243 is a reply to message #644236] Sun, 01 November 2015 11:02 Go to previous messageGo to next message
John Watson
Messages: 7212
Registered: January 2010
Location: Global Village
Senior Member
There isn't really anything to upgrade with ASM. If you've installed GI, just create an ASM instance and point the asm_diskstring to the disc devices you are using. It should discover and mount the disc groups.

That having been said, installing GI 11.2.0.4 is rather silly. It is already out of premier support. What's wrong GI 12.1.0.2?
Re: Oracle 10g upgrade to 11g with asm non rac [message #644250 is a reply to message #644240] Mon, 02 November 2015 00:57 Go to previous messageGo to next message
bas_vbs
Messages: 27
Registered: January 2011
Location: india
Junior Member
Thanks John,

I will update again details about existing setup
Oracle 10g(10.2.0.4.0) running on HPUX non rac/standalone with asm (all db related files on asm),3 instance running on same server
oracle home is common for all 3 instance and asm instance

its client requirement we have to upgrade 11gr2
as i mentioned 11g grid installation went through smoothly but refer to documentation it should detect running asm instance(10g -instance ) already used by existing database and upgrade it to 11g as first part,if i follow different approach to documentation

how to handle asm instance in upgrade processes,it asm is not there i would simply upgraded 10g database to 11g which i have done many in non asm setup,without any need to install 11g grid infra software,as per document mentioned that it is required for asm upgrade to 11g

your suggestion as below ,seems assume there is no existing asm instance,in my case 10g asm instance is already present and all db files are mounted on this asm instance

>>just create an ASM instance and point the asm_diskstring to the disc devices you are using. It should discover and mount the disc groups.



Re: Oracle 10g upgrade to 11g with asm non rac [message #644329 is a reply to message #644250] Tue, 03 November 2015 06:53 Go to previous messageGo to next message
EdStevens
Messages: 887
Registered: September 2013
Senior Member
bas_vbs wrote on Mon, 02 November 2015 00:57

Oracle 10g(10.2.0.4.0) running on HPUX non rac/standalone with asm (all db related files on asm),3 instance running on same server
oracle home is common for all 3 instance and asm instance


Please clarify. When you say "oracle home is common for all 3 instance and asm instance", that seems to say the the db home is the same as the ASM home. This cannot be and I'm pretty sure that is not what you meant, but it is a point that needs clarification/confirmation.
Re: Oracle 10g upgrade to 11g with asm non rac [message #644330 is a reply to message #644329] Tue, 03 November 2015 06:57 Go to previous messageGo to next message
John Watson
Messages: 7212
Registered: January 2010
Location: Global Village
Senior Member
In releases < 11.2, the ASM instance ran off the same binaries as the RDBMS instance. There was also a cut down version of the cssd shipped with the RDBMS binaries. So one Oracle Home was all you needed - though people would usually install two, if only so that they could be patched independently.

What OP has failed to understand is that you can't really upgrade an ASM instnce. All you do is start a new one, off the new Oracle Home, and configure it to find the same discs.
Re: Oracle 10g upgrade to 11g with asm non rac [message #644331 is a reply to message #644250] Tue, 03 November 2015 07:00 Go to previous messageGo to next message
John Watson
Messages: 7212
Registered: January 2010
Location: Global Village
Senior Member
Quote:
its client requirement we have to upgrade 11gr2

You might want to clarify this. I have never had a client stipulate a version for GI. Why should they? Is it possible that they do not realize that the RDBMS and GI are independent products?
Re: Oracle 10g upgrade to 11g with asm non rac [message #644335 is a reply to message #644331] Tue, 03 November 2015 08:54 Go to previous messageGo to next message
bas_vbs
Messages: 27
Registered: January 2011
Location: india
Junior Member
I am referring what oracle docs are suggesting,as per it,oracle db home is in oracle 11g binaries (non grid 11g gi) will asm work in oracle 11g (without gi)
in short can I avoid installing 11g gi(grid) if no why it is required

thanks
Re: Oracle 10g upgrade to 11g with asm non rac [message #644336 is a reply to message #644335] Tue, 03 November 2015 08:56 Go to previous messageGo to next message
BlackSwan
Messages: 25792
Registered: January 2009
Location: SoCal
Senior Member
grid is NOT required for Oracle DB
Re: Oracle 10g upgrade to 11g with asm non rac [message #644337 is a reply to message #644336] Tue, 03 November 2015 08:57 Go to previous messageGo to next message
bas_vbs
Messages: 27
Registered: January 2011
Location: india
Junior Member
>>grid is NOT required for Oracle DB

is it true for oracle db with asm also ,I can avoid installing grid
Re: Oracle 10g upgrade to 11g with asm non rac [message #644339 is a reply to message #644337] Tue, 03 November 2015 09:04 Go to previous messageGo to next message
BlackSwan
Messages: 25792
Registered: January 2009
Location: SoCal
Senior Member
bas_vbs wrote on Tue, 03 November 2015 06:57
>>grid is NOT required for Oracle DB

is it true for oracle db with asm also ,I can avoid installing grid


is GOOGLE broken for you?

https://www.google.com/webhp?hl=en&tab=ww#hl=en&q=oracle+asm+installation
Re: Oracle 10g upgrade to 11g with asm non rac [message #644340 is a reply to message #644337] Tue, 03 November 2015 09:09 Go to previous messageGo to next message
Michel Cadot
Messages: 65317
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

http://docs.oracle.com/cd/E11882_01/install.112/e47689/oraclerestart.htm#LADBI999

Quote:
The Oracle Grid Infrastructure for a standalone server is the Oracle software that provides system support for an Oracle database including volume management, file system, and automatic restart capabilities. If you plan to use Oracle Restart or Oracle Automatic Storage Management (Oracle ASM), then you must install Oracle Grid Infrastructure before you install and create the database. Oracle Grid Infrastructure for a standalone server is the software that includes Oracle Restart and Oracle ASM. Oracle combines the two infrastructure products into a single set of binaries that is installed as the Oracle Grid Infrastructure home.

Re: Oracle 10g upgrade to 11g with asm non rac [message #644341 is a reply to message #644339] Tue, 03 November 2015 09:16 Go to previous messageGo to next message
bas_vbs
Messages: 27
Registered: January 2011
Location: india
Junior Member
google and oracle docs are the first and primary things referred it has no clear answer to this,if so please share link of doc which has answer to below

I repeat again specific for upgrading 10g db with asm to 11g db with asm ,11g gi is required to install or just oracle 11g binary is enough
Re: Oracle 10g upgrade to 11g with asm non rac [message #644343 is a reply to message #644341] Tue, 03 November 2015 09:46 Go to previous messageGo to next message
John Watson
Messages: 7212
Registered: January 2010
Location: Global Village
Senior Member
The answer is perfectly clear. Just to reiterate: releases <= 11.1.x, ASM was shipped with the RDBMS. In releases >=11.2.x, ASM is shipped with GI.

Are you sure that want to proceed? You could go to your client and explain that you need either some training or some consultancy support. He should not have a problem with that, but will definitely have a problem if you proceed with inadequate skills.
Re: Oracle 10g upgrade to 11g with asm non rac [message #644344 is a reply to message #644341] Tue, 03 November 2015 10:23 Go to previous messageGo to next message
Michel Cadot
Messages: 65317
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

What is not clear in "If you plan to use Oracle Automatic Storage Management (Oracle ASM), then you must install Oracle Grid Infrastructure"?

Re: Oracle 10g upgrade to 11g with asm non rac [message #644353 is a reply to message #644344] Tue, 03 November 2015 12:04 Go to previous messageGo to next message
scapy
Messages: 12
Registered: November 2015
Location: Portugal
Junior Member
Hi,

Have you search on Metalink for upgrade ASM??
Alternative Procedure To Upgrade ASM From Release 10.2 Or 11.1 To Release 11.2.0.# or To 12.1.0.1 On Unix/Linux Configurations (Standalone) Using ASM Role separation. (Doc ID 1645523.1)

You have to do aditional steps from 10.2 to 11.2. Read the MOS note and then reply to forum, if you have any problem.

Cumps
Re: Oracle 10g upgrade to 11g with asm non rac [message #644578 is a reply to message #644353] Tue, 10 November 2015 02:14 Go to previous messageGo to next message
bas_vbs
Messages: 27
Registered: January 2011
Location: india
Junior Member
i copied asm init file from old (10g asm home ) to 11g grid asm home
started asm instancw from 11g grid asm home,it discovered diskgroups
config cluster services,with old oracle 10 db,asm is working fine (old 10g oracle db and new 11 grid asm)

installed oracle 11g binaries on new oracle home
while mounting or opening in upgrade mode givig error as below

ORA-15064: communication failure with ASM instance
ORA-15295: ASM instance software version 11.2.0.1.0 less than client version 11.2.0.4.0

(additionally i also srvctl config asm and srvctl add asm,


Thanks
Re: Oracle 10g upgrade to 11g with asm non rac [message #644579 is a reply to message #644578] Tue, 10 November 2015 02:40 Go to previous messageGo to next message
John Watson
Messages: 7212
Registered: January 2010
Location: Global Village
Senior Member
What do you get from these:
crsctl stat res -t -init
crsctl stat res -t
Please make sure that you use [code] tags to enclose the output as I did above, described here How to use [code] tags and make your code easier to read
Re: Oracle 10g upgrade to 11g with asm non rac [message #644580 is a reply to message #644578] Tue, 10 November 2015 04:08 Go to previous messageGo to next message
scapy
Messages: 12
Registered: November 2015
Location: Portugal
Junior Member
bas_vbs wrote on Tue, 10 November 2015 02:14
i copied asm init file from old (10g asm home ) to 11g grid asm home
started asm instancw from 11g grid asm home,it discovered diskgroups
config cluster services,with old oracle 10 db,asm is working fine (old 10g oracle db and new 11 grid asm)

installed oracle 11g binaries on new oracle home
while mounting or opening in upgrade mode givig error as below

ORA-15064: communication failure with ASM instance
ORA-15295: ASM instance software version 11.2.0.1.0 less than client version 11.2.0.4.0

(additionally i also srvctl config asm and srvctl add asm,


Thanks


Have you read the MOS note, that i had sent in my previous post??
Why you copy the init and start de ASM instance??
To upgrade ASM 10.2 to 11.2, first of all you have to:

-remove current CSS service
-delete current ASM istance
--In previous you had install the GI software only

--In ASM old HOME, you have to deconfig old home, and in new home (11g) you have to configure new CSS e OHA
...... And some of the other steps to configure the new parameters in 11g GI (OHAS,etc)

Have you made some of this steps?
Re: Oracle 10g upgrade to 11g with asm non rac [message #644588 is a reply to message #644580] Tue, 10 November 2015 06:08 Go to previous messageGo to next message
scapy
Messages: 12
Registered: November 2015
Location: Portugal
Junior Member
If you can't see MOS note, i sent to you in PM message, see this link

https://oracleinstall.wordpress.com/2011/03/23/steps-to-upgrade-10-2-0-4-single-instance-with-asm-storage-to-11-2-0-2/
Re: Oracle 10g upgrade to 11g with asm non rac [message #644682 is a reply to message #644588] Fri, 13 November 2015 01:42 Go to previous messageGo to next message
bas_vbs
Messages: 27
Registered: January 2011
Location: india
Junior Member
As per document shared/link followed
step 15) dont gives output
KFOD-00313: file not found
can still proceed further to next step or some issue in the installation


when changing arguments to include full path
KFOD-00313: No ASM instances available. CSS group services were successfully initilized by kgxgncin

[Updated on: Fri, 13 November 2015 01:50]

Report message to a moderator

Re: Oracle 10g upgrade to 11g with asm non rac [message #644686 is a reply to message #644682] Fri, 13 November 2015 02:13 Go to previous messageGo to next message
bas_vbs
Messages: 27
Registered: January 2011
Location: india
Junior Member
further fiddling around and trying below worked

kfod disks=all op=disks

it given successful report
Re: Oracle 10g upgrade to 11g with asm non rac [message #644694 is a reply to message #644686] Fri, 13 November 2015 04:41 Go to previous messageGo to next message
bas_vbs
Messages: 27
Registered: January 2011
Location: india
Junior Member
Hello Scapy
after following steps you shared ,finally i am strucking at same place same as i was facing initially ,



ORA-15295: ASM instance software version 11.2.0.1.0 less than client version 11.
2.0.4.0
ORA-00210: cannot open the specified control file
ORA-00202: control file: 'control01.ctl'
ORA-17503: ksfdopn:2

summarasing what steps followed
1)followed steps as per document you shared
2)installed 11g grid in new oracle home(which will be asm home)
3)followed steps as per document you shared

4)ASM in 11g grid home seems to be ok(grid 11g version -11.2.0.1.0)
started services aand tested to be ok(like css,crs,oracle restart)
5)installed oracle 11g binaries(11.2.0.4.0) in new oracle home
6)when tried to mount 11g db instance it given error as above

Re: Oracle 10g upgrade to 11g with asm non rac [message #644695 is a reply to message #644694] Fri, 13 November 2015 05:04 Go to previous messageGo to next message
John Watson
Messages: 7212
Registered: January 2010
Location: Global Village
Senior Member
Look, just start again. Do it from the beginning, and do it right. At the moment, you have installed GI 11.2.01 and RDBMS 11.2.0.4. That is an impossible combination.

Do what I suggested two weeks ago: install GI 12.1.0.2, then RDBMS 11.2.0.4.

Re: Oracle 10g upgrade to 11g with asm non rac [message #644696 is a reply to message #644695] Fri, 13 November 2015 05:52 Go to previous messageGo to next message
scapy
Messages: 12
Registered: November 2015
Location: Portugal
Junior Member
Hi bas_vbs,

Before you doing something, you have to read the docs.
Have you made a search on google for the error?
As John Watson saied, you can't have this combination. you have two options, or install GI 11.2.0.4 or install GI 12, and then you can have your database in 11.2.0.4
Re: Oracle 10g upgrade to 11g with asm non rac [message #644852 is a reply to message #644696] Wed, 18 November 2015 22:36 Go to previous message
bas_vbs
Messages: 27
Registered: January 2011
Location: india
Junior Member
thanks Scapy

it got upgraded successfully,both asm and db home to 11gr2 with compatible software of same version for gi
i am working for patching both db home and grid to latest psu

i see for gi psu again steps are different,will test it and update you
Previous Topic: TNS-03502: Message 3502 not found
Next Topic: Cannot start Oracle -- unable to find file
Goto Forum:
  


Current Time: Tue Jan 16 02:43:05 CST 2018

Total time taken to generate the page: 0.01249 seconds