Oracle VM 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.

Tweaking LLVM Obfuscator + quick look into some of LLVM internals.

Tweaking LLVM Obfuscator + quick look into some of LLVM internals.

OCM 11g Preparation – Use Grid Infrastructure to manage oracle databases and other resources

In this topic we are not talking about grid or Oracle RAC yet, but this item is here. So, having proficiency in using the GI to manage a database (and we are still talking about standalone server) means to me “Oracle Restart“.
When installing grid infrastructure for a standalone, we get some utilities to set up and manage the oracle databases. The main utility for this is srvctl. The bright side for us is that the binary is much more simple, with just a few options.

ORA-39095

I kicked off an expdp with the following parameters. I set the filesize parameter but forgot to set the dumpfile parameter to match:

Quiz Night

How many rows will you return from a single table query if you include the predicate


        rownum > 2

in the where clause.

Warning: this IS a catch question

To make it easier and avoid ambiguity, you may assume the table is the standard SCOTT.EMP table.

 

Part 2:

This posting was prompted by noticing a note that Dominic Brooks posted a few months ago.

MySQL database (5.0) will not start up

The data is held in a single large file named ibdata1, and the file

seems to have grown too large. This database is held on a Windows 2003

Server. I need someone to tell me how to extract the data from the

large datafile without starting the database OR extend the allowed size

for the file on Windows so that I can start db.

Starting the db from a command window, I get:

>> CMD window >>
C:\Program Files\MySQL\MySQL Server 5.0\bin>mysql

applyElasticConfig.sh fails with Unable to locate any IB switches

With the release of Exadata X5 Oracle introduced elastic configurations and changed the process on how the initial configuration is performed. Back before you had to run applyconfig.sh which would go across the nodes and change all the settings according to your config. This script has now evolved and it’s called applyElasticConfig.sh which is part of OEDA (onecommand). During one of the recent deployments I ran into the below problem:

Some People’s Kids

"Expectations is the place you must always go to before you get to where you're going. Of course,
some people never go beyond Expectations, but my job is to hurry them along whether they like it or not."
- Norton Juster, The Phantom Tollbooth

From time to time I find a situation where a developer believes that:

fsfreeze in Linux

The fsfreeze command, is used to suspend and resume access to a file system. This allows consistent snapshots to be taken of the filesystem. fsfreeze supports Ext3/4, ReiserFS, JFS and XFS.

A filesystem can be frozen using following command:

# /sbin/fsfreeze -f /data

Now if you are writing to this filesystem, the process/command will be stuck. For example, following command will be stuck in D (UNINTERUPTEBLE_SLEEP) state:

Understanding Flash: Summary – NAND Flash Is A Royal Pain In The …


So this is it – the last article in my mini-series on understanding flash. This is the bit where I draw it all together in a neat conclusion that makes you think, “Yes! That was worth reading”. No pressure eh?

Extracting Oracle data & Generating JSON data file using ROracle

In a previous blog post I showed you how to take a JSON data file and to load it into your Oracle Schema using R. To do this I used ROracle to connect to the database and jsonlite to do the JSON processing of the data.Alternatives to using ROracle would be RODBC, RJDBC and DBI. So you could use one of these to connect to the database.

view counter