Upgrading to Oracle 12


  What is the latest Oracle 12.x available for upgrading an Oracle 11g server and ASM ?

joe_echavarriaDatabase AdministratorAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

slightwv (䄆 Netminder) Commented:
Latest depends on your Operating System.

I would log into Oracle Support and check the Certification Matrix and available Patchsets for your specific OS.
joe_echavarriaDatabase AdministratorAuthor Commented:
I just found that it will be Oracle for my windows x64 64 bit 2008 R2 server.

On which section of the Oracle Support i can download that version for upgrading ?

And what considerations when upgrading from  to the  ?
slightwv (䄆 Netminder) Commented:
>>On which section of the Oracle Support i can download that version for upgrading ?

Since there isn't a patchset for Windows that I'm aware of, you can download it from here:

>>And what considerations when upgrading from  to the  ?

Should be no different from upgrading any version of Oracle.  I would look through the docs for new features and deprecated/removed ones.

Focusing more on the features/functions no longer available...

I'm currently testing upgrades from to and haven't seem anything major as far as compatibility.  Your database might be using options and features that I do not.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

joe_echavarriaDatabase AdministratorAuthor Commented:
Besides two normal databases on that server, there is an ASM database.

Any considerations for upgrading  ASM database to ?
slightwv (䄆 Netminder) Commented:
I've never used ASM but I cannot imagine there isn't a seamless upgrade path.

Maybe another Expert that has done an ASM upgrade to 12.1 will have more information later.
joe_echavarriaDatabase AdministratorAuthor Commented:
What will be the Oracle DOS command inventory to run for finding out everything that might installed about Oracle on the server ?
slightwv (䄆 Netminder) Commented:
I don't believe there is one.  At least not easily.  You could write code to parse the inventory file or open it up and just look at it.  It is XML based.

To see what is installed in the Oracle Home, you typically just run the installer and look at installed products.

Then you need to see what each database may or may not have installed or be using.  Just because you have an option installed doesn't mean the database is using it.

There are queries for that.   Examples can be found here:
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.