AIX6-oracle10g安装步骤 -1

1、.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 m

2、bytes 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%

3、/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/d

4、ev/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 or

5、acle安装要求项目参数数据库实例名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/a

6、dump数据库用户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

7、 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.lib

8、perfstat 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.r

9、te 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 n

10、ame ：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 d

11、ata 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/p

12、roduct/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

13、=$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

14、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

15、里面通过查询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 or