1、检查操作系统版本[root@ora10g ~]# uname -aLinux ora10g.localdomain 2.6.18-164.el5 #1 SMP Thu Sep 3 02:16:47 EDT 2009 i686 i686 i386 GNU/Linux[root@ora10g ~]# lsb_release-aLSB Version: :core-3.1-ia32:core-3.1-noarch:graphics-3.1-ia32:graphics-3.1-noarchDistributor ID: EnterpriseEnterpriseServerDescription: Enterprise Linux Enterprise Linux Serverrelease 5.4 (Carthage)Release: 5.4Codename: Carthage在Oracle VirtualBox 安装 Oracle 10g For Oracle Linux 5详细图文教程下载
下载在Linux公社的1号FTP服务器里,下载地址:FTP地址:ftp://www.linuxidc.com用户名:www.linuxidc.com密码:www.muu.cc在 2011年LinuxIDC.com11月在Oracle VirtualBox 安装 Oracle 10g For Oracle Linux 5下载方法见 http://www.linuxidc.net/thread-1187-1-1.html2、检查内存大小[root@ora10g ~]# free total used free shared buffers cachedMem: 1035140 339916 695224 0 19824 267012-/+ buffers/cache: 53080 982060Swap: 2096440 0 20964403、 检查磁盘空间利用率,我们打算在/orasoft安装数据库软件我们打算在/oradata目录中存放数据文件和归档日志[root@ora10g ~]# df -hFilesystem Size Used Avail Use% Mounted on/dev/sda7 4.7G 3.0G 1.6G 66% //dev/sda6 2.0G 36M 1.9G 2% /tmp/dev/sda3 4.9G 139M 4.5G 3% /orasoft/dev/sda2 5.8G 141M 5.4G 3% /oradata/dev/sda1 190M 12M 170M 7% /boottmpfs 506M 0 506M 0% /dev/shm4、创建相关的用户及用户组和相关目录,并修改权限和所有者及所属组[root@ora10g ~]# groupadd dba[root@ora10g ~]# groupadd oinstall[root@ora10g ~]# useradd -m -g oinstall -G dba -d /orasoft/home oracle[root@ora10g ~]# passwd oracleChanging password for user oracle.New UNIX password:BAD PASSWORD: it is based on a dictionary wordRetype new UNIX password:passwd: all authentication tokens updated successfully.[root@ora10g ~]# chown -R oracle:oinstall /orasoft/ /oradata/[root@ora10g ~]# chmod -R 755 /orasoft/ /oradata/[root@ora10g ~]# cd/-bash: cd/: No such file or directory[root@ora10g ~]# cd /[root@ora10g /]# ls -rtltotal 162drwxr-xr-x 2 root root 4096 Jan 9 2009 srvdrwxr-xr-x 2 root root 4096 Jan 9 2009 optdrwxr-xr-x 2 root root 4096 Jan 9 2009 mntdrwxr-xr-x 2 root root 4096 Jan 9 2009 mediadrwxr-xr-x 2 root root 4096 Jan 9 2009 homedrwx------ 2 root root 16384 Nov 16 22:40 lost+founddrwxr-xr-x 2 root root 4096 Nov 16 22:41 selinuxdrwxr-xr-x 14 root root 4096 Nov 16 22:46 usrdrwxr-xr-x 3 root root 4096 Nov 16 22:49 tftpbootdrwxr-xr-x 4 root root 1024 Nov 16 22:52 bootdrwxr-xr-x 13 root root 4096 Nov 16 22:53 libdrwxr-xr-x 2 root root 4096 Nov 16 22:53 bindrwxr-xr-x 2 root root 12288 Nov 16 22:53 sbindrwxr-xr-x 23 root root 4096 Nov 16 22:58 vardrwxr-xr-x 3 oracle oinstall 4096 Nov 16 23:00 oradatadr-xr-xr-x 94 root root 0 Nov 16 23:30 procdrwxr-xr-x 11 root root 0 Nov 16 23:30 sysdrwxr-xr-x 2 root root 0 Nov 16 23:31 miscdrwxr-xr-x 2 root root 0 Nov 16 23:31 netdrwxrwxrwt 7 root root 4096 Nov 16 23:31 tmpdrwxr-xr-x 11 root root 3580 Nov 16 23:31 devdrwxr-x--- 6 root root 4096 Nov 16 23:39 rootdrwxr-xr-x 4 oracle oinstall 4096 Nov 16 23:46 orasoftdrwxr-xr-x 99 root root 12288 Nov 16 23:46 etc4、 修改内核参数在文件最后添加如下内容,相关参数介绍将会在后期的oracle安装参数详解中进行介绍,有兴趣的朋友可以继续关注[root@ora10g /]# vi /etc/sysctl.conf--这部分为共享内存参数设置kernel.shmall = 2097152 --共享内存段最大页数kernel.shmmax = 2147483648 --单个共享内存段大小的上限字节数kernel.shmmni = 4096 --共享内存段的最小长度kernel.sem = 250 32000 100 128 --信号量四个值分别代表:semmsl,semmns,semopm,semmnifs.file-max = 65536 --配置系统中打开的最大文件数net.ipv4.ip_local_port_range = 1024 65000 --本地网口限速net.core.rmem_default=262144net.core.rmem_max=262144net.core.wmem_default=262144net.core.wmem_max=262144"/etc/sysctl.conf" 47L, 1280C written[root@ora10g /]# /sbin/sysctl-pnet.ipv4.ip_forward = 0net.ipv4.conf.default.rp_filter = 1net.ipv4.conf.default.accept_source_route = 0kernel.sysrq = 0kernel.core_uses_pid = 1net.ipv4.tcp_syncookies = 1kernel.msgmnb = 65536kernel.msgmax = 65536kernel.shmmax = 4294967295kernel.shmall = 268435456kernel.shmall = 2097152kernel.shmmax = 2147483648kernel.shmmni = 4096kernel.sem = 250 32000 100 128fs.file-max = 65536net.ipv4.ip_local_port_range = 1024 65000net.core.rmem_default = 262144net.core.rmem_max = 262144net.core.wmem_default = 262144net.core.wmem_max = 2621445、 修改安全限制参数这两个参数是对linux用户可以使用的进程数和打开的文件数的设置限制|"GITPUB个人空间MFyl L$k7KL
oxf%O l2UUsoft是软限制:用户可以超过这个设置的值,但一定不能超过hard的值。hard是硬限制:一般soft比hard小。如果用LV管理的话,还需要加上如下两行:
m^$P$D+yf^t/J,Y20674423M$K
c2C&[^doracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netoracle soft memlock 3145728
L.bsqZ20674423x2e_
-------------------------------------------------------------------------------- hB_)sloracle hard memlock 3145728oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net:}3y,Y6]-X0LY[root@ora10g /]# vi /etc/security/limits.conforacle soft nproc 2047 --oracle hard nproc 16384 --单用户可打开的最大进程数为16384个oracle soft nofile 1024 --oracle hard nofile 65536 --可打开最大文件个数65536"/etc/security/limits.conf" 56L, 1903C written7、配置相关的限制[root@ora10g /]# vi/etc/pam.d/loginsession required/lib/security/pam_limits.so ---设置可插入认证模块(PAM)限制session required pam_limits.so ---为oracle设置Shell限制"/etc/pam.d/login" 18L, 722C written8、添加如下系统环境变量[root@ora10g /]# vi /etc/profile# /etc/profileif [ $USER = "oracle" ]; then if [ $SHELL = "/bin/ksh" ]; then ulimit -p 1638 ulimit -n 65536 else ulimit -u 16384 -n 65536 fifi"/etc/profile" 68L, 1205C written
Oracle在不同平台间表空间迁移Oracle中shrink space命令详解相关资讯 Oracle数据库 Oracle入门教程 oracle数据库教???
- Oracle数据库全球化 (03月01日)
- Oracle数据库日期过滤方法性能比较 (02/02/2015 13:20:26)
- Oracle数据库安装中端口被占用问题 (10/29/2014 07:42:24)
| - 在CentOS 6.6上搭建C++运行环境并 (10/10/2015 19:44:40)
- Oracle数据库无法使用localhost和 (11/14/2014 16:39:10)
- 使用SQLT来构建Oracle测试用例 (08/28/2014 06:17:41)
|
本文评论 查看全部评论 (0)