Oracle : Password file

At command line orapwd file=./PWDFILE password=password entries=10 In sqlplus: select * from <a href="http://www.adp-gmbh.ch/ora/misc/dynamic_performance_views.html#pwfile_users">v$pwfile_users</a>; USERNAME SYSDB SYSOP ------------------------------ ----- ----- <a href="http://www.adp-gmbh.ch/ora/misc/sys_system_internal.html">SYS</a> TRUE TRUE <a href="http://www.adp-gmbh.ch/ora/sql/grant.html">grant</a> <a href="http://www.adp-gmbh.ch/ora/admin/sysdba.html">SYSDBA</a> to USERNAME; <a href="http://www.adp-gmbh.ch/ora/sql/grant.html">grant</a> <a href="http://www.adp-gmbh.ch/ora/admin/sysdba.html">SYSOPER</a> to USERNAME;

Oracle : Remove 11.1 RAC cluster

Use cluster remove tool found : http://download.oracle.com/otndocs/products/clustering/deinstall/clusterdeconfig.zip This is a command line tool - unzip on node and de-install database home then crs home ./clusterdeconfig -home /u01/app/crs/11.1.0/crs -checkonly ./clusterdeconfig -home /u01/app/crs/11.1.0/crs  ./clusterdeconfig -home /u01/app/oracle/product/11.1.0/db_1 -checkonly  ./clusterdeconfig -home /u01/app/oracle/product/11.1.0/db_1 Need to run a 3 root scripts on each node

Linux : Getting hardware info from the command line

dmidecode

CVS : Pre-tag check failure

Very annoying and a completely useless error message This may be caused by a validation rule being set up on tags - eg. disallowing them to be moved/deleted Look at ../CVS/CVSROOT/taginfo which matches items being tagged to an executable to validate the action eg a line like DEFAULT /usr/local/bin/stop_tag_hack.sh will redirect to the shell script which can contain something like the following to stop deletes or changes : TAG_OP=$2 if [ "$TAG_OP" != "add" ]; then    exit -1    # exit 0 fi

Mysql : Reset root password

service mysql stop mysqld_safe --skip-grant-tables & mysql -uroot mysql UPDATE user SET password=PASSWORD("abcd") WHERE user="root"; FLUSH PRIVILEGES; mysql -uroot -pabcd mysql

Windows : Remove IE advanced security

* This is done by uninstalling the windows component Control Panel->Add or Remove Programs->Add/Remove Windows Components->Stuff

RMAN : Simple restore of archive log to default location

$ORACLE_HOME/bin/rman nocatalog connect target dba_cron/password run { ALLOCATE CHANNEL c1 DEVICE TYPE DISK; restore archivelog sequence 214629; restore archivelog sequence 214630; }