Visits

4401 (since Aug 23, 2008)

Personal

Linux auto start/stop scripts

Normally DBAs and SAs have a tendency to create the auto start/stop scripts like following.

# cat /etc/init.d/oracle

case $1 in
start)
/opt/oracle/product/11.1.0/bin/dbstart;
;;
stop)
/opt/oracle/product/11.1.0/bin/dbshut;
;;
esac

# ln -s /etc/init.d/Oracle /etc/rc.d/rc0.d/K01oracle
# ln -s /etc/init.d/Oracle /etc/rc.d/rc3.d/S99oracle
# ln -s /etc/init.d/Oracle /etc/rc.d/rc4.d/S99oracle
#

… Continue reading more

Slow drop user

For past 3 weeks i was covering for a project dedicated DBA who had gone on leave for 3 weeks (some people are just lucky). Its an Oracle Peoplesoft General Ledger application on Oracle 10.2.0.3 database. Lot of copies of application are hosted in same database as multiple copies for different stages of software lifecyle.

I was

… Continue reading more