在 Solaris 10 上安装 Oracle 10g 完全详解

硬件要求
[#root@sun10g /]#/usr/sbin/prtconf | grep "Memory size"


Memory size: 1024 Megabytes
[#root@sun10g /]#
[#root@sun10g /]#/usr/sbin/swap -s


total: 159060k bytes allocated + 26872k reserved = 185932k used, 2167140k available


[#root@sun10g /]#df -h /tmp
Filesystem             size   used  avail capacity  Mounted on
/dev/dsk/c1t0d0s3      486M   1.1M   436M     1%    /tmp


[#root@sun10g /]#/bin/isainfo -kv
32-bit i386 kernel modules


软件要求
软件包
[#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


补丁包
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
-------可不要






修改 /etc/hosts 文件
[#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










创建 oracle 用户和 组
[#root@sun10g /]#groupadd -g 500 oinstall
[#root@sun10g /]#groupadd -g 501 dba     
[#root@sun10g /]#groupadd -g 502 oper


[#root@sun10g /]#useradd -u 500 -g oinstall -G dba,oper -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(oper)


[#root@sun10g /]#id nobody
uid=60001(nobody) gid=60001(nobody)


配置内核参数
[#root@sun10g /]#cp /etc/system /etc/system.orig
[#root@sun10g /]#ls /etc/system*
/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_semmsl=256
set semsys:seminfo_semvmx=32767
set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=10


创建用于安装 oracle 软件的目录
[#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




配置 oracle 用户的环境变量


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: