Installation of oracle817 under SOLAIRS8

Oracle
First, the preparation before installation

1, the task performed by root (log in with root user)

1.1 Setting System Variables

1 using a text editor to open the "/etc/system" file

# Vi/etc/system

2 Insert the following lines at the end of the "/etc/system" file

Set shmsys:shminfo_shmmax=4294967295
Set Shmsys:shminfo_shmmin=1
Set shmsys:shminfo_shmmni=512
Set shmsys:shminfo_shmseg=128

Set semsys:seminfo_semmap=64
Set semsys:seminfo_semmni=4096
Set semsys:seminfo_semmns=4096
Set semsys:seminfo_semmsl=4096
Set semsys:seminfo_semmnu=4096
Set semsys:seminfo_semume=64
Set semsys:seminfo_semopm=100


Note:
SHMMAX maximum size of a shared memory segment
(Maximum number of bytes in shared memory segment)
Shmmin minimum size of shared memory segment
(minimum size of shared memory segment)
Shmmni maximum number of shared memory identifiers in the system
(Maximum number of shared memory identifiers in the system)
SHMSEG maximum number of shared memory segments a user process can attach
(The maximum number of shared memory segments that can be allocated per user process)
Semmni Maximum number of semaphore identifiers in the system
(Maximum number of semaphore identifiers in the system)
SEMMSL Maximum number of semaphores in a set
(Maximum number of semaphores in each (semaphore) collection)
Semmns Maximum number of semaphores in the system
(Maximum number of semaphores in the system)
SEMOPM maximum number of operations per SEMOP call
(Maximum number of semaphores per SEMOP call)
SEMVMX Semaphore Maximum Value
(maximum value of semaphore)

Attention!
The SEMMSL and Semmns values mentioned above apply only to the initial installation, which should be adjusted according to the actual application after the installation is completed.

★SEMMSL values can be computed in the following ways:
The largest processes value in the "Init[sid].ora" file for all Oracle instances + 10

★semmns values can be computed in the following ways:
The sum of the processes values in the "Init[sid].ora" file of each Oracle instance in the system (excluding the largest processes value) + The maximum processes value of * 2 + * Oracle instance number.

Note: [SID] is the specific database instance name

For example, a system with three Oracle instances has the processes parameter in its respective "Initsid.ora" file set to the following values:
Oracle_sid=a, processes=100
Oracle_sid=b, processes=100
Oracle_sid=c, processes=200

The SEMMSL value is calculated as follows:
SEMMSL = [(c=200) + 10] = 210
The Semmns value is calculated as follows:
Semmns = [(a=100) + (b=100)] + [(c=200) * 2] + [(# of Instances=3) * 10] = 630

For the operating system, setting a high parameter value can cause the machine to fail to start, and for parameter restrictions, refer to the Sun SPARC Solaris System Administration documentation.

3 Reboot the system for the new kernel parameters to take effect
# Sync;sync;reboot

4 after the system restarts, you can check the values of "Maximum shared Memory" and "Minimum shared Memory" ("Shared Memory area" at the bottom of the list) by using the Sysdef command.
# Sysdef


1.2 Set up group, user and related catalogue

1 Create a "DBA" and "Oinstall" group, add a user named "Oracle" and set a password for it
# Groupadd DBA
# Groupadd Oinstall (optional)
# useradd-g dba-g oinstall-d/export/home/oracle-m-s/bin/sh Oracle
# passwd Oracle

The above operations can also be implemented through Admintool management tools.
# Admintool

2) Create the related directory
# mkdir-p/u01/oracle/product/8.1.7
# Chown-r Oracle:dba/u01/oracle
# Chmod-r 775/u01/oracle
# mkdir/var/opt/oracle
# Chown-r Oracle:dba/var/opt/oracle



2. Tasks performed by Oracle user

1 exit root login and login with Oracle user previously created

2 Modify the Oracle user's ". Profile" configuration file
I don't know. Profile this file, but it can be generated by local.profile this template file under Oracle User. Profile This file

# MV Local.profile. Profile

#vi. Profile

Add the following content
display=192.168.0.28:0.0
Oracle_base=/u01/oracle
oracle_home=/u01/oracle/product/8.1.7
Oracle_sid=oracle8
ora_nls33= $ORACLE _home/ocommon/nls/admin/data
Classpath= $ORACLE _home/jre/lib: $ORACLE _home/jlib: $ORACLE _home/product/jlib: $ORACLE _home/network/jlib: $ORACLE _ Home/rdbms/jlib
Ld_library_path= $ORACLE _home/lib:/lib:/usr/lib
Nls_lang=american_america. Zhs16gbk
Path=/usr/bin:/usr/ucb:/etc:/usr/local/bin:/usr/ccs/bin:/usr/openwin/bin
Path= $ORACLE _home/bin: $PATH
Export PATH
Export DISPLAY oracle_home oracle_base oracle_sid ora_nls33 ld_library_path Nls_lang CLASSPATH
3 The Oracle user logs on again so that the previously modified ". Profile" file Configuration takes effect

4) through the ENV command to check if the configuration is effective
$ env

5 Enter the directory where the Oracle installation files are located and start the installation
(Assuming that the oracle817 installation file exists in "/export/home/oracle/ora817/disk1")

$ cd/export/home/oracle/ora817/disk1
$./runinstaller

Note: 1, the download of Oracle Cpio file to unlock the method is: CPIO-IDCMV < <filename.cpio>.

2, in the installation process, when prompted to run the root.sh ($ORACLE _home/root.sh) script, to manually open a new console (console) as root user execution.

3, such as the installation completed after the initialization of the database process encountered Ora-03114:not connected to ORACLE errors, it should be appropriate to increase the number of SEMMSL, Semmns and other parameters.

6 after the installation of the simple test

The default is already an Oracle user login, executing lsnrctl start to start Oracle LISTENER

$ lsnrctl Start

When the listener starts successfully, you will see the following similar information:

Lsnrctl for Intel SVR4 unix:version 8.1.7.0.0-production on 23-jun-2002 04:02:46
(c) Copyright 1998 Oracle Corporation. All rights reserved.
Starting/u01/oracle/product/8.1.7/bin/tnslsnr:please wait ...
Tnslsnr for Intel SVR4 unix:version 8.1.7.0.0-production
System parameter File Is/u01/oracle/product/8.1.7/network/admin/listener.ora
Log messages Written To/u01/oracle/product/8.1.7/network/log/listener.log
Listening on: (Description= (Address= (PROTOCOL=IPC) (Key=extproc))
Listening on:
(Description= (address= (protocol=tcp) (host=gokmen.selcuk.edu.tr) (port=1521))
Listening on:
(Description= (address= (protocol=tcp) (host=gokmen.selcuk.edu.tr) (port=2481))
(Protocol_stack= (PRESENTATION=GIOP)
(Session=raw)))
Connecting to (description= address= (PROTOCOL=IPC) (Key=extproc))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version Tnslsnr for Intel SVR4 unix:version 8.1.7.0.0-production
Start Date 23-jun-2002 04:02:47
Uptime 0 days 0 hr. 0 min. 0 sec
Trace level off
Security off
SNMP off
Listener Parameter File/u01/oracle/product/8.1.7/network/admin/listener.ora
Listener Log File/u01/oracle/product/8.1.7/network/log/listener.log
Services Summary ...
Plsextproc has 1 service handler (s)
ORCL has 1 service handler (s)
The command completed successfully

If you see a similar message like this, the listener has started:

Lsnrctl for Intel SVR4 unix:version 8.1.7.0.0-production on 24-jun-2002 05:02:46
(c) Copyright 1998 Oracle Corporation. All rights reserved.
Tns-01106:listener using Listener name Listener has already been started

7 Write Database startup script

Since it had a problem with the startup script, I simply wrote a simple script here myself.

Start and close scripts

1), startup script (Dbstart)

#! /bin/bash

Su-oracle<eof

. /home/oracle/.bash_profile

Lsnrctl start

Svrmgrl<eoe

Connect Internal

Startup

Exit

EoE

Exit

Eof

2), close the script (dbstop)

#! /bin/bash

Su-oracle<eof

. /home/oracle/.bash_profile

Lsnrctl stop

Svrmgrl<eoe

Connect Internal

Shutdown immediate

Exit

EoE

Exit

Eof

Then assign executable permissions and copy to/ETC/INIT.D

Chmod +x Dbstart

Chmod +x Dbstop

In making a connection

Ln–s/etc/init.d/dbstart/etc/rc2.d/s99dbstart

Ln–s/etc/init.d/dbstop/etc/rc0.d/k10dbstop

Oracle will be able to operate properly under Solaris.