Great Lakes Oracle Conference – Presentation Download

NEOOUG did a wonderful job in organizing the Great Lakes Oracle Conference event and the venue. This was the first time me doing two presentations in one conference, that too, for two different type of audience. E-Business Suite R12 Upgrade and Oracle Database 12c New Features. I want to thank Sybex for sending the newly published … Read more

OracleDB12c New Feature: Unified Auditing

Unified Auditing is a new feature introduced in Oracle Database 12c, to streamline and standardize all audit trail information. The traditional auditing architectures involve many audit-trail locations and tables to review information for the auditors, and do not follow a standard. Every new product introduced in the database had to essentially have a new audit table … Read more

ASM User Management Q&A

Q: Can you create users in ASM instance? A: Yes, absolutely. Q: Why? A: For better security. Q: I was told there is no database associated with ASM, it is just an instance, so where is this user really created? A: You must have a password file to create users. The users are added to … Read more

Oracle Enterprise Manager 12c Cloud Control: Setup VirtualBox

Oracle provides the template for VirtualBox OEM 12c Cloud Control 12.1.0.3 version. For practicing and learning OEM 12c Cloud Control, this is the quickest way to get Cloud Control up and running. Enjoy! Access the setup document from Slideshare  http://www.slideshare.net/BijuThomas3/oem-12c-cloud-control-setup-virtual-box Happy Holidays!  

Validate Database Links – Script

Here is a PL/SQL script to validate the database links accessible to an user.  I wrote this to identify the working links after a database refresh or to verify links that connect from non-prod to prod… Hope it helps…   REM Validate Database Links REM Private links under connected user and Public links REM REM … Read more

OPatch Options!

A friend of mine was working to apply the July 2013 PSU, and had to rollback two one off patch conflicts. Since the instance was cloned from production, OPatch was failing with this error… $ $ORACLE_HOME/OPatch/opatch rollback -id 12834800 The patch should be applied/rolled back in ‘-all_nodes’ mode only. Converting the RAC mode to ‘-all_nodes’ … Read more

Oracle Database 12c Licensing Trivia!

Was reading the licensing doc, and this is a note to self… [any decisions must be based on the licensing doc and not this blog]. Couple of things not changed… Almost all “cool” features are available only in EE edition. Almost all “cool” features outside of storing data requires some kind of “Extra Cost” option I … Read more