[Re-post from Jaffar's Oracle blog] Upgrade, Migrate and Consolidate to Oracle Database 12c slide deck by Mike Dietrich

Upgrade, Migrate and Consolidate to Oracle Database 12c slide deck by Mike Dietrich

Mike and his team did it once again. This time its 12c Upgrade/Migrate.

Here is the excerpt from his blog:

with (sorry, we've did it again!) over 500 slides covering:

• The brand new Parallel Upgrade including new Pre/Post-Upgrade-Fix-Ups
• The new Full Transportable Export/Import Feature
• Obviously Oracle Multitenant, which got talked about a lot as Pluggable Databases or Container Databases before
• Plenty of new parameters, cool and very helpful features and much more ...
• Download the slides Upgrade, Migrate and Consolidate to Oracle Database 12c
• And of course, the slide deck will see some updates in the near future

-Mike

You can download the slide deck on:

https://blogs.oracle.com/UPGRADE/entry/finally_oracle_database_12c_is

Re-post from "Jaffar's (Mr RAC) Oracle blog"

I am CISM (Qualified) Now!!!

I had appeared for CISM (Certified Information Security Manager) on 8th June, 2013 in Kuwait.

Alhamdulillah (All Praises are for Allah [Glorified be He]), I was able to pass the exam, since I was not able to prepare as I had done at the time of CISA preparation.

Just as CISA exam demands you think like an Auditor when answering the CISA questions, CISM too demands you answer the CISM questions as an Information Security Manager would. It is more of a "Management" perspective of Security.

My current organization's ISMS (Information Security Management System) Implementation (i.e. ISO 27001) and me being a part of the core implementation team, really helped me a lot in answering the CISM exam.

For more information about ISACA and CISM please hop into ISACA's website: https://www.isaca.org/Pages/default.aspx

Once Again, "Knowledge is Power".

[Re-post from Jaffar's Oracle blog] Useful MOS notes on 12c

Useful MOS notes on 12c

"Here is the list of useful MOS notes on 12c:

1. Oracle Database 12c Release 1 (12.1) Upgrade New Features [ID 1515747.1]
2. NOTE:1520299.1 - Master Note For Oracle Database 12c Release 1 (12.1) Database/Client Installation/Upgrade/Migration Standalone Environment (Non-RAC)
3. NOTE:1493645.1 - Oracle Database 12c Release 1 (12.1) DBUA : Understanding New Changes With All New 12.1 DBUA 
4. NOTE:1503653.1 - Complete Checklist for Manual Upgrades to Oracle Database 12c Release 1 (12.1)
5. Oracle Database 12c Release 1 (12.1) Upgrade New Features [ID 1515747.1]
6. RMAN RECOVER TABLE Feature New to Oracle Database 12c [ID 1521524.1]
7. How to Merge Multiple Partitions in Oracle 12C [ID 1482263.1]
8. How to Drop/Truncate Multiple Partitions in Oracle 12C [ID 1482264.1]
9. How to Create Interval-Reference Partitioned Tables in Oracle 12c [ID 1519042.1]"

Re-post from "Jaffar's (Mr RAC) Oracle blog"

[Re-post from Jaffar's Oracle blog] Deprecated database init. parameters in 12c

Deprecated database init. parameters in 12c

"Here is a very short blog about all the deprecated database initialization parameters in 12c.  It is sometime becomes essential to be familiar with those database features and init. parameters that are either de-supported or deprecated in a new release of Oracle database before proceeding with the upgrade. This is because, some of the legacy applications upgrade decision either directly or in-directly depends on those changes.

To obtain a list of deprecated database parameter in 12c, use the following SQL statement:

SQL> SELECT name from v$parameter WHERE isdeprecated = 'TRUE' ORDER BY name;

Here is the list:

active_instance_count
background_dump_dest
buffer_pool_keep
buffer_pool_recycle
commit_write
cursor_space_for_time
fast_start_io_target
global_context_pool_size
instance_groups
lock_name_space
log_archive_local_first
log_archive_start
max_enabled_roles
parallel_automatic_tuning
parallel_io_cap_enabled
parallel_server
parallel_server_instances
plsql_v2_compatibility
remote_os_authent
resource_manager_cpu_allocation
sec_case_sensitive_logon
serial_reuse
sql_trace
standby_archive_dest
user_dump_dest

I am little bit surprised to see the sec_case_sensitive_logon parameter in the list."

Re-post from "Jaffar's (Mr RAC) Oracle blog"