《Oracle 10G Install on SuSE10》由会员分享,可在线阅读,更多相关《Oracle 10G Install on SuSE10(15页珍藏版)》请在金锄头文库上搜索。
1、Oracle 10G Install on SuSE10环境anticell-suse: # uname -aLinux anticell-suse 2.6.16.46-0.12-bigsmp #1 SMP Thu May 17 14:00:09 UTC 2007 i686 i686 i386 GNU/Linuxanticell-suse: # free -m total used free shared buffers cachedMem: 4048 1334 2714 056 1109-/+ buffers/cache: 167 3880Swap: 2055 0 2055* Shared
2、为0,后面会碰到问题。花了2个小时查这个问题。* swap 为2055,太小,OS检查无法通过,需要增加Oracle安装过程1、确认各种软件是否已安装C/C+ ToolSuSE 默认安装的gcc libaio2、创建DBA和OINSTALL用户组:groupadd g 202 dbagroupadd g 201 oinstall3创建oracle用户useradd -d /home/oracle g oinstall -G dba -m -p oracle -u 1001 -s /bin/bash oracle修改oracle 用户的密码passwd oracle修改安装软件以及数据库目录权限
3、:新建/opt/oracle目录chown R oracle:dba /opt/oracle*其中默认NLS_LANG=AMERICAN,如果在中文OS下安装界面会产生乱码。建议在英文环境下安装。如果安装界面是乱码的话,到时可先export LC_CTYPE=en_US.UTF-8,再安装即可。4、设置oracle环境变量a、vi .profile最后加入以下export ORACLE_BASE=/opt/oracleexport ORACLE_HOME=$ORACLE_BASE/products/10.2.0/db_1export ORACLE_SID=test01export PATH=$
4、PATH:$HOME/bin:$ORACLE_HOME/binexport LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/libb、编辑/etc/sysctl.conf文件:(修改核心参数,如果没有这个文件,自己vi一个)oraclelinux: more /etc/sysctl.conf# Disable response to broadcasts.# You dont want yourself becoming a Smurf .ipv4.icmp_echo_ignore_broadcasts = 1# enable route verification
5、on all interfacesnet.ipv4.conf.all.rp_filter = 1# enable ipV6 forwarding#net.ipv6.conf.all.forwarding = 1#net.core.rmem_default = 262144net.core.rmem_max = 262144net.core.wmem_default = 262144net.core.wmem_max = 262144kernel.shmall = 2097152kernel.shmmax = 2147483648kernel.shmmni = 4096kernel.sem =
6、250 32000 100 128fs.file-max = 65536net.ipv4.ip_local_port_range = 1024 65000最大共享内存段尺寸(字节):shmmax = xxxxx*1024*2(为内存的2倍,切换到字节。要是超过这个值,在运行dbca时会出现Ora -27123:Unable to attach to shared memeroy segment)-后来看到网上说官方文档建议是内存的1/2,Shmmni 最小共享内存 4096KB.Shmall 所有内存大小,但是我照内存的2倍也能成功安装oracle。#最小共享内存段尺寸(字节)Shmmni4个
7、参数依次为SEMMSL(每个用户拥有信号量最大数);SEMMNS(系统信号量最大数);SEMOPM(每次semopm系统调用操作数);SEMMNI(系统辛苦量集数最大数).注解:可以用sysctl p来确认参数文件/etc/sysctl.conf中的内容,使用#/etc/init.d/boot.sysctl start命令使参数文件中设置的参数生效,在这里要注意的一点是在系统重新启动之后不能自动读取刚才创建的文件。 需要调整一下:#chkconfig boot.sysctl onc、编辑/etc/security/limits.conf文件, 设置oracle对文件的要求linux: # vi
8、 /etc/security/limits.conf# /etc/security/limits.conf#Each line describes a limit for a user in the form:# #Where:# can be:# - an user name# - a group name, with group syntax# - the wildcard *, for default entry# - the wildcard %, can be also used with %group syntax,# for maxlogin limit# can have th
9、e two values:# - soft for enforcing the soft limits# - hard for enforcing hard limits# can be one of the following:# - core - limits the core file size (KB)# - data - max data size (KB)# - fsize - maximum filesize (KB)# - memlock - max locked-in-memory address space (KB)# - nofile - max number of op
10、en files# - rss - max resident set size (KB)# - stack - max stack size (KB)# - cpu - max CPU time (MIN)# - nproc - max number of processes# - as - address space limit# - maxlogins - max number of logins for this user# - priority - the priority to run user process with# - locks - max number of file l
11、ocks the user can hold# #* soft core 0#* hard rss 10000#student hard nproc 20#faculty soft nproc 20#faculty hard nproc 50#ftp hard nproc 0#student - maxlogins 4# End of file#oracle soft nproc 2047#oracle hard nproc 16384#oracle soft nofile 1024#oracle hard nofile 65536#oracle hard nofile 65536 #orac
12、le soft nofile 65536oracle hard nproc 16384oracle soft nproc 16384d、修改/etc/profile文件ulimit n 1024005、启动oracle的xwindows,需要将root注销,用oracle 用户登录启动xwindows:startx,不然无法启动oracle的xwindows,会提示说已经有用户启动xwindows。错误提示如下Fatal server error Server is already active for display 0 When you get an error like Fatal se
13、rver error:Server is already active for display 0If this server is no longer running, remove /tmp/.X0-lock and start again.如果你不注销root可以通过尝试方式This is display number(0, default) and you cant run two display in same system with identical display number. If you want to check if any xserver is really run
14、ning, invoke ps aux | grep cat /tmp/.X0-lock and this will yeild an output164:foo 7977 0.0 0.1 3928 760 pts/1 S+ 23:21 0:00 grep -i -colour -n 14847 foo is users name, the person running that startx session.To run your session, you have two option1) become superuser and kill the the corresponding PID2) or, in a better way, start a different X-session by invoking a command likestartx - :1to start a server with display 1(I will prefer this option).补充下:我是通过vnc安装的,如果是telnet过去的话,远程装的话,还需要xhost + 本机IP6、用oracle用户减压软件包unzip /tmp/oracle/10201_database_linux32.zip7、运行./runInstaller i