Oracle10g在rhel5.5上的安裝

1、oracle10g在rhel5.5上的安裝過(guò)程和注意的問(wèn)題1.具體系統(tǒng)需求 swap 分區(qū)不小于2g selinux disable 狀態(tài) 安裝組件包括 gnome desktop environment editors graphical internet text-based internet development libraries development tools legacy software development server configuration tools administration tools base legacy software support syste

2、m tools x window system在rhel5.5中瀏覽器用的是firefox3.6版本的.2.安裝步驟 1 解包文件 unzip 10201_database_linux32.zip 2 配置主機(jī)名和地址 the /etc/hosts file must contain a fully qualified name for theserver: vi /etc/hosts 3設(shè)置kernel參數(shù) add the following lines to the /etc/sysctl.conf file: vi /etc/sysctl.confkernel.shmall = 2097

3、152kernel.shmmax = 2147483648kernel.shmmni = 4096# semaphores: semmsl, semmns, semopm, semmnikernel.sem = 250 32000 100 128fs.file-max = 65536net.ipv4.ip_local_port_range = 1024 65000net.core.rmem_default=262144net.core.rmem_max=262144net.core.wmem_default=262144net.core.wmem_max=262144run the follo

4、wing command to change the current kernel parameters:/sbin/sysctl -padd the following lines to the /etc/security/limits.conf file: vi /etc/security/limits.conf* soft nproc 2047* hard nproc 16384* soft nofile 1024* hard nofile 65536add the following line to the /etc/pam.d/login file, if it does not a

5、lready exist: vi /etc/pam.d/loginsession required /lib/security/pam_limits.sodisable secure linux by editing the /etc/selinux/config file, making sure the selinux flag is set as follows: vi /etc/selinux/configselinux=disabledalternatively, this alteration can be done using the gui tool (system admin

6、istration security level and firewall). click on the selinux tab and disable the feature. 4 配置安裝包和用戶環(huán)境 install the following packages:# from redhat as5 disk 1cd /media/cdrom/serverrpm -uvh setarch-2*rpm -uvh make-3*rpm -uvh glibc-2*rpm -uvh libaio-0*cd /eject# from redhat as5 disk 2cd /media/cdrom/s

7、erverrpm -uvh compat-libstdc+-33-3*rpm -uvh compat-gcc-34-3*rpm -uvh compat-gcc-34-c+-3*rpm -uvh gcc-4*rpm -uvh libxp-1*cd /eject# from redhat as5 disk 3cd /media/cdrom/serverrpm -uvh openmotif-2*rpm -uvh compat-db-4*cd /eject在linux的console中新建下列用戶和群組create the new groups and users:groupadd oinstallg

8、roupadd dbauseradd -g oinstall -g dba oraclepasswd oraclecreate the directories in which the oracle software will be installed:mkdir -p /u01/app/oracle/product/10.2.0/db_1chown -r oracle.oinstall /u01 login as root and issue the following command: xhost + 修改linux版本,因?yàn)閛racle10g不支持rhel5.5的安裝，支持rhel4的安

9、裝.所以要做一下修改.edit the /etc/redhat-release file replacing the current release information (red hat enterprise linux server release 5 (tikanga) with the following: vi /etc/redhat-releaseredhat-4設(shè)置oracle環(huán)境變量 先后執(zhí)行命令su - oracle和vi .bash_profile，在.bash_profile文件的最后面添加入以下內(nèi)容。# set the ld_assume_kernel environ

10、ment variable only for red hat 9 and# for red hat enterprise linux advanced server 3 (rhel as 3) !# use the linuxthreads with floating stacks implementation instead of nptl:export ld_assume_kernel=2.4.1# oracle environmentexport oracle_base=/u01/app/oracle # 該值與第6節(jié)中創(chuàng)建的oracle base相同export oracle_home

11、=$oracle_base/product/10.2.0/db_1; # 與第6節(jié)中創(chuàng)建的oracle home相同export oracle_sid=orcl # oracle數(shù)據(jù)庫(kù)的系統(tǒng)標(biāo)識(shí)符export oracle_term=xterm# export tns_admin= set if sqlnet.ora, tnsnames.ora, etc.# are not in $oracle_home/network/adminexport nls_lang=americanexport ora_nls33=$oracle_home/ocommon/nls/admin/datald_lib

12、rary_path=$oracle_home/lib:/lib:/usr/libld_library_path=$ld_library_path:/usr/local/libexport ld_library_path# 設(shè)置oracle中相關(guān)命令的path環(huán)境變量export path=$path:$oracle_home/bin:/sbin:/tmp/opatch最后執(zhí)行命令source .bash_profile，使修改后.bash_profile文件立即生效。6.安裝 重起系統(tǒng)，以oracle的身份登錄，進(jìn)行安裝。installationlog into the oracle user

13、. if you are using x emulation then set the display environmental variable:display=:0.0; export displaystart the oracle universal installer (oui) by issuing the following command in the database directory:./runinstallerduring the installation enter the appropriate oracle_home and name then continue

14、installation. for7.post installationedit the /etc/redhat-release file restoring the original release information:red hat enterprise linux server release 5 (tikanga)edit the /etc/oratab file setting the restart flag for each instance to y:orcl:/u01/app/oracle/product/10.2.0/db_1:y二、啟動(dòng)數(shù)據(jù)庫(kù)# su - oracle

15、 /以oracle的身份啟動(dòng)。1,使用em(enterprise managment)1.1啟動(dòng)em$oracle_home/bin/emctl start dbconsole如果出現(xiàn)下面相關(guān)信息,說(shuō)明服務(wù)啟動(dòng)tz set to prcoracle enterprise manager 10g database control release .0copyright (c) 1996, 2004 oracle corporation. all rights reserved.http:/localhost.localdomain:5500/em/console/aboutapp

16、licationstarting oracle enterprise manager 10g database control . started.1.2使用em在瀏覽器地址中輸入如下地址:http:/localhost.localdomain:5500/em/console/如果不出現(xiàn)登錄對(duì)話頁(yè)面,請(qǐng)確保你的數(shù)據(jù)庫(kù)服務(wù)與監(jiān)聽(tīng)服務(wù)正常啟動(dòng)了注意:如果監(jiān)聽(tīng)程序不啟動(dòng),可以通過(guò)sqlplus登錄,但在此頁(yè)面中不能正常顯示.現(xiàn)在你就可以正常使用em了!2,使用isqlplus2.1啟動(dòng)isqlplus$oracle_home/bin/isqlplusctl start如果出現(xiàn)如下信息,說(shuō)明正常啟動(dòng).

17、isql*plus .0copyright (c) 2004 oracle. all rights reserved.starting isql*plus .isql*plus started.2.2使用isqlplus在瀏覽器地址中輸入如下地址:http:/localhost.localdomain:5560/isqlplus/這樣就出現(xiàn)了isqlplus的登錄界面,就可使用isqlplus了下面是命令行下的啟動(dòng)/關(guān)閉oracle服務(wù)器方法1： su - oracle lsnrctl start啟動(dòng)監(jiān)聽(tīng)器時(shí)使用 lsnrctl stop關(guān)閉監(jiān)聽(tīng)器時(shí)使用 sqlplus /no

18、log sql connect / as sysdba sql startup啟動(dòng)oracle服務(wù)器時(shí)使用 shutdown immediate關(guān)閉oracle服務(wù)器時(shí)使用方法2： su - oracle lsnrctl start啟動(dòng)監(jiān)聽(tīng)器時(shí)使用 lsnrctl stop關(guān)閉監(jiān)聽(tīng)器時(shí)使用 dbstart 啟動(dòng)服務(wù)器時(shí)使用 dbshut關(guān)閉oracle服務(wù)器時(shí)使用 其實(shí)方法1是啟動(dòng)/關(guān)閉oracle服務(wù)器，方法2是啟動(dòng)/關(guān)閉系統(tǒng)中的oracle服務(wù)。10 卸載oracle/ oracle_home與第7節(jié)中oracle_home的意義相同，如/opt/oracle/product/10.1cd oracle_home/oui/binsh runinstaller執(zhí)行上述命令后又會(huì)出現(xiàn)安裝向?qū)Ы缑?，但需要選擇deinstall按鈕。再根據(jù)你的需要，指定將要被卸載的組件，或者卸載整個(gè)oracle。3.安裝中要注意一下問(wèn)題如果在root用戶下安裝，會(huì)報(bào)錯(cuò)提示不能在r