ºìÁªLinuxÃÅ»§
Linux°ïÖú

oracle °²×°±¸Íü

·¢²¼Ê±¼ä:2007-08-27 00:01:12À´Ô´:ºìÁª×÷Õß:beasept
Òª²é¿´¿ÉÓà RAM ºÍ½»»»¿Õ¼ä´óС£¬ÔËÐÐÒÔÏÂÃüÁ
grep MemTotal /proc/meminfo
grep SwapTotal /proc/meminfo

ÀýÈ磺
# grep MemTotal /proc/meminfo
MemTotal:512236 kB
# grep SwapTotal /proc/meminfo
SwapTotal:1574360 kB

½ÓÏÂÀ´£¬´´½¨ÓÃÓÚ°²×°ºÍά»¤ Oracle 10g Èí¼þµÄ Linux ×éºÍÓû§ÕÊ»§¡£Óû§ÕÊ»§½«³ÆΪ oracle£¬¶ø×齫³ÆΪ oinstall ºÍ dba¡£ÒÔ root Óû§Éí·ÝÖ´ÐÐÒÔÏÂÃüÁ

/usr/sbin/groupadd oinstall
/usr/sbin/groupadd dba
/usr/sbin/useradd -m -g oinstall -G dba oracle
id oracle

ÀýÈ磺
# /usr/sbin/groupadd oinstall
# /usr/sbin/groupadd dba
# /usr/sbin/useradd -m -g oinstall -G dba oracle
# id oracle
uid=501(oracle) gid=501(oinstall) groups=501(oinstall),502(dba)

ÉèÖà oracle ÕÊ»§µÄ¿ÚÁpasswd oracle

ÀýÈ磺
# passwd oracle
Changing password for user oracle.
New password:
Retype new password:
passwd:all authentication tokens updated successfully.

ÒÔ root Óû§Éí·ÝÖ´ÐÐÒÔÏÂÃüÁmkdir -p /u01/app/oracle
mkdir -p /u02/oradata
chown -R oracle:oinstall /u01/app/oracle /u02/oradata
chmod -R 775 /u01/app/oracle /u02/oradata

ÀýÈ磺
# mkdir -p /u01/app/oracle
# mkdir -p /u02/oradata
# chown -R oracle:oinstall /u01/app/oracle /u02/oradata
# chmod -R 775 /u01/app/oracle /u02/oradata

Linux Äں˷dz£³öÉ«¡£Óë´ó¶àÊýÆäËû *NIX ϵͳ²»Í¬£¬Linux ÔÊÐíÔÚϵͳÆô¶¯ºÍÔËÐÐʱÐ޸Ĵó¶àÊýÄں˲ÎÊý¡£Íê³ÉÄں˲ÎÊý¸ü¸Äºó²»±ØÖØÐÂÆô¶¯ÏµÍ³¡£Oracle Êý¾Ý¿â 10g ÐèÒªÒÔÏÂËùʾµÄÄں˲ÎÊýÉèÖá£ÆäÖиø³öµÄÊÇ×îСֵ£¬Òò´ËÈç¹ûÄúµÄϵͳʹÓõÄÖµ½Ï´ó£¬Ôò²»Òª¸ü¸ÄËü¡£

kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000

Èç¹ûÄú°´ÕÕÒÔÉÏ˵Ã÷°²×°ÁË Linux£¬ÇÒÄں˲ÎÊýÈ«²¿²ÉÓÃĬÈÏÖµ£¬ÔòÖ»ÐèÔÚÒÔ root Óû§Éí·ÝµÇ¼ºóÖ´ÐÐÏÂÃüÁî¡£

cat >> /etc/sysctl.conf <kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
EOF
/sbin/sysctl -p

ÀýÈ磺
# cat >> /etc/sysctl.conf <> kernel.shmall = 2097152
> kernel.shmmax = 2147483648
> kernel.shmmni = 4096
> kernel.sem = 250 32000 100 128
> fs.file-max = 65536
> net.ipv4.ip_local_port_range = 1024 65000
> EOF
# /sbin/sysctl -p
net.ipv4.ip_forward = 0
net.ipv4.conf.default.rp_filter = 1
kernel.sysrq = 0
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
/sbin/sysctl -a | grep shm
/sbin/sysctl -a | grep sem
/sbin/sysctl -a | grep file-max
/sbin/sysctl -a | grep ip_local_port_range

ÀýÈ磺
# /sbin/sysctl -a | grep shm
kernel.shmmni = 4096
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shm-use-bigpages = 0
# /sbin/sysctl -a | grep sem
kernel.sem = 250 32000 100 128
# /sbin/sysctl -a | grep file-max
fs.file-max = 65536
# /sbin/sysctl -a | grep ip_local_port_range
net.ipv4.ip_local_port_range = 1024 65000

Èç¹ûϵͳµÄ²ÎÊýÉèÖõıÈÉÏÊö²ÎÊýֵС£¬Ôò±à¼­ /etc/sysctl.conf Îļþ£¬Ìí¼Ó»ò¸ü¸ÄÕâЩ²ÎÊý¡£Íê³Éºó£¬ÔËÐÐÒÔÏÂÃüÁ»î¸ü¸Ä£º/sbin/sysctl -p
ÎÄÕÂÆÀÂÛ

¹²ÓÐ 3 ÌõÆÀÂÛ

  1. boy8239 ÓÚ 2007-08-27 23:35:52·¢±í:

    :handshake :handshake
    Êdz­Ï®ÍøÉϵģ¬²»ÊÇÔ­´´µÄ

  2. JustForLOVE ÓÚ 2007-08-27 21:32:44·¢±í:

    :0L :0L :ha3nd

  3. JustForLOVE ÓÚ 2007-08-27 21:30:50·¢±í:

    :ha3nd