Search This Blog

Monday 20 March 2017

Oracle sys password reset steps

To Reset SYS user password, Login as oracle user or set environment variable to access sqlplus.

export ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe
export ORACLE_SID=XE
export PATH=$ORACLE_HOME/bin:$PATH

sqlplus /nolog
connect / as sysdba
alter user sys identified by <your pwd>;

Wednesday 8 March 2017

Bugzilla upgrade steps

bash$ cd /var/www/html/bugzilla
bash$ wget  https://ftp.mozilla.org/pub/mozilla.org/webtools/bugzilla-5.0.2-to-5.0.3.diff.gz  bash$ gunzip bugzilla-2.22-to-2.22.1.diff.gz  bash$ patch -p1 < bugzilla-2.22-to-2.22.1.diff

Reversed (or previously applied) patch detected! Assume -R? [n] -R

      Apply anyway? [n] Y 

bash$ ./checksetup.pl