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.

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.

This wiki has been made possible by:

2025/06/01 11:59

oracle

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.

→ Read more...

2025/06/01 11:59

oracle

AIX LDAP authentication on eDirectory

Summary: ALthough AIX is by now on version 7.3 I find these old pages so fascinating I decided to keep them. On this page I'll show you how to configure AIX if you need authentication from eDirectory. This page is for AIX 5.3.
Date: Between 2010-2013
Refactor: 21 December 2024: Checked formatting.

This is a tutorial on how to setup AIX local authentication through LDAP on eDirectory. The version eDirectory that is being used is 8.8.4 which is installed on a NetWare 6.5 SP8 server. This server is for testing purposes and installed with NetWare 6.5 SP 8. The AIX version being used is 5.3 TL 6 FP 7 (5300-06-07-0818). This server is also for testing purposes but (because it's a POWER architecture based OS) can't run inside VMware and is running as a LPAR inside the production network. To be able to use the LDAP from the NetWare server I had to use port forwarding inside vmware and add a static route in AIX.

NOTE: During testing I had to change the NetWare test server for a NetWare production server. I found out you need to LUM enable users which is not so easy on a NetWare only environment. In my production environment the schema was already extended with the correct schema.

See AIX Info for more information about static routes on AIX. See VMware Cheatsheet for more information about port forwarding in VMware Server.
The steps taken are: