Leave a Comment:
33 comments
Hi atul,
Nice doc..
Appreciate your efforts.
Thanks a ton for you to keep us updated to latest oracle technologies.
Thanks,
Venu
One doubt..
Is is mandatory to modify compatibility parameter before 11g upgrade?
Thanks,
Venu
Hi Atul
Could you please let me know the downtime of upgrade.
Rgds
DBA.
Hi Atul
Post db upgrade when trying to bring db up,got below error message.
Kindly let me know the possibility of error.
SQL> startup
ORACLE instance started.
Total System Global Area 284565504 bytes
Fixed Size 1299428 bytes
Variable Size 92277788 bytes
Database Buffers 188743680 bytes
Redo Buffers 2244608 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
Process ID: 12879
Session ID: 155 Serial number: 3
Rgds
ReplyORA-01092: ORACLE instance terminated Disconnection forced is a generic error when Oracle detects a serious problem at database start time.
Check alert log and see root cause of issue
ReplyHello, Thanks for the information. We are upgrading and moving the database from one server to another at the same time. What should the process of upgrade be? Should we upgrade the db first before moving it to the new server or upgrade it after?
ReplyDid you already upgrade an Oracle 10g RAC instance to Oracle 11g RAC with ASM?
ReplyHi Atul,
What would be the additional steps in case of a physical standby database?
Can you please post the sequence of that also and where it fits in the list of steps that you have mentioned here?
Many thanks for this article.
Thanks
Nagarajan
hi
this is very good Doc .. I was Done successfully done Oracle 10g to 11g up gradation.
thx a lot…
we r excepting Doc’s from ur side.
thanks
Boopathi.P
Hi Shiva,
Even i too came across the same situvation, pls try to run the catuprd script or try to query the dba_data_files from another window. Probably you could see all the datafiles.
Thanks,
Dhanasekar
Hi Beta,
this is champak lal gada from dhaulakuan Delhi.
I would like to thank you for this wondrful article on behalf of my grandson.
Regards,
Champak
hi atul
your article is very good. If possible please send atleast 60 pages for my projects.
Reply@ ashokreddy,
You can get your 60 pages from
http://download.oracle.com/docs/cd/B28359_01/server.111/b28300/toc.htm
ReplyHi,
Need your input on Oracle database upgrade from 10g (10.2.04) to 11gR2. (Both ebusiness suite 11.5.10) and other Non ERP systems running on oracle database 10g.
Does the upgrade impacts any of the applications (for example database procedures, packages, tables, forms etc.. does the code needs to be modified).
Would it be possible to know before the upgrade to identify the application programs/codes getting impacted
Thanks
Rajesha
Hi Atul/Colleague,
We are on Oracle apps 12.0.6 and database 10gR2.I need your help, how & what to explain to management that we should go for 11gR2 from 1ogR2
Regards,
Reply@aisufi,
Most convincing point is support matrix, check when is 10gR2 going out of support for 12.0.6 and then present it to management.
For technical reasons, check new features in 11gR1 and see if you are planning to use some of those features.
Replyhello,
i dont find the “utlu111i.sql”-file in the oracle-home-folder 🙁
I can download this file somewhere separately?
thanks for any answers
best regards
Reply@ tralveller,
Are you using 11gR1 or 11gR2 software ?
Are you looking for this file in new Home or Old Home ?
If you are using 11gR1 and looking in new Oracle_Home then could you please confirm what installation type you used (client , server..)
ReplyWe have db on 10g. which i will be upgarding to 11g with encryption of 1 tablespace.
AS the scope is just to encrypt 1 tablespace with upgrade(from 10g to 11gR1), i am using the approach for upgeade to 11gR1 as mention by you in above steps.
Question is the 10g database which I will be upgrading to 11gR1 has 3 tablespace which are in read only status. In this case can I still use above steps to upgrade or no?
Regards,
ReplyHi Atul,
I refer the document, which helps alot during the upgrade the DB.
ReplyHi,
We have running EBS on single node (apps,db on same server) on linux.
Now we have planned to migrate database from linux to AIX while apps will remain on linux(split EBS to two nodes).
Can anyone help how this will be done.
Regards,
Muhammad Shahid
Hi,
We have running EBS 12.0.6 on single node (apps,db(10.2.0.3) on same server) on linux4.
Now we have planned to migrate database 10g from linux to AIX 5.3 while apps will remain on linux(split EBS to two nodes).
I know that this will be done with export/import.
But on new AIX server we should install oracle 10g from normal media or EBS db media.
Is there any difference both 10g media’s( like in utility,packages,autoconfig etc).
Can anyone help how this will be done.
Regards,
Muhammad Shahid
thanks for sharing. you can find complete steps with screenshots at following link.
http://www.solarishowto.com/?p=574
Reply@ muhammad.shahid,
How about using transportable database for platform migratio?
Check metalink note 734763.1 Using Transportable Database to migrate E-Business Suite R12 Using Oracle Database 10gR2 or 11g
Check if there are any limitations for migration from Linux to AIX at http://www.oracle.com/technetwork/database/features/availability/maa-wp-10gr2-platformmigrationtdb-131164.pdf
Replycan anyone tell me whether any dataloss may happen while upgrading oracle 10g to 11g?
ReplyHi Atul,
I reviewed the above document, Which is very useful for go through and practice later. Hope it is useful for every one who recommends from 10g to 11g.
Thanks in advance and keep posting for any updates.
Reply