Monday, 11 July 2011

Oracle : Restart Grid Control 11GR2

export ORACLE_SID=OEM #Where oracle home is /u01/app/oracle/Middleware/oms11g


. oraenv

emctl stop oms -all
# The -all stops the web tier as well
export ORACLE_SID=AGENT
. oraenv
emctl stop agent
emctl start agent
export ORACLE_SID=OEM
. oraenv
emctl start oms

Friday, 8 July 2011

Linux : Larger vnc windows

Need to start the vncserver bigger - such as
vncserver -geometry 1280x960

Linux : Get gnome in vnc

edit ~/.vnc/xstartup and change the windows manager invocation at the bottom :
#twm &
exec gnome-session &

Tuesday, 5 July 2011

Oracle : Deinstall 11.2 Single-node Cluster on ASM

* Remove oracle home for databases using deinstall usign downloaded deinstall
 cd /u01/app/oracle/media/deinstall
 ./deinstall -home /u01/app/oracle/product/11.2/db_1
 
* Stop and remove the asm service (?)
  srvctl stop asm -force -n bangor
  srvctl  remove asm  -f -n bangor
 
* Using local  deinstaller - run local deinstall
  cd /u01/grid/product/grid
  ./deinstall -local
  # Answer various questions by accepting all defaults
  # Prompted to run the folloiwng as root (all one line)
  /u01/app/oracle/media/deinstall/./perl/bin/perl -I/u01/app/oracle/media/deinstall/./perl/lib \
   -I/u01/app/oracle/media/deinstall/./crs/install \
   /u01/app/oracle/media/deinstall/./crs/install/rootcrs.pl -force  -deconfig -paramfile \
   "/local/home/grid/deinstall_noHomeName.rsp"
  # Process continues and finally prompts to run followng as root
  rm -rf /etc/oraInst.loc
  rm -rf /opt/ORCLfmap* Remove oracle home for databases using deinstall usign downloaded deinstall
 cd /u01/app/oracle/media/deinstall
 ./deinstall -home /u01/app/oracle/product/11.2/db_1
 
* Stop and remove the asm service (?)
  srvctl stop asm -force -n bangor
  srvctl  remove asm  -f -n bangor