AIX6-oracle10g安装步骤-1.doc

Oracle10g安装1.1 检查系统要求1.1.1 查看系统版本和补丁#uname aAIX# oslevel -r1.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 ctools f bos.cifs_fs.rteFileset Level State Description -Path: /usr/lib/objreposbos.adt.base 5 COMMITTED Base Application Development Toolkit bos.adt.lib COMMITTED Base Application Development Libraries bos.adt.libm COMMITTED Base Application Development Math Library f 5 COMMITTED Base Profiling Support bos.cifs_fs.rte 5 COMMITTED Runtime for SMBFS bos.perf.libperfstat 5 COMMITTED Performance Statistics Library Interface bos.perf.perfstat 5 COMMITTED Performance Statistics Interface ctools 5 COMMITTED Proc Filesystem Tools Path: /etc/objreposbos.adt.base 5 COMMITTED Base Application Development Toolkit bos.cifs_fs.rte 5 COMMITTED Runtime for SMBFS bos.perf.libperfstat 5 COMMITTED Performance Statistics Library Interface bos.perf.perfstat 5 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/bin:$PATH; export PATHCLASSPATH=$ORACLE_HOME/JRE/lib:$ORACLE_HOME/JRE/lib/rt.jar:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATHumask=022ORACLE_HOSTNAME=HPRDBM; export ORACLE_HOSTNAME1.3 数据库安装1.3.1 oracle文件解压通过FTP 工具上传数据库安装文件到/ 跟目录下$ cpio dimv shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down.SQL startupORACLE instance started.Total System Global Area 8.3886E+10 bytesFixed Size 2254312 bytesVariable Size 3070233112 bytesDatabase Buffers 8.0766E+10 bytesRedo Buffers 48074752 bytesDatabase mounted.Database opened.SQL数据库状态的查询：对于一个陌生的数据库，我们并不知道她处于什么样的状态，那么这个时候我们可以通过SQL*PLUS来查询。在SQL*PLUS里面通过查询v$database 和 v$instance通过查询后得到的结果来判断，命令是：SELECT open_mode FROM v$database;和SELECT status FROM v$instance;例如：SQL select open_mode from v$database;OPEN_MODE-READ WRITESQLSQL select status from v$instance；STATUS-OPENSQL数据库启动脚本：#!/bin/shORACLE_HOME= /oracle/product/10.2.0ORA_OWNER=oraclecase $1 instart)# Start the