在HPUNIX下安装ORACLE过程_图文_百度文库

1、HPUNIX 上安装 ORACLE 数据库过程 :2008-7-18 10:00cpio idcmv < HP_IA64_server_.0_Disk1.cpiocpio idcmv < HP_IA64_server_.0_Disk2.cpiocpio idcmv < HP_IA64_server_.0_Disk3.cpio/opt/java1.5/bin/jar xvf p4547809_92080_HPUX_IA64.zip(不能用这个解压,会报错 UTF8不能转换chown -R oracle:dba patchchown -R

2、 oracle:dba /dev/dvg1chmod 755 /dev/dvg1/r*uname aincdkhdb1#oracle> bdfFilesystem kbytes used avail %used Mounted on/dev/vg00/lvol3 1081344 352088 723568 33% /dev/vg00/lvol1 1835008 128096 1693680 7% /stand/dev/vg00/lvol8 8912896 2832320 6033160 32% /var/dev/vg00/lvol7 8192000 2763448 5386168 34%

3、 /usr/dev/vg00/ulv 10256384 19684 9596969 0% /u/dev/vg00/lvol4 4194304 337584 3826640 8% /tmp/dev/vg00/oraclelv 15368192 2568412 11999802 18% /oracle在 ORACLE 用户下 :建目录 /var/opt/oracle chown R oracle:dba双机建立互信 (两边都做 :cp /.rhosts /oraclevi .rhostsncdkhdb1 oraclencdkhdb2 oracle用 rlogin ncdkhdb2测试 ;vi .p

4、rofileEDITOR=viexport EDITORumask 022export ORACLE_BASE=/oracle/app/oracleexport ORACLE_HOME=/oracle/app/oracle/product/9.2.0export NLS_LANG=AMERICAN_AMERICA.ZHS16CGB231280export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/dataexport ORACLE_OWNER=oracleexport LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib:/

5、lib:$ORACLE_HOME/rdbms/lib export LIBPATH=$ORACLE_HOME/lib:$ORACLE_HOME/ctx/libexport SHLIB_PATH=$ORACLE_HOME/lib32:$ORACLE_HOME/rdbms/lib32exportPATH=/bin:/usr/bin:/usr/sbin:/etc:/usr/ccs/bin:/usr/local/bin:/$ORACLE_HOME/bin:/usr/bin/X11: $PATHCLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HO

6、ME/rdbms/jlib CLASSPATH=$CLASSPATH:$ORACLE_HOME/network/jlibexport CLASSPATHDISPLAY=28:0.0export DISPLAYORACLE_SID=ncdkhdb1export ORACLE_SIDPS1='ncdkhdb1#oracle> 'export PS1rcp .profile ncdkhdb2:/oracleremsh ncdkhdb2vi .profile修改 .profile 文件 .写祼设备对应文件 : RAW_FILENAME.TXT(后来发现这个文

7、件是在建库时用来指定表空间 所指定的裸设备文件的位置的,可以不建,手工指定就行了system = /dev/dvg1/rrsytemtemp = /dev/dvg1/rrtempundo1 = /dev/dvg1/rrundo1undo2 = /dev/dvg1/rrundo2tools = /dev/dvg1/rrtoolsindex = /dev/dvg1/rrindexexample = /dev/dvg1/rrexampleuser = /dev/dvg1/rrusercontrol1 = /dev/dvg1/rrcontrol1control2 = /dev/dvg1/rrcontr

8、ol2control3 = /dev/dvg1/rrcontrol3redo_111 = /dev/dvg1/rrredo_111redo_112 = /dev/dvg1/rrredo_112redo_121 = /dev/dvg1/rrredo_121redo_122 = /dev/dvg1/rrredo_122redo_131 = /dev/dvg1/rrredo_131redo_132 = /dev/dvg1/rrredo_132redo_211 = /dev/dvg1/rrredo_211redo_212 = /dev/dvg1/rrredo_212redo_221 = /dev/dv

9、g1/rrredo_221redo_222 = /dev/dvg1/rrredo_222redo_231 = /dev/dvg1/rrredo_231redo_232 = /dev/dvg1/rrredo_232spfile = /dev/dvg1/rrspfilesrvconfig = /dev/dvg1/rsrvconfig建立应用数据表空间的裸设备文件 :(由系统管理员来建 # lvcreate n tjfx_data.dbf L 50000 /dev/dvg1cd /oracle/setup/Disk1 ./runInstaller(15:36 # pwd/oracle/app/ora

10、cle/product/9.2.0# ./root.shRunning Oracle9 root.sh script.The following environment variables are set as:ORACLE_OWNER= oracleORACLE_HOME= /oracle/app/oracle/product/9.2.0Enter the full pathname of the local bin directory: /usr/local/bin: /usr/bin Copying dbhome to /usr/bin .Copying oraenv to /usr/b

11、in .Copying coraenv to /usr/bin .Creating /etc/oratab file.Adding entry to /etc/oratab file.Entries will be added to the /etc/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished running generic part of root.sh script.Now product-specific root actions will be p

12、erformed.# 软件安装成功 , 重启机器 ;升级 ORACLE9208:./oracle/setup/patch/Disk1/runInstaller报错 :warning: unable to convert from “ UTF-8” TO “ utf8” for NLS!B 11.23/tmp/OraInstall2008-07-20_05-38-03PM. sh: /oracle/setup/patch/Disk1/install/unzip: cannot executeNo such file or directory重新用 /oracle/app/product/9.2.

13、0/bin/unzip p4547809_92080_HPUX_IA64.zip 解压后 , 正常 : 两边做 :rootncdkhdb2:/oracle/oraInventory#./orainstRoot.shCreating the Oracle inventory pointer file (/var/opt/oracle/oraInst.loc Changing groupname of /oracle/oraInventory to dba.rootncdkhdb2:/oracle/oraInventory# 在一个节点上做 :rootncdkhdb2:/oracle/oraInv

14、entory#cd /oracle/app/oracle/product/9.2.0 rootncdkhdb2:/oracle/app/oracle/product/9.2.0#ls *.shroot.shrootncdkhdb2:/oracle/app/oracle/product/9.2.0#./root.shRunning Oracle9 root.sh script.The following environment variables are set as:ORACLE_OWNER= oracleORACLE_HOME= /oracle/app/oracle/product/9.2.

15、0Enter the full pathname of the local bin directory: /usr/local/bin: /usr/bin Copying dbhome to /usr/bin .Copying oraenv to /usr/bin .Copying coraenv to /usr/bin .Creating /etc/oratab file.Adding entry to /etc/oratab file.Entries will be added to the /etc/oratab file as needed byDatabase Configurati

16、on Assistant when a database is createdFinished running generic part of root.sh script.Now product-specific root actions will be performed. 补丁安装成功 .重启机器 .建库 :cd $ORACLE_HOMEcd binnetca(两边都要配 (配一边就可以,自动在两边生成 LISTENER 。 ORA 文件 $ /ORACLE_HOME/BIN/gsdctl startncdkhdb1#oracle>Successfully started the daemon on the local node. $ dbca 在另一台机器上启动 GSD:$ gsdctl start$ 报错 ,PRKC-1021: Problem in the clusterwarefailed to get status of GSD on local node;发现 /dev/dvg1下的裸设备的属性不对 , 改为 ORACLE:DBA且在另一节点上缺少 /VAR/OPT/ORACLE/srvConfig.loc文件 , 考贝 . 两边做 gsdctl stop(两边 srvconfig init f(安装节点 gsdctl start