Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

LinuxÏÂOracleµÄ°²×°Ïêϸ²½Öè

 
1.       ϵͳÅäÖùý³Ì
2.1. oracle°²×°Ìõ¼þ¼ì²é
2.1.1.               Ó²¼þ¼ì²é
¼ì²éÓ²¼þÇé¿öÊÇ·ñ·ûºÏoracle 10g µÄ°²×°ÒªÇó¡£ÒÔrootµÇ¼ϵͳ£¬ÓÃϱíÃüÁîÊä³öµÄÖµÓ¦´óÓÚ»òµÈÓÚ½¨ÒéÖµ¡£
¼ì²éÏîÄ¿
ÃüÁî/·½·¨
½¨ÒéÖµ
ÄÚ´æ
#grep MemTotal /proc/meminfo
1GB
½»»»·ÖÇø
#grep SwapTotal /proc/meminfo
1.5±¶ÄÚ´æ´óС
/tmpĿ¼¿ÕÏÐÇø
#df –k /tmp
400MB
Ó²ÅÌ¿ÕÏпռä
#df -k
4GB
 
 
 
 
 
 
2.1.2.               Èí¼þ¼ì²é
2.1.2.1.  ϵͳÈí¼þ°ü¼ì²é
¶ÔSUSE Linux Enterprise 10ÐèÒªÈçϵÄÈí¼þ°ü£º
binutils-2.15.90.0.1.1-32.5
gcc-3.3.3-43.24
gcc-c++-3.3.3-43.24
glibc-2.3.3-98.28
gnome-libs-1.4.1.7-671.1
libstdc++-3.3.3-43.24
libstdc++-devel-3.3.3-43.24
make-3.80-184.1
pdksh-5.2.14-780.1
sysstat-5.0.1-35.1
xscreensaver-4.16-2.6
libaio-0.3.105-2
Ò»°ãÇé¿öϳýÁË compatºÍlibaioµÄһЩ°üûÓа²×°Í⣬ÆäËûµÄ°ü¶¼ÒѾ­°²×°ÁË£¬¿ÉÒÔʹÓÃÕâ¸öÃüÁî½øÐвéѯ£»
¶ÔRedHatEL 5À´Ëµ£¬ÐèÒªÒÔϰü£¨°´Ë³Ðò°²×°£©£º
1.      Kernel-header-2.6.18-128.wl5.i386.rpm
2.      glibc-headers-2.5-34.i386.rpm
3.      glibc-devel-2.5-24.i386.rpm
4.      glibc-2.5-34.i386.rpm
5.      libaio-0.3.106-3.2.i386.rpm
6.      libgomp-4.3.2.7-7.el5.i386.rpm
7.      libxp-1.0.0-8.1.el5.i386.rpm
8.      openmotif-2.3.1-2.el5.i386.rpm
9.      compat-gcc-3.4.6-4.i386.rpm
10.  compat-gcc-34-c+-3.4.6-4.i386.rpm
11.  compat-libf2c-34-3.4.6-4.i386.rpm
12.  compat-gcc-34-g77-3.4.6-4.i386.rpm
13.  compat-libstdcff-33-3.3.3-6c.i386.rpm
14.  gcc-4.1.2-44.el5.i386.rpm
 
¼ì²éÒѰ²×°µÄ°ü  # rpm -q package_name
°²×°ËùÐè°ü(ÉϱíËùÁÐ)   &n


Ïà¹ØÎĵµ£º

LinuxÉ豸ģÐÍÖ®input×ÓϵͳÏê½â

Ò»£ºÇ°ÑÔ
×î½üÔÚÑо¿androidµÄsensor driver£¬Ö÷ÒªÊÇE-compass£¬ÆäÖÐÓõ½ÁËLinux input×Óϵͳ.ÔÚÍøÉÏÒ²¿´Á˺ܶàÕâ·½ÃæµÄ×ÊÁÏ£¬¸Ð¾õ»¹ÊÇÕâÆª·ÖÎöµÄ±È½ÏϸÖÂ͸³¹£¬Òò´Ë×ªÔØÒ»ÏÂÒÔ±ã×Ô¼ºÑ§Ï°£¬Í¬Ê±ºÍ´ó¼Ò·ÖÏí£¡
£¨ÕâÆª²©¿ÍÖ÷ÒªÊÇÒÔ¼üÅÌÇý¶¯ÎªÀýµÄ£¬²»¹ý½²½âµÄÊÇLinux Input Subsystem£¬¿ÉÒÔ×ÐϸµÄÑо¿Ò»Ï£¡£©
¼üÅÌÇý¶¯½«¼ì ......

oracle method

--single line method
select ascii('A') Big_A from dual;
select chr(65) A, chr(122) z, chr(223) ch3 from dual;
select concat('sigo','way') from dual;
select initcap('sigoway') from dual;
select instr('ababab','a',-1,2), instr('ababab','a',1,3) from dual;
select instrb('ababab','a',1,3) from dua ......

¹ØÓÚORACLE PLSQL¶ÁÎļþ

ת×Ô£ºhttp://www.oracle.com/technology/obe/obe9ir2/obe-cnt/plsql/plsql.htm
¶¼Ëµ¶ÁÊé²»ÇóÉõ½âº¦ËÀÈË£¬Ò»µãÒ²²»´í£¬×î½üÎÒ´ÓÍøÉÏÌÔµ½¹ØÓÚORACLEÈçºÎ´ÓÊý¾Ý¿âĿ¼Ï¶ÁÎļþ£¬ÓÚÊǾÍÓÃÓÚÉú²úÁË£¬½á¹ûÉÏÁËÉú²ú£¬³ÌÐòËÀ»î¾ÍÊÇÅܲ»³öÀ´£¬Ô­ÒòÊÇÎÒÃǵķþÎñÆ÷×öÁËREC£¬Èç¹ûÔÚÁ½Ì¨»úÆ÷ÉÏÕÒÒ»¸öÄ¿Â¼ÄØ£¬ÒÔÇ°ÄØÔÚ×Ô¼ºµÄ³ÌÐòÀï°Ñ·¾ ......

ÐÞ¸ÄLinux¾²Ì¬Â·ÓÉ

 route add -net  10.10.101.0  netmask 255.255.255.0 gw 10.10.100.1
cat route-eth0
10.10.101.0/24 via 10.10.100.1 dev eth0
/etc/rc.d/init.d/network restart
netstat -r
[root@1314it network-scripts]# cat /etc/sysconfig/network-scripts/route-eth0
123.123.123.0 via 156.156.156.156 de ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ