How to install, patch and interim

Install Oracle Db 10g on Linux: 
http://www.oracle.com/technology/pub/articles/smiley_10gdb_install.html
    
See Create an Oracle database instance, How to create a database, RedHat Linux & Oracle 10g, OPatch and RDA
Inventory
I recommend to always specify the inventory location using the parameter "-invPtrLoc ./oraInst.loc" when running the runInstaller,
opatch, and so on.

oraInst.loc and oratab - default location is /var/opt/oracle

Re/Create the inventory
--Rename folders currently containing the inventory
./runInstaller -silent -attachHome -invPtrLoc ./oraInst.loc ORACLE_HOME="/app/oracle/product/10.2.0" ORACLE_HOME_NAME="OraHome10g"

 


    
Is my Oracle running 32 bit or 64 bit?
cd $ORACLE_HOME/bin
file oracle
uname -m (Linux)

oracle:         ELF 64-bit MSB executable SPARCV9 Version 1, dynamically linked, not stripped
or
oracle:         ELF 32-bit MSB executable SPARC Version 1, dynamically linked, not stripped

You may also issue a:
select * from v$version
but sometime shows nothing

Migrate from 32 bit to 64 bit
note 62290.1
Migrate from Windows(32) to Linux(32)
note 414878.1

 

Verify OS before installing
Download RDA, see OPatch and RDA
./rda.sh -T hcve

Old way
Note:169706.1
Note:189256.1
oracle/database/InstallPrep_v030406.zip

 

10g, manual install HR Sample Schema
Download 10g companion cd for version 10.1.0.2

cd C:\Downloads\Disk1\stage\Components\oracle.demo.common_schema\10.1.0.2.0\1\DataFiles
uncompress on same folder demo.1.1.jar and hr.jar

sql>@hr_main

 

How to download less known products
Oracle Universal Installer can be downloaded through metalink as product Universal Installer
Analytic Workspace Manager: http://download.oracle.com/otn/java/olap/AWM_102010A_Win32.zip

 

Have a detailed list of version, patches and interims

Install the opatch if not present

Set the ORACLE_HOME variable if it is not
	On windows you may run
	>set ORACLE_HOME=D:\oracle\ora92
Set the INVENTORY_LOC variable if it is not, you may look in \\HKEY_LOCAL_MACHINE\Software\Oracle\inst_loc
	set INVENTORY_LOC=C:\Programmi\Oracle\Inventory

>opatch lsinventory -detail

select * from v$option

 

Client
9i
SQL Loader in Database Utilities
ProC in Oracle Programmer

How to make software accessible and usable to all users
$ORACLE_HOME/install/changePerm.sh
#or, unsupported:
chmod 755 $ORACLE_HOME