Set up OS-specific resources (like shared memory).

Extract all the Disk* files somewhere:
    mkdir /tmp/odisks
    cd /tmp/odisks
    gunzip -c /tmp/lnx*disk1* | cpio -ivdm
    gunzip -c /tmp/lnx*disk2* | cpio -ivdm
    gunzip -c /tmp/lnx*disk3* | cpio -ivdm

Make users and groups
    groupadd -g 1601 oinstall  # ORAINVENTORY group
    groupadd -g 1602 dba       # OSDBA and OSOPER group
    useradd -c Oracle -g oinstall -G oracle,dba -d /usr/local/oracle -m oracle


################################################
Install glibc-devel and old gcc.  See
/home/blaine/html/install_ora9_suse.html
################################################

Create Inventory and Oracle Home directories, e.g.
    mkdir /usr/local/oraInventory /usr/local/orahome1 /usr/local/oradata
    chown oracle:oinstall /usr/local/oraInventory /usr/local/orahome1...
(Note that oraInventory will hold < 10M.  Registry-like stuff.)

Run path/to/Disk1/runInstaller as user 'oracle'.  
You may want to export the variable ORACLE_HOME to your target directory
before you start.
Set ORACLE_BASE! because it writes dbca stuff to $ORACLE_BASE/oradata.
Specify the install directories that you want to use.  Otherwise, use 
defaults other than directions below.
    UNIX Group Name: oinstall
    "Database" will give you the client too.
    "Custom"
    Select following components:   WILL THIS GIVE ME OLTP???
        Oracle9i
        Oracle Net Services / Oracle Net Listener
        Oracle9i for UNIX Documentation
        Oracle JDBC/OCI Interfaces
    Create Database?  No

    ###########
    Now Net Config Assist. and Agent Config. Assist. fail with JRE 1.1.8 
     libc failures.  Just continuing.
    I think the errors below don't happen with newer version, or with
    my workarounds noted elsewhere:
    Link stage will fail with makefile ins_ctx.mk.  Leave the gui running and
    (if it lets you.  Once I could only close the error message Window).
         Edit the file $ORACLE_HOME/ctx/lib/ins_ctx.mk.  Edit the line ^setup.
         Remove "ictxhx".
         Then tell the error window to retry.  It should now succeed.
    Configuration Tools will stop with errors.
        Cd to $ORACLE_HOME/oracle.swd.jre/bin/i386/native_threads and
        ln -s java jre
        Then, in the error window, click on each tool in turn and click Retry
        if it lets you.  Once I had to kill the whole program here because
        it got stuck.  If so, you will have to copy listener.ora and
        tnsnames.ora from $ORACLE_HOME/network/config/samples to
        $ORACLE_HOME/network/config.
    Oracle Net Configuration Assistant.
        On 2nd or 3rd screen, pick "No, I want to defer this configuration..."
        and Next.
    ###########

Run "dbca" to create a database.
IMPORTANT!!  Don't create spfile!  This way, it will use good-old init.ora file.
    template: "New Database"
    Global name: gdn1.nextel.com
    SID: sidGdn1
    De-select Oracle Ultra Search
    De-select all example schemas, unless you want them.
        MEMORY: I custom size like this: 32 / 24 / 32 / 8 / 24
        DB DSIZING: Sort Area Size: 256000
    Password must start with a letter (not digit)

export ORACLE_SID=sidGdn1
pupbld
helpins

Run sqlplus as system/systempwd
    create user x identified by "password" default tablespace users;
    grant connect, resource to x;
[And if you want this user to have access to the demo data...
    grant select on hr.countries to x;
 (ditto for tables departments, employees, jobs, job_history,
  locations, regions; ditto for update if you want that).

[Note that there are sample files for listener.ora and tnsnames.ora in
 $ORACLE_HOME/network/admin/samples.  I had to use those because the
 installer did not install these files into .../admin.]
Add an entry for the new SID in $ORACLE_HOME/network/admin/listener.ora.
Start the listener.
    LD_LIBRARY_PATH=$ORACLE_HOME/lib lsnrctl start listener

Edit $ORACLE_HOME/network/admin/tnsnames.ora to add a connect string.
Sample tnsnames.ora that works:
    g1= (DESCRIPTION= (ADDRESS= (PROTOCOL=tcp) (HOST=localhost) (PORT=1521))
	        (CONNECT_DATA= (SID=sidGdn1))
	    )

If network access doesn't work, it's probably a client-side problem.
Verify that TNSNAMES is in use (See $ORACLE_HOME/network/admin/sqlnet.ora
or/and run netca).  I don't know why anybody would want to use a domain 
with their connect string, since the connect strings are 100% locally 
defined, but that's how Oracle sets things up by default.
If there is a connect string default domain set in sqlnet.ora 
(parameter NAMES.DEFAULT_DOMAIN), then the connect strings in tnsnames.ora
must specify that domain.  I recommend commenting out NAMES.DEFAULT_DOMAIN
and just forget about connect string domains forever.  This is a
client-side issue only, since the domains don't appear in listener.ora.

TEST
Local SQL*Plus (using $ORACLE_HOME and ORACLE_SID)
   As any user, export $ORACLE_HOME and $ORACLE_SID, add $ORACLE_HOME/bin 
   to search path,
   Run "LD_LIBRARY_PATH=$ORACLE_HOME/lib sqlplus a_oracle_uname/the_password".
Network SQL*Plus
   Run "LD_LIBRARY_PATH=$ORACLE_HOME/lib sqlplus a_oracle_uname/the_password@connstring" (using the connstring
    that you defined in tnsnames.ora).
Run a Java program using an oracle JDBC driver.
   javac -classpath .:$ORACLE_HOME/jdbc/lib/classes12.zip Your/Dir/Prog.java
   java -cp .:$ORACLE_HOME/jdbc/lib/classes12.zip Your.Dir.Prog

run "sqlplus /nolog" to configure/start/stop, etc.  Once inside sqlplus, run
    connect as sysoper (give user "system" and no password at all).
At that point you can startup or shutdown (and do lotsa other useful stuff).


To shutdown, use the sqlplus /nolog as explained above.
To shutdown the network listener, run
    LD_LIBRARY_PATH=$ORACLE_HOME/lib lsnrctl stop listener


Mon Mar 21 12:37:15 EST 2005 Oracle 10g CLIENT install
Make groups oinstall, dba, oracle.  Make first oracle's primary group, others
 oracle's secondary groups.
Do NOT need gui for root setup parts
    Set TEMP, TMPDIR to /tmp
    Set ORACLE_BASE to new Oracle Home
        (makes oraInventory subdirectory here)
Set up a gui environment for oracle
    Fucking gui keeps stealing focus!
    Set OUIHome1 to new Oracle Home (suggests a subdirectory)
    Choose Installation Type of "Runtime" (356M)

"Twelve schemas make up the Oracle9i sample schema collection:
    hr oe pm sh qs qs_adm qs_cb qs_cbadm qs_cs qs_es qs_os qs_ws 
(http://www.oracle.com/technology/oramag/oracle/02-jul/o42schema.html)

ACCOUNTS CREATED BY DEFAULT:  * = don't drop!,  x = Axe
(Extra accounts are samples + Data Mining + Time Series + Spatial + UltraSearch
  9i Workspace Manager + OLAP)
x   ANONYMOUS  Http access to XML data   ***
    CTXSYS (for ConText cartridge)
x   DBSNMP                               ***
x   HR
x   MDSYS
x   ODM
x   ODM_MTR
x   OE
x   ORDPLUGINS
x   ORDSYS
    *OUTLN
x   PM
x   QS
x   QS_ADM
x   QS_CB
x   QS_CBADM
x   QS_CS
x   QS_ES
x   QS_OS
x   QS_WS
    *RMAN
x   SCOTT
x   SH
x   WKPROXY
x   WKSYS
x   WMSYS                    *** ???
    XDB (for XML)
x   CWMLITE (I think this is an OLAP sample schema)
(leave TRACESVR if present)
http://www.idevelopment.info/data/Oracle/DBA_tips/Database_Administration/DBA_26.shtml

*** These 3 accounts are created by a base install adding only XML and
context server add-ons.  Safe to remove these accounts afterwards.


---------------
Sun Apr  8 22:23:50 EDT 2007 install onto Suse 10.
Had to edit install/.oinst to add Suse10 and Suse10Optional stanza.
UNIX oracle passwd: 0rac3
starter DB global db name: gdnO1
passwords for SYS, SYSTEM, YSSMAN, DBSNMP:  intpwd
Installation destination name: OraDb10g_home1  (/opt/oracle/10ghome)
Install log: /opt/oracle/10g-inv/logs/installActions2007-04-08_10-30-29PM.log
Had to install gcc.
Had to install glibc-devel-32bit>
gettext-devl (which also installed libstdc++-devel
glibc-obsolete
I FUCKING GIVE UP.  It will not link with current libraries.
Need all these obsolete fucking libraries.