系統(tǒng)大全為您提供??一。安裝centos6.5?x86安裝centos?6?x86,選擇desktop?,選擇?"開發(fā)"?勾選?"開發(fā)工具"和"附加開發(fā)"?兩項(xiàng)。內(nèi)存2G,swap分區(qū)4200M二。安裝ora所需的庫(kù)1.安裝系統(tǒng)包rpm?-q?binutils-2.20.51.0.2?compat-libcap1?compat-libstdc++-33-3.2.3?gcc-4.4.7?gcc-c++-4.4.7?glibc-2.12?glibc-devel-2.12?libgcc?libstdc++-?libstdc++-devel?libgcc?libstdc++-?libstdc++-devel?libaio-0.3.107?libaio-devel-0.3.107?make-3.81?sysstat-9.0.4缺三個(gè)rpm?-ivh?compat-libcap1-1.10-1.i686.rpm?compat-libstdc++-33-3.2.3-69.el6.i686.rpm?libaio-devel-0.3.107-10.el6.i686.rpm2.安裝數(shù)據(jù)庫(kù)驅(qū)動(dòng)包rpm?-q?unixODBC-2.2.14?unixODBC-devel-2.2.14rpm?-ivh?unixODBC-2.2.14*.rpm?unixODBC-devel-2.2.14*.rpm3.安裝ksh包，按照官方文檔，ksh包安裝有誤，可能版本太高不兼容。wget?ftp://sdgtxuyong:xxxxx@192.168.7.66/tools/database/oracle11/ksh-20100621-18.el5.i386.rpmwget?ftp://sdgtxuyong:xxxxx@192.168.7.66/tools/database/oracle11/pdksh-5.2.14-37.el5_8.1.i386.rpmrpm?-ivh?ksh-20100621-18.el5.i386.rpmrpm?-ivh?pdksh-5.2.14-37.el5_8.1.i386.rpm4.安裝字體，解決安裝時(shí)中文亂碼缺少?"中易宋體18030"?v2.01mkdir?-p?/usr/fonts/zh_CN/TrueTypecd?/usr/fonts/zh_CN/TrueTypewget?ftp://sdgtxuyong:xxxxxx@192.168.7.66/tools/database/oracle11/zysong.ttf5.關(guān)閉?iptableschkconfig?iptables?offchkconfig?ip6tables?off三。修改centos內(nèi)核1.修改控制文件vim?/etc/sysctl.confkernel.shmmni?=?8192kernel.sem?=250?32000?100?128fs.file-max?=?6815744net.ipv4.ip_local_port_range?=?9000?65500net.core.rmem_default?=?4194304net.core.rmem_max?=?4194304net.core.wmem_default?=?262144net.core.wmem_max?=?1048576fs.aio-max-nr?=?10485762.修改許可文件vim?/etccuritymits.conf*?soft?nproc?2047*?hard?nproc?16384*?soft?nofile?1024*?hard?nofile?655363.修改登陸安全文件vim?/etc/pam.d/loginsession?required?pam_limits.so4.修改selinuxvim?/etclinux/configSELINUX=disabled5.修改主機(jī)名vim?/etc/hosts?刪除掉所有其他的條目?只留一條192.168.7.72?ora.tralinhotel.cn?ora四。建用戶組和目錄結(jié)構(gòu)等1.建用戶和組，并設(shè)置密碼groupadd?oinstallgroupadd?dbagroupadd?opergroupadd?asmadminuseradd?-g?oinstall?-G?dba,oper,asmadmin?oraclepasswd?oracle2.建目錄結(jié)構(gòu)mkdir?-p?/u01/app/oracle/product/11.2.0/mkdir?/u01/oradatachmod?-R?755?/u01chown?-R?oracle.oinstall?/u013.修改環(huán)境變量vim?/home/oracle/.bash_profileexport?TMP=/tmpexport?TMPDIR=$TMPexport?ORACLE_BASE=/u01/app/oracleexport?ORACLE_HOME=$ORACLE_BASE/product/11.2.0/export?ORACLE_SID=oraexport?PATH=$PATH:$ORACLE_HOME/bin:/usr/local/sbin:/usr/local/binexport?LD_LIBRARY_PATH=$ORACLE_HOMEb:b:/usrb:/usr/localbexport?CLASS_PATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlibexport?LANG="zh_CN.UTF-8"export?ORACLE_TERM=vt100if?[?$USER?=?"oracle"?]?;?thenif?[?$SHELL?=?"/bin/ksh"?]?;?thenulimit?-p?16384ulimit?-n?65536elseulimit?-u?16384?-n?65536fifi4.即時(shí)生效在終端運(yùn)行?/sbin/sysctl?-p?五。安裝ora11g2r1.下載ora11g2rsu?-?oraclewget?ftp://sdgtxuyong:xxxxx@192.168.7.66/tools/database/oracle11/linux_11gR2_database_1of2.zipwget?ftp://sdgtxuyong:xxxxx@192.168.7.66/tools/database/oracle11/linux_11gR2_database_2of2.zipunzip?linux_11gR2_database_1of2.zipunzip?linux_11gR2_database_2of2.zip2.到ui界面，用root開啟xhost+xhost?+3.安裝ora11g2rsu?-?oraclecd?database./runInstaller4.修改tmpfs的分區(qū)大小vim?/etc/fstabtmpfs?default,size=6g?0?0六。安裝sqlplus的翻頁(yè)程序和help補(bǔ)丁1.sqlplus翻頁(yè)程序wget?ftp://sdgtxuyong:xxxxx@192.168.7.66/tools/database/oracle11/rlwrap-0.37.tar.gztar?zxvf?rlwrap-0.37.tar.gz./configuremake?&&?make?install寫入用戶環(huán)境變量#?echo?'alias?sqlplus="rlwrap?sqlplus"'》?/home/oracle/.bash_profile2.安裝幫助?help?用?system登陸@?/sqlplus/admin/help/hlpbld.sql?helpus.sql用法：help?shutdown3.證書bug,瀏覽器提示秘鑰長(zhǎng)度過短，無法使用web版管理certutil?-setreg?chainminRSAPubKeyBitLength?512七。自啟動(dòng)腳本（###待續(xù)）八。常用命令sqlplus?/?as?sysdba1.開啟關(guān)閉startup?nomount?mount?openalter?database?mount?openshutdown?immediate2.監(jiān)聽服務(wù)lsnrctl3.開啟oem監(jiān)控命令emctl?start|stop?dbconsole4.查詢當(dāng)前用戶名和表空間select?username,default_tablespace?from?user_users;5.用戶創(chuàng)建create?user?用戶名?identified?by?口令?[account?lock|unlock]解鎖alter?user?用戶名?account?lock|unlock;授權(quán)grant?CONNECT,?RESOURCE?TO?用戶名；回收revoke?CONNECT,?RESOURCE?FROM?用戶名；???以上就是系統(tǒng)大全給大家介紹的如何使的方法都有一定的了解了吧，好了，如果大家還想了解更多的資訊，那就趕緊點(diǎn)擊系統(tǒng)大全官網(wǎng)吧。??本文來自系統(tǒng)大全http:///如需轉(zhuǎn)載請(qǐng)注明！推薦：win7純凈版