Friday Dec 18, 2015

Tech Tip: Get updates about new/important MOS Notes

There's nothing more annoying than unwanted and useless email newsletters in your inbox.

No doubt.

But sometimes I wish to have an alert about important MOS Note changes, recent additions to my favorite notes, updates to the bugs I monitor etc. I would like to know about helpful new MOS articles - when they get published ;-)

And this is what you need to do (and I'll have to apologize for the small pictures but our fancy, modern blog design template does not allow to include larger pictures ...).
.

Log into MOS and change your SETTINGS

Once you've logged in you'll click on MORE and then navigate to SETTINGS.

Change SETTINGS in MOS
.

Choose HOT TOPICS EMAIL in the left navigation menu

HOT TOPICS EMAIL
.

Update the settings

Here it is important that you choose "Send with Selected Options" first and then "HTML" as otherwise the email does not seem to get sent ("Text" option does not seem to work).

HTML Option
.

Add Products you'd like to get updates about 

Add Product Selection

Of course you may add more products - I chose only the "Database" in my example. 
.

Change the number of items you'd like to see 

No of Items

*** AND DON'T FORGET TO HIT THE "APPLY" BUTTON FURTHER DOWN ON THE SCREEN ***
.

 Check your current Favorites

Then it's important to check your current "Favorites". Click on the yellow/orange STAR in the upper menu close to the search field and select "Documents". If "Documents" does not get displayed there's no need to clean up as you haven't marked anything as favorite yet. But in my below example you see that I have a lot of very old docs in my list. 

Check Favorites

So I will clean them up first.
.

Clean Up the favorite documents list

Click on "Manage Favorites" via the yellow/orange STAR and mark all unwanted documents by using either the usual SHIFT or STRG keys. Hit "Remove".

In my case the list is empty now.  
.

Mark documents as FAVORITES 

The important work is now to mark certain documents or bugs as FAVORITES. In the below example I'd choose the most important MOS Note 161818.1 via the plain ID search (right side of the screenshot), and once the note gets displayed I'll push the withe STAR on the upper left corner above the document - the STAR will turn yellow/orange

Empty fav list

Once I've did that I will find this note now in my list of favorite documents:

Repeat this with the notes you'd like to get informed about changes. For instance I monitor always the "Known Issues and Alerts" for Oracle Database 12.1.0.2 and 11.2.0.4:

Issues and Alerts
.

Receive the email update

Once you've did that you'll get an email per day with the recent changes - and it will contain information about the updates in your fav notes.


.

Summary

It's hard to keep track about recent changes and updates to important MOS Notes. And it's even harder to learn about newly published articles in your areas of interest. The HOT Topics email feature in MOS is pretty cool and extremely helpful. I like it a lot.

But you'll have to enable it first in your settings as MOS does not want to spam you. 

Credits to Roy who dug out all the tiny pieces such as the HTML switch ;-)

--Mike

Wednesday Dec 16, 2015

New version of our Hands-On Lab available for download "Upgrade/Migrate/Consolidate to Oracle 12c" HOL

Yes! Finally ...

Roy did all the hard work and patched all our environments with the most recent PSUs. And he managed also to upload our Hands-On Lab not only internally to retriever (Oracle internally) but also to OTN.

What you'll be able to do?

  • Upgrade an 11.2.0.4 database UPGR to Oracle Database 12.1.0.2
  • Plug in UPGR into the CDB2, an Oracle Database 12.1.0.2 Container database, and make it a PDB
  • Migrate an 11.2.0.4 database FTEX into another PDB using the Full Transportable Export/Import feature
  • Unplug an Oracle Database 12.1.0.1 PDB and plug it into an Oracle Database 12.1.0.2 container database and finally upgrade it
  • And of course you can play around with the entire environment
    .

What we've did for your convenience? 

  • Switched to a new PDF viewer which allows better copy&paste - see the instructions document.
    Unfortunately we are not allowed to distribute the relatively old version of Adobe PDF Reader for Linux. 
  • Applied the most recent PSUs to the 11.2.0.4 and 12.1.0.2 homes
  • Fixed some minor things
  • Updated the HOL Instructions
  • Added an "aritificial" environment variable $OH12 to shorten typing
  • And some other tiny little things ...
  • And the lab is packaged with Oracle VBox 5.0.10 including the matching VBox Extensions which caused us trouble with the previous lab environment which was settled on Vbox 4.3 - so we hope that now all will go well.
    .

Where can you download the lab and the instructions?

All credits to Roy!!!

Thanks
--Mike

Thursday Oct 01, 2015

Some Seoul Impressions - 09/2015

A very intense week in Seoul, Korea, is over - and Roy and I both returned a bit sick ;-) The pleasures of traveling ...

But thanks to all our colleagues who did all the orga work, to everybody who traveled from near and far to our 2 day internal workshop (and I still remember many names :-) - it was great fun to spend those two days with all of you) - and of course the the customers and partners we've had the pleasure either to visit or come to our workshop. Upgrade is in your hands now - just do it

Finally some Seoul impressions - and even though it was my 5th visit to Seoul I'd realize still haven't seen a lot of the city :-( Next time ...

Roy and I ended our trip again - our usual ritual - with a visit to the Best Bar on the Planet :-) 

Seoul 1

Seoul 2

Seoul 3

Seoul 4

Seoul 5

Seoul 6

Seoul 7

Seoul 8

Seoul 9

Seoul 10

Pictures were taken in the Bongeunsa Temple, and in and around the COEX Center.

CU soon again!

--Mike

PS. Forgot to mention this one here ... looks a bit like row-organization inside ... :-)

Hana

Monday Sep 28, 2015

Upcoming Upgrade Workshops in Prague and Bucharest

Oracle Upgrade Workshops Fall 2015

I've just returned from a work intense week from Seoul, South Korea - and there are upcoming Upgrade / Migrate /Consolidate to Oracle Database 12c workshops already on my radar - and both are almost booked out completely. So if you are either based in the Prague or the Bucharest region you may quickly sign up (and show up as well) :-)
.

  • Upgrade / Migrate / Consolidate to Oracle Database 12c
    .
    Wednesday, October, 7, 2015
    Prague, Czech Republic
    @Oracle Czech
    .
    Registration Link is here
    .
    .
  • Upgrade / Migrate / Consolidate to Oracle Database 12c
    .
    Tuesday, October 13, 2015
    Bucharest, Romania
    @Oracle Romania
    .
    Registration Link is here 
    .

Hope to see you there :-)

--Mike

Friday Feb 13, 2015

Hands-On-Lab "Upgrade, Migrate & Consolidate to Oracle Database 12c" available for DOWNLOAD now!

Wow ... that was a hard piece of work. Roy put a lot of effort into getting our Hands-On-Lab on OTN for download. We promised to have it available after OOW - or at least a description how to create it by yourself. And finally it's there. Find it here:

A few important things to mention before you start the download: 

  • It's a Virtual Box image
  • You will need to install Oracle Virtual Box first - and please install also the VBox Extensions
  • Your PC must have a 64-bit host operating system
  • You need to enable Virtualization options in your computer's BIOS
  • You PC should have at least 4GB of RAM - having 8GB is very helpful
  • A fast disk (SSD) will speed up things
  • The instructions are available for download but are included in the download as well
  • The lab will guide you through the following tasks:
    1. Upgrade an 11.2.0.4 database to Oracle 12.1.0.2
    2. Plug in this database into a 12.1.0.2 CDB
    3. Migrate an 11.2.0.4 database with Full Transportable Export into another PDB
    4. Unplug an 12.1.0.1 PDB and plug/upgrade it into an 12.1.0.2 CDB

You'll find a picture as screen background inside the VBox image always giving you guidance about "what to accomplish" and "how to switch environments".

Enjoy :-)

--Mike 

 

 

Thursday Jan 29, 2015

Upgrade to 12c and Plugin - one fast way to move into the world of Oracle Multitenant

What is the best way to move into Oracle Multitenant (which includes Single Tenant with just one PDB) as well?

This question came up on the blog, it's part of the Multitenant chapter in our big slide deck but let me elaborate this a bit more in detail. Of course there are several ways to move a database into a Single/Multitenant environment such as Data Pump but one fact is for sure: You can't convert a stand-alone database to become a container database (CDB$ROOT). A container database has to be built up from scratch as first step. Please use the DBCA to create it as this is the easiest path.

Upgrade and Plugin

But how can your stand-alone database be moved now?

  1. Upgrade your stand-alone database to Oracle Database 12c, ideally to Oracle 12.1.0.2 with the newest PSU included already. Upgrade it to exactly the same version including the same PSU as your container database (CDB) got created from.
    --
  2. Then start your stand-alone database in read-only mode - of course at this step you'll encounter downtime:
    startup open read only;
    --
  3.  Generate the XML description file – this file will contain the information describing the database structure. To create it the database has to be in read only mode:
    exec DBMS_PDB.DESCRIBE('/tmp/pdb1.xml');
    --
  4. Shutdown the database
    shutdown immediate
    --
  5. Change into your new CDB and do a compatibility check:
    SET SERVEROUTPUT ON
    DECLARE
    compatible CONSTANT VARCHAR2(3) := CASE DBMS_PDB.CHECK_PLUG_COMPATIBILITY( pdb_descr_file => '/tmp/pdb1.xml', pdb_name => 'PDB1') WHEN TRUE THEN 'YES' ELSE 'NO'
    END;

    BEGIN
    DBMS_OUTPUT.PUT_LINE(compatible);
    END;
    /
    --
  6. Plugin your stand-alone database (in my case with a new name PDB1):
    create pluggable database PDB1 using '/tmp/pdb1.xml' nocopy tempfile reuse;
    --
    Be aware that using the NOCOPY option will require that you have a valid backup of your database. If you'll use the COPY option instead you will need additional disk space. When using NOCOPY files will remain at their location. When using COPY you'll combine it with the FILE_NAME_CONVERT option, converting source to destination paths.
    It's always a recommendation to keep the TEMP tablespaces. In case you'd like to remove then you'll have to drop the tablespace and the tempfile before. Otherwise there will be a reference in the XML manifest file making it impossible to plug in your new PDB.

    --
  7. Connect to this new PDB1 and perform sanity operations:
    alter session set container=PDB1;
    @?/rdbms/admin/noncdb_to_pdb.sql

    This script will do required sanity operations to connect the PDB with the CDB. It will do things such as change object id's, mark common objects etc. Its runtime can vary between 5 minutes and several hours depending on the complexity of the former stand-alone's database data dictionary. It will do recompilations of many invalid objects as well. Please test it carefully. 
    If this step gets skipped the PDB can be open in read-only mode only.
  8. ----

  9. Now the database is plugged in – but not open yet. It will need to be started.
    startup
    show pdbs

    exit
    --
  10. To connect to the consolidated PDB1 from the command prompt the following command syntax needs to be used:
    sqlplus "sys/oracle@pdb1 as sysdba"
    As an alternative you could use the EZconnect syntax:
    sqlplus "sys/oracle@//localhost:1521/pdb1 as sysdba"

1.
-Mike

Monday Jan 12, 2015

Upcoming Upgrade Workshops Jan/Feb 2015

The new year will start with a good bunch of Upgrade, Migrate & Consolidate to Oracle Database 12c workshops in Japan, USA, Canada and Europe: 

January 20, 2015  
Tokyo,
Japan
Oracle Database 12c Upgrade Seminar
including Hands-On for Partners
by invitation only



February 04, 2015  
Irving (Dallas), TX
USA
Oracle Database 12c Upgrade Seminar - Dallas
Register
.

February 05, 2015  
Houston, TX
USA
Oracle Database 12c Upgrade Seminar - Houston
Register
.

February 09, 2015  
Bratislava,
Slovakia
Oracle 12c Database Upgrade Seminar - Bratislava
Register
.

February 10, 2015  
Budapest,
Hungary
Oracle 12c Upgrade Seminar Budapest
Register
.

February 10, 2015  
Reston, VA
USA
Oracle 12c Upgrade Seminar Reston
Register
.

February 11, 2015  
Atlanta, GA
USA
Oracle Database 12c Upgrade Seminar - Atlanta
Register
.
February 19, 2015  
Nürnberg,
Germany
Franconian User Group:
Oracle Database 12c Upgrade
17:30-21:00 Uhr - TU Nürnberg GSO - 
Raum WE.012 Wasertorstraße 10
Anmeldung
.

Thursday Nov 06, 2014

Beijing, Seoul - and OTN Tour Tokyo - just in one week

Uhhh ... next week will be a tough traveling experience. 19870 km (12347 mi), all in cattle class on 4 different airlines.

Picture rights remain at The New York Times

I tried to avoid Lufthansa as they canceled recently flights I heavily relied on - with no reason! And there's still a huge risk of announcing just their 9th strike within a year and a bit.

But I'm really looking forward to the workshops, to see all the colleagues, customers and of course some great friends. Roy and I will do two internal two-day workshops in Beijing and Seoul with each more than 50 participants - and we'll include a nice hands-on-experience as well. And mid-week I'll head out to Tokyo to present at the DB TECH SHOWCASE 2014 - which is part of the OTN ACE Tour.

CU soon - thanks!!!

-Mike 


Monday Apr 14, 2014

Upcoming UPGRADE Workshops in Europe - Register Now

There will be a lot of travel within the next few weeks. So please keep your fingers crossed that Lufthansa pilots don't go on strike for their ridicolous goals again. And I hope to see you in one of our upcoming workshops within the next weeks somewhere in the below cities.

Click on the date/location to the RIGHT to register, see location and agenda etc. 

CU soon :-)

- Mike and Roy 

Thursday Mar 06, 2014

Free Webcast available now On Demand --- Upgrade and Migrate to Oracle Database 12c and Consolidate with Oracle Multitenant

Almost 90 minutes about Upgrade, Migrate and Consolidate to Oracle Database 12c with or without Multitenant Option.
Available now on demand. Just register yourself and watch it whenever it is convenient for you:

Register to receive the On Demand Link and Watch It!

-Mike 

Tuesday Jan 07, 2014

Upcoming ASIA Upgrade to Oracle 12c workshops

.

Happy New Year to all of you and your families!!!

.

We have still a few remaining seats for the upcoming workshops in January 2014.

Oracle Database 12c Upgrade, Migrate and Consolidate Workshops


  • Singapore - Jan 21, 2014
    • Register Here!
      @Singapore Post Centre Theatrette - Level 5 - 10 Eunos Road 8 - Singapore 408600

  • Jakarta/Indonesia - Jan 22, 2014
  • Kuala Lumpur/Malaysia - Jan 23, 2014

Oracle's Global Server Technology Upgrade Development Group offers you an opportunity to attend this exclusive full day seminar on how to Upgrade, Migrate & Consolidate to Oracle Database 12c.

Oracle's latest generation of database technology has significant new features. It offers great potential for migrations and consolidation, making more efficient use of hardware and delivering major improvements in management efficiency.

In this seminar the Oracle Database Upgrade Development team will guide you through several different examples of upgrade, migration and consolidation techniques and strategies - shown with real world customer cases.

You will learn:
  • How to take full advantage of the new features and options in Database 12c
  • The changes and enhancements to the Oracle Database upgrade process
  • Best practices to upgrade and migrate successfully

So you may register asap and spread the word :-)
Looking forward to meet you there!

-Mike

About

Mike Dietrich - Oracle Mike Dietrich
Master Product Manager - Database Upgrade & Migrations - Oracle

Based in Germany. Interlink between customers/partners and the Upgrade Development. Running workshops between Arctic and Antartica. Assisting customers in their reference projects onsite and remotely. Connect via:

- -

Search

Archives
« February 2016
SunMonTueWedThuFriSat
 
4
5
6
7
8
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
     
       
Today
Slides Download Center
Visitors since 17-OCT-2011
White Paper and Docs
Workshops
Viewlets and Videos
Workshop Map
x Oracle related Tech Blogs
This week on my Rega & Pono
Upgrade Reference Papers