upgrade 10g R2 and 11g R2 to 12c

any one successfully upgrade one instance and really succes without any problem ?

OR what is thep problme you experienced and how you guys solve it?

Please also list down any high level steps, preferrably from the one who really did the migration.

What version of 10g?  Direct upgrade to 12c is supported from 10.2.0.5 and higher.  Documentation for that is here -> http://docs.oracle.com/database/121/UPGRD/intro.htm#UPGRD60047

For upgrades, the best high level steps come from the documentation.  That is where we always start.  The 12c upgrade guide can be found here -> http://docs.oracle.com/database/121/UPGRD/toc.htm

did you tried the update ? any incident and how to solve this ?

basically how many steps, any step by steps upgrade process with screenshot?

"What version of 10g? "

10g R2

As posted, you need the full 4 parts of the version number to determine if direct upgrade is possible.

Every upgrade is different.  There is really nothing that is transferable from one to another.  It all depends on what features you use and how you use them.  That is why you should be going through may iterations of upgrades on non-production databases to figure these things out.

I can say that working in a company with over 80 production databases we can see more than half of them go with no problems at all and then one has a major problem.  We did nothing different and the particular database that has a problem isn't special.

the 10g R2 we have is Version 10.2.0.3.0

"There is really nothing that is transferable from one to another. "

just shutdown the Oracle and copy all data file and log file , archieve log and redo log to the target one, restore the configuration file and data file on the target one will do ?

"I can say that working in a company with over 80 production databases we can see more than half of them go with no problems at all and then one has a major problem."

so that mean 40% of Db server has problem ? it still a huge percentage ! or just 10% ?

what is the major problem is it and how you solve that?

As per the documentation link that I provided, 10.2.0.3 is cannot be upgraded directly to 12.  You would have to have an intermediate upgrade to a version where direct upgrade is supported, or you should be able to do an upgrade with exp/imp (or expdp/impdp).

Not sure why you are including steps to copy all the files.  I don't believe that is required in the upgrade.

Typically we see minor problems in about 5-10% of the upgrades.  Major issues only occur in one or two databases.

There is no one problem or one solution that you ever see.

"you should be able to do an upgrade with exp/imp (or expdp/impdp)."

this will export schema as well ?

"Not sure why you are including steps to copy all the files.  I don't believe that is required in the upgrade."

exp/imp  is the best?

from your point of view, what version should I upgrade to first then 12c ? what is the way to migrate it easily?

RMAN backup and restore ?

any migration wizard to do everything for us ?

we also concern about what has to be change on application so that it can works well with Oracle 12c from Oracle 10g, any reserve keyworld concern and the real need to know informatoin from your experience?

exp/imp (or expdp/impdp) will bring schemas across.  It is a way, it may not be the best way.

If you want to do the 2 step upgrade, I would say the latest version of 10.2 that you can get your hands on and then go to 12.

There is a utility provided to do the upgrade.  It is detailed in the upgrade guide that I already posted a link for.  It is provided by Oracle and is their preferred method of upgrade.

I don't see how you can do an upgrade with RMAN.

Application changes are going to depend on your application.  Nobody else can guide you on that.  The release notes should give you the guidance to see what if anything needs to change.  From my experience, unless you use OCI you are shouldn't need more than a recompile.  Again, it depends on your application.

"exp/imp (or expdp/impdp) will bring schemas across.  It is a way, it may not be the best way.
"

a vendor said it should be no risk on doing this! what is the best way then ?

"If you want to do the 2 step upgrade, I would say the latest version of 10.2 that you can get your hands on and then go to 12."

What is the 2 step upgrade you are referring to ?  you mean upgrade our existing Version 10.2.0.3.0
 to the latest 10g R2 vesrion (like 10.2.0.5 ) and then upgrade to 12c directly ?

"I don't see how you can do an upgrade with RMAN."

ok, ignore it.

"my experience, unless you use OCI you are shouldn't need more than a recompile.
"

what is an OCI ?

from previous PHP and MYSQL ugprade, what we expenice is we need:
1) a POC/test platform to have one of hte database upgrade to the vesrion we want and we test it
2) check the reserved keyword for PHP so that developer can see if any application code needs to be change.

So basically we are going to do some gap analysis, please suggest!

we are using the following language to talk to Oracle:

•      PHP
•      HTML5, JavaScript, Ajax.
•      Oracle APEX

any idea on reserve keyword and sth else needs to be care with migrating from our oracel to 12c ?

run this one  on 10.2.0.3.0 oracle ?

so I strongly belive that 11g Enterprise  11.2.0.1.0 can be upgrade to Oracle 12c direclty ?

so for the machien we can't upgrade direclty like 10.2.0.3.0, we can only relies on export and import.

for any  verions since 10.2.0.5.0 , we can only use the build in upgrade program to do it ?

Like using the migration wizard, exp/imp can have problems.  I have never seen a 100% solution.  Sometimes it works flawlessly, but never all the time.

As for a 2 step upgrade, the first step is to upgrade to a version that supports direct upgrade (see links above already provided).  Then do the direct upgrade to 12c.

If you don't know what OCI is, then you probably aren't using it.  It is a low level API used to connect to Oracle.  Seeing as you seem to be using standard client connections, I don't see a problem with applications.  You probably want to upgrade the Oracle client on the machines.

may I know if I should run that on existing Oracle 10g R2 node:

select *
             from v$reserved_words

Select allOpen in new window

?

one more notes to you, we have middle tier and the middle tier is calls to the PLSQL (Packages, Functions or Procedures). or any reserve keyword ?

"Like using the migration wizard, exp/imp can have problems. "

so all method has problem on it ? but which one is much better?  migration wizard? our vendor said exp and imp, we can't just let problem happen.

"I don't see a problem with applications.  You probably want to upgrade the Oracle client on the machines. "

you mean there will be no problem on application size anyway but just setup a POC to test it ?

so if problem happens, just upgrade oracle client ?

"As for a 2 step upgrade, the first step is to upgrade to a version that supports direct upgrade (see links above already provided).  Then do the direct upgrade to 12c."

we need to use migration wizard to do it but, for the 2 steps upgrade, still have change to get into trouble, right?

There is no solution that will guarantee that it will work every single time under every situation.  Period.

exp/imp can be time prohibitive based on the size of your database.

There is only one answer to all your questions.  Set up a test environment and test.  When you are done, test some more.

"exp/imp can be time prohibitive based on the size of your database."

please explain further about this? you mean if the size of the database is so large, the exp and imp can fail ?

what is the  real life exmaple of THAT SIZE ?

"Set up a test environment and test.  When you are done, test some more. "

as i said before, we will do this but based on the migration expereince, we need both.

a test platform for this kind of test and a reserve keyword list so that programmer can have something to check with.

I ran this:

select *
             from v$reserved_words

Select allOpen in new window

and please see the attached excel file for referring, I am not sure what is that mean and what is it for ?
10gR2-reserved-keyword.xls

Size of the export file shouldn't be an issue.  The time involved in dumping and reloading the database is the issue.  If you have a window of 12 hours to get the upgrade done and the exp/imp takes 14 hours to complete, then it isn't a viable option.

ok.


Any suggest on my find out on reserved keyword using :

select *
             from v$reserved_words

Select allOpen in new window

?

any situation  in which both upgrade wizard and exp/imp doesn't work ? how to solve it ?

no direct upgrade option also means that we can't use DBUA for that, right?

so 12c's DBUA is not helpful for us.

johnsone,

"If you have a window of 12 hours to get the upgrade done and the exp/imp takes 14 hours to complete, then it isn't a viable option."


but for some oracle database we have is 10.2.0.x, no direct upgrade option is possible, so exp/imp should be the only one ?

I see some upgrade methods are::

The methods are:
1. Database Upgrade, using either DBUA or the command-line upgrade scripts
2. Transportable tablespaces (TTS) export and import, using the Oracle Database 12c feature full transportable export/import, or the traditional TTS mode
3. Oracle Data Pump Export/Import, using either dump files or network mode
4. The Original Export/Import utilities

this is only for directly upgrade able version, right ?

As I have posted numerous times here, direct upgrade from some versions of 10.2.0 can be direct upgraded to 12c.

Direct upgrade would be done using dbua.

I have never tried transportable tablespaces to do an upgrade.  It may be possible, but I never tried it.  If there are data file differences between the 2 Oracle versions it could take a lot of time to rewrite the used data blocks.  Again, something you would need to test.

expdp/impdp or exp/imp are the original methods.  With the size of current databases I don't see a lot of people using these anymore for upgrades.

"expdp/impdp or exp/imp are the original methods.  With the size of current databases I don't see a lot of people using these anymore for upgrades. "

so the best method is to upgrade versions of 10.2.0.x to a version which can be direct upgrade to 12c and it should be fastest and easliest one ?

I would think it would be the easiest and least error prone way to do the upgrade.

Johnsone,

it seems that you only tried the DBUA before, right ?

so it is perfect from your point of view ?

good !