Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Upgrading to Oracle 12

Posted on 2015-02-05
7
Medium Priority
?
172 Views
Last Modified: 2015-02-09
Hi,

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

Regards,
0
Comment
Question by:joe_echavarria
[X]
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
7 Comments
 
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.
0
 
LVL 1

Author Comment

by:joe_echavarria
ID: 40591343
I just found that it will be Oracle 12.1.0.2.0 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 11.2.0.4.0  to the 12.1.0.2.0  ?
0
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 2000 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:
http://www.oracle.com/technetwork/database/enterprise-edition/downloads/database12c-win64-download-2297732.html

>>And what considerations when upgrading from 11.2.0.4.0  to the 12.1.0.2.0  ?

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 11.2.0.3 to 12.1.0.2 and haven't seem anything major as far as compatibility.  Your database might be using options and features that I do not.
0
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 
LVL 1

Author Comment

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

Any considerations for upgrading 11.2.0.4.0  ASM database to 12.1.0.2.0 ?
0
 
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.
0
 
LVL 1

Author Comment

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

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 2000 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:
http://www.dba-oracle.com/t_list_installed_components.htm
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

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

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

604 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