Oracle10g安装1.1 检查系统要求1.1.1 查看系统版本和补丁#uname aAIX# oslevel -r6.1.0.01.1.2 内存容量$ lsattr -El mem0ent_mem_cap I/O memory entitlement in Kbytes Falsegoodsize 127744 Amount of usable physical memory in Mbytes Falsemem_exp_factor Memory expansion factor Falsesize 127744 Total amount of physical memory in Mbytes Falsevar_mem_weight Variable memory capacity weight False1.1.3 交换空间# lsps aPage Space Physical Volume Volume Group Size %Used Active Auto Type Chksumhd6 hdisk0 rootvg 33024MB 1 yes yes lv 01.1.4 系统文件空间# df -gFilesystem GB blocks Free %Used Iused %Iused Mounted on/dev/hd4 5.00 4.77 5% 11064 1% /dev/hd2 10.00 7.38 27% 60217 4% /usr/dev/hd9var 5.00 4.47 11% 8631 1% /var/dev/hd3 10.00 9.53 5% 1091 1% /tmp/dev/hd1 5.00 2.53 50% 2610 1% /home/dev/hd11admin 0.25 0.25 1% 5 1% /admin/proc - - - - - /proc/dev/hd10opt 5.00 4.65 8% 10878 1% /opt/dev/livedump 0.25 0.25 1% 7 1% /var/adm/ras/livedump/dev/lv00 0.25 0.24 4% 18 1% /var/adm/csd/dev/lv_ptfs 10.00 6.74 33% 5481 1% /ptfs/dev/lvarch 249.75 245.05 2% 84 1% /arch/dev/lvbackup 299.50 299.00 1% 6 1% /backup/dev/lvoracle 49.50 33.55 33% 22528 1% /oracle/dev/lvoradata 499.00 494.53 1% 9 1% /oradata1.1.5 系统硬件# getconf HARDWARE_BITMODE641.1.6 Oracle安装要求项目参数数据库实例名hpreas内存使用80G数据库连接模式独占Oracle工作目录/oracle数据存放位置/oracle/oradata/HPREAS跟踪文件位置/oracle/admin/hpreas/udump/oracle/admin/hpreas/bdump/oracle/admin/hpreas/cdump/oracle/admin/hpreas/pfile/oracle/admin/hpreas/script是否归档模式是归档路径/arch回闪工作区/oracle/flash_recovery_area审计数据存放目录/oracle/admin/hpreas/adump数据库用户sys/oracle Sysdbasystem/oracle DBAscott/oracle USER1.2 系统配置1.2.1 软件包检查# lslpp -l bos.adt.base bos.adt.lib bos.adt.libm bos.perf.perfstatbos.perf.libperfstat bos.perf.proctools bos.adt.prof bos.cifs_fs.rteFileset Level State Description -Path: /usr/lib/objreposbos.adt.base 6.1.6.15 COMMITTED Base Application Development Toolkit bos.adt.lib 6.1.2.0 COMMITTED Base Application Development Libraries bos.adt.libm 6.1.6.0 COMMITTED Base Application Development Math Library bos.adt.prof 6.1.6.15 COMMITTED Base Profiling Support bos.cifs_fs.rte 6.1.6.15 COMMITTED Runtime for SMBFS bos.perf.libperfstat 6.1.6.15 COMMITTED Performance Statistics Library Interface bos.perf.perfstat 6.1.6.15 COMMITTED Performance Statistics Interface bos.perf.proctools 6.1.6.15 COMMITTED Proc Filesystem Tools Path: /etc/objreposbos.adt.base 6.1.6.15 COMMITTED Base Application Development Toolkit bos.cifs_fs.rte 6.1.6.15 COMMITTED Runtime for SMBFS bos.perf.libperfstat 6.1.6.15 COMMITTED Performance Statistics Library Interface bos.perf.perfstat 6.1.6.15 COMMITTED Performance Statistics 1.2.2 创建oinstall、dba组及oracle用户启动 #smitty security1、创建 oinstall、dba 组进入dtterm 界面选择Groups回车后，选择添加组（Add a group）回车后Group name ：oinstallGroup Id ：500其他默认，创建完成后同样创建 dba 组。Group name ：oinstallGroup Id ：5012、创建oracle 用户进入dtterm 界面选择Users回车后，选择添加用户（Add a User）回车后User name ：oraclePrimary group ：oinstallGroup set ：dba3、Oracle用户属性修改：Soft FILE size -1 (Unlimited)Soft CPU time -1 (Unlimited)Note: This is the default value.Soft DATA segment -1 (Unlimited)Soft STACK size -1 (Unlimited)以上操作完成后退出smitty环境。1.2.3 修改oracle用户密码$ passwd oracle默认密码:oracle1.2.4 修改目录的权限#chown R oracle:oinstall /oracle#chmod R 775 /oracle1.2.5 设置oracle用户的环境变量$ su oracle$ vi .profile添加下面内容：ORACLE_BASE=/oracle; export ORACLE_BASEORACLE_HOME=$ORACLE_BASE/product/10.2.0; export ORACLE_HOMEORACLE_SID=hpreas; export ORACLE_SIDTNS_ADMIN=$ORACLE_HOME/network/admin; export TNS_ADMINORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data; export ORA_NLS33LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib; export LD_LIBRARY_PATHPATH=$ORACLE_HOME/