Zurück

Short Guide to install Oracle 8.1.7 on SUN Solaris 2.6, 7, 8


The following, short Installation Guide shows how to install Oracle 8.1.7 for SUN Solaris 2.6 / 2.7. You may download our scripts to create a database, we suggest this way and NOT using DBASSIST. Use DBASSIST only to generate a template script, because some important INITSID.ora values are wrong and may lead to a poorly tuned database. Besides this scripts, you can download our NET8 configuration files TNSNAMES.ORA. LISTENER.ORA and SQLNET.ORA.

For our installation, we used the following ORACLE_HOME and ORACLE_SID, please adjust these parameters for your own environment.

ORACLE_HOME = /opt/oracle/product/8.1.7
ORACLE_SID = DIA2


Check Hardware Requirements

Minimal Memory: 256 MB
Minimal Swap Space: Twice the amount of the RAM

To determine the amount of RAM memory installed on your system, enter the following command.

$ /usr/sbin/prtconf

To determine the amount of SWAP installed on your system, enter the following command and multiply the BLOCKS column by 512.

Use the latest kernel patch from Sun Microsystems (http://sunsolve.sun.com)

Operating System Software Requirements

Use the latest kernel patch from Sun Microsystems. Solaris 2.6 requires at least kernel jumbo patch revision #105181-15 for successful installation of Release 2 (8.1.7).

- Download the Patch from: http://sunsolve.sun.com
- Read the README File included in the Patch
- Usually the only thing you have to do is:

$ cd <patch cluster directory>
$ ./install_custer
$ cat /var/sadm/install_data/<luster name>_log
$ showrev -p

Reboot the system

To determine your current operating system information:

$ uname -a

To determine which operating system patches are installed:

$ showrev -p

To determine which operating system packages are installed:

$ pkginfo -i [package_name]

To determine if your X-windows system is working properly on your local system, but you can redirect the X-windows output to another system.

$ xclock

To determine if you are using the correct system executables:

$ /usr/bin/which make
$ /usr/bin/which ar
$ /usr/bin/which ld
$ /usr/bin/which nm

Each of the four commands above should point to the /usr/ccs/bin directory. If not, add /usr/ccs/bin to the beginning of the PATH environment variable in the current shell.

Java Runtime Environment (JRE)

The JRE shipped with Oracle8i is used by Oracle Java applications such as the Oracle Universal Installer is the only one supported. You should not modify this JRE, unless it is done through a patch provided by Oracle Support Services. The inventory can contain multiple versions of the JRE, each of which can be used by one or more products or releases. The Installer creates the oraInventory directory the first time it is run to keep an inventory of products that it installs on your system as well as other installation information. The location of oraInventory is defined in /var/opt/oracle/oraInst.loc. Products in an ORACLE_HOME access the JRE through a symbolic link in $ORACLE_HOME/JRE to the actual location of a JRE within the inventory. You should not modify the symbolic link.

The Solaris 2.6 following patches are required or recommended for JRE 1.1.8_10

Patch ID

Description

Required or Recommended? 

106040-11

X Input and Output Method patch

Required (OK)

105181-15

Kernel patch

Required (OK)

105284-25

Motif Runtime Library Patch

Recommended (OK)

105490-07

Dynamic linker patch

Recommended (OK)

105633-21

OpenWindows 3.6: Xsun patch (1)

Recommended (OK)

105568-13

Libthread patch

Recommended (OK)

105210-19

LibC patch

Recommended (OK)

105669-07

CDE 1.2: libDTSvc patch (dtmail)

Recommended (OK)

107636-01

X Input and Output Method patch

Required

106980-05

Libthread patch

Recommended

107607-01

Motif fontlist, fontset, libxm

Recommended

107078-10

Open Windows 3.6.1 Xsun patch (1)

Recommended

Check Software Limits

Oracle8i Release 3 (8.1.7) includes native support for files greater than 2 GB. Check your shell to determine whether it will impose a limit.

To check current soft shell limits, enter the following command:

$ ulimit -Sa

To check maximum hard limits, enter the following command:

$ ulimit -Ha

The file (blocks) value should be multiplied by 512 to obtain the maximum file size imposed by the shell. A value of unlimited is the operating system default and is the maximum value of 1 TB.

Setup the Solaris Kernel

Set to the sum of the PROCESSES parameter for each Oracle database, adding the largest one twice, then add an additional 10 for each database. For example, consider a system that has three Oracle instances with the PROCESSES parameter in their initsid.ora files set to the following values:

ORACLE_SID=DIA1, PROCESSES=100
ORACLE_SID=DIA2, PROCESSES=100
ORACLE_SID=DIA3, PROCESSES=200

The value of SEMMNS is calculated as follows:

SEMMNS = [(A=100) + (B=100)] + [(C=200) * 2] + [(# of instances=3) * 10] = 630

Setting parameters too high for the operating system can prevent the machine from booting up. Refer to Sun Microsystems Sun SPARC Solaris system administration documentation for parameter limits.

*
* Kernel Parameters on our SUN Enterprise with 640MB for Oracle 8.1.x
*
set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=10
set semsys:seminfo_semmni=100
set semsys:seminfo_semmsl=100
set semsys:seminfo_semmns=2500
set semsys:seminfo_semopm=100
set semsys:seminfo_semvmx=32767

Create Unix Group «dba»

$ groupadd -g 400 dba
$ groupdel dba

Create Unix User «oracle»

$ useradd -u 400 -c "Oracle Owner" -d /export/home/oracle \
  -g "dba" -m -s /bin/ksh oracle

Setup ORACLE environment ($HOME/.profile) as follows

# Setup ORACLE environment

ORACLE_HOME=/opt/oracle/product/8.1.7; export ORACLE_HOME
ORACLE_SID=DIA2; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
TNS_ADMIN=/export/home/oracle/config/8.1.7; export TNS_ADMIN
NLS_LANG=AMERICAN_AMERICA.UTF8; export NLS_LANG
ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data; export ORA_NLS33
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/openwin/lib
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/dt/lib:/usr/ucblib:/usr/local/lib
export LD_LIBRARY_PATH

# Set up the search paths:

PATH=/bin:/usr/bin:/usr/sbin:/opt/bin:/usr/ccs/bin:/opt/local/GNU/bin
PATH=$PATH:/opt/local/bin:/opt/NSCPnav/bin:$ORACLE_HOME/bin
PATH=$PATH:/usr/local/samba/bin:/usr/ucb:.
export PATH

# CLASSPATH must include the following JRE location(s):

CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
CLASSPATH=$CLASSPATH:$ORACLE_HOME/network/jlib

Install from CD-ROM

Usually the CD-ROM will be mounted automatically by the Solaris Volume Manager, if not, do it as follows as user root.

$ su root
$ mkdir /cdrom
$ mount -r -F hsfs /dev/.... /cdrom

exit or CTRL-D

Check oraInst.loc File

If you used Oracle 8.1.x before on your system, then you must edit the Oracle Inventory File, usually located in: 
/var/opt/oracle/oraInst.loc

inventory_loc=/opt/oracle/product/8.1.7/oraInventory

Install with Installer

Install Oracle 8i with customized Response File: svrtypical.rsp as User «oracle». We suggest to start runInstaller in the foreground, therefore remove the "&" from runInstaller at the end of the file.

$ cd /cdrom/oracle8i
$ DISPLAY=<Any X-Window Host>:0.0
$ export DISPLAY
$ ./runInstaller

A configuration script needs to be run as root before installation can proceed. Please leave this window up, go run /opt/oracle/product/8.1.7/root.sh as root from another window, then come back here and click OK to continue.The installation of Oracle8i Enterprise Edition was successful.

Start root.sh as «root»

Start the script root.sh as User «root». Note that the File /var/opt/oracle/oratab is not used in the High Availabilty Environment.

$ su root
$ cd $ORACLE_HOME
$ ./root.sh

 Setup Listener for Oracle8.1.7

Create the necessary log- and config directories. Set ORACLE_HOME to the new location. Setup the Net8 Files: listener.ora, tnsnames.ora and sqlnet.ora.

$ cd $ORACLE_HOME
$ mkdir sqlnet
$ cd sqlnet
$ mkdir config log
$ cd config

Start / Stop and check the listener

It is very important that the listener works correctly.

$ lsnrctl
LSNRCTL> start LSNRDIA2
LSNRCTL> service LSNRDIA2

Check that listener starts without an error, check that listener is running.

$ ps -ef | grep tns

Install current patches

Download patchsets from:

ftp://oracle-ftp.oracle.com/server/patchsets/unix/SUN_SOLARIS2/81patchsets

Read the patch_note.htm file to install the patch.

Create the Database

Edit and save the CREATE DATABASE File initDIA2.sql in $ORACLE_HOME/dbs, or create a symbolic-Link from $ORACLE_HOME/dbs to your Location.

initDIA2.ora -> /export/home/oracle/config/8.1.7/initDIA2.ora

$ svrmgrl
SVRMGR> @initDIA2.sql

Check the Logfile, then stop and start the Database

$ svrmgrl
SVRMGR> @shutdown immediate
SVRMGR> startup

Create own DB-Create Script (optional)

You can generate your own DB-Create Script using the Tool: $ORACLE_HOME/bin/dbassist.

To start the Database automatically on Boot-Time, create or use our Startup Scripts dbora and lsnrora (included in ALL_FILES.tar.gz), which must be installed in /etc/init.d. Create symbolic Links from the Startup Directories in /etc (e.g. /etc/rc2.d).

lrwxrwxrwx 1 root root S99dbora -> ../init.d/dbora
lrwxrwxrwx 1 root root S99lsnrora -> ../init.d/lsnrora

Download Scripts for Sun Solaris

These Scripts can be used as Templates. Please note, that some Parameters like ORACLE_HOME, ORACLE_SID and PATH must be adjusted on your own Environment. Besides this, you should check the initSID.ora Parameters for your Database (Size, Archivelog, ...)

Version 7.3.4

init<SID>.ora (DB Parameter File)

dbora (DB Startup File)

init<SID>.sql (Create Database Script)

lsnrora (Listener Startup File)

listener.ora (Listener Configuration

dbstart.sh (DB Startup Script)

tnsnames.ora (SQL*Net Connect Strings)

dbshut.sh (DB Shutdown Script)

Download all Files (ALL_FILES.tar.gz)

 

Version 8.1.5

init<SID>.ora (DB Parameter File)

dbora (DB Startup File)

init<SID>.sql (Create Database Script)

lsnrora (Listener Startup File)

listener.ora (Listener Configuration

dbstart.sh (DB Startup Script)

tnsnames.ora (Net-8 Connect Strings)

dbshut.sh (DB Shutdown Script)

sqlnet.ora (Net-8 Client Configuration)

Download all Files (ALL_FILES.tar.gz)

Version 8.1.6

init<SID>.ora (DB Parameter File)

 

init<SID>.sql (Create Database Script)

dbora (DB Startup File)

listener.ora (Listener Configuration

lsnrora (Listener Startup File)

tnsnames.ora (Net-8 Connect Strings)

dbstart.sh (DB Startup Script)

sqlnet.ora (Net-8 Client Configuration)

dbshut.sh (DB Shutdown Script)

Download all Files
(ALL_FILES.tar.gz)

Oracle Installation Guide (PDF)
Oracle Administration Guide (PDF)
Version 8.1.7

init<SID>.ora (DB Parameter File)

dbora (DB Startup File)

init<SID>.sql (Create Database Script)

lsnrora (Listener Startup File)

listener.ora (Listener Configuration

dbstart.sh (DB Startup Script)

tnsnames.ora (Net-8 Connect Strings)

dbshut.sh (DB Shutdown Script)

sqlnet.ora (Net-8 Client Configuration)

Download all Files (ALL_FILES.tar.gz)