Monthly Archives: April 2011

Restoring a database from TSM.

Posted on April 28, 2011 by Gary

If you require to restore a database from TSM, you will require some additional information than just your backup tape.

Email
Posted in Oracle, Recovery Manager | Tagged , | Comments Off

Using EMCLI to get agent properties.

Posted on April 28, 2011 by Gary

EMCLI allows us to obtain agent properties, and indeed to set them from the command line. Such a tool would be useful in maintaining possibly multiple OEM’s depending on criteria, and updating each agent remotely.

Email
Posted in Configuration., EMCLI, OMS, Oracle Agent | Tagged , , , | Comments Off

Using EMCLI to unblock and resync agents.

Posted on April 28, 2011 by Gary

A common problem I find is resyncing agents and getting them unblocked. EMCLI allows this.

Email
Posted in EMCLI, Oracle Agent | Comments Off

Creating and working with Groups in EMCLI.

Posted on April 28, 2011 by Gary

Here’s a spin off to create and manage/monitor groups in OMS, but using EMCLI to configure them.

Email
Posted in EMCLI, Oracle Configuration Manager | Tagged , , | 1 Comment

ORA-00904: “ORIGINAL_OBJECT_NAME”: invalid identifier

Posted on April 28, 2011 by Gary

Found an interesting change from 11.1.0.6 to 11.1.0.7. Bearing in mind that oracle do not support importing data exported from a later oracle version.

Email
Posted in Oracle | Comments Off

Battling OMS 11g

Posted on April 26, 2011 by Gary

Had Oracle Management Server Problems. Didn’t seem to resolve it though.

Email
Comments Off

Teradata Compression Tool: AtanaSuite

Posted on April 15, 2011 by sidn

Teradata Compression Tool Teradata supports compression from version 12 onwards. Unlike some other databases, we cannot do this command: alter table daily_inventory compress; // We can’t do this in Teradata We need to specify what column values we like to compress and we can only pick up to 256 of them. Well, what happens if [...] Continue reading →

Email
Posted in AtanaSuite, Netezza, Teradata | Tagged , | Comments Off

Partitioning made easy. Part 4, reference partitioning.

Posted on April 15, 2011 by Gary

What is reference partitioning ? Ok, so I’ve looked at various partitioning options, now to look at composite Reference partitioning.

Email
Posted in Partitioning. | Tagged , , , | Comments Off

Partitioning made easy. Part 3, 11g.

Posted on April 15, 2011 by Gary

Partitioning made easier with 11g. Ok, if you Checked Part 2, we had a table defined called B, which is weekly partitioned from year 2000 to year 2020. However, in 11g there’s a easier method to performing this.

Email
Posted in Partitioning. | Tagged , , | Comments Off

Partitioning made easy. Part 2.

Posted on April 15, 2011 by Gary

How to create a simple range subpartitioned table, the easy way. Ok, if you Checked Part 1, we had a table defined called A, which is weekly partitioned from year 2000 to year 2020. Now the client want’s it sub-partitioned. … Continue reading →

Email
Posted in Partitioning. | Tagged , , , , | Comments Off