Oracle10g在rhel5.5上的安装

1、oracle10g在rhel5.5上的安装过程和注意的问题1.具体系统需求 swap 分区不小于2g selinux disable 状态 安装组件包括 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 配置安装包和用户环境 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环境变量 先后执行命令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节中创建的oracle base相同export oracle_home

11、=$oracle_base/product/10.2.0/db_1; # 与第6节中创建的oracle home相同export oracle_sid=orcl # oracle数据库的系统标识符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环境变量export path=$path:$oracle_home/bin:/sbin:/tmp/opatch最后执行命令source .bash_profile，使修改后.bash_profile文件立即生效。6.安装 重起系统，以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/如果不出现登录对话页面,请确保你的数据库服务与监听服务正常启动了注意:如果监听程序不启动,可以通过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启动监听器时使用 lsnrctl stop关闭监听器时使用 sqlplus /no

18、log sql connect / as sysdba sql startup启动oracle服务器时使用 shutdown immediate关闭oracle服务器时使用方法2： su - oracle lsnrctl start启动监听器时使用 lsnrctl stop关闭监听器时使用 dbstart 启动服务器时使用 dbshut关闭oracle服务器时使用 其实方法1是启动/关闭oracle服务器，方法2是启动/关闭系统中的oracle服务。10 卸载oracle/ oracle_home与第7节中oracle_home的意义相同，如/opt/oracle/product/10.1cd oracle_home/oui/binsh runinstaller执行上述命令后又会出现安装向导界面，但需要选择deinstall按钮。再根据你的需要，指定将要被卸载的组件，或者卸载整个oracle。3.安装中要注意一下问题如果在root用户下安装，会报错提示不能在r