INSTALL ORACLE 9.0.1 (SUN Solaris) I-300
SYSADMIN PRE-INSTALLATION
1) If using Veritas file system, confirm VxFS configured. The list of Veritas programs installed can be checked with pkginfo: pkginfo | grep VRTS
2) Confirm 2.5 gigabytes disk for oracle rdbms software is available, plus 1 gb for sample database.
3) Update IPC kernel parameters to following typical values:
SHMMAX 1 Gigabyte [on Solaris, units are bytes; sets potential memory available]
SHMMNI 400
SHMSEG 108
SEMMNS 6640
SEMMNI 3320
SEMMSL 1000
SEMOPM 100
SEMVMX 32767
3) Confirm: make utility is installed. Be aware that the DBA will be using xwindows to access server.
4) Confirm OS patches are installed.
5) Confirm swap space at least 2x physical RAM and /tmp > 400 mb (needed by installer).
6) Confirm large file system (> 2 GB) is enabled.
7) Create groups oper, dba, oinstall
8) Set-up 'oracle' account with default korn (/ksh) shell. Specify primary group oinstall.
9) Set ulimit for oracle and root users to allow unlimited file size.
10) Verify usr/local/bin exists. Verify that /tmp is writeable by the oracle user.
11) In etc/services file, add entry: Oracle 9i listener 1521/tcp.
12) Create directory (owned by oracle) for oracle executables—e.g., /u01/app/oracle.
13) Ensure that the oracle user will be able to create a subdirectory under the various database filesystems--/u02, /u03, etc.
14) Create directory (owned by oracle) to hold exports or other backups—e.g., /exim
15) Execute chmod 755 on these subdirectories, so that they are executable by all. Allow setuid and set groupid for filesystem (e.g., /u01) where oracle is installed.
16) Mount oracle cdrom. Installer will first use CDROM with ‘runInstaller’ program.
ORACLE DBA PRELIMINARY
1) Confirm that oracle user can write to mount points (e.g., /u02, /u03, etc.)
2) Check "readme" file on CDROM for last-minutes changes or patches required.
3) Note that x-windows workstation is used for Oracle 8i installation. (Note: Oracle suggests Exceed be set to ‘native’ windows mode (xconfig/Screen Definition—set multiple windows).
4) If F-Secure SSH utility is used, configure for X-windows as follows: Start F-Secure. At Connect window, select Properties then Connection. Check box: Forward X11. Then select Apply then Ok.
5) [optional] To avoid warnings about fonts, ensure that the X11 font set is available. If using network font server, client must be setup as “Font Client.”
In Windows (not Exceed), open Exceed Xconfig. Select Fonts then Font Database.
Select font server desired then select Add.
Close all Xconfig windows. Fonts will be available to client when Exceed is restarted.
6) Create the .profile file in the oracle account with the following entries:
export ORACLE_TERM=vt220
export ORACLE_BASE =/u00/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/9.0.1
export ORACLE_SID=editest [insert actual instance name]
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export PATH=/usr/ccs/bin:/usr/local/bin:$ORACLE_HOME/bin:/usr/openwin/bin/:$PATH
export SHLIB_PATH=$ORACLE_HOME/lib
export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/product/jlib
stty kill '^' [in case '@' is set to the 'kill line' command]
umask 022
stty erase ^H
set -o vi
7) Confirm unlimited file size and memory privilege with ulimit -Sa and ulimit -Ha.
8) Exceed may be used in several ways:
Exceed Passive mode: Start Exceed. If Display Manager opens, select Passive.
Non-Passive mode: Start Exceed and open Exceed x-windows shell.
ORACLE DBA: INSTALLATION
1) As Oracle user, confirm x-windows running and env variables are set.
2) Set up display as follows (not necessary if F-Secure with X11 Forwarding is used).
export DISPLAY=[workstation-name]:0.0 then xhost +[server-name]
3) Activate the OUI (Oracle Universal Installer) as follows:
cd /SD_CDROM then ./runInstaller [1 min wait]
4) In "Welcome" window, select Next to proceed.
5) File Locations: Confirm path to cdrom and oracle executables, then select Next (typically just accept the listed values). The Installer will now load “Product Information.” [1 minute delay].
6) Available Products: Select Oracle Enterprise Edition 9.0.1, then next. On next screen, select Enterprise Edition, then next [a few minute delay].
7) Database Configure: Select “General Purpose” (or Software only for no sample database).
8) Enter group to use for sysdba and sysoper (default of oinstall works ok).
9) Upgrading or Migrating an Existing Database: Check if migration desired.
10) Database Identification: Enter SID & global database name – e.g, prod1.digitalthink.com.
11) When prompted, enter path for database files.
12) Database Character Set: Typically, select Unicode (UTF8).
13) Installer will now show “Summary screen.” Review then select Install (wait 30 sec). Installation/linking will now proceed [delay 1 hour].
14) When prompted, specify location for for 2nd and 3rd CDROMs.
15) When prompted to run root.sh, request Sysadmin to run script $ORACLE_HOME/root.sh.
16) Installer will run Net Config Asst, WebServer Config Asst, and Database Config Asst.
17) Password Management: Acknowledge” window and (optionally) unlock accounts.
18) [optional] Change primary group of oracle user to dba.
19) Update script dbshut to use shutdown immediate, rather than shutdown normal.
Cwl 08/21/01