Oracle 10g 在HP-Unix上的安装

Oracle 10g 在HP-Ux上的安装

1

确认Oracle Database 10g Oracle Home 安装目录

1.1

检查# more /etc/oratab文件中目录是否存在
 orcl:/app/oracle/product/1020:N

2

磁盘空间检查:

2.1

# bdf

2.2

确认数据库信息:
host name
port number
service name
password of the SYS user

3

检查硬件配置:(以root用户登录)

3.1

检查内存:
# /usr/sbin/dmesg | grep "Physical:"
也可以通过/bin/vmstat来查看

3.2

检查swap space:
/usr/sbin/swapinfo -a

3.3

检查tmp目录:(400 MB of disk space available)
# bdf /tmp

3.4

检查总的磁盘空间:
# bdf

3.5

确认system architecture是否能运行:
# /bin/getconf KERNEL_BITS     (结果应该为:64)

4

检查Software Requirements on HP-UX(检查software and patches是否已安装:)

4.1

查看version of HP-UX:
$ uname -a
HP-UX bilut04 B.11.11 U 9000/800 1136991649 unlimited-user license

4.2

查看HP-UX 11i Quality Pack是否已安装
/usr/sbin/swlist -l bundle | grep GOLD
  GOLDAPPS11i           B.11.11.0406.5 Gold Applications Patches for HP-UX 11i v1, June 2004
  GOLDBASE11i           B.11.11.0406.5 Gold Base Patches for HP-UX 11i v1, June 2004

4.3

查看是否某个patch是否安装
/usr/sbin/swlist -l patch | grep PHSS_28880

4.4

创建必须的Symbolic Links,以便在完成安装后能relink Oracle products
# cd /usr/lib
# ln -s libX11.3 libX11.sl
# ln -s libXIE.2 libXIE.sl
# ln -s libXext.3 libXext.sl
# ln -s libXhp11.3 libXhp11.sl
# ln -s libXi.3 libXi.sl
# ln -s libXm.4 libXm.sl
# ln -s libXp.2 libXp.sl
# ln -s libXt.3 libXt.sl
# ln -s libXtst.2 libXtst.sl

5

创建UNIX Group and User (视是否为首次安装而创建以下group and user)
Oracle Inventory group (dba)   ---首次安装需要创建
Oracle software owner user (oracle)

5.1

确认是否Oracle dba Group Exists:
more /var/opt/oracle/oraInst.loc
inventory_loc=/app/oracle
inst_group=dba

5.2

如果不存在:
# /usr/sbin/groupadd dba

5.3

确认是否Oracle Software Owner User Exists
# id oracle
uid=105(oracle) gid=103(dba)

5.4

如果不存在:create the oracle user
# /usr/sbin/useradd -g dba oracle
设置口令:# passwd oracle

5.5

修改一个已存在的Oracle Software Owner User
# /usr/sbin/usermod -g dba oracle

6

确认Software Directories
■ Oracle base directory      /app/oracle
■ Oracle Inventory directory  /app/oracle/product/1020
■ Oracle home directory       /app/oracle

6.1

确认Oracle home directories:
more /etc/oratab   (结果类似如下:)
# *:/app/oracle/product/1020:N
*:/app/oracle/product/1020:N
orcl:/app/oracle/product/1020:N
……………

7

Configure the oracle User’s Environment
follow these steps 设置Oracle user's 变量:

7.1

1.Start a new terminal session, for example, an X terminal (xterm).

7.2

2.Enter the following command to ensure that X Window applications can
display on this system:
$ xhost +

7.3

3.确认当前用户是oracle

7.4

4.确认default shell
$ echo $SHELL

7.5

5.编辑oracle user’s shell startup file
Bourne shell (sh), Bash shell (bash), or Korn shell (ksh):
$ vi .profile

7.6

7.specifying a value of 022 for the default file
creation mask:
umask 022

7.7

确认:ORACLE_SID, ORACLE_HOME, or ORACLE_BASE environment variables 已经设置

7.8

run the shell startup script
$ . ./.profile

7.9

$ DISPLAY=local_host:0.0 ; export DISPLAY  export TERM=vt100----- (local_host is the host name or IP address
of the system you want to use to display the Installer (your workstation or PC).)

8

用dbf命令确认temp空间,如果不存在,以root用户创建:
su - root
# mkdir /mount_point/tmp
# chmod a+wr /mount_point/tmp
# exit

8.1

设置TEMP and TMPDIR environment variables
$ TEMP=/mount_point/tmp
$ TMPDIR=/mount_point/tmp
$ export TEMP TMPDIR

8.2

设置ORACLE_BASE environment variable:
$ ORACLE_BASE=/app/oracle
$ export ORACLE_BASE

8.3

确保TNS_ADMIN environment variable未设置:
$ unset TNS_ADMIN

8.4

确认environment正确设置:
$ umask   --(umask command displays a value of 22, 022, or 0022)
$ env | more

9

设置内核参数:

9.1

作为root用户的登录,配置内核参数:
登陆 #sam 进入system administrator manager
在其中选择kernel configuration，
进入以后在选择configurable parameters
修改以下参数
MAXDSIZ    1073741824
MAXDSIZ_64 2147483648
MAXSSIZ    134217728
MAXSSIZ_64 1073741824
MAXUSERS   1024
NPROC  8212  20+8*MAXUSERS
SEMMNI 20480
SEMMNS 32760
SEMMSL 2048
SEMVMX 32768
SEMMNU 8208  (NPROC-4)
SHMMAX 4160749568
SHMMNI 1024
SHMSEG 1024
此参数参考机型:HP-UX bilut41 B.11.11 U 9000/800 (tf)   (16CPU  Physical:67073024 Kbytes)

10

如果是以光盘安装,需要Mounting Discs on HP-UX:方法如下:

10.1

切换到root用户

10.2

如果需要,unmount当前的光盘:
# /usr/sbin/umount /SD_CDROM

10.3

在光驱里插入光盘,输入类似以下命令:
/usr/sbin/mount -F cdfs -o rr /dev/dsk/cxtydz /SD_CDROM

10.4

如果安装程序显示光盘驱动对话框,则输入:/SD_CDROM

11

Installing Oracle Database 10g Products

11.1

Mount the disc, if it is not already mounted

11.1

如果需要,以oracle登录并 set DISPLAY 环境变量.

11.1

开始安装:$ cd /tmp
$ /directory_path/runInstaller

11.1

安装到一定程度后会要求以root用户执行两个脚本，启动终端
$ su root
# /opt/oracle/oraInventory/orainstRoot.sh
# /opt/oracle/product/10.2/db_1/root.sh

11.1

On the Welcome screen, click Next

11.1

On the Specify File Locations screen, verify that the Oracle home name and
path specifies the Oracle home for an Oracle Database 10g installation, then
click Next.

11.1

On the Select a Product to Install screen, choose Oracle Database 10g Products,
then click Next.

11.1

To complete the installation, follow the instructions displayed in the Installer
screens

11.1

When the installation completes, click Exit, then click Yes to exit from the
Installer

11.1

When you run the root.sh script, if you do not want to install Legato Single
Server Version, enter 3 to quit the installation.

12

完成后续安装:Post-installation Tasks

13

检查Enterprise Manager
$ emctl start dbconsole
打开IE浏览器，输入http://hostname:1158/em
以sys用户登录
检查isqlplus
$ isqlplusctl start
打开浏览器，输入http://hostname:5560/isqlplus
以system用户登录

14

Removing Oracle Software

14.1

Start the Installer as follows:
$ $ORACLE_HOME/oui/bin/runInstaller

14.2

In the Welcome screen, click Deinstall Products

14.3

In the Inventory screen, select the Oracle home containing the products that you
want to remove.

14.4

If you want to delete specific products select them from the tree window.

14.5

Click Remove.

14.6

The Installer displays a confirmation screen asking you to confirm that you
want to deinstall the products and their dependant components.

14.7

Click Yes.