ï»??xml version="1.0" encoding="utf-8" standalone="yes"?>http://www.aygfsteel.com/chenliqun/zh-cnThu, 19 Jun 2025 11:11:00 GMTThu, 19 Jun 2025 11:11:00 GMT60http://www.aygfsteel.com/chenliqun/archive/2006/04/03/39011.html陈立¾Ÿ?/dc:creator>陈立¾Ÿ?/author>Mon, 03 Apr 2006 12:20:00 GMThttp://www.aygfsteel.com/chenliqun/archive/2006/04/03/39011.htmlhttp://www.aygfsteel.com/chenliqun/comments/39011.htmlhttp://www.aygfsteel.com/chenliqun/archive/2006/04/03/39011.html#Feedback0http://www.aygfsteel.com/chenliqun/comments/commentRss/39011.htmlhttp://www.aygfsteel.com/chenliqun/services/trackbacks/39011.htmlSolaris10 x86 u1 下安è£?Oracle 10g Release 2

关键�br />
Solaris、Oracle

操作环境

Dell 2850
Solaris 10 x86 u1
Oracle 10g Release 2
Bash shell

¾l¼åˆçŸ¥è¯†

Solaris 10 x86 u1会在Dell 2850下以64位模式运行ã€?br />Oracle 10g Release 2ž®±æ˜¯64位架æž?br />
参考资æ–?br />安装文äšg10201_database_solx86_64.zip内的帮助文档
http://www.dbspecialists.com/presentations/oracle10gsolaris.html
http://download-west.oracle.com/docs/html/B13972_01/toc.htm

下蝲文äšg
http://www.oracle.com/technology/software/products/database/oracle10g/index.html
注册后点�br />Oracle Database 10g Release 2 (10.2.0.1.0) for Solaris Operating System (x86-64)
下蝲
10201_database_solx86_64.zip

‹‚€æŸ¥ç³»¾lŸçŽ¯å¢?br />
¼‹®ä¿¾pȝ»Ÿå¯ä»¥˜qè¡Œå›‘ÖŞ界面或可以远½E‹è¿è¡Œå›¾å½¢ç•Œé¢ï¼Œåœ¨æ­¤ä½¿ç”¨çš„è¿œ½E‹æ¡Œé¢æ˜¯X Manager 2.0
打开XBrowseråQŒè¾“入服务器的IP地址卛_¯˜qžä¸Šã€?br />
查看¾pȝ»Ÿç‰ˆæœ¬åQˆè¦æ±?.10 64-bitåQ?br />? uname -a
SunOS javasvr 5.10 Generic_118844-26 i86pc i386 i86pc
? isainfo -kv
64-bit amd64 kernel modules

查看物理内存åQˆè¦æ±?12MB以上åQŒæŒ‰å…·ä½“情况åQ?br />? /usr/sbin/prtconf | grep "Memory size"
Memory size: 2048 Megabytes

查看交换文äšgåQˆè¦æ±?G以上åQ?br />? /usr/sbin/swap -l
swapfile             dev  swaplo blocks   free
/dev/dsk/c0t0d0s1   55,65      8 4192952 4192952

临时文äšg½Iºé—´åQˆè¦æ±?00M以上åQ?br />? df -h /tmp
Filesystem             size   used  avail capacity  Mounted on
swap                   3.1G     8K   3.1G     1%    /tmp

˜q™é‡Œçš„物理内存äØ“2GåQŒç†è®ÞZ¸Šä¸?G*1.5=3G合适，˜q™é‡Œå†æ·»åŠ?12MB

创徏一ä¸?12MB的交换文ä»Óž¼š
# mkfile 512M /export/home/swapone

æ·ÕdŠ åˆšåˆ›å»ºçš„交换文äšgåQ?br /># swap -a /export/home/swapone

‹‚€æŸ¥ä¸€ä¸‹ï¼š
# swap -l
swapfile             dev  swaplo blocks   free
/dev/dsk/c0d0s1     102,1       8 1056376 1056376
/export/home/swapone  -        8 1048568 1048568

下面讄¡½®äº¤æ¢æ–‡äšg在重启后自动加蝲使用åQ?br /># vi /etc/vfstab
/export/home/swapone    -       -       swap    -       no      -

查看¼‹¬ç›˜½Iºé—´åQˆè¦æ±?.7G以上åQ?br /> df -h
Filesystem             size   used  avail capacity  Mounted on
/dev/dsk/c0t0d0s0       29G   3.1G    25G    12%    /
......
swap                   3.1G   636K   3.1G     1%    /etc/svc/volatile
......
/dev/dsk/c0t0d0s7       27G   6.3G    20G    24%    /export/home

查看以下软äšg包是否存åœ?br />? pkginfo -i SUNWarc SUNWbtool SUNWhea 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      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
system      SUNWxwfnt X Window System platform required fonts
ERROR: information for "SUNWi1cs" was not found
ERROR: information for "SUNWi15cs" was not found

˜q™é‡Œéœ€è¦å®‰è£…两个包åQšSUNWi1cså’ŒSUNWi15cs

˜q™é‡Œä»Žä¸‹è½½çš„安装镜像文äšg安装

加蝲存放镜像文äšg分区
? mkdir /mnt/storage
? mount -F pcfs /dev/dsk/c0t0d0p4:1 /mnt/storage

以块讑֤‡åŠ è²é•œåƒæ–‡äšg
? lofiadm -a /mnt/storage/solaris10/sol-10-u1-ga-x86-dvd.iso
/dev/lofi/1
? mount -F hsfs -o ro /dev/lofi/1 /mnt/isoimg

安装˜q™ä¸¤ä¸ªåŒ…
? pkgadd -d /mnt/isoimg/Solaris_10/Product SUNWi1cs
? pkgadd -d /mnt/isoimg/Solaris_10/Product SUNWi15cs

卸蝲加蝲的文�br />? umount /mnt/isoimg/
? lofiadm -d /dev/lofi/1
? umount /mnt/storage/

ç”׃ºŽä½¿ç”¨çš„Solaris 10 u1比较斎ͼŒž®×ƒ¸æ‰“补丁了ã€?br />

创徏用户和组

需要创å»ÞZ¸¤ä¸ªç»„oinstallå’ŒdbaåQŒä¸¤ä¸ªç”¨æˆ·oracleå’Œnobody

先查看是否已存在
? grep oinstall /etc/group
? grep dba /etc/group
? id -a oracle
? id -a nobody
uid=60001(nobody) gid=60001(nobody) groups=60001(nobody)

创徏¾l?br />? groupadd oinstall
? groupadd dba

创徏用户
? useradd -g oinstall -G dba -d /export/home/oracle -s /usr/bin/bash -c 'Oracle software owner' -m oracle
? id -a oracle
uid=107(oracle) gid=104(oinstall) groups=105(dba)

讄¡½®å¯†ç 
? passwd oracle
***

创徏所需目录

需要创å»ÞZ¸¤ä¸ªç›®å½•oracleå’ŒoradataåQŒä¸€ä¸ªç”¨æ¥å­˜å‚¨ç¨‹åºæ–‡ä»Óž¼Œä¸€ä¸ªç”¨æ¥å­˜å‚¨æ•°æ®æ–‡ä»?br />
查看¼‚ç›˜½Iºé—´
? df -kh

创徏目录oracleåQˆéœ€è¦?G以上åQ?br />? mkdir -p /opt/oracle
? chown -R oracle:oinstall /opt/oracle
? chmod -R 775 /opt/oracle

创徏目录oradataåQˆéœ€è¦?.2G以上åQ?br />? mkdir -p /export/home/oradata
? chown -R oracle:oinstall /export/home/oradata
? chmod -R 775 /export/home/oradata

调整内核参数

备䆾配置文äšg
? cp /etc/system /etc/system.orig

修改配置文äšgåQŒæ·»åŠ å¦‚下几è¡?br />? vi /etc/system
* for install oracle 10g
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

重启¾pȝ»Ÿ
? reboot

准备安装文äšg

解压安装文äšgåQ?br />? unzip 10201_database_solx86_64.zip
得到文äšg夹database

配置环境参数

用oracleç™Õd½•
? su - oracle

讄¡½®çŽ¯å¢ƒå‚æ•°
? vi .profile
umask 022
ORACLE_BASE=/opt/oracle
ORACLE_SID=cdtdb
export ORACLE_BASE ORACLE_SID

重新ç™Õd½•æŸ¥çœ‹
-bash-3.00$ umask
0022
? env | more
-bash-3.00$ env | more
......
ORACLE_SID=cdtdb
ORACLE_BASE=/opt/oracle
......

开始安装过½E?br />
用Xmanagerç™Õd½•åˆ°æœåŠ¡å™¨
用oracle用户

˜qè¡Œdatabase目录下的runInstaller

Select Installation Method
  Advanced Installation

Specify Inventory directory and credentials
  /opt/oracle/oraInventory
  oinstall

Select Installation Type
  Enterprise Edition

Sepcify Home Details
  Name: OraDb10g_home1
  Path: /opt/oracle/oracle/product/10.2.0/db_1

Product-Specific Prerequisite Checks
  全部通过卛_¯åQ?br />
Select Configuration Option
  Create a database

Select Database Configuration
  General Purpose

Specify Database Configuration Options
Global Database Name:cdtdb    SID:cdtdb
Select Database Character set: Simplified Chinese ZHS16GBK
选中Create database with sample schemas

Select Database Management Option
选中Use Database Control for Database Management
    Enable Email Notification
        61.144.43.235
        chenliqun@pyp.edu.cn

Specify Database Storage Option
选中File System
    location:/export/home/oradata

Specify Backup and Recovery Options
选中Do not enable Automated backups

Specify Database Schema Passwords
¾lŸä¸€ä½¿ç”¨ä¸€ä¸ªå¯†ç ï¼š***

Summary

Execute Configuration Scripts
按照提示åQŒç”¨root用户˜qè¡Œè„šæœ¬

安装完成åQ?br />
安装日志åQ?br />/opt/oracle/oracle/product/10.2.0/db_1/cfgtoollogs/dbca/cdtdb

iSQL*Plus URL:
http://192.168.200.11:5560/isqlplus

iSQL*Plus DBA URL:
http://192.168.200.11:5560/isqlplus/dba

Enterprise Manager 10g Database Control URL:
http://192.168.200.11:1158/em
用sys用户以sysdbaíw«ä†¾ç™Õd½•

完成服务配置

用oracleç™Õd½•
? su - oracle

修改配置文äšg
? vi .profile
stty istrip
PS1='# '
umask 022
MAIL=/usr/mail/${LOGNAME:?}
PATH=/usr/bin:/usr/sbin:/usr/sadm/bin:/usr/sfw/bin:/usr/local/bin:/usr/ucb:/etc:.
ORACLE_SID=cdtdb
ORAENV_ASK=NO
ORACLE_BASE=/opt/oracle
export PS1 PATH ORACLE_BASE ORACLE_SID ORAENV_ASK
. oraenv

正确配置数据库实例入�br />? vi /var/opt/oracle/oratab
cdtdb:/opt/oracle/oracle/product/10.2.0/db_1:Y

创徏自动˜qè¡Œè„šæœ¬
? vi /etc/init.d/oracle
#!/bin/sh
ORA_HOME=/opt/oracle/oracle/product/10.2.0/db_1
ORA_OWNER=oracle
if [ ! -f $ORA_HOME/bin/dbstart ]
then
  echo "Oracle startup: cannot start"
  exit
fi
case "$1" in
   'start') # Start the Oracle databases and listeners
            su - $ORA_OWNER -c "$ORA_HOME/bin/dbstart"
            su - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl start"
            su - $ORA_OWNER -c "$ORA_HOME/bin/emctl start dbconsole"
            su - $ORA_OWNER -c "$ORA_HOME/bin/isqlplusctl start"
            ;;
   'stop')  # Stop the Oracle databases and listeners
            su - $ORA_OWNER -c "$ORA_HOME/bin/isqlplusctl stop"
            su - $ORA_OWNER -c "$ORA_HOME/bin/emctl stop dbconsole"
            su - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl stop"
            su - $ORA_OWNER -c "$ORA_HOME/bin/dbshut"
            ;;
esac

建立½W¦å·˜qžæŽ¥
? ln -s /etc/init.d/oracle /etc/rc2.d/S99oracle
? ln -s /etc/init.d/oracle /etc/rc0.d/K10oracle


其它配置和错误排�br />
解决emå’Œisqlplus中文按钮ä¹Þq é—®é¢˜
# cd $ORACLE_HOME/jre/1.4.2/lib
# cp font.properties font.properties.orig
# cp font.properties.zh_CN_UTF8 font.properties

# cd $ORACLE_HOME/jdk/jre/lib/
# cp font.properties font.properties.orig
# cp font.properties.zh_CN_UTF8 font.properties

清除¾~“存的文ä»?br /># cd $ORACLE_HOME/oc4j/j2ee/oc4j_applications/applications/em/em/cabo/images/cache/zhs
# rm *.*

# cd $ORACLE_HOME/oc4j/j2ee/oc4j_applications/applications/isqlplus/isqlplus/cabo/images/cache/zhs
# rm *.*

排除tnslsnr启动错误åQ?br />错误信息åQšFailed to auto-start Oracle Net Listene using /ade/vikrkuma_new/oracle/bin/tnslsnr
˜q™é‡Œçš„Listene应该是Listener吧！

# vi $ORACLE_HOME/bin/dbstart
ž®?ORACLE_HOME_LISTNER=/ade/vikrkuma_new/oracle
改äØ“ ORACLE_HOME_LISTNER=$ORACLE_HOME

可见åQŒè¿™æ˜¯ç”±äºŽOracel工程师手误引èµøP¼éžå¸¸ä¸åº”该！

启动Oracle时启动Apache出错

查看错误提示
# vi /var/adm/messages
Mar 30 08:31:50 javasvr svc.startd[7]: [ID 652011 daemon.warning] svc:/network/http:apache2: Method "/
lib/svc/method/http-apache2 start" failed with exit status 1.

? svcs -a | grep apache2
maintenance    Mar_31   svc:/network/http:apache2
上面说明apache2没有正常˜qè¡Œ

应该是Oracle安装æ—Óž¼Œæƒ›_¯åŠ¨Apache2åQŒä½†Apache2作äØ“SMF服务åQŒä¸å…è®¸å¤–部½E‹åºå•ç‹¬å¯ç”¨ã€?br />
如果不需要Apache2服务åQŒå…³é—­å®ƒ
? svcadm disable http:apache2

如果需要，ž®±å¯ç”¨å®ƒ
? svcadm disable http:apache2
? svcadm enable http:apache2

注意åQŒemå’Œisqlplus使用的是oc4j服务器ã€?br />

陈立¾Ÿ?/a> 2006-04-03 20:20 发表评论

]]> Ö÷Õ¾Ö©Öë³ØÄ£°å£º ÇÕÖÝÊÐ| ×ñÒåÊÐ| ¼ÃÔ´ÊÐ| ÈýÃÅÏØ| Î÷ÎÚÖéÄÂÇßÆì| ÐðÓÀÏØ| ×ñ»¯ÊÐ| ¶ëüɽÊÐ| ×ÔÖÎÏØ| ÍÍÃÅÇø| »ñ¼ÎÏØ| µÃÈÙÏØ| ÃÏ´å| ²ý¼ªÊÐ| Î÷ÏçÏØ| °ºÈÊÏØ| ÂÐƽÏØ| Ú«ºÓÊÐ| ¾üÊÂ| ÆÕ¸ñÏØ| µ±ÑôÊÐ| ¿ªÔ­ÊÐ| ÄϽ§| ÐÂÄþÏØ| Äþ»¯ÏØ| ·áÔ­ÊÐ| ̨ÄÏÏØ| ͨ½­ÏØ| Èê³ÇÏØ| Ρɽ| ´ó·áÊÐ| ÍͲýÏØ| Ì«ÆÍËÂÆì| ¹ã¶«Ê¡| ĪÁ¦| ÉϺ¼ÏØ| ÐĮ̈ÏØ| ÏæÎ÷| ÄþÏÄ| ͨÖÝÊÐ| ãëÉÏÏØ|