Oracle10g 在linux as 5as 6下的安装

Oracle10g 在linux as 5/as 6下的安装一Oracle安装前配备1.red hat 5下安装时需检查如下安装包make-3.79.1 gcc-3.2.3-34 glibc-2.3.2-95.20 glibc-devel-2.5-12.i386.rpm glibc-headers-2.5-12.i386.rpm 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 libXpm-3.5.5-3.i386.rpm libXp openmotif21-2.1.30-8 setarch-1.3-1 libgomp-4.1.1-52.el5.i386.rpm查询所需安装包与否完整rpm -q gcc make binutils openmotif setarch compat-db compat-gcc compat-gcc-c+ compat-libstdc+ compat-libstdc+-devel libXp 由于缺失的包之间有严格的依赖关系，因此必须按照如下顺序安装缺失的包rpm -Uvh compat-db-4*rpm -Uvh libaio-0*rpm -Uvh compat-libstdc+-33-3*rpm -Uvh glibc-headers-2.5-12.i386.rpmrpm -Uvh glibc-devel-2.5-12.i386.rpmrpm -Uvh compat-gcc-34-3*rpm -Uvh compat-gcc-34-c+-3*rpm -Uvh libXp-1*rpm -Uvh openmotif-2*rpm -Uvh gcc-4*rpm -Uvh glibc-2.5-12.i686.rpmrpm -Uvh libgomp-4.1.1-52.el5.i386.rpmrpm -Uvh gcc-4.1.1-52.el5.i386.rpm安装完毕后仍然提示部分包没有安装，但是不影响使用package compat-gcc is not installedpackage compat-gcc-c+ is not installedpackage compat-libstdc+ is not installedpackage compat-libstdc+-devel is not installed另一种说法：查询所需安装包与否完整rpm -q gcc make binutils openmotif setarch libXp 而对于需要安装的包，按如下核心字搜索和安装即可 compat - libXp - openmotif 所有安装完毕即可(我是这样做的) * 2.red hat 6.1下安装时需检查如下安装包(1).redhat6.1 安装oracle10g 在执行命令./runInstaller安装报如下错误时，需要安装有关补丁包。(2)在red hat 6.1 安装时需要安装如下包rpm -ivh libX11-*rpm -ivh libXt*rpm -ivh libXext-*rpm -ivh libXa-*rpm ivh libXau-*rpm ivh libSM-*rpm ivh libICE-*rpm ivh libXi-*rpm ivh libxcb-*rpm ivh libuuid-* (3)在redhat 6.1上oracle10g 仅安装了以上的包，仍然还是不行的，在安装过程中仍会报缺少包。例如下图(4)red hat 6.1 上安装oracle前 ，建议安装如下包。# rpm -ivh libstdc+-devel-4.4.4-13.el6.i686.rpm -nodeps kernel-headers-2.6.32-71.el6.i686.rpm glibc-headers-2.12-1.7.el6.i686.rpm glibc-devel-2.12-1.7.el6.i686.rpm gnome-icon-theme-2.28.0-2.el6.noarch.rpm dmz-cursor-themes-0.4-4.el6.noarch.rpm sgml-common-0.6.3-32.el6.noarch.rpm libaio-devel-0.3.107-10.el6.i686.rpm ncurses-devel-5.7-3.0208.el6.i686.rpm elfutils-libelf-devel-0.148-1.el6.i686.rpm compat-gcc-34-3.4.6-19.el6.i686.rpm libXxf86misc-1.0.2-1.el6.i686.rpm libXxf86vm-1.1.0-1.el6.i686.rpm libXt-1.0.7-1.el6.i686.rpm libXmu-1.0.5-1.el6.i686.rpm mpfr-2.4.1-6.el6.i686.rpm cpp-4.4.4-13.el6.i686.rpm xorg-x11-xauth-1.0.2-7.1.el6.i686.rpm compat-gcc-34-c+-3.4.6-19.el6.i686.rpm libdaemon-0.14-1.el6.i686.rpm avahi-0.6.25-8.el6.i686.rpm avahi-glib-0.6.25-8.el6.i686.rpm shared-mime-info-0.70-4.el6.i686.rpm libIDL-0.8.13-2.1.el6.i686.rpm ORBit2-2.14.17-3.1.el6.i686.rpm GConf2-2.28.0-6.el6.i686.rpm gnome-vfs2-2.24.2-6.el6.i686.rpm libbonobo-2.24.2-4.el6.i686.rpm libtool-ltdl-2.2.6-15.5.el6.i686.rpm unixODBC-2.2.14-11.el6.i686.rpm gtk2-engines-2.18.4-5.el6.i686.rpm libmcpp-2.7.2-4.1.el6.i686.rpm mcpp-2.7.2-4.1.el6.i686.rpm xorg-x11-server-utils-7.4-15.el6.i686.rpm libXv-1.0.5-1.el6.i686.rpm ConsoleKit-x11-0.4.1-3.el6.i686.rpm xorg-x11-xinit-1.0.9-13.el6.i686.rpm libXp-1.0.0-15.1.el6.i686.rpm libXxf86dga-1.1.1-1.el6.i686.rpm libdmx-1.1.0-1.el6.i686.rpm xorg-x11-utils-7.4-8.el6.i686.rpm compat-db43-4.3.29-15.el6.i686.rpm compat-db42-4.2.52-15.el6.i686.rpm ppl-0.10.2-11.el6.i686.rpm cloog-ppl-0.15.7-1.2.el6.i686.rpm gcc-4.4.4-13.el6.i686.rpm gcc-c+-4.4.4-13.el6.i686.rpm compat-libstdc+-33-3.2.3-69.el6.i686.rpm compat-db-4.6.21-15.el6.i686.rpm gnome-themes-2.28.1-6.el6.noarch.rpm system-icon-theme-6.0.0-2.el6.noarch.rpm system-gnome-theme-60.0.2-1.el6.noarch.rpm unixODBC-devel-2.2.14-11.el6.i686.rpm readline-devel-6.0-3.el6.i686.rpm libgnome-2.28.0-11.el6.i686.rpm2.增长Oracle安装和使用的顾客(1) 新增组和顾客groupadd oinstallgroupadd dbauseradd -g oinstall -G dba -d /home/oracle oraclepasswd oracleuseradd d /home/顾客名 顾客名 u id g 顾客组注意几种命令行的使用：切换顾客：Su 顾客名增长顾客：Useradd: 删除顾客：userdel: rm rf 顾客名修改顾客权限：Chmod R 775 /home/顾客名修改顾客组：chown R oracle:dba /home/oracle /指定文献的所属顾客和所属组修改顾客密码：passwd 顾客名查看顾客：more /etc/passwd 查看顾客组：more /etc/group775代表意思： rwx（4+2+1）：rwx（4+2+1）：rwx（4+2+1）*注意：配备文献用vi命令修改4.修改配备文献(1) /etc/sysctl.conf 行末添加如下内容，已有的修改kernel.shmall = 2097152 kernel.shmmax = kernel.shmmni = 4096 # semaphors: semmsl, semmns, semopm, semmni kernel.sem = 250 3 100 128 fs.file-max = 65536 net.ipv4.ip_local_port_range = 1024 65000 net.core.rmem_default=262144 net.core.rmem_max=262144 net.core.wmem_default=262144 net.core.wmem_max=262144运营下面的命令使得内核参数生效/sbin/sysctl -p (2) /etc/security/limits.conf 行末添加如下内容#use for oracle * soft nproc 2047 * hard nproc 16384 * soft nofile 1024 * hard nofile 65536 (3) /etc/pam.d/login 行末添加如下内容session required pam_limits.so(4) /etc/selinux/config更改 SELINUX=disabled 关闭防火墙，必须的(5) /etc/redhat-release Linux版本信息，5不支持Oracle，安装后可以改回去Red Hat Enterprise Linux AS release 3 (Taroon) 或Red Hat Enterprise Linux AS release 4 (Nahant Update 4)(6) gedit /etc/profile 就是增长JDK配备的文献，在增长JDK配备后紧接着增长如下内容if $USER = oracle ;thenif $SHELL = /bin/ksh ; thenulimit -p 16384ulimit -n 65536elseulimit -u 16384 -n 65536fifi(6) bash_profile 在创立顾客后在顾客的目录下有一种.bash_profile(使用Oracle顾客)并在文献中增长如下内容(ORACLE_BASE是最重要的，她代表Oracle的安装途径)(在安装时就可以创立数据库，如果安装完毕重启，则再启动监听时无法启动，则要注意ORACLE_HOME在数据库安装后要根据实际途径进行修改)ORACLE_BASE=/home/oracle ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1 ORACLE_SID=tspfPATH=$PATH:$HOME/bin:$ORACLE_HOME/bin LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH LD_LIBRARY_PATH二数据的安装执行命令cpio -idmv conn / as sysdbaSqlstartup -启动数据库服务Sqlshutdown immediate-关闭数据库服务$ lsnrctl start -启动监听$ lsnrctl stop -关闭监听$ lsnrctl stauts -查看监听状态7.创立顾客create user ltpf identified by ltpf default tablespace USERS temporary tablespace TEMP profile DEFAULT; grant connect to tspon;-赋权 grant resource to tspon; -赋权8.查看表空间select df.tablespace_name tsname,totalspace totalM,freespace freeM,round(1-freespace/totalspace)*100,2) used% from(select tablespace_name,round(sum(bytes)/1024/1024) totalspace from dba_data_files group by tablespace_name) df,(select tablespace_name,round(sum(bytes)/1024/1024) freespace from dba_free_space group by tablespace_name) fs where df.tablespace_name=fs.tablespace_name;9.扩表空间有两个方式新增数据文献：alter tablespace users add datafile /home/oracle/oradata/pon/users02.dbf size 10g;扩展原数据文献：alter database datafile /home/oracle/oradata/tspf/sysaux01.dbf resize 5G; 这两种仅针对使用文献系统的，对裸设备要慎用！