JamesKoopmann.com header image 4

Entries from April 2008

Cheep-man’s archive log mover for Oracle

April 23rd, 2008 · No Comments

Now, before I get too many comments on why this won’t work, let me just say that this really is a cheap-man’s archive log mover. AND it does assume that you know your archive log process very well and the number of logs defined within your database. Setting the KEEPLOGS parameter inside this script is [...]

[Read more →]

Tags: Oracle

Oracle - looking at snapshot ranges

April 19th, 2008 · 3 Comments

A lot of the AWR reports ask for, before spitting out their report, the number of days back you would like to go before entering your beginning and ending snapshot IDs. When they report on all the snapshot IDs they have left out, I think, one very important piece of information that just might cloud [...]

[Read more →]

Tags: Oracle

Install Oracle11g on Linux CentOS-5

April 11th, 2008 · No Comments

Glad to be back. It HAS been awhile and hopefully you forgive thecheapdba for staying away.
BUT this post, I am sure you will like. It is an installation guide for Oracle 11g on Linux CentOS-5.
As the installation is quite lengthy I will just provide you with a link to the main, new and “improved” website [...]

[Read more →]

Tags: Oracle