SAP 4.6c Oracle recommendations

March 10, 2008

I had put this together for a 4.6C system back in 2005. Some of these are now default behavior, but you may still have some older systems that have not yet been converted, or it may provide a good reference at some point. Read more

SAP instance check shell script

March 10, 2008

I wrote this script about about four years ago and came across it again today.  This will probobly be helpful in someway to someone someday ;)

This script requires the SAP SDK, which is available from SAP.  If you can’t find it let me know.

So, this script will do the following:

  • Attempt to connect to sap using sapinfo command check to see if host is already known to be down, or if recovered from being down

  • send pages / email to defined list

  • Tracks systems that are already down so as not to resend email / pages

Read more

Rename / Move Oracle datafile

March 10, 2008

I needed to move a datafiles from one directory to another. The datafile was created in the wrong location. Here is a procedure I used:

Read more

APF and BFD on Debian

March 8, 2008

Howto install APF / BFD on a Debian system

.. Read more

HTTP to HTTPS via mod_rewrite

March 8, 2008

I was looking for this information one day, and thought I would share what I found.

 

To redirect a website from http -> https I utilized mod_rewrite. And created a .htaccess file with the following contents.

 

$ cat .htaccess
Options FollowSymLinks
RewriteEngine On
RewriteCond %{SERVER_PORT} !^443$
RewriteRule ^(.*)         https://your_server.com/$1

Xen virtualization notes

March 8, 2008

I have recently been working virtualizing Windows and Linux machines using Xen.  A few things popped up along the way and a bit of research was done to make things work properly, these are some of the notes I used along the way.

 

- I am partial to using LVM based devices for creating my virtual machines. Think lvm snapshots for backups.
Read more

Netdump, figuring out what caused that system crash

March 8, 2008

We have all been there before. Your server crashed, nothing indicates what happened. You check /var/log/messages and all you see is.. well.. nothing. With no sign of what happened, or indication of why it happened you are left to.. wait until it happens again. On Red Hat based systems, you have an answer. [...]

Dedicated Linux Server Checklist for the New Year.

March 8, 2008

If you have a dedicated Linux server, this list is for you. Below are a few items you need to do, to ensure your 2008 will be a bit brighter. This list is by no means comprehensive, but hopefully gets you started in the right direction this year. Check your backups and perform a [...]

cPanel / Fantastico Deluxe install doesn’t do anything.

March 8, 2008

We ran into an issue when installing Fantastico. After clicking the installation button, everything seemed to download just fine, but every time you go back to the Fantastico link it says it is not installed. It turns out, Fantastico uses wget to download files. wget is called with the ‘-P’ option, which is not [...]

MySQL threads tuning

February 21, 2007

Some quick info I have pulled off of the web on MySQL performance tuning.  I am currently working on some mysql performance tuning and this is some of the information I have gathered.

 

Threads_created details the number of threads that have been created since the MySQL server started, and Connections is the total number of client connections to the MySQL server since startup. To work out the thread cache hit ratio, we use this calculation:

Read more

Next Page »