oracle11g安装配置手册

Oracle安装配置手册V1.0版oracle安装配置手册V1.0版第1页共35页目录1安装Oracle前的系统准备工作.............................................................................................21.1检查需要的软件包.......................................................................................................21.2修改系统内核参数.......................................................................................................21.3创建oracle组和用户.................................................................................................31.4创建oracle安装目录.................................................................................................31.5设置oracle用户环境变量.........................................................................................32安装Oracle..............................................................................................................................42.1解压缩安装文件...........................................................................................................42.2安装ORACLE..............................................................................................................43创建数据库.............................................................................................................................103.1配置监听.....................................................................................................................103.2创建数据库实例.........................................................................................................143.3检查oracle实例是否安装成功.................................................................................213.4设置开机自启动数据库实例.....................................................................................214数据库配置.............................................................................................................................224.1数据库基本信息.........................................................................................................224.2修改ORACLE核心参数...........................................................................................224.3建数据库表空间.........................................................................................................234.4建数据库用户.............................................................................................................234.5导入数据.....................................................................................................................234.6用PLSQLDeveloper工具编译失效对象.................................................................234.7修改用户密码.............................................................................................................245系统故障处理.........................................................................................................................245.1数据库文件损坏.........................................................................................................245.2Oracle逻辑结构故障的处理方法：.........................................................................325.3数据库服务器硬件故障.............................................................................................34oracle安装配置手册V1.0版第2页共35页1安装Oracle前的系统准备工作1.1检查需要的软件包以root用户登录系统，使用rpm-q软件包关键词命令进行检测rpm-q--qfbinutilscompat-libstdc++-33elfutils-libelfelfutils-libelf-develgccglibcgcc-c++glibc-commonglibc-develglibc-headerslibaiolibaio-devellibgcclibstdclibstdc++-develmakesysstatunixODBCunixODBC-devel1.2修改系统内核参数在/etc/sysctl.conf中添加以下行：vi/etc/sysctl.conffs.aio-max-nr=1048576fs.file-max=6815744#kernel.shmall=2097152#kernel.shmmax=536870912kernel.shmmni=4096kernel.sem=25032000100128net.ipv4.ip_local_port_range=900065500net.core.rmem_default=262144net.core.rmem_max=4194304net.core.wmem_default=262144net.core.wmem_max=1048586运行下面的命令应用以上OS参数：/sbin/sysctl–p添加以下行到/etc/security/limits.conf文件中：vi/etc/security/limits.conf*softnproc2047*hardnproc16384*softnofile1024*hardnofile65536如果/etc/pam.d/login文件中没有以下行，则添加以下内容：vi/etc/pam.d/loginsessionrequiredpam_limits.so修改/etc/selinux/config文件来关闭linux防火墙，确保SELINUX设置如下：oracle安装配置手册V1.0版第3页共35页vi/etc/selinux/configSELINUX=disabled1.3创建oracle组和用户groupaddoinstallgroupadddbauseradd-goinstall-Gdbaoraclepasswdoracle1.4创建oracle安装目录mkdir/oraclechown-Roracle:oinstall/oraclechmod-R775/oracle1.5设置oracle用户环境变量以oracle用户登陆系统，在.bash_profile文件尾添加以下行：vi/home/oracle/.bash_profile#Getthealiasesandfunctionsif[-f~/.bashrc];then.~/.bashrcfi#UserspecificenvironmentandstartupprogramsORACLE_SID=amdbORACLE_BASE=/oracleORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1exportORACLE_SIDORACLE_BASEORACLE_HOMEPATH=$PATH:$ORACLE_HOME/bin:$HOME/binexportPATHLD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/libexportLD_LIBRARY_PATHCLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlibexportCLASSPATHif[$USER=oracle];thenoracle安装配置手册V1.0版第4页共35页if[$SHELL=/bin/ksh];thenulimit-p16384ulimit-n65536elseulimit-u16384-n65536fifi2安装Oracle2.1解压缩安装文件$mkdir/oracle/soft通过FTP上传安装包到/oracle/soft/目录下使用命令unzip文件名解压安装包unzipp10404530_112030_Linux-x86-64_1of7.zipunzipp10404530_112030_Linux-x86-64_2of7.zip设置oracle帐户可以操作安装文件所在的目录chown-Roracle:oinstal