Parm Patram

for i in `ndd -get /dev/${DEV} \? | awk '{print $1}'| grep ^[a-z]`;
do
echo -n "$i:"; ndd -get /dev/${DEV} $i;
done

mv /etc/localtime /etc/localtime-old

ln -sf /usr/share/zoneinfo/GMT /etc/localtime

hwclock –systohc (or –utc)

ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YYYY HH24:MI:SS';

The problem is that the ssh session will wait for the command to complete and the ‘&’ to background the task does not seem to work. The net result is that the script running the nohup ssh command hangs.

This is because by default ssh does not allocate a TTY to run a command. You can force TTY allocation by using the ‘-t’ option to ssh, which will permit backgrounding, and the ssh command will return immediately.

In order to demonstrate, create a file /tmp/sleepy like so:

#!/bin/bash
while ( true ); do
echo `date` “sleep”
sleep 1
done

This command will invoke the script over ssh using nohup and &:

ssh -t localhost ‘nohup /tmp/sleepy &’

passwd -f <login>

chage -d0 <login>

/o10g/grid/oracle/agent10g/OPatch/opatch lsinventory

select trunc(first_time), count(sequence#) from v$log_history group by trunc(first_time) order by trunc(first_time)

select SUPPLEMENTAL_LOG_DATA_MIN,SUPPLEMENTAL_LOG_DATA_PK,SUPPLEMENTAL_LOG_DATA_UI,SUPPLEMENTAL_LOG_DATA_FK,SUPPLEMENTAL_LOG_DATA_ALL from v$database

install rlwrap (available from http://utopia.knoware.nl/~hlub/rlwrap/)

then add this to the bash_profile:

alias sqlplus=’rlwrap sqlplus’