linux ÏÂoracle µÄ°²×°(·þÎñ¶ËºÍinstant client)
linux ϰ²×°oracle ÊÇÒ»¼þºÜÁîÈËÍ·ÌÛµÄÊÂÇ飬ÎÒ°Ñ×Ô¼ºµÄ°²×°²½ÖèÄóöÀ´¸ø´ó¼Ò·ÖÏíһϡ£
Ò».linux·þÎñ¶ËµÄ°²×°.
1.ÏÂÔØoracle·þÎñ¶ËÈí¼þ,ÏÂÔØÍøÖ·ÈçÏÂ
http://www.oracle.com/technology/software/products/database/index.html
ÎÒÑ¡ÔñµÄ°æ±¾ÊÇ£ºOracle Database 10g Release 2 (10.2.0.1.0) for Linux x86-64
½øÈëÒ³ÃæºóÑ¡Ôñ
10201_database_linux_x86_64.cpio.gz À´ÏÂÔØ
2.ÏÂÔØokºó½øÐÐÈí¼þµÄ°²×°²½ÖèÈçÏÂ:
(1) ½âѹ°²×°°ü: gunzip 10201_database_linux_x86_64.cpio.gz
(2) ÔÙ½âѹ°²×°°ü: cpio -idmv 10201_database_linux_x86_64.cpio
(3) ½øÈëÍøÖ· http://www.oracle.com/pls/db102/homepage
Ñ¡Ôñ¶ÔÓ¦µÄInstallation GuidesÀ´½øÐа²×°.
ÎÒÑ¡ÔñµÄ°²×°ÎĵµÎª:Database Installation Guide for Linux x86-64
3.È»ºó´ò¿ªÒ³Ãæ¾Í¿ÉÒÔ°´ÕÕ°²×°Ïòµ¼ÎĵµµÄָʾÀ´°²×°Êý¾Ý¿âÁË,°²×°²½ÖèÈçÏÂ:
(1).°²×°µÄ×¼±¸¹¤×÷,ÕâÊÇÕû¸ö°²×°µÄÀ§ÄÑËùÔÚ.Ê×ÏÈҪȷ¶¨ÄãµÄ»úÆ÷É϶¼×°ÁËoracleÈ»¼þËùÐèÒªµÄ°ü.
Red Hat Enterprise Linux 4.0:(²»Í¬°æ±¾ÐèÒªµÄ°ü²»Ò»Ñù)
binutils-2.15.92.0.2-10.EL4
compat-db-4.1.25-9
control-center-2.8.0-12
gcc-3.4.3-9.EL4
gcc-c++-3.4.3-9.EL4
glibc-2.3.4-2
glibc-common-2.3.4-2
gnome-libs-1.4.1.2.90-44.1
libstdc++-3.4.3-9.EL4
libstdc++-devel-3.4.3-9.EL4
make-3.80-5
pdksh-5.2.14-30
sysstat-5.0.5-1
xscreensaver-4.18-5.rhel4.2
²é¿´ÏµÍ³°æ±¾
# cat /proc/version
²é¿´ÕâЩ±¨ÊÇ·ñ°²×°,ÓÃÏÂÃæµÄÃüÁî
# rpm -q package_name
(2).Ϊoracle´´½¨Óû§ºÍÓû§×é
Creating the Oracle Inventory Group(´æÈ¡×é)
# /usr/sbin/groupadd oinstall
Creating the OSDBA Group:
# /usr/sbin/groupadd dba
Creating an OSOPER Group (Optional):
# /usr/sbin/groupadd oper
Creating the Oracle Software Owner User:
# /usr/sbin/useradd -g oinstall -G dba[,oper] oracle //-g ±íʾÖ÷Òª×é,-G±íʾ´ÎÒª×é,oinstallÊÇÖ÷Òª×é.
# passwd oracle
Èç¹ûÒªÐÞ¸ÄÒѾ´æÔÚµÄÓû§:
/usr/sbin/usermod -g oinstall -G dba[,oper] oracle
²é¿´nobodyÊÇ·ñ´æÔÚ
# id nobody
²»´æÔÚÔò´´½¨
# /usr/sbin/useradd nobody
¼ìÑéoracleÊÇ·ñ´´½¨³É¹¦
# id oracle
(3).Configuring Kernel Parameters(ÅäÖÃkernel µÄ²ÎÊý)
ÍÆ¼öµÄkernel²ÎÊýÁбí,ÄãµÄÖµ¿ÉÒ
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
£¨L2CAPÐÒé¼ò½é£¬L2CAPÔÚBlueZÖеÄʵÏÖÒÔ¼°L2CAP±à³Ì½Ó¿Ú£©
Ò»£ºL2CAPÐÒé¼ò½é£º
Logical Link Control and Adaptation Protocol(L2CAP)
Âß¼Á¬½Ó¿ØÖƺÍÊÊÅäÐÒé (L2CAP) ΪÉϲãÐÒéÌá¹©ÃæÏòÁ¬½ÓºÍÎÞÁ¬½ÓµÄÊý¾Ý·þÎñ£¬²¢Ìṩ¶àÐÒ鹦ÄܺͷָîÖØ×é²Ù×÷¡£L2CAP ³äÐíÉϲãÐÒéºÍÓ¦ÓÃÈí¼þ´«ÊäºÍ½ÓÊÕ×î´ó³¤¶ÈΪ 64K µÄ L2CAP Ê ......
Service Discovery Protocol(SDP)ÌṩһÖÖÄÜÁ¦£¬ÈÃÓ¦ÓóÌÐòÓз½·¨·¢ÏÖÄÄÖÖ·þÎñ¿ÉÓÃÒÔ¼°ÕâÖÖ·þÎñµÄÌØÐÔ¡£
·þÎñ·¢ÏÖÐÒé(SDP»òBluetooth SDP)ÔÚÀ¶ÑÀÐÒéÕ»ÖжÔÀ¶ÑÀ»·¾³ÖеÄÓ¦ÓóÌÐòÓÐÌØÊâµÄº¬Ò⣬·¢ÏÖÄĸö·þÎñÊÇ¿ÉÓõĺÍÈ·¶¨ÕâЩ¿ÉÓ÷þÎñµÄÌØÕ÷¡£SDP¶¨ÒåÁËbluetooth client·¢ÏÖ¿ÉÓÃbluetooth server·þÎñºÍËüÃǵÄÌØÕ÷µÄ·½·¨¡£ ......
¾³£ÔÚÆ½Ê±µÄ¿ª·¢ÖÐÒªÓõ½oracleµÄÈÕÆÚº¯Êý£¬Ã¿´Î¶¼ÒªÉÏÍøÈ¥²é£¬ÏÖÔÚÓеãʱ¼ä£¬×Ô¼ºÊÕ¼¯ÕûÀíÁËһϡ£ÌùÔÚÕâÀ·½±ã×Ô¼º£¬Ò²·½±ã´ó¼Ò¡£
----------------------------------------------------------------------------------------------------------------------------------
³£ÓÃÈÕÆÚÐͺ¯Êý
1¡£Sysdate µ±Ç°È ......
1.
²éÕÒJava
ÏîÄ¿ÖУ¬main
·½·¨¶¨ÒåÔÚÄĸöÎļþ
Àï.
¡¡¡¡Çл»µ½ÄãÒª²éÕÒÏîÄ¿µÄĿ¼ÏÂÖ´ÐÐ
¡¡¡¡grep -rlI '\
¡¡¡¡Èç¹ûÄã¾õµÃ×Ô¼º´ò×ֿ죬²»ÅÂÂé·³Ö´ÐÐÈçÏÂÃüÁîÒ²¿ÉÒÔÕÒµ½¸ÃÎļþ
¡¡¡¡find -type f -name *.java -exec grep -l '\
2
¿ìËٵĽ¨Á¢Ò»¸öÎļþ£¬²¢ÊäÈëһЩÄÚÈÝ
¡¡¡¡cat >> filename
£¬ÊäÈëÒ» ......