Installing Oracle 8.1.7
=======================

1.Check the /etc/system file and have the following semaphores setup:

  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=400
  set semsys:seminfo_semopm=100
  set semsys:seminfo_semvmx=32767

2.Save the file and reboot 

3.Create the Solaris Group account oinstall (primary) 

4.Create the Solaris Group Account dba (secondary) 

5.Create an Oracle User Account: oracle 

6.Set /export/home/oracle as the primary home directory of oracle user. 

7.Set the following environmental startup values for oracle:

  ORACLE_SID=dskorcl
  ORACLE_HOME=/opt/oracle/product/8.1.7
  ORACLE_BASE=/opt/oracle
  NLS_LANG=AMERICAN_AMERICA.UTF8

  Make sure the following directories are in the PATH
  /usr/xpg4/bin
  $ORACLE_HOME/bin,/usr/bin,
  /etc,/usr/ccs/bin,/usr/openwin/bin,/usr/local/bin (/usr/ucb should come
  after /usr/ccs/bin). 

8. Login as oracle.

9.  cd /cdrom/cdrom0.

10.Run the Install Script (runInstall) 

11.Set the group name to oinstall 

12.Select Typical Install of the Oracle Database Server 

13.Global Database Name:  dskorcl.dswkim.org

14.Oracle SID: dskorcl

15.Oracle Data: /opt/oracle/database (This should be another mounted filesystem) 

16.Important users and passwords to remember:

   user: SYS, pass: change_on_install
   user: SYSTEM, pass: manager 


Steps to create tablespaces manually:
Create the Content Server Table Space for ftuser (note:
/opt/oracledata/oradata/vignette is the database instance for this, please refer
                               to the name you have created).

1./opt/oracle/product/8.1.7/bin/sqlplus 
2.Use sqlplus, login as system: password manager 
3.create tablespace dskorcl_data datafile
  '/opt/oracle/oradata/oradata/wlspoc5/dskorcl_data01.dbf' size 300M; 
4.create tablespace dskorcl_temp datafile
  '/opt/oracle/oradata/oradata/wlspoc5/dskorcl_temp01.dbf' size 100M; 
5.create user ewirelessidentified by ewirelessdefault tablespace dskorcl_data
  temporary tablespace dskorcl_temp; 
6.grant connect,resource to ewireless; 

To start the database

  1.svrmgrl 
  2.connect internal 
  3.startup/shutdown 

Modify the file tnsnames.ora ($ORACLE_BASE/product/8.1.7/network/admin)
  Copy the WLSORA template and add DSKORCL = (Beginning) and
  SERVICE_NAME=dskorcl.dswkim.org