安装Oracle11.1.0.6 for Solaris 10

Oracle11g的Unix版本终于发布了，简单记录一下Oracle11.1.0.6在Solaris 10

首先是硬件是否满足安装需要：

# /usr/sbin/prtconf|grep "Memory size"
Memory size: 8192 Megabytes
# /usr/sbin/swap -s
total: 195408k bytes allocated + 24264k reserved = 219672k used, 14974200k available

要求内存不小于1G，在内存小于2G，SWAP应该是内存的1.5倍，内存2到8G，SWAP和内存相同大小即可，内存超过8G，SWAP是内存的0.75倍。

# /bin/isainfo -kv
64-bit sparcv9 kernel modules

检查系统体系结构是否和下载的Oracle软件匹配。

# df -h /tmp
Filesystem size used avail capacity Mounted on
swap 14G 944K 14G 1% /tmp
# df -h /data
Filesystem size used avail capacity Mounted on
/dev/dsk/c1t1d0s7 67G 64M 67G 1% /data

要求临时表空间不少于200M，安装目录应大于4G。

下面检查系统软件情况，首先是操作系统版本：

# uname -r
5.10

然后检查Oracle所需的包是否已经安装：

# pkginfo -i SUNWarc SUNWbtool SUNWhea SUNWlibC SUNWlibm SUNWlibms SUNWsprot SUNWtoo SUNWi1of SUNWi1cs SUNWi15cs SUNWxwfnt
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 SUNWlibC Sun Workshop Compilers Bundled libC
system SUNWlibm Math & Microtasking Library Headers & Lint Files (Usr)
system SUNWlibms Math & Microtasking Libraries (Usr)
system SUNWsprot Solaris Bundled tools
system SUNWtoo Programming Tools
system SUNWxwfnt X Window System platform required fonts

检查网络设置是否满足要求：

# cat /etc/nsswitch.conf | grep hosts
# "hosts:" and "services:" in this file are used only if the
hosts: files
# hostname
netdb1
# domainname

# cat /etc/hosts
#
# Internet host table
#
127.0.0.1 localhost
172.0.2.61 netdb1 loghost

系统检查完成，开始建立Oracle用户和dba组：

# groupadd oinstall
# groupadd dba
# useradd -g oinstall -G dba oracle
# passwd oracle
New Password:
Re-enter new Password:
passwd: password successfully changed for oracle
# id nobody
uid=60001(nobody) gid=60001(nobody)

检测并修改系统的核心参数，编辑/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=8589934592
set shmsys:shminfo_shmmni=100

后建立安装Oracle所需的目录结构。

# mkdir -p /export/home/oracle
# chown -R oracle:oinstall /export/home/oracle
# mkdir -p /data/oracle/product/11.1
# chown -R oracle:oinstall /data

编辑oracle用户目录下的.profile文件，添加下列环境变量：

ORACLE_BASE=/data/oracle
export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.1
export ORACLE_HOME
PATH=$ORACLE_HOME/bin:$PATH
export PATH
ORACLE_SID=test11g
export ORACLE_SID

DISPLAY=172.0.2.61:1.0
export DISPLAY

下面开始安装过程。

通过vnc连接到图形化界面，执行xhost +，切换到Oracle用户，执行runInstaller命令。

选择高级安装，然后继续，设置相应的inventory目录和操作系统组名称，点击继续。选择企业版，添加简体中文。

输入ORACLE_BASE：/data/oracle和安装路径：/data/oracle/product/11.1。

剩下的大部分步骤和10g的安装差别不大，这里就不过多描述了。

在建立数据库的时候输入ORACLE_SID：test11g和GLOBAL_NAME：test11g.netdb。

Oracle11g for Solaris版本添加了对11g新增权限的选择，运行用户在安装的时候进行设置，这是前面推出的几个平台上没有的，Oracle还是不断的在添加一些新的东西。

在整个安装完成后，依次执行/data/oraInventory/orainstRoot.sh和/data/oracle/product/11.1/root.sh文件：

# . /data/oraInventory/orainstRoot.sh
Changing permissions of /data/oraInventory to 770.
Changing groupname of /data/oraInventory to oinstall.
The execution of the script is complete
# . /data/oracle/product/11.1/root.sh
Running Oracle 11g root.sh script...

The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /data/oracle/product/11.1

Enter the full pathname of the local bin directory: [/usr/local/bin]:
Creating /usr/local/bin directory...
Copying dbhome to /usr/local/bin ...
Copying oraenv to /usr/local/bin ...
Copying coraenv to /usr/local/bin ...


Creating /var/opt/oracle/oratab file...
Entries will be added to the /var/opt/oracle/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.
Finished product-specific root actions.

最后登陆数据库：

$ sqlplus "/ as sysdba"

SQL*Plus: Release 11.1.0.6.0 - Production on Tue Nov 20 10:46:56 2007

Copyright (c) 1982, 2007, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select * from v$version;

BANNER
-----------------------
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
PL/SQL Release 11.1.0.6.0 - Production
CORE 11.1.0.6.0 Production
TNS for Solaris: Version 11.1.0.6.0 - Production
NLSRTL Version 11.1.0.6.0 - Production