Freeware: Diff pdf

Very useful pdf comparision program http://www.qtrac.eu/diffpdf.html

Windows : List users AD group

net user /domain ruwins

Linux : Clear bash history

alias histfix='history -c;rm -rf ~/.bash_history;'

Linux : zip without files names, list zip contents

zip -j - will Junk directories paths from files being added unzip -l - will list files in z zip archive

Vmware : Fullscreen Mode

Ctrl-Alt-Enter

Outlook : Advanced Search

Ctrl-Shift-F

Mocking a pmon process using perl

perl -e '$0="ora_pmon_OXOEM1"; 1 while 1' &

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

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 &

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

Windows : Alt-tab problems

go to "Control Panel\All Control Panel Items\System" [wich shows information about windows edition, system , activation & …] on the right click on "advanced system settings" under the "advanced" tab under "performance" click on "settings" under "visual effects" tab click on custom and check all of the items on the list and after that click ok .... I hope it works for you!

Oracle : Startup 9.2 dataguard

startup nomount alter database mount standby database; alter database recover managed standby database disconnect;

Netapps : Delete blocking locks

* Log on to netapp filer To view locks - priv set diag; lock status -f  To delete locks - priv set diag; sm_mon -l [servername]

Linux : Yum - installing a specific version

To get all versions of a package in a repo * yum search --showduplicates  mercurial * Then install with full name yum install mercurial-1.7.2-1.el5.rf.x86_6

Visual Studio : Disable vshost generation

The Visual Studio hosting process improves debugger performance and enables new debugger features, such as partial-trust debugging and design-time expression evaluation. You can disable the hosting process if you need to. To disable the hosting process * Open a project in Visual Studio. * On the Project menu, click Properties. * Click the Debug tab. * Clear the Enable the Visual Studio hosting process check box.

Oracle : Dropping queue tables

alter session set events '10851 trace name context forever, level 2'" , followed by a DROP TABLE tname

Test1

test1

Linux : Asset tag under linux

/usr/sbin/dmidecode | egrep -i 'serial|asset'

VMWare : Getting vmplayer to stop/start by remote control

Download VMWare VIX api from http://www.vmware.com/support/developer/vix-api/ Install in linux by running bash VMware-VIX-1.10.3-368992.x86_64.bundle (needs gui) Use vmrun command eg. vmrun -T player start /local/vmware/Bangor/Bangor.vmx vmrun -T player stop /local/vmware/Bangor/Bangor.vmx

Oracle : Clone grid control agent

In Grid Control->Deployments->Install Agent->Clone Agent On source server in dir above the agent home  zip -r agent11g_201105v1.zip agent11g Copy to target server or the OEM server Take care to pick the correct OS in the drop down, linux != linux x64!

Linux : Faster file transfer via ssh and tar compression

time scp  ARCHIVE_01.dbf oracle@remote.server.com:/b04/volbackupnew/oradata/NEWDEV5/dataguard/test real    41m5.699s time tar cvfz - ARCHIVE_01.dbf | ssh oracle@remote.server.com "tar zxvf - --directory /b04/volbackupnew/oradata/NEWDEV5/dataguard/test " real    0m57.987s

Jira : Dragging issues direct from the (Oracle) db

col c1 format a900 set lines 2000 pages 0 head off long 2000 longchunksize 2000 wrap on trimspool on trim on with base_data as ( select i.id iid, -1 aid, to_char('######### '||i.pkey ||' - '||i.assignee ||' - '||i.summary || ' #########') c1 from jira_dbo.jiraissue i where 1=1 and i.assignee like 'data%' union all select i.id iid, 0 aid, to_char(substr(i.DESCRIPTION,0,1000)) c1 from jira_dbo.jiraissue i where 1=1 and i.assignee like 'data%' union all select i.id, a.id, to_char(substr(a.ACTIONBODY,0,1000)) c1 from  jira_dbo.JIRAISSUE i, jira_dbo.jiraaction a where 1=1 and a.issueid = i.id and i.assignee like 'data%' ) select c1 from base_data  order by iid,aid

Linux : Marble Mouse Paste on Centos 5.5

Section "InputDevice"           Identifier  "Mouse0"           Driver      "mouse"           Option      "Protocol" "ExplorerPS/2"           Option      "Device" "/dev/input/mice"           Option      "Emulate3Timeout" "50"           Option      "Buttons" "7"           Option      "ZAxisMapping" "6 7"           Option      "Emulate3Buttons" "on" EndSection

Linux : Customize Vim Colors 2

In ~/.vimrc syntax on colorscheme murphy

Linux : Customize Vim Colors

In ~/.vimrc syntax on colorscheme ron #colorscheme desert

Linux : directory color in ls too dark

ls shows directories in a dark unreadable blue with a black background Change /etc/DIR_COLORS.xterm - set the DIR line to DIR 01;34 (lighter blue)

Grid Control : Set up a public monitor display PC

Config within Grid Control - a MONITOR user * Set up a monitor role in Grid Control  * Setup->Roles->Create  * Enter name but no roles, sys privs,  No admin users * Set up a monitor admin user * Setup->Administrators  * Enter name etc, then assign the MONITOR_ROLE, no sys privs * Assign targets to the role  * for EACH TARGET to be seen by the monitor need to grant view access individually !!  * Go to each target page->Access link->Add->MONITOR_ROLE  * Save * To add a location to a target  * In each target screen there is a Target Properties link that includes a location field  * Various screens including All Targets can be customised to show the Location (Customize table columns) * The best page to display is probably All Targets * To limit the tabs displayed log in as MONITOR and choose Preferences->Target Subtabs and remove unwanted subtabs Config on the display box * Use Firefox  * Set as the default browser Tools->Options->General  * Install the ReloadEvery firefox plugin - this adds an option to the context menu on each page (right click on the web page to find it)  * Set up a shortcut to OEM - will need to login perhaps - maybe can include password?  * Navigate to the All Targets page  * Turn on the reload for every minute * To lock down the monitoring PC  * Download and install kidkeylock http://www.100dof.com/kidkeylock.html  * Create a shortcut to start it  * TIP add /setup param to the shortcut to avoid being locked out immediately  * In the program options set two pins and turn off all keyboard and all mouse and baloon tip (which shows the password)

Linux : Change runlevel

Use telinit :- su -c 'telinit 3'

Oracle : oraenv gives XPointer evaluation failed

In 11G+ this is due ORACLE_BASE not being set in the course of running oraenv What is happening is $ORACLE_HOME/bin/orabase is being run to update $ORACLE_HOME/inventory/ContentsXML/oraclehomeproperties.xml and erroring as the particular key it is looking for is not in the file ( PROPERTY NAME="ORACLE_BASE" I guess) - however the error is ignored resulting in $ORACLE_BASE being unset Made a one line change to oraenv to check the return value and use the OLD_ORACLE_BASE - which will probably work most of the time ;) ORACLE_BASE=`$ORABASE_EXEC` [ "$?" -ne 0 ] && { echo "Warning - failure of $ORABASE_EXEC"; ORACLE_BASE=$OLD_ORACLE_BASE; }  # New line