Home » Applications » Oracle Fusion Apps & E-Business Suite » Migrating 11i(11.5.9 /9.2.07) on hp to R12.1.3/11.2.02 on AIX 6.1‎ (11.5.9 /9.2.07 and R12.1.3/11.2.02)
Migrating 11i(11.5.9 /9.2.07) on hp to R12.1.3/11.2.02 on AIX 6.1‎ [message #535495] Wed, 14 December 2011 06:01 Go to next message
dafon
Messages: 9
Registered: December 2011
Junior Member
Hello Experts,
I have read some blogs regarding database migration of 11i on different platforms.I do need some advice on the best approach.

Here is my current env.that require some guidelines
I have my DB(9207) and concurrent manager/Admin tier on HP server (11.5.9) . 32 bit
The Apache/report is on REDHAT Linux 32 bit

My Objective is to have DB/Apps tier as a single node on AIX 6.1 by doing a fresh Install of R12.1.3
and migrate the Database/Apps tier to AIX. The database is going to be 11.2.0.2
(ie Apps Install R12.1.1 and upgrade to 12.1.3
upgrade rdbms 11.1.0.7 to 11.2.02 ) and then
start migrating the db/apps from hp to AIX
From the blog,It doesn't look like 9207 is supported as per #369693.1
Please let me know the best approach and any metalink note that can useful for the purpose.
Note: I can't not do any database upgrade to10gR2 at this time.

Thanks for your help and advice.

Dayo
Re: Migrating 11i(11.5.9 /9.2.07) on hp to R12.1.3/11.2.02 on AIX 6.1‎ [message #535511 is a reply to message #535495] Wed, 14 December 2011 07:30 Go to previous messageGo to next message
John Watson
Messages: 4489
Registered: January 2010
Location: Global Village
Senior Member
This is a huge task, horribly complicated. There are many metalink articles such as 230627.1 and 238276.1 that will help, but none that will tell you exactly what to do. I have done similar operations, the last one was moving from a split configuration on Linux to single node on AIX. It took several weeks of testing.
You can't do it in one operation.
There are many dependencies between the versions and platforms of each component.
You will be installing zillions of EBS, forms, and DB patches.
If I were you, I would try this sequence:

1. Install an 11.5.9 middle tier on AIX and remove the 11.5.9 middle tier from Linux
2. Create 11.2 DB on AIX
3. Move DB (with exp/imp) and concurrent processing (you'll have to ask Oracle to write a patch for this) from HPUX to AIX
4. Upgrade 11.5.9 apps to 12.1

You'll need weeks, possibly months, of testing to develop a reliable, repeatable, technique.

Good luck.
Re: Migrating 11i(11.5.9 /9.2.07) on hp to R12.1.3/11.2.02 on AIX 6.1‎ [message #535519 is a reply to message #535511] Wed, 14 December 2011 08:14 Go to previous messageGo to next message
dafon
Messages: 9
Registered: December 2011
Junior Member

Thanks John,
The approach sound good but due to the time schedule I will probably not have that much time to do series of testing and another issue is that Oracle DEV do take time to create a patch request.
One clarification on steps 1 and 2:
1) Install an 11.5.9 middle tier on AIX and remove the 11.5.9 middle tier from Linux
-- you are saying the middle tier on Linux should be remove after installing 11.5.9 on AIX
The new env.that I am going to have will have both the db and apps tier (single node) on AIX
My thought is having the 1159 on a single node(db/apps) on AIX should be good.

2) Create 11.2 DB on AIX
-Do you mean installing 11.2. software only on AIX and then do an exp/imp of 9207 from hp to AIX.
Re: Migrating 11i(11.5.9 /9.2.07) on hp to R12.1.3/11.2.02 on AIX 6.1‎ [message #535520 is a reply to message #535519] Wed, 14 December 2011 08:27 Go to previous messageGo to next message
John Watson
Messages: 4489
Registered: January 2010
Location: Global Village
Senior Member
Quote:
another issue is that Oracle DEV do take time to create a patch request.
No, it is an automated procedure, takes about half an hour.

Quote:
I will probably not have that much time to do series of testing
Then you can't do it. Full stop.

Quote:
you are saying the middle tier on Linux should be remove after installing 11.5.9 on AIX
Yes, unless you want to proceed with two middle tiers.


Quote:
The new env.that I am going to have will have both the db and apps tier (single node) on AIX
Er... are you under the impression that you can do a brand new 12.1 install, and somehow move the data over? You haven't looked at those notes I gave, have you. It doesn't work like that.

Quote:
Do you mean installing 11.2. software only on AIX and then do an exp/imp of 9207 from hp to AIX
Yes (with complications.)
Re: Migrating 11i(11.5.9 /9.2.07) on hp to R12.1.3/11.2.02 on AIX 6.1‎ [message #535526 is a reply to message #535520] Wed, 14 December 2011 09:05 Go to previous messageGo to next message
dafon
Messages: 9
Registered: December 2011
Junior Member
Thanks. I have discussed with my Project manager and we are going to use a diff.approach by
1)Installing R12.1.1
2)Upgrade 12.1.1 to 12.1.3 by applying maintenance patches
3)upgrade apps db 11.1.0.7 to 11.2.0
steps 1-3 will be on AIX


4)Create a dblink from AIX to HP
5)Write a conversion program using the the dblink to move
over all open tranx data from HP(1159) to AIX(1213)

6)All other tranx will be move to another database essbase

The above processes sound good.

Thanks
Dayo
Re: R12.1.3 /opmn failed due to XML parse: missing instance name attribute -- using instance id [message #544600 is a reply to message #535495] Wed, 22 February 2012 15:19 Go to previous message
dafon
Messages: 9
Registered: December 2011
Junior Member
Apps Guru,
Can you please help. I have tried many changes and none seems to be working.

error:
XML parse: missing instance name attribute -- using instance id

I am having problem starting opmnctl on my PC hosting RH5.6 with R12.1.3

/u01/oraapps/R12/apps/tech_st/10.1.3/opmn/bin
[applmgr@knowers bin]$ opmnctl start
XML parse: missing instance name attribute -- using instance id
OPMN log file open failed: /u01/oraapps/R12/inst/apps/VIS_knowers/ora/10.1.2/opmn/logs//opmn.log (No such file or directory)
opmnctl: opmn start failed.


###############################
/u01/oraapps/R12/apps/tech_st/10.1.3/opmn/bin
[applmgr@knowers bin]$ cd ..
[applmgr@knowers opmn]$ ls -la
total 28
drwxr-xr-x 7 applmgr dba 4096 Feb 20 11:14 .
drwxr-xr-x 61 applmgr dba 4096 Feb 20 11:15 ..
drwxrwxr-x 2 applmgr dba 4096 Feb 20 11:15 bin
drwxrwxr-x 3 applmgr dba 4096 Feb 20 11:16 conf
drwxrwxr-x 2 applmgr dba 4096 Nov 28 2008 lib
drwxr-xr-x 6 applmgr dba 4096 Feb 20 11:15 logs
drwxrwxr-x 2 applmgr dba 4096 Dec 29 2006 mesg
###############################

Thanks
Previous Topic: No One Knows? Help on OAB Fast Formula Testing
Next Topic: XML parse: missing instance name attribute -- using instance id
Goto Forum:
  


Current Time: Fri Aug 22 17:02:44 CDT 2014

Total time taken to generate the page: 0.14434 seconds