SHIFT-WIKI - Sjoerd Hooft's InFormation Technology
This WIKI is my personal documentation blog. Please enjoy it and feel free to reach out through blue sky if you have a question, remark, improvement or observation. See below for the latest additions, or use the search or tags to browse for content.
Outlook Line Breaks
Summary: How to configure outlook to not remove line breaks in plain text emails.
Date: Around 2014
Refactor: 4 January 2025: Checked links and formatting.
PowerShell: Use Out-GridView To Select Value for Variable
Summary: How to use the Out-GridView powershell commandlet to select a Value for a Variable.
Date: Around 2020
Refactor: 8 March 2025: Checked links and formatting.
Out-GridView allows you to interact with the output from a get commandlet. For example, say you want to select a server from Active Directory and put it in a variable but you can't quite remember the name.
Use the following command to display all AD computers, allowing you to select a server to put it in the variable:
$server = Get-ADComputer -Filter * | Out-GridView -PassThru -Title "Select server:"
Note the importance of the passthru option. If you don't set it, there won't be an option to actually select the server you need, it will just display all the AD computers.
How to Determine the Installed Oracle Version Including Patches on AIX
Summary: How to Determine the Installed Oracle Version Including Patches on AIX.
Date: Around 2013
Refactor: 8 March 2025: Checked links and formatting.
On AIX, login as the oracle user and change directory to the ORACLE_HOME/OPatch (Note: OP are in capital) directory:
cd $ORACLE_HOME/OPatch
Then issue the opatch lsinventory command. I use these options:
- all (will check all oracle installations in ORACLE_HOME)
- invPtrLoc (provides the file location of oraInst.loc, which will provide the oracle inventory location)
bash-3.00$ opatch lsinventory -all -invPtrLoc ../oraInst.loc Invoking OPatch 10.2.0.4.3 Oracle Interim Patch Installer version 10.2.0.4.3 Copyright (c) 2007, Oracle Corporation. All rights reserved. Oracle Home : /opt/oracle/product/10.2 Central Inventory : /opt/oracle/oraInventory from : ../oraInst.loc OPatch version : 10.2.0.4.3 OUI version : 10.2.0.4.0 OUI location : /opt/oracle/product/10.2/oui Log file location : /opt/oracle/product/10.2/cfgtoollogs/opatch/opatch2010-09-16_11-41-52AM.log Lsinventory Output file location : /opt/oracle/product/10.2/cfgtoollogs/opatch/lsinv/lsinventory2010-09-16_11-41-52AM.txt -------------------------------------------------------------------------------- List of Oracle Homes: Name Location OUIHome1 /opt/oracle/product/10.2 Installed Top-level Products (2): Oracle Database 10g 10.2.0.1.0 Oracle Database 10g Release 2 Patch Set 3 10.2.0.4.0 There are 2 products installed in this Oracle Home. There are no Interim patches installed in this Oracle Home. -------------------------------------------------------------------------------- OPatch succeeded.
Oracle User Management
Summary: How to manage user accounts in Oracle.
Date: Around 2013
Refactor: 8 March 2025: Checked links and formatting.
The listed commands assume you're logged into the system as the oracle owner user, this way you don't have to provide the password when connecting to the database.