2. 本章中出现的SQL是进入到sqlplus中的命令提示符，不是命令的组成部分。从sqlplus中退出到linux命令提示符下，输入exit命令，SQLexit 1． 用ROOT超级用户创建用户和组 groupadd oinstall groupadd dba useradd -g oinstall -G dba oracle passwd oracle 2． 设置oracle的系统环境 A．以oracle用户的身份登录，编辑它的.bashrc文件加入以下语句 export ORACLE_BASE/etc/ora9 export ORACLE_HOME/etc/ora9/product/9.2 export PATHORACLE_HOME/binORACLE_HOME/Apache/Apache/binPATH export ORACLE_OWNERoracle export ORACLE_SIDknown export ORACLE_TERMvt100 export LD_ASSUME_KERNEL2.4.1 export THREADS_FLAGnative export LD_LIBRARY_PATH/etc/ora9/product/9.2/libLD_LIBRARY_PATH export PATH/etc/ora9/product/9.2/binPATH export LCen_US export ORACLE_BASE/etc/ora9 export ORACLE_HOME/etc/ora9/product/9.2 export PATHORACLE_HOME/binORACLE_HOME/Apache/Apache/binPATH export ORACLE_OWNERoracle export ORACLE_SIDknown export ORACLE_TERMxterm export THREADS_FLAGnative export LD_LIBRARY_PATH/etc/ora9/product/9.2/libLD_LIBRARY_PATH export PATH/etc/ora9/product/9.2/binPATH export NLS_LANG“simplified chinese“_china.zhs16gbk export ORA_NLS33ORACLE_HOME/ocommon/nls/admin/data LIB,CLASS LD_LIBRARY_PATHORACLE_HOME/lib/lib/usr/lib LD_LIBRARY_PATHLD_LIBRARY_PATH/usr/local/lib export LD_LIBRARY_PATH 3． 运行下面的命令，创建Oracle的安装点mount point mkdir /etc/ora9 mkdir /etc/ora9/product mkdir /etc/ora9/product/9.2 chown –R oracle.oinstall /etc/ora9 //chmod -R 777 /etc/ora9 --mkdir /var/opt/oracle9i --chown oracle.dba /var/opt/oracle9i --chmod 755 /var/opt/oracle9i 4． 拷贝文件到操作系统的/software/backup/oracle9i目录下。
解压数据库文件 cd /software/backup/oracle9i gunzip ship_9204_linux_disk1.cpio.gz gunzip ship_9204_linux_disk2.cpio.gz gunzip ship_9204_linux_disk3.cpio.gz cpio -idmv ship_9204_linux_disk1.cpio cpio -idmv ship_9204_linux_disk2.cpio cpio -idmv /proc/sys/kernel/shmmax cat /proc/sys/kernel/shmmax 1073741824 7． 界面工具的乱码修改 想改几个改几个 先改dbca ---------------------------------------------------- [oracletooth oracle] cd ORACLE_HOME [oracletooth 9.2] cd bin [oracletooth bin] vi dbca ---------------------------------------------------- 将最后一段 Run DBCA JRE_DIR/bin/jre -DORACLE_HOMEOH -DJDBC_PROTOCOLthin -mx64m -classpath CLASS PATH oracle.sysman.assistants.dbca.Dbca ARGUMENTS 改成 Run DBCA java -DORACLE_HOMEOH -DJDBC_PROTOCOLthin -mx64m -classpath CLASS PATH oracle.sysman.assistants.dbca.Dbca ARGUMENTS 再改oemapp [oracletooth bin] vi oemapp 也是最后一段 if [ “1“ “ocmcli“ ] then c JRE -DADMIN_WRLADMIN_WRL -DORACLE_HOMEORACLE_HOME -DORBdisableLoca tortrue -Djdbc.backward_compatible_to_816true JREOPTIONS_STRING -CLASSPATH_Q UAL CLASSPATHADD oracle.sysman.vtx.vtxOemApp.OemApp APPLICATION “2“ “3“ “4“ “5“ “6“ “7“ “8“ “9“ else c JRE -DADMIN_WRLADMIN_WRL -DORACLE_HOMEORACLE_HOME -DORBdisableLoca tortrue -Djdbc.backward_compatible_to_816true JREOPTIONS_STRING -CLASSPATH_Q UAL CLASSPATHADD oracle.sysman.vtx.vtxOemApp.OemApp APPLICATION 2 3 4 5 6 7 8 9 fi 改成 if [ “1“ “ocmcli“ ] then c java -DADMIN_WRLADMIN_WRL -DORACLE_HOMEORACLE_HOME -DORBdisableLoca tortrue -Djdbc.backward_compatible_to_816true JREOP