There are a lot of usefully MySQL commands that I either don’t run enough to remember or just end up using some GUI to accomplish. Nothing against Navicat, but what kind of sysadmin would I be if I couldn’t do it at the command line as well. Anyhow, I had to do a bunch of [...]
Below is a list of RHEL system configuration changes that Oracle 10G requires before it is installed.
First, check the following kernel parameters using the commands below:
/sbin/sysctl -a | grep kernel.shmall
/sbin/sysctl -a | grep kernel.shmmax
/sbin/sysctl -a | grep kernel.shmmni
/sbin/sysctl -a | grep kernel.sem
/sbin/sysctl -a | grep fs.file-max
/sbin/sysctl -a | grep net.ipv4.ip_local_port_range
/sbin/sysctl -a | grep net.core.rmem_default
/sbin/sysctl [...]
I managed to corrupt my NetInfo database on an OS 10.4 server a few weeks ago by not cleanly unmounting the drive after booting from DVD and resetting the admin password. Long story short, this left me with no users on the system at all. With no users, I could not log in to create [...]
Rather than leave MySQL open to the world, consider firewalling it off and tunneling a connection over ssh.
This command will allow you to connect to your MySQL server on hostname.domain.com on localhost:7777.
ssh -L7777:127.0.0.1:3306 user@hostname.domain.com
Whenever you go to install applications and services on registered RHEL servers, it’s always nice to use the RPMs because up2date will keep everything current for you. Managing upgrades gets a whole lot easier when you can bring your system up to current with one simple command. Because of this, I decided that I would [...]
OpenGroupWare is an open source groupware package intended as an alternative to proprietary applications such as Exchange and PostPath. It is fairly robust in its feature set, and even integrates well with MS Outlook.
Its strongest points, in my opinion are that it does not depend in any way on Active Directory, and that it [...]
When you install RHEL, the filesystems are labeled for you. Usually you won't have to mess with it anymore, but on occasion, you may want to change them to more accurately represent the data that is stored on that partition. If, for instance, you used to have all of your database files on a partition [...]
There is a convention of thought amongst Oracle DBA's that databases should never be installed on disks that are configured into a RAID 5 array. The argument goes, that since Oracle accesses and writes to random points within relatively large files, the overhead of constantly calculating block-level parity on these files is substantial, resulting in [...]
If you're familiar with UNIX, you know that changing mount points is really pretty easy. All you have to do is go into "/etc/fstab", "/etc/vfstab" (or whatever your flavor of UNIX happens to call its filesystem table) and change the mount directory.
If, for instance, you had a Solaris box, and you wanted to make the [...]
I'm a blogger. I'm also a systems administrator at a University. Thus, when the University decided to charter a project to offer each member of the institution a blog, I was selected to sit on the committee. We boiled all of the software choices down to Drupal, Movable Type, and Wordpress MU.
In my evaluation of [...]
