- 论坛徽章:
- 0
|
请教oracle 与hpux
1.2.1 硬件要求
Hardware Requirements
Memory A minimum of 512 MB of RAM is required to install Oracle9i Server. A minimum of 512 MB of RAM is required to install Oracle9i Management and Infrastructure. HP only: If you are installing Oracle Real Application Clusters on a cluster with Hyper Messaging Protocol (HMP), each Oracle shadow process using HMP requires an additional 0.3 MB of memory. Allocate memory depending on the applications and the number of users on the systems.
Swap space Disk space equal to the system's physical memory, or 1GB, whichever is greater.
CD-ROM device A CD-ROM drive capable of reading ISO 9660 format CD-ROM discs with RockRidge extensions.
Note: To use HP's Hyper Messaging Protocol (HMP) for cluster interconnection in an Oracle Real Application Clusters environment on HP-UX, you must have Hewlett-Packard proprietary HyperFabric Switches. These should be product A6384a, the fiber-based HyperFabric2 switch. Use adaptor cards A6386a and A7525a (fiber cable).
Random Access Memory
Platform Command
AIX $ /usr/sbin/lsattr -E -l sys0 -a realmem
HP $ grep MemTotal /proc/meminfo
Swap Space
Platform Command
AIX $ /usr/sbin/lsps -a
HP $ /usr/sbin/swapinfo -a
From the output of the command that you enter, divide the value shown in the BLOCKS column by 2.
1.2.2 磁盘空间要求
Component Required Disk Space
Database software 3.5 GB
u Temporary Disk Space Required by the Oracle Universal Installer
The Oracle Universal Installer requires up to 400 MB of space in the /tmp directory. If you do not have enough space in the /tmp directory, set the TMPDIR and TMP environment variables to specify a directory with sufficient space.
1.2.3 操作系统要求
1.2.3.1 操作系统版本
Platform Operating System Version Command
AIX 4.3.3 4.3.3 $ oslevel -r
HP HP-UX version 11.0 (64-bit). $ uname -a
1.2.3.2 操作系统补丁
OS Required Patches Web Sites to Download the Patches From
AIX 4.3.3 Maintenance Level 09 and IY24568, IY25282, IY27614, IY30151 http://techsupport.services.ibm.com/server/fixes
HP-UX 11.0 (64- bit) Sept. 2001 Quality Pack, PHCO_23792, PHCO_24148, PHKL_24268, PHKL_24729, PHKL_ 25475, PHKL_25525, PHNE_24715, PHSS_23670, PHSS_24301,PHSS_24303, PHSS_24627, PHSS_22868 For patch bundles: http://www.software.hp.com/SUPPORT_PLUS For individual patches: http://itresourcecenter.hp.com
1.2.3.3 支持Oracle RAC的操作系统要求
Platform Packages and Patches
AIX 4.3.3 PSSP 3.4 (SP only), HACMP/ES CRM 4.4.1 (RS6000 only)
HP MC/ServiceGuard A.11.13 OPS Edition, PHSS_25915, PHNE_26177
Determining Installed Patches
Platform Command
AIX $ instfix -a -ivk APAR_number
HP $ /usr/sbin/swlist -l patch
1.2.3.4 JRE Patches
Platform JRE Version
AIX JRE 1.1.8-build 20020313
HP JRE 1.1.8.06
The following table lists required or recommended JRE patches:
OS Required Patch Required/Recommend
HP PHCO_23792 PHCO_24148 PHKL_25475 PHNE_23456 PHNE_24034 PHSS_24303 Recommended Recommended Recommended Recommended Recommended Recommended
Operating System and Font Packages
OS Package Type Required Packages
AIX Operating system bos.adt.base,bos.adt.lib,bos.adt.libm,bos.perf.perfstat
Additional Operating System Requirements
Software Requirement
X Server and Window Manager Use any X server supported by your UNIX operating system. Use any Sun-supported window manager supported by your UNIX operating system.For Hummingbird Exceed, use a native window manager.For WRQ Reflections, allow a remote window manager.To determine if your X Window System is working properly on your local system, enter the following command $ xclock The X clock should appear on your monitor
Required executables The following executables must be present: make, ar, ld, nm.
Note: Due to a known HP bug (Doc. id: KBRC00003627), the default HP-UX (64-bit) operating system installation does not create a few required X library symbolic links. These links must be created manually before starting Oracle9i installation. To create these links, you must have superuser privileges, as the links are to be created in the /usr/lib directory. After enabling superuser privileges, run the following commands to create the required links: $ cd /usr/lib $ ln -s /usr/lib/libX11.3 libX11.sl $ ln -s /usr/lib/libXIE.2 libXIE.sl $ ln -s /usr/lib/libXext.3 libXext.sl $ ln -s /usr/lib/libXhp11.3 libXhp11.sl $ ln -s /usr/lib/libXi.3 libXi.sl $ ln -s /usr/lib/libXm.4 libXm.sl $ ln -s /usr/lib/libXp.2 libXp.sl $ ln -s /usr/lib/libXt.3 libXt.sl $ ln -s /usr/lib/libXtst.2 libXtst.sl
Raw device Requirements for seed database
名称 空间大小
/dev/rSYSTEM_01 1G 系统表空间 system
/dev/rTEMP_N01 1G 临时表空间 temp
/dev/rUNDO_01 1G 回滚段表空间1.
/dev/rUNDO_02 1G 回滚段表空间2.
/dev/rTOOLS_01 120M 工具表空间 TOOLS
/dev/rINDEX_01 100M INDEX表空间
/dev/rEXAMPLE 160M EXAMPLE表空间
/dev/rUSERS_01 100M 用户表空间 USERS
/dev/rCONTROLFILE_01 100M 控制文件1
/dev/rCONTROLFILE_02 100M 控制文件2
/dev/rRedo_11 100M 节点1 Redo空间1
/dev/rRedo_21 100M 节点1 Redo空间2
/dev/rRedo_31 100M 节点1 Redo空间3
/dev/rRedo_12 100M 节点2 Redo空间1
/dev/rRedo_22 100M 节点2 Redo空间2
/dev/rRedo_32 100M 节点2 Redo空间3
/dev/rSPFILE 100m 9i初始文件
/dev/rSRVCONFIG 100m 9i CLUSTER database 配置文件
1.3 安装IAS的需求
1.3.1 Oracle 9i iAS硬件要求
Item Minimum Requirement
AIX CPU All AIX compatible processors (64-bit)
HP CPU HP 9000 Series HP-UX processor for HP-UX 11.0 (64-bit)
Memory 512 MB
Disk space for AIX Application Server: · J2EE and Caching - 1 GB · Portal and Wireless - 1.8 GB · Business Intelligence - 2.7 GB · Unified Messaging - 3.5 GB Infrastructure - 5 GB Oracle9iAS Developer Kits - 1.5 GB
Disk space for HP Application Server: · J2EE and Caching - 800 MB · Portal and Wireless - 1.8 GB · Business Intelligence - 2.5 GB · Unified Messaging - 3.8 GB Infrastructure - 5.1 GB Oracle9iAS Developer Kits - 1.5 GB
u Oracle9iAS Memory Requirements
Install Type Component Configuration Minimum Memory Requirements
J2EE and Web Cache · Oracle HTTP Server · Oracle9iAS Containers for J2EE · Oracle9iAS Web Cache 256 MB
All other Oracle9iAS install types Configure up to three additional Oracle9iAS components 512 MB
All other Oracle9iAS install types Configure four or more additional Oracle9iAS components 512 MB
u Oracle9iAS Infrastructure Memory Requirements
Install Type Component Configuration Minimum Memory Requirements
Oracle9iAS Infrastructure · Oracle9iAS Metadata Repository · Oracle9iAS Single Sign-On · Oracle Internet Directory · Oracle Management Server · J2EE and Web Cache 512 MB
u Oracle9iAS Developer Kits Memory Requirements
Install Type Component Configuration Minimum Memory Requirements
Oracle9iAS Developer Kits · Oracle XML Developer Kit · Oracle9iAS Portal Developer's Kit · Oracle9iAS Wireless Developer's Kit · Oracle LDAP Developer's Kit · J2EE and Web Cache 512 MB
u Oracle9iAS Software Requirements for AIX-Based Systems
Item Requirement
Operating System AIX 4.3.3 (64-bit only)
Software JDK 1.3.1
Operating System patches for AIX 4.3.3 ML9 IY05995 IY07276 IY01050 IY17528 IY25282
Clusterware Patches PSSP 3.2 IY04109 IY04149 IY04767 HACMP/ES 4.4 IY03478 IY04109 IY06749 IY20220 IY17439 IY15677 IY14572 IY13935
Window Manager Use any supported IBM AIX window manager that supports Motif, such as dtwm, twm, and olwm.
1.3.2 Oracle9iAS Software Requirements for HP 9000 Series HP-UX
Item Requirement
Operating System HP-UX 11.0 (64-bit)
Software JDK 1.3.1
Operating System Patches HP-UX 11.00 PA-RISC Patches: You must install any prerequisite patches for JDK. These patches are available from the HP Web site. Note: Several of the patches listed below have dependency patches that must also be installed. When you navigate to the download Web page for an individual patch, click the dependency link and make sure that you install the dependency patches if required. Dec 2000 Patch Bundle PHSS_23377 PHCO_23770 PHKL_23226 PHCO_23092 PHCO_23792 PHCO_23963 PHCO_24148 PHKL_18543 PHKL_23226 PHKL_23409 PHKL_24826 PHKL_24943 PHKL_24971 PHNE_21731 PHNE_23456 PHNE_23833 PHSS_23440 PHSS_17535 PHSS_23546 PHSS_23800 PHKL_25188 PHSS_23823 Clusterware: MC/ServiceGuard 11.09 OPS Edition PHCO_23919
Required Executables The following executables must be present in the /usr/ccs/bin directory: make, ar, ld, nm, and cc.
2 Oracle安装配置
2.1 概述
本文档列出财政部项目中ORACLE产品安装的实施过程，目的在于确保Oracle产品安装及整个项目实施的顺利进行。
2.2 安装数据库产品
2.2.1 ROOT用户需要做的工作
核心参数配置及说明
Kernel Parameter Setting Purpose Recommend value
KSI_ALLOC_MAX (NPROC *  Defines the systemwide limit of queued signals that can be allocated.
MAX_THREAD_PROC 256 Defines the maximum number of kernel threads allowed per process. You may need to increase the value if required by your application. Setting it to a default or low value may lead to an out of memory error for certain applications. 1000
MAXDSIZ 1073741824 bytes Refers to the maximum data segment size in bytes for 32-bit systems. Setting this value too low may cause the processes to run out of memory.
MAXDSIZ_64 2147483648 bytes Refers to the maximum data segment size in bytes for 64-bit systems. Setting this value too low may cause the processes to run out of memory.
MAXSSIZ 134217728 bytes Defines the maximum stack segment size in bytes for 32-bit systems.
MAXSSIZ_64BIT 1073741824 Defines the maximum stack segment size in bytes for 64-bit systems.
MAXSWAPCHUNKS 16384 Defines the maximum number of swap chunks where SWCHUNK is the swap chunk size (1 KB blocks). SWCHUNK is 2048 by default. It specifies the maximum amount of configurable swap space on the system.
MAXUPRC ((NPROC*9)/10) Defines the maximum number of user processes.
MSGMAP (MSGTQL + 2) Defines the maximum number of message map entries.
MSGMNI NPROC Defines the number of message queue identifiers.
MSGSEG 32767 Defines the number of segments available for messages.
MSGTQL NPROC Defines the number of message headers.
NCALLOUT (NPROC + 16) Defines the maximum number of pending timeouts.
NCSIZE ((8 * NPROC + 204 +VX_NCSIZE) Defines the Directory Name Lookup Cache (DNLC) space needed for inodes. VX_NCSIZE is by default 1024.
NFILE (15 * NPROC + 204 Defines the maximum number of open files.
NFLOCKS 4096 Defines the maximum number of file locks available on the system.
NINODE (8 * NPROC + 204 Defines the maximum number of open inodes.
NKTHREAD (((NPROC * 7) / 4) + 16) Defines the maximum number of kernel threads supported by the system.
NPROC 4096 Defines the maximum number of processes.
SEMMAP (SEMMNI + 2) Defines the maximum number of semaphore map entries.
SEMMNI 4096 Defines the maximum number of semaphore sets in the entire system.
SEMMNS (SEMMNI * 2) Defines the maximum number of semaphores in the system. The default value of SEMMNS is 128, which is, in most cases, too low for Oracle9i software.
SEMMNU (NPROC - 4) Defines the number of semaphore undo structures.
SEMVMX 32768 Defines the maximum value of a semaphore.
SHMMAX Available physical memory Defines the maximum allowable size of one shared memory segment. The SHMMAX setting should be large enough to hold the entire SGA in one shared memory segment. A low setting can cause creation of multiple shared memory segments which may lead to performance degradation. 2*1024*1024*1024
SHMMNI 512 Defines the maximum number of shared memory segments in the entire system.
SHMSEG 32 Defines the maximum number of shared memory segments one process can attach.
VPS_CEILING 64 Defines the maximum System-Selected Page Size in kilobytes.
创建UNIX组用于DBA管理及安装
dba
创建UNIX用户管理ORACLE软件及数据库
oracle
创建链接
cd /usr/lib
ln -s /usr/lib/libX11.3 libX11.sl
ln -s /usr/lib/libXIE.2 libXIE.sl
ln -s /usr/lib/libXext.3 libXext.sl
ln -s /usr/lib/libXhp11.3 libXhp11.sl
ln -s /usr/lib/libXi.3 libXi.sl
ln -s /usr/lib/libXm.4 libXm.sl
ln -s /usr/lib/libXp.2 libXp.sl
ln -s /usr/lib/libXt.3 libXt.sl
ln -s /usr/lib/libXtst.2 libXtst.sl
2.2.2 Oracle用户需要做的工作
设置环境变量
ORACLE_BASE /oracle/o9i/app/oracle
ORACLE_HOME $ORACLE_BASE/product/902
ORACLE_SID Gfgz
CLASSPATH Must include $ORACLE_HOME/jlib/<product jar file>; ORACLE_HOME/product/jlib/product_jar_file
LD_LIBRARY_PATH $ORACLE_HOME/lib
SHLIB_PATH $ORACLE_HOME/lib32
NLS_LANG American.America.zhs16gbk
ORA_NLS33 $ORACLE_HOME/ocommon/nls/admin/data
LIBPATH $ORACLE_HOME/lib32$ORACLE_HOME/lib for AIX
PATH HP Path is $ORACLE_HOME/bin,/usr/bin,/etc, /usr/bin/X11 and /usr/local/bin, if it exists AIX Path is $ORACLE_HOME/bin,/etc, /usr/bin,/usr/bin/X11,/usr/lbin, and /usr/local/bin, if it exists
从CDROM上安装Oracle 9i
mount CDROM
1． $ ioscan -fun -C disk –---->;决定CDROM的设备文件名
2． 编辑/etc/pfs_fstab，按如下格式加入一行
device_file mount_point filesystem_type translation_method
如：/dev/dsk/c4t2d0 /cdrom pfs-rrip xlat=unix 1 0
3． 以root登录，mount CDROM
# nohup /usr/sbin/pfs_mountd &
# nohup /usr/sbin/pfsd &
# /usr/sbin/pfs_mount /cdrom
Oracle Universal Installer
启动 Oracle Universal Installer
1. 以oracle登录,运行installer
$ /cdrom_mount_point_directory/runInstaller
2. 在“Cluster Node Selection window”中选择要安装的节点名
3. 在“File Locations window”中选择oracle软件要安装的位置
4. 指定安装组：缺省为dba
5. 在另外窗口，以root身份运行/tmp/OraInstall/orainstRoot.sh
6. 指定安装主目录名称
7. 选择安装语言，中文/英文
8. 选择安装类型“Oracle 9i database”
9. 选择安装customize installation
10. 在”Available Product Components window”中选择要安装的产品
oracle 9.2.0.1
enterprise edition
partition option
tuning pack
diagnosing
-security option
-Pro*c
-Java product
label security
net services
oracle net listener
11. 选择使用建库工具DBCA建立数据库
12. 在installer安装完所有产品之后，需要以root用户执行
# cd $ORACLE_HOME
#./root.sh
13. 如果选择RAC，需要在所有节点运行root.sh
14. 出现”Configuration Tools window”中，通过DBCA进行数据库创建工作,此时，在如下选择中
General Purpose configuration
Transaction Processing option
Data Warehouse option
Customized installation option
选择Customized installation option并准备如下信息，
Data, control, and redo log file settings
Tablespace and extent sizes
Database memory parameters
Archiving modes, formats and destinations
Trace file destinations
Character set values
检查安装会话的log信息
检查oraInventory_location/logs/installActionsdate_time.log中有无错误信息。
2.2.3 安装的后续工作
root用户的工作
cd $ORACLE_HOME
sh root.sh
Oracle用户的工作
修改UNIX用户启动文件
.profile
设置，确认环境变量
Initializing the oraenv Script
在多节点系统中，在启动文件（.profile）后加入下列脚本
#!/bin/sh
echo "The SIDs on this machine are:"
cat /etc/oratab | awk -F: '{print $1}' | grep -v "#"
ORAENV_ASK="YES"
. /usr/local/bin/oraenv
备份root.sh脚本
设置初始化参数
？？
？？
？？
其他Oracle产品安装后的工作
配置Shared Server参数
？？
？？
如果单独配置Oracle Net 服务
$ORACLE_HOME/bin/netca
如果单独启动DBCA
$ORACLE_HOME/bin/dbca
配置新建立的数据库
SQL>; @$ORACLE_HOME/rdbms/admin/utlrp
Configuring Oracle Real Application Clusters
管理Oracle RAC
如需要在服务器启动时自动启动RAC，需要编辑/etc/init.d/dbora增加一行，
su - oracle -c $ORACLE_HOME/bin/gsd
配置Oracle Label Security
确认初始化参数compatible=9.0.2.1
2.2.4 安装IAS产品
2.2.4.1 Oracle9i Application Server
设置环境变量
ORACLE_HOME /oracle/ias/oracle/app/oracle/product/902
DISPLAY hostname:display_number.screen_number
TMP and TMPDIR /tmp
LD_LIBRARY_PATH $ORACLE_HOME/lib
SHLIB_PATH $ORACLE_HOME/lib32
TNS_ADMIN
ORA_NLS33 $ORACLE_HOME/ocommon/nls/admin/data
LIBPATH $ORACLE_HOME/lib32$ORACLE_HOME/lib for AIX
PATH HP Path is $ORACLE_HOME/bin,/usr/bin,/etc, /usr/bin/X11 and /usr/local/bin, if it exists AIX Path is $ORACLE_HOME/bin,/etc, /usr/bin,/usr/bin/X11,/usr/lbin, and /usr/local/bin, if it exists
Hostnames File Configuration
Oracle Universal Installer需要完整的主机名信息，包括域名
在/etc/hosts.* 中加入下面一行：
IP_ADDRESS FULLY_QUALIFIED_HOSTNAME SHORT_HOSTNAME ALIASES
例如：
148.87.9.44 scgf-a.sc.mof scgf-a
创建UNIX用户及组
dba
端口分配
Oracle HTTP Server port = 7777
Oracle HTTP Server SSL port = 4443
Oracle HTTP Server listen port = 7779
Oracle HTTP Server SSL listen port = 4444
Oracle HTTP Server Jserv port = 8007
Enterprise Manager Servlet port = 1810
配置核心参数
同数据库要求
Oracle9iAS安装
在依次遇到的以下安装画面中，给出恰当值。
1. Welcome:
2. Inventory Location: 指定inventory安装位置
3. File Locations:指定安装的源文件，目标目录
4. Available Products:选择Oracle9i Application Server安装。
5. Installation Types:在安装类型中，选择J2EE and Web Cache
§ J2EE and Web Cache
§ Portal and Wireless
§ Business Intelligence and Forms
§ or Unified Messaging.
6. Component Configuration and Startup
选择oracle9i ias webcache
7. 选择“Oracle9iAS Infrastructure Use”
选择NO
9. 根据在此机器上是否已经安装过IAS，在下面选项中做合适选择。
o Create Instance Name and ias_admin Password
§ Instance Name: 指定9ias的安装INSTANCE名字,这里统一采用 ias作为instance name.
§ ias_admin Password: 该用户管理此节点上的所有9IAS的安装。在安装其它instance时会需要此口令,口令统一设置为manager1
o Enter ias_admin Password: 如果在ORACLE_HOME下已经有过安装IAS，需要输入从前安装时用到的口令。
o Create Instance Name: 如果在另外的ORACLE_HOME下有过安装，输入新的INSTANCE 名字。
10. Metadata Repository:指定metadata repository
11. Outgoing Mail Server: Enter the outgoing mail server to use with Oracle9iAS Reports Services. This screen appears if you have selected Oracle9iAS Reports Services for installation.
12. Installation Summary:检查安装内容
13. Install: 安装开始进行
14. Oracle9iAS Configuration Tools: 检查Oracle9iAS配置工具。
15. End of Installation: 提示用户安装完毕
2.2.4.2 Oracle9iAS安装后续工作
· 启动Oracle Enterprise Manager Web Site
EMCTL start, stop, status, set password, etc.
· 启动关闭组件
o Oracle9iAS的组件控制可以通过Oracle Enterprise Manager Home Page来完成.
· 组件端口配置
o 见前面端口配置部分。 |
|
免费注册
发表于 2003-01-21 11:11
