Reading Oracle Trace File

Here are some steps for extracting Oracle Trace File. This file is commonly used to analyze database performance/problem

Files are located on /$ORACLE_HOME/admin/$DB_NAME/udump

Trace file example
niaga_ora_13228.trc
niaga_ora_13379.trc


Extraction steps
$ cd /data/oracle/admin/niaga/udump
$ tkprof niaga_ora_13228.trc 13228.txt sys=no explain=niaga/niaga sort=prsela,exeela,fchela

The outout for above syntax will be 13228.txt

You can open 13228.txt using your own text editor

Creating / Changing MySQL Password

Steps for creating user on MySQL
1. Login to MySQL as root and then follow this step
CREATE USER 'user_name'@'localhost' IDENTIFIED BY 'password';

2. Grant Access to the user
GRANT ALTER,SELECT,INSERT,UPDATE,DELETE,CREATE,DROP
ON database_name.* TO 'user_name'@'localhost';

Here are steps for changing root password (in case root password is blank)
/usr/bin/mysqladmin -u root password 'new-password'

If you are using hostname
/usr/bin/mysqladmin -u root -h honda.pacomnet.com password 'new-password'

Compiling Apache for a better performance

Here is configure script that I used for my Production environment:

./configure --prefix=/data/apache \
--enable-so \
--enable-lua \
--enable-headers \
--enable-unique-id \
--enable-ssl \
--enable-vhost-alias \
--enable-file-cache \
--enable-cache \
--enable-disk-cache \
--enable-mem-cache \
--enable-expires \
--enable-rewrite \
--disable-cgi \
--disable-version \
--disable-userdir \
--with-mpm=worker \
--enable-nonportable-atomics=yes \
--enable-deflate \
--with-included-apr

Adding Cisco Access List

1. Log in to Cisco (Using Telnet or SSH)

2. Enter administration (enable) mode
cisco-router>enable
cisco-router#
cisco-router#conf terminal

3. Create an access list (extended)
cisco-router#ip access-list extended acl-testing
cisco-router#permit tcp host 10.8.19.1 host 202.152.162.229 eq 8181