linuxÏ°²×°oracle10xe°æ
radhat 5.2Ï°²×°oracle10g
1¡¢ÏµÍ³ÐèÇó£º
Äڴ棺ÖÁÉÙ512mb£¬ÍƼöÓÃ1g£»
Ó²ÅÌ£º·þÎñÆ÷ÖÁÉÙ60g£»
£¨Ò»°ãÇé¿öÏÂÓ²¼þ¶¼ÄÜ·ûºÏÒªÇó£©
Èí¼þ°ü£ºglibc-2.3.2, libaio-0.3.96
½»»»¿Õ¼ä:
RAM: 0~256MB, SWAP: 3 ±¶ RAM ´óС
RAM: 256~512MB, SWAP: 2 ±¶ RAM ´óС
RAM: >=512MB, SWAP: 1024 MB
°²×°ÒÀÀµÈí¼þ°ü
rpm –ivh libaio-0.3.96.i386.rpm
rpm –ivh glibc-2.3.2.i386.rpm
ʵ¼ÊÉÏÒª°²×°ÕâÁ½¸öÈí¼þ°ü»¹ÐèÒª°²×°ÆäËûһЩÈí¼þ£¬¾ßÌåµÄÈí¼þÎÒ¶¼¼Ç¼ÔÚÒÑ°²×°ºÃµÄÄÇ̨µçÄÔÖÐÁË£»
´´½¨ 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
´´½¨Ä¿Â¼
ÒÔ 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
ÅäÖà Linux Äں˲ÎÊý
ÒÔ root Óû§Éí·ÝµÇ¼ºóÖ´ÐÐÏÂÃüÁî¡£
cat >> /etc/sysctl.conf <<EOF
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
ÒÔ root Óû§Éí·ÝÔËÐÐÒÔÏÂÃüÁîÀ´ÑéÖ¤ÉèÖãº
/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
Ϊoracle Óû§ÉèÖà Shell ÏÞÖÆ
Oracle ½¨Òé¶Ôÿ¸ö Linux ÕÊ»§¿ÉÒÔʹÓõĽø³ÌÊýºÍ´ò¿ªµÄÎļþÊýÉèÖÃÏÞÖÆ¡£Òª½øÐÐÕâЩ¸ü¸Ä£¬ÒÔ root Óû§µÄÉí·ÝÖ´ÐÐÏ
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
¿Î³Ì¼ò½é
RH033 ºìñÆóÒµLinux»ù´¡¿Î³Ì
ÊʺÏûÓÐʹÓÃLinux »ò UNIX ÃüÁîÐеľÑ飬µ«ÏëÕÆÎÕʹÓúͶ¨Öƺìñ Linux¹¤×÷Õ¾»·¾³ËùÐè¼¼ÄܵÄÈËÔ±¡£
RH133 ϵͳ¹ÜÀí
ÊÊÓÃÓÚÏëͨ¹ýѧϰºìñÆóÒµLinux µÄϵͳ¹ÜÀí¼¼ÄÜ£¬×Ô¼º¿ÉÒÔÔÚÏÖÓÐÍøÂçÖÐÌí¼ÓºÍÅäÖù¤×÷Õ¾µÄÓû§¡£
ÕâÒ»¿Î³ÌµÄ×îºóÒ»ÌìΪ RH202 ºìñÈÏÖ¤¼¼Ê¦ÈÏÖ¤²Ù×÷¿¼ÊÔ¡£
RH ......
1. ×¼±¸¹¤×÷£º
¿ª·¢°åµÄipÉèÖÃ
gzsd> net set ipaddr 192.168.0.11 ÉèÖÿª·¢°åµÄIP
gzsd> net set serverip 192.169.0.10 ÉèÖÃtftp serverµÄIP
gzsd> net set netmask 255.255.255.0 ÉèÖÃ×ÓÍøÑÚÂë
gzsd> net save ±£´æÉèÖÃ
gzsd> net ping XXX ²âÊÔÁ¬½Ó×´¿ö
°²×°tftp·þÎñÆ÷
windowsÏÂ
ÔËÐйâÅ̹¤¾ß ......
QQ:1156316388 Tel:010-51527259
Ò»¡¢Æô¶¯
Èý¸öÃüÁ
1¡¢sqlplux /nolog
2¡¢connect /as sysdba
3¡¢startup
¶þ¡¢¹Ø±Õ
1¡¢shutdown immediate;
[oracle@zhao ......