OracleNotes

Author: Biju

  • Oracle Tidbits – October 2014

    “Oracle *daily* TidBits” published at https://www.facebook.com/oraclenotes on all weekdays in October 2014. You will also see these tidbits, one tidbit at a time, for each page refresh on the right side of this blog as well… Hope you find these helpful to learn something new or to remind you of its existence and use…

    Publish Date TidBit
    6-Oct The Grid Infrastructure Management Repository is automatically installed with Oracle Grid Infrastructure 12c release 1 (12.1.0.2). The GIMR enables such features as Cluster Health Monitor, Oracle Database QoS Management, and Rapid Home Provisioning, and provides a historical metric repository that simplifies viewing of past performance and diagnosis of issues. This capability is fully integrated into Oracle Enterprise Manager Cloud Control for seamless management.
    7-Oct The Grid infrastructure Management Repository database (12c feature) is named MGMTDB and it is managed using the “srvctl” commands.  For example “srvctl config mgmtdb” or “srvctl start mgmtdb” or “srvctl stop mgmtdb”
    8-Oct When you install Oracle Grid Infrastructure 12c, the GI management repository database MGMTDB is created by default on the same diskgroup as the OCR.
    9-Oct The Cluster Health Monitor (CHM) in Oracle Grid Infrastructure 12c detects and analyzes operating system and cluster resource-related degradation and failures. CHM stores real-time operating system metrics in the Oracle Grid Infrastructure Management Repository.
    10-Oct The Grid infrastructure Management Repository database (MGMTDB, 12c feature) runs on one node in the cluster, and must support failover to another node in case of node or storage failure. The GIMR database is single-tenant deployment of CDB with one PDB.
    13-Oct In #DB12c statistics are automatically created as part of a bulk load operation such as a CREATE TABLE AS SELECT operation or an INSERT INTO … SELECT operation on an empty table.
    15-Oct Starting with #DB12c 12.1.0.2, you can use the SAVE STATE clause of ALTER PLUGGABLE DATABASE statement to preserve the open mode of the pluggable database. If SAVE STATE is specified, open mode of specified PDB is preserved across CDB restart on instances specified in the INSTANCES clause. Similarly, with the DISCARD STATE clause, the open mode of specified PDB is no longer preserved. This clause provides the flexibility to choose the automatic startup of application PDBs when a CDB undergoes a restart.
    17-Oct In #DB12c, ALTER TABLE … MOVE PARTITION becomes non-blocking online DDL while DML operations continue to run uninterrupted on the partition that is being moved. Global indexes are maintained during the move partition, so a manual index rebuild is no longer required.
    20-Oct Using Active Dataguard in #DB12c, reporting applications are able to write to global temporary tables at the standby database without any modification.
    22-Oct SQL*Loader in #DB12c has a new option that does not require the user to create a SQL*Loader control file. Instead, command-line parameters are used to specify how the data file is loaded, and SQL*Loader automatically chooses the best method with which to load the data. Data files formatted as comma-separated values (CSV) to both SQL*Loader and external tables are supported.
    24-Oct Rapid Home Provisioning (rhpctl utility) is a method of deploying software homes to nodes in a cloud computing environment from a single cluster where you create, store, and manage templates of Oracle homes as images (called gold images) of Oracle software, such as databases, middleware, and applications. You can make a working copy of any gold image, and then you can provision that working copy to any node in the cloud.
    27-Oct In #DB12c Datapump Export and Import, the LOGTIME command-line parameter allows you to request that messages displayed during export and import operations be timestamped. The options for this parameter are STATUS (timestamps on status messages only), LOGFILE (timestamps on log file messages only) and ALL (timestamps on both status and log file messages).
    29-Oct Staring in Oracle #DB12c, the SIMILAR value for CURSOR_SHARING is deprecated. Use FORCE instead.
    31-Oct Starting with Oracle #DB12c, the software deinstallation standalone utility is replaced with a deinstall option using Oracle Universal Installer (OUI). You can also run the deinstallation tool using the runInstaller command on Linux and UNIX (or setup.exe on Windows) with the -deinstall and -home options from the base directory of the installation media for Oracle Database, Oracle Database Client, or Oracle Grid Infrastructure.

  • Oracle Open World 14 – A Diary

    I had the opportunity to attend this year Open World conference in San Francisco. This was my 7th open world and each year my excitement only goes up. And, this year was special – first conference as Oracle ACE. I am thankful to Oracle Publishers Seminar (+ Oracle ACE program) and OneNeck IT for giving me the opportunity.

    Sunday:

    Sunday is the first day of conference and was eventful for me. (Oh forgot, I got upgraded to business class by American on 767 plane, so the day started really good).

    Reached just before noon at the conference, and went straight to the OTN lounge to meet the RAC Attack Ninjas. Though I went to help, I actually did upgrade my virtual box 12c RAC to 12.1.0.2 and learned about the Grid Infrastructure Management Repository (tweet here). Thanks to Seth and Eric for their help. The cluster upgrade is done in a rolling fashion, and thus the database service was unavailable only on the node that is being upgraded. So, the upgrade can be done without a database outage.

    After the OTN RAC Attack, did not attend any session on Sunday, went to the hotel the check-in. There also got a surprise upgrade to a room on penthouse floor on the Hilton Financial District, overlooking the San Francisco Bay. Beautiful view!

     

    Was lazy to go back to Moscone to watch Larry keynote, so watched him online. Larry was in a real good mood, I enjoyed the keynote.

    By the time the keynote was over, was almost late to the Oracle ACE dinner. This was my first OOW ACE dinner, and there were some surprises too (the dance!). Got to meet few friends I only know on the internet… This is a great bunch of people!

    Monday:

    Attended few sessions in the morning and spent some time at the OneNeck booth.

    My 12c OCA certification book was published in May. To my surprise, saw several copies of the book along with Freeman’s OCP book in the book store.

     

    Monday ended with a customer dinner… (yum stake!)

    Tuesday:

    All of Tuesday morning, including lunch was with Oracle Publishers Seminar. Met many authors, and listened to Oracle product leaders. The round table with Oracle product managers was especially good this year.

    Spent rest of the day at the Oracle demo grounds visiting cloud and Sparc booths.

    Evening was the OneNeck customer appreciation happy hour/dinner at the Hilton. Had a good time.

    Wednesday:

    Attended several good sessions on Wednesday.

    Had opportunity to listen to Jonathan Lewis talking on the technology behind Delphix. Enjoyed the company of Sandesh and Gopal, and it was a special moment to get a photo with JL.

     

    Evening was the Pythian/OTN blogger meet up. Met several great folks…

    The appreciation event was well attended, this year the weather was perfect. Spent some time, till 11pm…

    Thursday:

    Had to finish some work emails in the morning… Attended couple of sessions before taking off to Airport. BTW, had my photo with Yury, no jumping though!

     

    Flight to Dallas was delayed about 3 hours! so return home was not that fun!! But glad to be home with family…

    During the Open World week I did not publish any Oracle Tidbits on the facebook page (and twitter too). This was intentional as I was tweeting a lot from the conference already. I will resume publishing the tidbits again this week…

    Have a great day!