Yes, I am alive! And still contributing...

Hey everyone! 

It's been a while (more than 12 years) that I've been away from this blogpost. I have been receiving emails on what happened to me and why did I stop posting @oracleendevor.

Back in 2010-11, I had the opportunity presented to migrate onto Mainframe System and Database Management, which meant that I had to switch to a new set of technology leaving behind all my contributions in the Oracle world. Thankfully, there have been better Oracle Gurus to relinquish your quest for knowledge.

Nevertheless, during the past 15 years, I've learned so much and grown in so many ways as a professional trying to contribute in the arenas I was assigned to. 

In the Mainframe/IT world, I specialized in Software AG's ADABAS Database and related products, managing a VLDB of app. 27 TB hosted on z16 Mainframe System (z/OS). Additionally, I had the opportunity to deliver results in the management domains as well, namely techno-functional PM, ISMS and RM.

During this tenure, I managed to achieve the following certifications :

•            Certified Information Security Manager (CISM)

•            Certified Information Systems Auditor (CISA)

•            PECB ISO 31000 Risk Manager

•            IBM Z Cyber Resiliency Solution Design Technical Advocate

•            BTA's CERTIFIED BLOCKCHAIN BUSINESS FOUNDATIONS (CBBF)

I would like to thank all those who wrote to me and all those who still find my Oracle contributions beneficial.

In terms of contributions, I am not sure how this blogpost can be made further beneficial to you all. Your suggestions are welcomed!!

Nevertheless, you may follow and benefit from my posts on LinkedIn:

https://www.linkedin.com/in/zafferkhan/  

Once again, thanks for your support and well-wishes.

ZK

[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"

[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"

Oracle Database: To z/OS or To z/Linux? That is the Question!!!

Oracle has been supporting Oracle Databases on z/OS since version 8.

"Experiences with Oracle Database 10g on z/OS", is a good IBM Publication that describes experiences with the installation process of Oracle 10g on z/OS.
http://www.redbooks.ibm.com/abstracts/sg247055.html

"Oracle® Database Installation Guide 10g Release 1 (10.1) for IBM z/OS (OS/390)" from Oracle is a detailed documentation on the subject.
http://docs.oracle.com/html/B13525_01/title.htm

The last supported Oracle Database on IBM z/OS operating system was Oracle Database 10g. Unfortunately, those with this combination of implementation will not benefit from the latest features and benefits of Oracle Database 11g R2 on z/OS.

My Oracle Support (formerly Metalink): Note 461234.1 Oracle Database on z/OS Support Status

The possible options for people with Oracle Database 10g on z/OS, is:

1. Either, shift to a different RDBMS Database on z/OS (continuing on existing hardware investments);
2. Or, continue with Oracle Database onto a different Operating System (possible investments in additional Hardware Environments).

Fortunately, IBM offers its "Linux on System z" as a possible alternative to run the Oracle Databases; and Oracle too supports its latest Oracle Database release on z/Linux.

This means that Oracle customers have an option to stick with the latest updates on Oracle Database and leverage their existing hardware investments, by switching on to Linux on System z (a.k.a. z/Linux) on Mainframes as their operating system.

The 10g migration from z/OS to z/Linux must be thoroughly tested. And once found satisfactory and stable, it can be upgraded to latest release of Oracle Database on z/Linux.

For more information on 11gR2 on z/Linux:

"Oracle® Database Quick Installation Guide [11g Release 2 (11.2) for IBM: Linux on System z]"

http://docs.oracle.com/cd/E11882_01/install.112/e24328/toc.htm

Download Oracle Database 11g Release 2 (11.2.0.2.0) for zLinux64

http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html