Oracle实用技巧V0.1.0406.docVIP

软件安装 Fedora 16安装oracle 1G 1.1 准备工作 按照要求，对版本/etc/redhat-release文件进行修改 安装必须的系统组件 系统调优/etc/sysctl.conf, /etc/security/limits.conf 软件安装组与用户创建 环境变量创建 1.2 Others Others 3. /etc/pam.d/login session required pam_limits.so --------------------------------------------------------- 4. /etc/security/limits.conf oracle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 1024 oracle hard nofile 65536 -------------------------------------------------------- 6. /etc/selinux/config SELINUX=disabled ------------------------------------------------------ 7. /etc/redhat-release redhat release 5 ----------------------------------------------------- 8. mkdir -p /app/oracle/product/10.2.0/db_1 chown -R oracle:oinstall /app chmod -R 775 /app ----------------------------------------------------------- 9. .bash_profile # Oracle Settings TMP=/tmp; export TMP TMPDIR=$TMP; export TMPDIR ORACLE_HOSTNAME=; export ORACLE_HOSTNAME ORACLE_UNQNAME=dbhome_1; export ORACLE_UNQNAME ORACLE_BASE=/app/oracle; export ORACLE_BASE ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1; export ORACLE_HOME ORACLE_SID=dbhome_1; export ORACLE_SID ORACLE_TERM=xterm; export ORACLE_TERM PATH=/usr/sbin:$PATH; export PATH PATH=$ORACLE_HOME/bin:$PATH; export PATH LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH 一、安装oracle 10G 软件要求 依据官方的安装文档要求，系统上必须具有下面的软件包： binutils libaio, libaio-devellibXp-1.0.0-8.1.el5.i386.rpm libXp-devel-1.0.0-8.1.el5.i386.rpm ksh sysstat unixODBC, unixODBC-devel compat-libstdc++-33 gcc-3.2.3-34 gcc-c++-3.2.3-34 glibc-2.3.2-95.20 make-3.79.1 openmotif21-2.1.30-8 setarch-1.3-1 compat-db-4.0.14-5 compat-gcc-7.3-2.96.128 compat-gcc-c++-7.3-2.96.128 compat-libstdc++-7.3-2.96.128 compat-libstdc++-devel-7.3-2.96.128 查找到没有的包，就从上去下载吧，我就是从这上面下载的这四个包，虽然这些包的说明是给fedora core 3的，用在rhel4上也没有问题。 compat-gcc-8-.i386.rpm compat-gcc-c++-8-.i386.rpm compat-libstdc++-8-.i386.rpm compat-libstdc++-devel-8-.i386.rpm 创建用户和修改环境变量 # /usr/sbin/groupadd oinstall /创建