內(nèi)容說明centos安裝oracle10g

Linux(centos6.5)安裝oracle10G_64 /.help/CentOS6-Base-163yum#cd#mv/home/www/ftpfile/CentOS6-Base-163.repoCentOS-yum#yumcleanall#yummakecache#yumupdate#yum-yinstallbinutilscompat-libstdc++-33compat-33.i686elfutils-libelfelfutils-libelf-develgccgcc-c++glibc monglibc-develglibc-devel.i686glibc-headerskshlibaiolibaio.i686libaio-devellibaio-devel.i686libgcclibgcc.i686libstdc++libstdc++.i686libstdc++-develmakesysstat#yuminstall#yum-yinstalllibXp.i686#yum-yinstall#yum-yinstall sysctl.conf配置文件:#vim/etc/sysctl.conf#useforOraclekernel.shmall=kernel.shmmax=kernel.shmmni=4096kernel.sem=25032000100net.ipv4.ip_local_port_range=102465000net.core.rmem_default=net.core.rmem_max=net.core.wmem_default=262144net.core.wmem_max=#sysctl- limits.conf配置文件.此文件用于設(shè)置系統(tǒng)資源限制.#vi/etc/security/limits.conforaclesoftnproc2047oraclehardnproc16384oraclesoftnofile1024oraclehardnofile /etc/pam.d/login文件:#vi/etc/pam.d/loginsessionrequired/lib/security/pam_limits.sosessionrequiredpam_limits.so#groupaddoinstall#groupadd#useradd-goinstall-Gdba修改#passwd/etc/profile#vim/etc/profileif[$USER="oracle"];if[$S="/bin/ksh"];thenulimit-p16384ulimit-n

ulimit-u16384-n注意:如果文件是不能修改的.保存時(shí)輸入:wq!修改Linux版本.因?yàn)镺racle10G的時(shí)候,Centos6.5還沒有發(fā)行.所以必須修改:#vim/etc/redhat-創(chuàng)建oralce安裝 #mkdir-p/software/app/oracle/#chown-Roracle:oinstall/software/app/oracle/#od-R775/software/app/oracle/Oracle#vi#OracleSettingsexportTMP=/tmp;exportTMPDIR=$TMP;exportexportORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1;exportORACLE_SID=orcl;exportORACLE_TERM=xterm;exportPATH=/usr/sbin:$PATH;exportexportLD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib;#source將的10201_database_linux_x86_64.cpio.gz(數(shù)據(jù)庫安裝文件)到/software/app/oracle/ 我是從FTP #cpgz#gzip-dcpio#cpio-idmv<databaseoracle#chown-Roracle:oinstalloralce#su-oracle$cd$注意:如果執(zhí)行此命令時(shí)出現(xiàn)此錯(cuò)誤(DISYnotset.PleasesettheDISYandtryagain):root#su#exportDISY=:0.0#xhost+suoracle)oracle行./runInstaller.注意:如果安裝時(shí)出現(xiàn)以下錯(cuò)誤:root#yum-yinstall(libXt.so.6)#yum-yinstalllibXt.i686注意:如果安裝時(shí)出現(xiàn)以下錯(cuò)誤:#yum-yinstallOracle./runInstaller面.用戶進(jìn)行選擇安裝.選 存 ,這里不用選擇,系統(tǒng)已經(jīng)自動(dòng)填充了.直接下一步選擇安 ,因?yàn)樵趏ralce用戶的環(huán)境變量里已經(jīng)指定了($/home/oracle/.bash_profile).這里一定要注意,要修改數(shù)據(jù)庫字符集編碼 其他的不選設(shè)置數(shù)據(jù)庫連接65%BUG.Continue(roothosts#vim/etc/hosts#主機(jī)地址主機(jī)名稱44root#idoracleoracledbaid為dbaid,echo"501">retry16.rootsh#cd/software/app/racle/oraInventory/#./orainstRoot.sh#sh+x連接地址:或者:主機(jī)名:5560/isqlplus/如:$lsnrctlstatus查看數(shù)據(jù)庫狀態(tài)$lsnrctlstart開啟$lsnrctlstop關(guān)閉oralce創(chuàng)建表空間存 $mkdir$sqlplus"/ascreatetemporarytablespacetemp_tablespasesize1024mautoextendonnext100mmaxsize10240mextentmanagementcreatetablespacetest_tablespaceloggingsize1024mautoextendonnext100mmaxsize10240mextentmanagementcreateuserzoooqidentifiedbyzoooqdefaulttablespacetest_tablespacetemporarytablespac