I installed Oracle Enterprise Manager Cloud Control 12c soon after it's release in a virtual environment for the purpose of testing. I normally save passwords, ip-address, ports, and other details in a text file. But unfortunately, I was not able to locate the file for this particular VM.
However, it (more...)
I found the following Database Architecture Diagram for Oracle Database 12c on Oracle Education's website. It lists all the processes and the relationship between processes and other database components. I recommend you to take a print on A3 paper.
And below is a YouTube link which gives database architecture overview.
There are different ways of upgrading to the latest release
of Oracle database and Oracle provides multiple methods to upgrade. Few are
- Database Upgrade Assistant (DBUA)
- Manual Upgrade
- Transportable Tablespaces
- Datapump export/import
- Oracle Streams
- Oracle GoldenGate
I chose DBUA to upgrade my test database as it was the
Today while installing Oracle 11gR2 (18.104.22.168) 64-bit on RHEL 6.1 64-bit on a VMWare box, I received the mentioned error. Looking up at MOS wasn't fruitful. However, this seems to be an RHEL bug.
Starting Oracle Universal Installer...
Checking Temp space: must be (more...)
To be frank, I consider myself novice when it comes to
advanced export/import requirements. This is because I don’t deal with these
utilities on a day-to-day basis.
A simple requirement came across my desk to export selected
tables from a schema based on a common filter.
Say, you have 5 tables T1, T2, T3, T4, and T5. All have “ID”
as the primary key column and you have to export data from these tables only if
it is found in COMMON_TABLE. The COMMON_TABLE stores “ID” to be exported.
The first place that I look for solution is “Oracle
Starting with RACcheck 2.2.0, RACcheck support is extended to Oracle Single Instance Databases, Oracle Restart and RAC One Node configurations.
I downloaded the latest version of the tool and tested it against my play database. Below is a sample RACcheck output from a single instance database:
[oracle@localhost raccheck]$ ./raccheck -v
RACCHECK VERSION: 2.2.0_20121109
List of running databases
Select databases from list for
checking best practices. For multiple databases, select 1 for All or comma
separated number like 1,2 etc [1-2].
Blogging right from Tom's session "database new features". Here are the new features as they are discussed:
1. Identity Columns
Remember I blogged on this topic earlier.
2. Default on null
A default value is inserted into the column When it's null.
3. Improved defaults - metadata only defaults
Now add new default columns to a table on the fly. 12c does that for you.
4. Increased size limit for Varchar2 and NVarchar2
The column types can be upto 32k.
5. Row Pattern Matching
Efficient SQL functionality for reporting row patterns like identifying V and W patterns for your stock
I would like to thank all the attendees for attending my session "Very Large Databases (VLDB): Challenges and Opportunities". I am glad, the hall was full to it's capacity. :)
You may download the presentation by logging into OOW-2012 schedule builder.
I request all the attendees to kindly rate my session by logging into OOW: Schedule Builder.
See you all !!!
I am pleased to announce my first book "Oracle Database XE 11gR2 Jump Start Guide" published by Packt Publishers. The book is available in two formats "Print Book" and "ebook".
Please let your friends and colleagues know about the book. Have a look at the contents by following the below link:
The book is available for purchase from the publishers website (www.packtpub.com
) and other leading consumer websites like Amazon, Barnes and Nobles, Waterstones etc.
Thanks to all my readers who have encouraged me to write this book.
Today I received a congratulations email from “Oracle Certification Program” for successfully completing Oracle 10g OCM. Being an OCM is really an accomplishment in a DBA’s career. OCM is the most advanced database credential for an Oracle professional.
I still have to wait for another 2-3 weeks to receive OCM-Kit and to get my profile updated under “Oracle Certified Master Profiles”.