Complete explanation of Oracle 10g installation on Solaris 10

Hardware requirements
[# Root @ sun10g/] #/usr/sbin/prtconf | grep "memory size"

Memory size: 1024 megabytes
[# Root @ sun10g/] #
[# Root @ sun10g/] #/usr/sbin/swap-S

Total: 159060 K Bytes allocated + 26872 K reserved = 185932 K used, 2167140 K available

[# Root @ sun10g/] # DF-H/tmp
Filesystem size used avail capacity mounted on
/Dev/DSK/c1t0d0s3 486 m 1.1 m 436 m 1%/tmp

[# Root @ sun10g/] #/bin/isainfo-kV
32-bit i386 Kernel Modules

Software requirements
Software Package
[# Root @ sun10g/] # pkginfo-I sunwarc sunwbtool sunwhea sunwlibm sunwlibms sunwsprot \
> Sunwsprox sunwtoo sunwi1of sunwi1cs sunwi15cs sunwxwf
System sunwarc lint libraries (usr)
System sunwbtool CCS tools bundled with SunOS
System sunwhea SunOS header files
System sunwi15cs X11 ISO8859-15 codeset support
System sunwi1cs X11 ISO8859-1 codeset support
System sunwi1of ISO-8859-1 (Latin-1) Optional Fonts
System sunwlibm math & microtasking library headers & lint files (usr)
System sunwlibms math & microtasking libraries (usr)
System sunwsprot Solaris bundled tools
System sunwtoo programming tools
Error: Information for "sunwsprox" was not found
Error: Information for "sunwxwf" was not found

Patch pack
All installations
[# Root @ sun10g solaris_10] #/usr/sbin/patchadd-p | grep 118345
[# Root @ sun10g solaris_10] #/usr/sbin/patchadd-p | grep 119961

PL/SQL native compilation, Pro * C/C ++, Pro * Fortran, Oracle call interface, Oracle C ++ call interface, Oracle XML developer's kit (xdk)
[# Root @ sun10g solaris_10] #/usr/sbin/patchadd-p | grep 117837
[# Root @ sun10g solaris_10] #/usr/sbin/patchadd-p | grep 117846
[# Root @ sun10g solaris_10] #/usr/sbin/patchadd-p | grep 118682
------- Do not

Modify the/etc/hosts file
[# Root @ sun10g/] # vi/etc/hosts

: 1 localhost
127.0.0.1 localhost localhost.oracle.com
#192.168.8.247 sun10g loghost
192.168.8.247 sun10g.oracle.com sun10g

Create oracle users and groups
[# Root @ sun10g/] # groupadd-G 500 oinstall
[# Root @ sun10g/] # groupadd-G 501 DBA
[# Root @ sun10g/] # groupadd-G 502 restart

[# Root @ sun10g/] # useradd-u 500-G oinstall-G dBA, role-D/export/home/Oracle-m-S/bin/bash Oracle
[# Root @ sun10g/] # passwd Oracle
[# Root @ sun10g/] # passwd-r files Oracle
New password:
Re-enter new password:
Passwd: Password successfully changed for Oracle

[# Root @ sun10g/] # ID-A Oracle
Uid = 500 (Oracle) gid = 500 (oinstall) groups = 501 (DBA), 502 (region)

[# Root @ sun10g/] # ID nobody
Uid = 60001 (nobody) gid = 60001 (nobody)

Configure Kernel Parameters
[# Root @ sun10g/] # cp/etc/system. orig
[# Root @ sun10g/] # ls/etc/system *
/Etc/system. orig

[# Root @ sun10g/] # vi/etc/System

Set noexec_user_stack = 1
Set semsys: seminfo_semmni = 100
Set semsys: seminfo_semmns = 1024
Set semsys: seminfo_semms = 256
Set semsys: seminfo_semvmx= 32767
Set shmsys: shminfo_shmmax = 4294967295
Set shmsys: shminfo_shmmin = 1
Set shmsys: Sh minfo_shmmni = 100
Set shmsys: shminfo_shmseg = 10

Create a directory for installing Oracle software
[# Root @ sun10g/] # newfs/dev/rdsk/c1t1d0s1
[# Root @ sun10g/] # newfs/dev/rdsk/c1t1d0s2
[# Root @ sun10g/] # Mount-F ufs/dev/DSK/c1t1d0s0/u01
[# Root @ sun10g/] # vi/etc/vfstab

/Dev/DSK/c1t1d0s0/dev/rdsk/c1t1d0s0/u01 UFS 2 Yes-

[# Root @ sun10g/] # mkdir-P/u01/APP/Oracle
[# Root @ sun10g/] # chmod-r 775/u01
[# Root @ sun10g/] # chown-r ORACLE: oinstall/u01

Configure Oracle user environment variables

Export oracle_base =/u01/APP/Oracle
Export ORACLE_HOME =/u01/APP/Oracle/product/10.2.0/db_1
Export oracle_sid = Prod
Export tmpdir =/tmp
Export nls_lang = "american_america.al32utf8"
# Export nls_lang = "simplified chinese_china.zhs16gbk"
Export nls_date_format = "YYYY-MM-DD hh24: MI: SS"
Export Path = $ path:/usr/bin:/usr/local/bin:/usr/UCB:/etc:/usr/sbin:/usr/SFW/bin: /usr/CCS/bin:/opt/csw/bin:/usr/openwin/bin: $ ORACLE_HOME/bin: