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 ......
1. HCI²ãÐÒé¸ÅÊö£º
HCIÌṩһÌ×ͳһµÄ·½·¨À´·ÃÎÊBluetoothµ×²ã¡£ÈçͼËùʾ£º
´ÓͼÉÏ¿ÉÒÔ¿´³ö£¬Host Controller Interface(HCI) ¾ÍÊÇÓÃÀ´¹µÍ¨HostºÍModule¡£Hostͨ³£¾ÍÊÇPC£¬ ModuleÔòÊÇÒÔ¸÷ÖÖÎïÀíÁ¬½ÓÐÎʽ£¨USB,serial,pc-cardµÈ£©Á¬½Óµ½PCÉϵÄbluetooth Dongle¡£
ÔÚHostÕâÒ»¶Ë£ºapplication,SDP,L2capµÈÐÒé ......
Service Discovery Protocol(SDP)ÌṩһÖÖÄÜÁ¦£¬ÈÃÓ¦ÓóÌÐòÓз½·¨·¢ÏÖÄÄÖÖ·þÎñ¿ÉÓÃÒÔ¼°ÕâÖÖ·þÎñµÄÌØÐÔ¡£
·þÎñ·¢ÏÖÐÒé(SDP»òBluetooth SDP)ÔÚÀ¶ÑÀÐÒéÕ»ÖжÔÀ¶ÑÀ»·¾³ÖеÄÓ¦ÓóÌÐòÓÐÌØÊâµÄº¬Ò⣬·¢ÏÖÄĸö·þÎñÊÇ¿ÉÓõĺÍÈ·¶¨ÕâЩ¿ÉÓ÷þÎñµÄÌØÕ÷¡£SDP¶¨ÒåÁËbluetooth client·¢ÏÖ¿ÉÓÃbluetooth server·þÎñºÍËüÃǵÄÌØÕ÷µÄ·½·¨¡£ ......
OracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹ÔÓ뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃüÁî¿ÉÒÔ°ÑdmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£ ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓÃÀ´ÕýʽʹÓá£
Ö´Ðл·¾³£º¿ÉÒÔÔÚSQLPLUS.EXE»òÕßDOS£¨ÃüÁîÐУ©ÖÐÖ´Ð ......
LinuxÉ豸Çý¶¯
µÚÒ»Õ É豸Çý¶¯¼ò½é
Çý¶¯³ÌÐòµÄ½ÇÉ«ÊÇÌṩ»úÖÆ£¬¶ø²»ÊDzßÂÔ¡£
±àдÄں˴úÂëÀ´´æÈ¡Ó²¼þ£¬µ«ÊDz»ÄÜÇ¿¼ÓÌØ±ðµÄ²ßÂÔ¸øÓû§(Ö»ÐèÒª±íÏÖ³öÓ²¼þµÄ×î»ù±¾µÄ¹¦ÄÜ£¬ÈçºÎʹÓÃÕâЩ¹¦ÄÜÓÖÓû§×Ô¼ºÑ¡Ôñ)
¶Ô²ßÂÔ͸Ã÷µÄÇý¶¯ÌØÕ÷£ºÖ§³Öͬ²½ºÍÒì²½²Ù×÷¡¢¿ÉÒÔ¶à´Î´ò¿ª¡¢ÀûÓÃÓ²¼þÈ«²¿ÄÜÁ¦¡¢Ã»ÓÐÈí¼þ²ãÌṩ²ßÂÔÏà¹Ø ......