CentOS5.4下安装Oracle11g.docx

CentOS5.4下安装Oracle11g一安装CentOS系统，勾选GNOME，x-windows,vi以及开发工具，开发库等基本软件二安装必要的软件包，调整内核参数和Oracle用户资源限制，新建dba和oinstall组，新建oralce用户并设置环境变量！以下的软件包对于CentOS5系统安装Oracle 11g是必要的binutils-2.17.50.0.6compat-libstdc+-33-3.2.3elfutils-libelf-0.125elfutils-libelf-devel-0.125elfutils-libelf-devel-static-0.125gcc-4.1.2gcc-c+-4.1.2glibc-2.5-24glibc-common-2.5glibc-devel-2.5glibc-headers-2.5kernel-headers-2.6.18ksh-20060214libaio-0.3.106libaio-devel-0.3.106libgcc-4.1.2libgomp-4.1.2libstdc+-4.1.2libstdc+-devel-4.1.2make-3.81sysstat-7.0.2unixODBC-2.2.11unixODBC-devel-2.2.11调整内核参数，在/etc/sysctl.conf文件中添加下列参数，并使用sysctl -p命令使其生效kernel.shmall = 268435456kernel.shmall = 2097152kernel.shmmax = 536870912kernel.shmmni = 4096kernel.sem = 250 32000 100 128net.ipv4.ip_local_port_range = 9000 65500net.core.rmem_default = 262144net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048586fs.file-max = 6553600添加Oracle用户和相关的组rootoracle # groupadd oinstallrootoracle # groupadd dbarootoracle # mkdir /u01rootoracle # useradd -g oinstall -G dba -d /u01/oracle oraclerootoracle #passwd oraclerootoracle #chown -R oistall:dba /u01三设置Oracle用户环境变量oracleoracle $ cat .bash_profile# .bash_profile# Get the aliases and functionsif -f /.bashrc ; then. /.bashrcfi# User specific environment and startup programs PATH=$PATH:$HOME/binexport PATHORACLE_BASE=/u01ORACLE_HOME=$ORACLE_BASE/oracleORACLE_SID=salesPATH=$ORACLE_HOME/bin:$PATHexport ORACLE_BASE ORACLE_HOME ORACLE_SID PATHoracleoracle $ env | grep ORAORACLE_SID=salesORACLE_BASE=/u01ORACLE_HOME=/u01/oracle四开始安装1：解压出Linux版Oracle安装包，并将database复制到/u01/oracle目录下，运行/u01/oracle/database目录下的安装脚本runinstallerrootoracle # /u01/oracle/oraInventory/orainstRoot.shChanging permissions of /u01/oracle/oraInventory to 770.Changing groupname of /u01/oracle/oraInventory to oinstall.The execution of the script is complete rootoracle # /u01/oracle/root.shRunning Oracle 11g root.sh script.The following environment variables are set as:ORACLE_OWNER= oracleORACLE_HOME= /u01/oracleEnter the full pathname of the local bin directory: /usr/local/bin:Copying dbhome to /usr/local/bin .Copying oraenv to /usr/local/bin .Copying coraenv to /usr/local/bin .Creating /etc/oratab file.Entries will be added to the /etc/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished running generic part of root.sh script.Now product-specific root actions will be performed.Finished product-specific root actions.五安装数据库1：运行netca,配置网络参数oracleoracle $ ps -eforacle 11768 1 0 08:04 ? 00:00:01 /u01/oracle/bin/tnslsnr LISTENER root 11776 2276 0 08:05 ? 00:00:00 sshd: oracle privoracle 11778 11776 0 08:05 ? 00:00:00 sshd: oraclepts/42:运行dbca，安装数据库oracleoracle $ ps -eforacle 12455 1 0 08:25 ? 00:00:00 ora_pmon_salesoracle 12457 1 0 08:25 ? 00:00:00 ora_vktm_sales oracle 12461 1 0 08:25 ? 00:00:00 ora_diag_salesoracle 12463 1 0 08:25 ? 00:00:00 ora_dbrm_salesoracle 12465 1 0 08:25 ? 00:00:00 ora_psp0_salesoracle 12469 1 0 08:25 ? 00:00:01 ora_dia0_salesoracle 12471 1 0 08:25 ? 00:00:03 ora_mman_salesoracle 12473 1 0 08:25 ? 00:00:03 ora_dbw0_salesoracle 12475 1 0 08:25 ? 00:00:04 ora_lgwr_salesoracle 12477 1 0 08:25 ? 00:00:01 ora_ckpt_salesoracle 12479 1 0 08:25 ? 00:00:01 ora_smon_salesoracle 12481 1 0 08:25 ? 00:00:00 ora_reco_salesoracle 12483 1 0 08:25 ? 00:00:07 ora_mmon_salesoracle 12485 1 0 08:25 ? 00:00:01 ora_mmnl_salesoracle 12487 1 0 08:25 ? 00:00:00 ora_d000_salesoracle 12489 1 0 08:25 ? 00:00:00 ora_s000_salesoracle 12499 1 0 08:25 ? 00:00:00 ora_fbda_salesoracle 12501 1 0 08:25 ? 00:00:00 ora_smco_salesoracle 12503 1 0 08:25 ? 00:00:00 ora_qmnc_salesoracle 12505 1 0 08:25 ? 00:00:00 ora_w000_salesoracle 12519 1 0 08:25 ? 00:00:00 ora_q000_salesoracle 12521 1 0 08:25 ? 00:00:00 ora_q001_salesoracle 12599 1 0 08:26 ? 00:00:02 ora_cjq0_salesoracle 15398 1 0 08:32 pts/2 00:00:00 /u01/oracle/perl/bin/perl /u01/ooracle 15412 15398 18 08:32 pts/2 00:02:05 /u01/oracle/jdk/bin/java -serveroracle 15435 15398 2 08:32 pts/2 00:00:17 /u01/oracle/bin/emagentoracle 15524 1 0 08:33 ? 00:00:05 oraclesales (LOCAL=NO)oracle 15708 1 0 08:33 ? 00:00:00 oraclesales (LOCAL=NO)oracle 15741 1 10 08:33 ? 00:01:03 oraclesales (LOCAL=NO)oracle 15845 1 0 08:33 ? 00:00:04 oraclesales (LOCAL=NO)oracle 16003 1 0 08:35 ? 00:00:00 ora_w001_salesoracle 16042 1 0 08:36 ? 00:00:01 oraclesales (LOCAL=NO)oracle 16052 1 0 08:36 ? 00:00:03 oraclesales (LOCAL=NO)oracle 16055 1 1 08:36 ? 00:00:06 oraclesales (LOCAL=NO)oracle 16076 1 0 08:36 ? 00:00:02 oraclesales (LOCAL=NO)oracle 16079 1 6 08:36 ? 00:00:31 oraclesales (LOCAL=NO)oracle 16085 1 0 08:36 ? 00:00:00 oraclesales (LOCAL=NO)oracle 16087 1 0 08:36 ? 00:00:00 oraclesales (LOCAL=NO)oracle 16138 1 0 08:36 ? 00:00:00 oraclesales (LOCAL=NO)oracle 16140 1 0 08:36 ? 00:00:00 oraclesales (LOCAL=NO)oracle 16143 1 11 08:36 ? 00:00:50 oraclesales (LOCAL=NO)oracle 17091 11779 0 08:44 pts/4 00:00:00 ps -eforacleoracle $ sqlplus /nologSQL*Plus: Release 11.1.0.6.0 - Production on Mon Sep 28 08:45:46 2009Copyright (c) 1982, 2007, Oracle. All rights reserved.SQL conn / as sysdbaConnected.启动脚本# !/bin/bashORACLE_DESC=Oracle 11gcase $1 instart)echo Starting $ORAC