Upgrading to Oracle 12

Posted on 2015-02-05
Last Modified: 2015-02-09

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

Question by:joe_echavarria
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 40591131
Latest depends on your Operating System.

I would log into Oracle Support and check the Certification Matrix and available Patchsets for your specific OS.

Author Comment

ID: 40591343
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  ?
LVL 77

Accepted Solution

slightwv (䄆 Netminder) earned 500 total points
ID: 40591359
>>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.
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!


Author Comment

ID: 40591372
Besides two normal databases on that server, there is an ASM database.

Any considerations for upgrading  ASM database to ?
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 40591506
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.

Author Comment

ID: 40591554
What will be the Oracle DOS command inventory to run for finding out everything that might installed about Oracle on the server ?
LVL 77

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 500 total points
ID: 40591575
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:

Featured Post

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Can't Access My Database 57 88
oracle differnce between two timestamps 5 40
sql server store procedure contains temp tables need to convert oracle? 3 38
Oracle Errors 11 52
How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question