Oracle10g在rhel5.5上的安裝

1、oracle10g在rhel5.5上的安裝過程和注意的問題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 配置主機名和地址 the /etc/hosts file must contain a fully qualified name for theserver: vi /etc/hosts 3設置kernel參數 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版本,因為oracle10g不支持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設置oracle環(huán)境變量 先后執(zhí)行命令su - oracle和vi .bash_profile，在.bash_profile文件的最后面添加入以下內容。# 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數據庫的系統(tǒng)標識符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# 設置oracle中相關命令的path環(huán)境變量export path=$path:$oracle_home/bin:/sbin:/tmp/opatch最后執(zhí)行命令source .bash_profile，使修改后.bash_profile文件立即生效。6.安裝 重起系統(tǒng)，以oracle的身份登錄，進行安裝。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二、啟動數據庫# su - oracle

15、 /以oracle的身份啟動。1,使用em(enterprise managment)1.1啟動em$oracle_home/bin/emctl start dbconsole如果出現下面相關信息,說明服務啟動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/如果不出現登錄對話頁面,請確保你的數據庫服務與監(jiān)聽服務正常啟動了注意:如果監(jiān)聽程序不啟動,可以通過sqlplus登錄,但在此頁面中不能正常顯示.現在你就可以正常使用em了!2,使用isqlplus2.1啟動isqlplus$oracle_home/bin/isqlplusctl start如果出現如下信息,說明正常啟動.

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

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