Oracle Database 12.2

Create Multitenant databases with DBCA – Things to Know

Posted on September 21, 2017 by DBCA Single-/Multitenant 2

Create Multitenant databases with DBCA - Things to KnowWhen you create Multitenant databases with DBCA there are some Things to Know. And in Oracle Database 12.2.0.1’s Database Creation Assistant (DBCA) there is a common pitfall in the “Options” screen. It was grayed out in the previous release but when you choose to create a “custom” database you can select the options/components now. Be careful …

Previous posts

I did blog several times about the DBCA already:

And …

Continue reading...

New version of preupgrade.jar (build 5) is available

Posted on May 31, 2017 by Oracle Database 12.2.0.1 Uncategorized Upgrade / Migration 2

There’s a new and improved version of the preupgrade.jar (build 5 – May 2017) available for download from MyOracle Support:

The same note will get you access also to the most recent builds of preupgrd.sql for upgrades to Oracle Database 12.1 and utlu112i.sql for the unlikely event you’ll have to upgrade a database to Oracle 11.2.0.4.

Please always exchange the version getting installed by default with the version we offer via MOS Note:884522.1 as the downloadable version is usually much newer and improved over the one getting deployed …

Continue reading...

GIMR DB in Oracle Database 12.2

Posted on May 5, 2017 by ASM / RAC / GI 0

I did blog in the past already about the Grid Infrastructure Management Repository Database (GIMR DB):

Grid Infrastructure Management Repository (GIMR) database now mandatory in Oracle GI 12.1.0.2

SID and DBNAME are kept the same in Oracle Database 12.2. But there are a few changes and additions in Oracle Database 12.2.0.1.

GIMR DB in its own Disk Group

During a fresh installation of Oracle Grid Infrastructure 12.2.0.1 you’ll have the chance to create a disk group for GIMR DB:

GIMR DB in Oracle Database 12.2

GIMR DB – Gets its own disk group in Oracle 12.2

But you can migrate GIMR DB into a separate disk …

Continue reading...

What happens to PASSWORD_VERSIONS during an upgrade to Oracle 12.2?

Posted on April 25, 2017 by Oracle Database 12.2.0.1 Security 25

I did blog a day ago about ORA-1017 connection issues in Oracle Database 12.2 once you would like to use the deprecated init.ora/spfile parameter SEC_CASE_SENSITIVE_LOGON=FALSE:

Having some fun with SEC_CASE_SENSITIVE_LOGON and ORA-1017

But how can this change actually happen?

Let’s check how the PASSWORD_VERSIONS is set in a fresh Oracle Database 12.1.0.2 database with the January 2017 Proactive Bundle Patch applied to it:

SQL> select username, password_versions from dba_users order by 1;

USERNAME		       PASSWORD_VERSIONS
------------------------------ -----------------
ANONYMOUS
APPQOSSYS		       10G 11G 12C
AUDSYS			       10G 11G 12C
DBSNMP			       10G 11G 12C
DIP			       10G 11G 12C
GSMADMIN_INTERNAL	       10G 11G 12C
GSMCATUSER		       10G
… Continue reading...

Oracle Database 12.2 – Lifetime Support Policy updated

Posted on March 7, 2017 by Lifetime Support Policy Oracle Database 12.2.0.1 2

PLEASE SEE THIS BLOG POST FOR A MUCH NEWER AND UP-TO-DATE OVERVIEW:

https://mikedietrichde.com/2020/02/26/to-which-release-should-you-upgrade-to-revisited/

 

 

The Oracle Lifetime Support Policy brochure for tech products has been updated now as well in order to reflect the addition and availability of Oracle Database 12.2 on-premises:

Lifetime Support Policy – Oracle technology products

Lifetime Support Policy Oracle Database

Please note that this table and the brochure never makes a distinction between patch sets and base releases. For instance, the line talking about Oracle 11.2 does not say that Oracle Database 11.2.0.3 is out of any bug fixing support since Aug 27, 2015 – and Extended Support …

Continue reading...

Upgrade to Oracle Database 12.2 – New MOS Notes

Posted on March 6, 2017 by MyOracle Support Upgrade / Migration 23

Some very helpful MOS Notes got published regarding the upgrade to Oracle Database 12.2.0.1:

Furthermore check regularly for Known Issues and Alerts – currently the note has no content but exists already:

Cheers
–Mike…

Continue reading...

Oracle Database 12.2.0.1 on-premises is now available, too

Posted on March 1, 2017 by Oracle Database 12.2.0.1 11

Yep – it’s available … Oracle Database 12.2.0.1 on-premises is available for download now not only on Exadata and SuperCluster but on Linux x86-64, SPARC and Intel Solaris. For other platform plans please see MOS Note:742060.1.

–Mike…

Continue reading...

Client Certification for Oracle Database 12.1.0.2/12.2.0.1

Posted on February 17, 2017 by Oracle Database 12.2.0.1 4

I’ve received a question about client certification for Oracle Database 12.2.0.1 the other day.
And this reminded me on this very helpful MOS Note:

It spans the client interoperability back to the Oracle 9.2 days and is a very helpful resource.

Client Certification Oracle Database

And don’t forget that sometimes client software may need a patch as well. A customer I exchange emails with on a regular basis just upgraded the Database server to Oracle Database 12.1.0.2 and saw several strange errors with the JDBC client despite the fact that they …

Continue reading...

Oracle Database 12.2 for Exadata/SuperCluster available

Posted on February 13, 2017 by Oracle Database 12.2.0.1 3

Oracle Database 12.2.0.1 on-premises for Exadata and SuperCluster is now available for download from Oracle eDelivery/SoftwareCloud.

Connect to eDelivery and login.

Search for: “Oracle Database” and mark “Oracle Database Enterprise Edition …”


.

Click on “Select Platforms” and select “Linux x86-64“, then hit “Continue“:

Once you accepted the license agreement you’ll be able to download the software:

Please be aware that the software can be installed on Oracle Exadata and Oracle SuperCluster ONLY. To take advantage of the full potential of Oracle Database
12c Release 2 you should …

Continue reading...

DBMS_QOPATCH does not work in PDBs (right now)

Posted on February 8, 2017 by Oracle Database 12.2.0.1 Oracle Database 12c Patch Recommendation Single-/Multitenant 4

Thanks to Murthy who commented on this blog post and Jeannette Holland (SimCorp) who opened an SR resulting in an ER.

DBMS_QOPATCH in Multitenant

DBMS_QOPATCH will deliver useful information about installed patches only when executed within the CDB$ROOT. It has been designed this way for security reasons in Oracle Database 12.1 but I can easily see a need to check for installed patches within a PDB as well.

Testcase

I “borrowed” this test case from Jeannette’s SR:

SQL> COLUMN NAME FORMAT A8

SQL> SELECT NAME, CON_ID, DBID, CON_UID, GUID FROM V$CONTAINERS ORDER BY CON_ID;

 NAME     CON_ID DBID       CON_UID    GUID
 --------
… Continue reading...

Restarting a failed Database Upgrade with DBUA 12.2

Posted on January 25, 2017 by catctl.pl DBUA Oracle Database 12.2.0.1 27

In my previous blog post I did showcase how to restart a failed database upgrade on the command line before Oracle Database 12c, with Oracle Database 12.1.0.x and with the new Oracle Database 12.2.0.x:

Restarting a failed Database Upgrade with catctl.pl

Here I’d like to show the new capability of the Database Upgrade Assistant (DBUA) to restart an upgrade, a functionality the DBUA was missing until now. Please note that you can always go back to the command line, no matter in which version you have used the DBUA.

I won’t describe an upgrade with the DBUA in this …

Continue reading...

Upgrade to Oracle Database 12.2 – Slides are available

Posted on December 6, 2016 by Oracle Database 12.2.0.1 Slides 5

The workshops in Brussels and Utrecht were awesome with great audience – I enjoyed both events a lot. And thanks for your patience with my voice and the microphone issues we’ve had in Brussels before lunch.

I promised the workshop slides – and here they are, ready for download:

Upgrade, Migrate and Consolidate to Oracle Database 12.2 and the Cloud

Slides Oracle 12.2 Upgrade Migrate Consolidate

Please be aware: It’s the first drop of the slides, not everything has been updated yet for Oracle Database 12.2, and of course there are no 12.2 customer examples in the slides yet. But as usual, if you …

Continue reading...

New PREUPGRADE.JAR is available – MOS 884522.1

Posted on November 24, 2016 by Oracle Database 12.2.0.1 Upgrade / Migration 0

As promised – and thanks to everybody from the Database Upgrade Development Team – the new preupgrade.jar for Oracle Database 12.2 is available:

And of course the previous preupgrd.sql with the package utlupkkg.sql and the old utlu112i.sql for upgrade to Oracle 11.2.0.4 (which I wouldn’t do anymore) are available as well.

New Preupgrd.sql - MOS Note 884522.1

Please ALWAYS use the version downloaded from this MOS note as this version is much newer and better than the version getting shipped due to code freeze dates. And you will recognize that the new preupgrade.jar is now identical …

Continue reading...

Enabling Oracle 12.2 ADAPTIVE Features in Oracle 12.1.0.2

Posted on November 23, 2016 by Optimizer Oracle Database 12c Parameters 10

Oracle Database 12.2 introduces the new split-up adaptive parameters, OPTIMIZER_ADAPTIVE_PLANS and OPTIMITER_ADAPTIVE_STATISTICS. And the key trigger to cure potential and known performance issues in Oracle Database 12.1.0.2 is enabling Oracle 12.2 ADAPTIVE Features in Oracle 12.1.0.2

For more information please see:

Enabling Oracle 12.2 ADAPTIVE Features in Oracle 12.1.0.2

But Oracle Database 12.2 on-premises is not out yet – so what should you do when upgrading to Oracle Database 12.1 – or struggling with some of the “adaptive” features in Oracle 12.1?

… Continue reading...

OPTIMIZER_ADAPTIVE_FEATURES obsolete in Oracle 12.2

Posted on November 22, 2016 by Optimizer Oracle Database 12.2.0.1 Parameters 10

The Oracle Database 12.1 parameter OPTIMIZER_ADAPTIVE_FEATURES has been made OBSOLETE (i.e. must be removed from the SPFILE when upgrading) in Oracle Database 12.2.

It gets replaced with two parameters of whom one is enabled, the other one is disabled by default:

  • OPTIMIZER_ADAPTIVE_PLANS=TRUE by default
  • OPTIMIZER_ADAPTIVE_STATISTICS=FALSE by default

Nigel Bayliss, our “Optimizer” Product Manager has blogged about it already with way more detailed insights.

But as Oracle Database 12.2 on-premises is not available how should you deal with this feature in Oracle Database 12.1?

Enabling Oracle 12.2 ADAPTIVE Features in Oracle 12.1.0.2

 …

Continue reading...

SPFILE Parameter: max_pdbs – a must for Single Tenant

Posted on November 14, 2016 by Parameters Single-/Multitenant 4

Sometimes my job has a aspect making me smile at the end of the day 😉

I sat together with Johannes Ahrends during a talk at the OUGN Conference on the boat from Oslo towards Kiel. And we were discussing afterwards why there’s no official way to limit the number of PDBs which will be essential for customers wanting to go the Single Tenant track. I had my Hands-On environment up and we played a bit in the break recognizing that a constraint on CONTAINER$ won’t be the correct solution as unplug/plug operations leave leftovers in it unless you …

Continue reading...

Deprecated Parameters in Oracle Database 12.2.0.1

Posted on November 11, 2016 by Deprecated / Desupported Oracle Database 12.2.0.1 Parameters 11

This is the 3rd posting in my series about init.ora/SPFILE parameters in Oracle Database 12.2.0.1.

 

Finally, here’s the list of DEPRECATED parameters in Oracle Database 12.2.0.1:

O7_DICTIONARY_ACCESSIBILITY
active_instance_count
asm_preferred_read_failure_groups
background_dump_dest
buffer_pool_keep
buffer_pool_recycle
commit_write
cursor_space_for_time
db_block_buffers
fast_start_io_target
instance_groups
lock_name_space
log_archive_start
parallel_adaptive_multi_user
plsql_debug
plsql_v2_compatibility
rdbms_server_dn
remote_os_authent
resource_manager_cpu_allocation
sec_case_sensitive_logon
serial_reuse
sql_trace
standby_archive_dest
unified_audit_sga_queue_size
user_dump_dest
utl_file_dir

Only the ones in BOLD were newly marked as DEPRECATED in Oracle Database …

Continue reading...

Obsolete SPFILE Parameters in Oracle Database 12.2.0.1

Posted on November 10, 2016 by Oracle Database 12.2.0.1 Parameters 5

This is the 2nd posting in my series about init.ora/SPFILE parameters in Oracle Database 12.2.0.1.

Find the list of the 159 obsoleted parameters here (and of course in V$OBSOLETE_PARAMETERS):

_app_ctx_vers
_average_dirties_half_life
_aw_row_source_enabled
_compatible_no_recovery
_data_transfer_cache_size
_db_no_mount_lock
_dlm_send_timeout
_dtree_bintest_id
_dtree_compressbmp_enabled
_evolve_plan_baseline_report_level
_fast_start_instance_recovery_target
_fic_max_length
_fic_outofmem_candidates
_idl_conventional_index_maintenance
_kgl_latch_count
_kks_free_cursor_stat_pct
_kspptbl_mem_usage
_lm_direct_sends
_lm_multiple_receivers
_lm_rcv_buffer_size
_lm_statistics
_log_archive_buffer_size
_log_io_size
_max_log_write_io_parallelism
_module_action_old_length
_optimizer_adaptive_plans
_optimizer_choose_permutation
_oracle_trace_events
_oracle_trace_facility_version
_plan_verify_local_time_limit
_plsql_conditional_compilation
_px_async_getgranule
_px_slaves_share_cursors
_seq_process_cache_const
_spr_use_hash_table
_sqlexec_progression_cost
_use_hidden_partitions
… Continue reading...

New SPFILE parameters in Oracle Database 12.2.0.1

Posted on November 9, 2016 by Oracle Database 12.2.0.1 Parameters 8

This is the 1st posting in my series about init.ora/SPFILE parameters in Oracle Database 12.2.0.1.

Oracle Database 12.2.0.1 is available now in the Oracle Cloud.

And this is the list of 46 new init.ora/spfile parameters compared to Oracle Database 12.1.0.2 – including the links (where possible) to the Oracle Database 12.2 Reference documentation.

 

Parameter

Description
allow_global_dblinks LDAP lookup for DBLINKS
allow_group_access_to_sga Allow read access for SGA
… Continue reading...

Upgrades to Oracle Database 12.2.0.1 (and Downgrades)

Posted on November 8, 2016 by Oracle Database 12.2.0.1 Upgrade / Migration 39


Oracle Database 12c Release 2 (12.2) is available now in the Oracle Cloud in DBCS and ECS in both NAS and EMEA zones, as well as being available on Exadata Express Cloud Service. The Oracle Database 12.2 documentation should be published later today.

Just to note down, the versions supporting direct upgrade either with catctl.pl on the command line or with DBUA are:

  • Oracle Database 11.2.0.3
  • Oracle Database 11.2.0.4
  • Oracle Database 12.1.0.1
  • Oracle Database 12.1.0.2

Direct Upgrade to Oracle Database 12.2

No direct upgrades are supported from versions below Oracle Database 11.2.0.3.

For versions older than Oracle Database 11.2.0.3 other tools such as Data Pump or …

Continue reading...
Mike Dietrich
Oracle Senior Director of Product Manager for Database Upgrade, Migrations and Patching writing just another blog.

Opinions certainly are my own as is this page.

Archives

Categories

Upgrade @YouTube

Subscribe via Email

Join 7,349 other subscribers

Follow me on Twitter