We use cookies to optimize our website and our service.
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
The technical storage or access that is used exclusively for statistical purposes.
The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
Mike,
I am a bit confused about MOS note 2173141.1. There is no mention of parallel upgrade using catctl.pl. This note mentions running dbupgrade with no mention of parallelism.
Is there any MOS note on how to upgrade from 11.2.0.4 to 12.2 and convert from non-CDB to single tenant?
Thanks,
Arun
Arun,
"dbupgrade" is just a wrapper script to ease your typing. It wraps the "$ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catctl.pl catupgrd.sql" call with the default number of 4 workers (or higher in case you have more cores).
https://docs.oracle.com/database/122/UPGRD/changes-in-12c-release-2-upgrade.htm#UPGRD52756
and
https://docs.oracle.com/database/122/UPGRD/upgrading-parallel-upgrade-utility-catctl-pl.htm#UPGRD52865
Cheers
Mike
Hi Mike,
I guess the patch updates will follow the Jan/Apr/Jul/Oct schedule. It wouldn’t be cloud first? We can expect the first patch updates to be out in Apr 2017?
Cheers.
Hi Mike,
I’m also interested in question from Arun in regards upgrade (or migrate) from 11.2.0.4/12.1 to 12.2 and convert from non-CDB to single tenant.
Could you please advise if there are some MOS notes related to that?
Thank you!
Cheers,
Vlatko
Dates for PSUs and BPs (I’d highly recommend BPs over PSUs) stay the same:
https://www.oracle.com/technetwork/topics/security/alerts-086861.html
18 April 2017
18 July 2017
17 October 2017
16 January 2018
Cheers
Mike
Vlatko, will do – will be published tomorrow or the day after.
Cheers
Mike
Hello,
Just some feedback for the community that follows this blog.
I downloaded the 12.2 software yesterday and did a couple of test upgrades, everything worked as expected. Roy/Mike, great job making the upgrades simple and straight forward.
We have close to 150 single instance databases that we plan to upgrade to 12.2 in the next 3-6 months. I tried the GUI DBUA and the process took close to 53 mins.
I tried the DBUA -silent option and that went pretty well as well. The same database took 30 mins to upgrade. I used the following options for the -silent option.
/u01/app/oracle/product/12.2.0.1/bin/dbua -silent \
-sid <SID NAME> \
-oracleHome /u01/app/oracle/product/12.1.0.2 \
-recompile_invalid_objects true \
-gatheringStatistics true \
-upgradeTimezone true \
-emConfiguration NONE \
-upgrade_parallelism 4
Thanks.
Mike,
Is DBUA -silent the best option to get to a one command database upgrade. I’m trying to give something to my team that is simple and quick. I read something with an upgrade command line utility called "dbupgrade", is that new in 12.2?
Thanks.
Naveen
Naveen,
for "simple" DBUA (either silent or interactive) is currently the best approach for now (there will be something in a future patch set which may be even better).
"dbupgrade" is just a wrapper for:
$ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catctl.pl -n 4 $ORACLE_HOME/rdbms/admin/catupgrd.sql
Cheers
Mike
Mike,
Thank you so much for putting together all this excellent information. It is really coming in handy as we do our upgrade planning.
Can you please cover some fallback scenarios? If I want to upgrade a database from 11.2.0.4 to 12.2 and convert to single tenant, I will have to do it in two steps.
First upgrade the 11.2.0.4 database to 12.2 non-CDB. In second step, I will unplug the CDB and plug it into a single tenant CDB as a PDB.
This would imply that I will have to raise the COMPATIBLE parameter in step 1. The moment I do that, there is no fallback except to restore from cold backup.
How to deal with this situation?
Best regards,
Arun
Mike,
I am testing upgrade of 12.1 RAC GI to 12.2 and it fails at creating GIMR. It seems that after upgrade to 12.2, ASM is unable to read the spfile with the error:
ERROR: Unable to get logical block size for spfile ‘+DG_CRS/clu12c/ASMPARAMETERFILE/registry.253.938012473’.
MEMORY_TARGET defaulting to 1128267776.
Since ASM cannot read spfile, it does not know the disk discovery path and the diskgroups are not mounted. Querying the v$asm_diskgroup returns no rows. This causes failure of creating GIMR. The 12.1 GI home was patched to Oct 2016 patch. The cluvfy pre crsinst did not show any error. The 12.1 GI was working perfectly and I had tested stop/start of ASM multiple times. There is nothing on MOS about this error. The disks are iSCSI with 512 byte block size, so there is nothing unusual. Any help will be appreciated.
Thanks,
Arun
Hi Mike,
I’m getting ready to upgrade Oracle SE2 database from v12.1.0.2 to 12.2.0. I thought I read in upgrade notes that I needed to apply any SPU’s to 12.1.0.2 first, then upgrade to 12.2.0. I was under the impression that the major releases included all previous patches, which was kind of why we decided to wait and do the 12.2 upgrade. If I am supposed to apply SPU’s first, is the last one (ie Jan 2017) sufficient. Again I’m assuming they’re cumulative?
thank you,
Jennifer
Jennifer,
there are no SPUs for Oracle Database 12c (12.1 and 12.2) anymore.
You can choose between PSUs and BPs whereas I strongly recommend you the BPs as they contain more fixes and get some significant additions soon.
For 12.2.0.1 there are no patch bundles (PSUs or BPs) available yet. The first one will be released in mid April.
And you are right, SPUs (11.2), PSUs (11.2, 12.1, 12.2) and BPs (11.2. Exa-only, 12.1, 12.2) are all cummulative having the previous SPUs or PSUs or BPs included as well.
Cheers
Mike
Arun,
may I please ask you to open an SR and send me the SR number?
I won’t be able to solve this but I’m very interested what causes this.
Thanks
Mike
Mike,
I found out what was causing the ASM error. When I do a fdisk on the disk I used for ASM, it shows two sector sizes, logical and physical. The logical sector size was 512 bytes, the physical sector size was 128k. In my iSCSI target (I use FreeNAS), there is a setting which disables reporting of physical sector size. I checked that box and the physical sector size changed to 512 bytes and the error was resolved.
This seems to be a bug somewhere in Oracle as up to version 12.1, fdisk always reported physical sector size as 128k without causing any problem to ASM. In 12.2, it seems that instead of checking for logical sector size, some library is checking for physical sector size and throwing an error. Either that or they are verifying if physical and logical sector sizes match or something like that. But definitely, there is a behavior change. It took hours and hours of troubleshooting.
ERROR: Unable to get logical block size for spfile ‘+DG_CRS/clu12c/ASMPARAMETERFILE/registry.253.938012473’.
MEMORY_TARGET defaulting to 1128267776.
Thanks,
Arun
Arun,
first of all, sorry to hear that. Second, I will get in touch with the right people. If I get a useful insight answer I’ll let you know.
Cheers and thanks again for explaining – and glad you could solve it!
Mike
Arun,
would you please mind to grab our big 12.2 slide deck from the Slides Download Center and scroll forward to around slide 400 to the "Fallback Scenarios" section?
This will show you options for issues "During" and "After" the upgrade.
Let me know if anything is unclear.
Cheers
Mike
Mike,
How to upgrade from 12.1.0.2 to 12.2.0.1 with multitenent concept of one cdb with fours pdb database using dbua .please share the any doc of this .
Thanks
Baskar
Baskar,
please see the Upgrade Guide as it has all steps for the DBUA:
https://docs.oracle.com/database/122/UPGRD/upgrading-oracle-database-upgrade-assistant-dbua.htm#UPGRD105
Cheers
Mike
We would like to do upgrade from 11.2.0.4 to 12.2 and 12.1 to 12.2. We are having single instance [HAS/ASM] ,RAC with Golden Gate and RAC with Data Guard. I would like to know where I can find documents that lists step by step for RAC with Data Guard environment and for RAC with Golden Gate.
Thanks,
I would blindly direct you:
– for Data Guard to the Data Guard documentation
– for RAC to MOS and/or the RAC documentation.
The complexity of your environments may make it necessary that you talk to somebody at Oracle assisting you to define all the potential paths. The database upgrade itself is the least complicated part. And Data Guard isn’t either as long as you have a physical standby. But as soon as you move between hardware etc things get a bit more tricky. Please understand that I can’t deliver this via the blog for an entire environment.
Cheers
Mike
Hello
We would like upgrade a standalone CDB using ASM/HAS from 11.2.0.4 to 12.2.0.1. Can you provide documentation for the process using both dbua and silent upgrade using a response file as i am not able to use the GUI in my environment but i am in my test enviornment and i know i can create a response file from that. I would like to know about converting it back to a CDB post upgrade since 12.2 convert it to a non CDB? Thank you for your help.
Leon,
as far as my understanding of DBUA goes, it does not generate a response file. You’ll have to create it by yourself.
See the documentation:
https://docs.oracle.com/en/database/oracle/oracle-database/12.2/upgrd/upgrading-oracle-database-upgrade-assistant-dbua.html#GUID-29C7651A-28FD-4AA3-ACE4-D15708A9882B
Unfortunately the documentation has no real example – but I stopped asking for this.
I’d rather recommend you the command line upgrade, especially for cases where you upgrade an entire CDB environment with many PDBs. But actually I’m not really clear about your tasks. You say “11.2.0.4 to 12.2.0.1” but mention “we would like upgrade a standalone CDB” at the same time. As in 11.2.0.4 there’s no CDB architecture I’d assume you mean:
You have one or many 11.2.0.4 databases
You’d like to upgrade them to 12.2.0.1
You’d like to convert them to pluggable databases
Is this correct?
Then please follow this blog post:
https://mikedietrichde.com/2017/03/08/converting-an-12-1-non-cdb-and-plug-it-into-an-12-2-cdb/
Cheers,
Mike