Oracle 9i Redhat 9安装过程

Oracle9iRedhat9安装过程注:：1.本章中无特别说明,在命令行中出现’$’的为oracle用户登录，出现’#’为root用户登录。2.本章中出现的SQL是进入到sqlplus中的命令提示符，不是命令的组成部分。从sqlplus中退出到linux命令提示符下，输入exit命令，SQLexit1．用ROOT超级用户创建用户和组#groupaddoinstall#groupadddba#useradd-goinstall-Gdbaoracle#passwdoracle2．设置oracle的系统环境A．以oracle用户的身份登录，编辑它的.bashrc文件加入以下语句：exportORACLE_BASE=/etc/ora9exportORACLE_HOME=/etc/ora9/product/9.2exportPATH=$ORACLE_HOME/bin:$ORACLE_HOME/Apache/Apache/bin:$PATHexportORACLE_OWNER=oracleexportORACLE_SID=knownexportORACLE_TERM=vt100exportLD_ASSUME_KERNEL=2.4.1exportTHREADS_FLAG=nativeexportLD_LIBRARY_PATH=/etc/ora9/product/9.2/lib:$LD_LIBRARY_PATHexportPATH=/etc/ora9/product/9.2/bin:$PATHexportLC=en_US====================================================================exportORACLE_BASE=/etc/ora9exportORACLE_HOME=/etc/ora9/product/9.2exportPATH=$ORACLE_HOME/binORACLE_HOME/Apache/Apache/bin:$PATHexportORACLE_OWNER=oracleexportORACLE_SID=knownexportORACLE_TERM=xtermexportTHREADS_FLAG=nativeexportLD_LIBRARY_PATH=/etc/ora9/product/9.2/lib:$LD_LIBRARY_PATHexportPATH=/etc/ora9/product/9.2/bin:$PATHexportNLS_LANG=simplifiedchinese_china.zhs16gbkexportORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data#LIB,CLASSLD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/libLD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/libexportLD_LIBRARY_PATH3．运行下面的命令，创建Oracle的安装点(mountpoint)：#mkdir/etc/ora9#mkdir/etc/ora9/product#mkdir/etc/ora9/product/9.2#chown–Roracle.oinstall/etc/ora9//chmod-R777/etc/ora9--#mkdir/var/opt/oracle9i--#chownoracle.dba/var/opt/oracle9i--#chmod755/var/opt/oracle9i4．拷贝文件到操作系统的/software/backup/oracle9i目录下。解压数据库文件#cd/software/backup/oracle9i#gunzipship_9204_linux_disk1.cpio.gz#gunzipship_9204_linux_disk2.cpio.gz#gunzipship_9204_linux_disk3.cpio.gz#cpio-idmvship_9204_linux_disk1.cpio#cpio-idmvship_9204_linux_disk2.cpio#cpio-idmvship_9204_linux_disk3.cpio将生成三个文件夹：DISK1,DISK2,DISK35．安装系统字体解决中文乱码的问题将文件解压到/tmp/javacn中，解压后的结果如下所示：----------------------------------------------------[root@toothroot]#cd/tmp[root@toothroot]#cdjavacn[root@toothjavacn]#ls-l-----------------------------------------------------rw-r--r--1rootroot81021970-01-01font.propertiesdrwxr-xr-x9rootroot40966月2415:36j2sdk1.4.2_02-rw-r--r--1rootroot126422041970-01-01SimSun18030.ttc-rw-r--r--1rootroot105003521970-01-01simsun.ttc-rw-r--r--1rootroot77641970-01-01sm.sh-rw-r--r--1rootroot2604721970-01-01tahomabd.ttf-rw-r--r--1rootroot2655281970-01-01tahoma.ttf剩下的操作就是执行/tmp/javacn/sm.sh了。在执行sm.sh后系统后自动重启，所以在执行下面的操作前请一定保存正在进行的工作！6．安装必须支持Xwindows运行很多X程序都提示Xlib:connectionto:0.0refusedbyserver。解决办法：用平时用的账户登录，然后在终端输入以下命令，就可以搞定了！xhostlocal:oraclenon-networklocalconnectionsbeingaddedtoaccesscontrollist再试试suoracle$.DISK1$./runInstaller[usr/local/bin]：直接回车。下面是运行后的页面。ora-27123:unabletoattachtosharedmemorysegmentORA-27123:unabletoattachtosharedmemorysegment.Itemporarelyincreasedtheshmmaxsettingforthekernelbyexecutingthefollowingcommand:$su-root#cat/proc/sys/kernel/shmmax33554432#echo`expr1024\*1024\*1024`/proc/sys/kernel/shmmax#cat/proc/sys/kernel/shmmax10737418247．界面工具的乱码修改想改几个改几个先改dbca----------------------------------------------------[oracle@toothoracle]$cd$ORACLE_HOME[oracle@tooth9.2]$cdbin[oracle@toothbin]$vidbca----------------------------------------------------将最后一段#RunDBCA$JRE_DIR/bin/jre-DORACLE_HOME=$OH-DJDBC_PROTOCOL=thin-mx64m-classpath$CLASSPATHoracle.sysman.assistants.dbca.Dbca$ARGUMENTS改成：#RunDBCAjava-DORACLE_HOME=$OH-DJDBC_PROTOCOL=thin-mx64m-classpath$CLASSPATHoracle.sysman.assistants.dbca.Dbca$ARGUMENTS==========================================再改oemapp[oracle@toothbin]$vioemapp也是最后一段if[$1=ocmcli]thenexec$JRE-DADMIN_WRL=$ADMIN_WRL-DORACLE_HOME=$ORACLE_HOME-DORBdisableLocator=true-Djdbc.backward_compatible_to_816=true$JREOPTIONS_STRING-$CLASSPATH_QUAL$CLASSPATHADDoracle.sysman.vtx.vtxOemApp.OemApp$APPLICATION$2$3$4$5$6$7$8$9elseexec$JRE-DADMIN_WRL=$ADMIN_WRL-DORACLE_HOME=$ORACLE_HOME-DORBdisableLocator=true-Djdbc.backward_compatible_to_816=true$JREOPTIONS_STRING-$CLASSPATH_QUAL$CLASSPATHADDoracle.sysman.vtx.vtxOemApp.OemApp$APPLICATION$2$3$4$5$6$7$8$9fi改成：if[$1=ocmcli]thenexecjava-DADMIN_WRL=$ADMIN_WRL-DORACLE_HOME=$ORACLE_HOME-DORBdisableLocator=true-Djdbc.backward_compatible_to_816=true$JREOPTIONS_STRING-$CLASSPATH_QUAL$CLASSPATHADDoracle.sysman.vtx.vtxOemApp.OemApp$APPLICATION$2$3$4$5$6$7$8$9elseexecjava-DADMIN_WRL=$ADMIN_WRL-DORACLE_HOME=$ORACLE_HOME-DORBdisableLocator=true-Djdbc.backward_compatible_to_816=true$JREOPTIONS_STRING-$CLASSPATH_QUAL$CLASSPATHADDoracle.sysman.vtx.vtxOemApp.OemApp$APPLICATION$2$3$4$5$6$7$8$9Fi=======================================================最后，是netca[oracle@toothbin]$vinetca还是最后一段#RunNetConfigurationAssistantcd$NETTOOLSDIR$JRE-classpath$CLASSPATHoracle.net.ca.NetCA$*exit$status改成#RunNetConfigurationAssistantcd$NETTOOLSDIRjava-classpath$CLASSPATHoracle.net.ca.NetCA$*exit$status个人已经实现oracle中文安装和oracle中文界面的设置，安装文档完全可以实现8．手工启动Oracle例程$sqlplus/nologSQLconnect/assysdbaSQLstartupSQLexit9．手工启动Oracle侦听$lsnrctlstart10．手工关闭Oracle例程使用数据库前通过执行上面两步启动oracle例程，当使用完毕后用下列命令关闭：$sqlplus/nolo