Oracle Virtualization and Cloud Consulting
view counter

Database Feed

Oracle Database, Oracle 10g, Oracle 11g, Oracle XE, Oracle RAC, Oracle Instant Client, Oracle Data Guard and Oracle Exadata resources, news, and support articles.

OCM 11g Preparation – Configure ASM for the shared disks and create a clustered database

We have seen in Create ASM Disk Groups and Implement ASM failure groups how to configure ASM for shared disks, but in my opinion, this topics wants you to go further in the disk level.
It wants you to know how to:

OCM 11g Preparation – Install the Oracle Database 11gR2 software

So, this reminds me the first chapter. But, one thing that I’ve only noticed now is.. in the first skillset, it starts with “Create the Database”. There is no “Install Oracle Database software” there. ^^
Here, what I recommend you to practice is:

  • Install Oracle DB using GUI (preferable, of corse).
  • Install Oracle DB using CLI (and RSP file).
  • Do both of the above into local and shared Oracle Home.
  • Install Oracle Home using addNode.sh.
  • Remove a Oracle Home (from local and shared).

Path do Documentation:

I Wish I Sold More

I flew home yesterday from Karen’s memorial service in Jacksonville, on a connecting flight through Charlotte. When I landed in Charlotte, I walked with all my stuff from my JAX arrival gate (D7) to my DFW departure gate (B15). The walk was more stressful than usual because the airport was so crowded.

The moment I set my stuff down at B15, a passenger with expensive clothes and one of those permanent grins established eye contact, pointed his finger at me, and said, “Are you in First?”

Presentation will be

There is no much left for 2015 but there is too much work waiting me, presenting in different country means a lot of work and preparation, i am still waiting different events but till now this is confirmed:-

  • SIOUG2015
  • HROUG2015
  • OOW15
  • UKOUG TECH15

So Excited.CheersOsama Mustafa

Database 12.1.0.2 Certified with EBS 12.2

After Waiting too long finally I can upgrade my Oracle EBS Database ,Regarding to Oracle Blog "Database 12.1.0.2 Certified with EBS 12.2".You can Read more about this hereCheersOsama

My Friend Karen

My friend Karen Morton passed away on July 23, 2015 after a four-month battle against cancer. You can hear her voice here.

WordPressers Making a Splash

We read hundreds of blogs and websites every day, from up-and-coming voices and established pros alike. We love visiting those sites on WordPress.com, but it’s just as rewarding to see other platforms embrace the work of writers, journalists, and artists who regularly publish here, introducing it to new audiences.

Here’s a selection of WordPress.com bloggers who recently made a splash.

STANDARD date considerations in Oracle SQL and PL/SQL

Most of us know that the Oracle DATE datatype has upper and lower limits. From the Oracle 11g Database Concepts manual:

Oracle Database can store dates in the Julian era, ranging from January 1, 4712 BCE through December 31, 9999 CE (Common Era, or ‘AD’). Unless BCE (‘BC’ in the format mask) is specifically used, CE date entries are the default.

Existence

A recent question on the OTN Database Forum asked:

I need to check if at least one record present in table before processing rest of the statements in my PL/SQL procedure. Is there an efficient way to achieve that considering that the table is having huge number of records like 10K.

Creating standby database inc DG Broker and 12c changes

I thought I would refresh my knowledge of creating a standby database and at the same time include some DataGuard Broker configuration which also throws in some changes that came along with 12c

Overview

Database Name QUICKIE host server 1 ASM disk

Database Name STAN host server 2 ASM disk

Create a standby database STAN using ACTIVE DUPLICATE from the source database QUICKIE

 

view counter