linuxÏ oracleµÄ°²×°
°²×°×¼±¸£º
ÏÂÔØÎļþ
l Oracle Database 10g Release 2(10.2.0.1) Software
½âѹÎļþ
½âѹÎļþÃüÁ
unzip 10201_database_linux32.zip
½âѹºóµÄÎļþ¼Ð¿ÉÄÜ“database”»ò“db/Disk1”
HostsÎļþ
ÔÚ/etc/hosts ÎļþÖаüº¬Ò»¸öÍêÕûºÏ·¨µÄ·þÎñÆ÷Ãû
<IP-address> <fully-qualified-machine-name> <machine-name>
ÉèÖÃÄں˲ÎÊý
ÔÚ/etc/sysctl.confÖÐÌí¼ÓÒÔÏÂÐУº
#kernel.shmall = 2097152
#kernel.shmmax = 2147483648
kernel.shmmni = 4096
# semaphores: semmsl, semmns, semopm, semmni
kernel.sem = 250 32000 100 128
#fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default=262144
net.core.rmem_max=262144
net.core.wmem_default=262144
net.core.wmen_max=262144
ÔËÐÐÏÂÃæµÄÃüÁîÓ¦ÓÃÒÔÉÏOS²ÎÊý
/sbin/sysctl -p
Ìí¼ÓÒÔÏÂÐе½/ect/security/limits.confÎļþÖÐ
* soft nproc 2047
* hard nproc 16384
* soft nofile 1024
* hard nofile 65536
Èç¹û/etc/pam.d/loginÎļþÖÐûÓÐÒÔÏÂÐУ¬ÔòÌí¼ÓÒÔÏÂÄÚÈÝ£º
session required /lib/security/pam_limits.so
ÐÞ¸Ä/etc/selinux/configÎļþÀ´¹Ø±Õlinux·À»ðǽ£¬È·±£SELINUXÉèÖÃÈçÏ£º
SELINUX=disabled
¼ì²é°²×°°ü
¼ì²éÊÇ·ñ¾ß±¸ÒÔÏ°²×°°ü£º
make-3.79.1
gcc-3.2.3-34
glibc-2.3.2-95.20
compat-db-4.0.14-5
compat-gcc-7.3-2.96.128
compat-gcc-c++-7.3-2.96.128
compat-libstdc++-7.3-2.96.128
compat-libstdc++-devel-7.3-2.96.128
libXp
openmotif21-2.1.30-8
setarch-1.3-1
²éѯËùÐè°²×°°üÊÇ·ñÍêÕû(ȱÉÙ²¹É¶)
rpm -q gcc make binutils openmotif setarch compat-db compat-gcc compat-gcc
Ïà¹ØÎĵµ£º
£¨L2CAPÐÒé¼ò½é£¬L2CAPÔÚBlueZÖеÄʵÏÖÒÔ¼°L2CAP±à³Ì½Ó¿Ú£©
Ò»£ºL2CAPÐÒé¼ò½é£º
Logical Link Control and Adaptation Protocol(L2CAP)
Âß¼Á¬½Ó¿ØÖƺÍÊÊÅäÐÒé (L2CAP) ΪÉϲãÐÒéÌṩÃæÏòÁ¬½ÓºÍÎÞÁ¬½ÓµÄÊý¾Ý·þÎñ£¬²¢Ìṩ¶àÐÒ鹦ÄܺͷָîÖØ×é²Ù×÷¡£L2CAP ³äÐíÉϲãÐÒéºÍÓ¦ÓÃÈí¼þ´«ÊäºÍ½ÓÊÕ×î´ó³¤¶ÈΪ 64K µÄ L2CAP Ê ......
´¥·¢Æ÷ trigger
·ÖÀࣺǰ´¥·¢£¬ºó´¥·¢
Ðд¥·¢Æ÷£¬Óï¾ä´¥·¢Æ÷
Ðд¥·¢Æ÷ÓëÓï¾ä´¥·¢Æ÷µÄÇø±ð£º
Ðд¥·¢Æ÷ÒªÇóµ±Ò»¸ö DML Óï¾ä²Ù×÷Ó°ÏìÊý¾Ý¿âÖеĶàÐÐÊý¾Ýʱ£¬¶ÔÓÚÆäÖеÄÿ¸öÊý¾ÝÐУ¬Ö»ÒªËüÃÇ·ûºÏ´¥·¢Ô¼ÊøÌõ¼þ£¬¾ù¼¤»îÒ»´Î´¥·¢Æ÷,FOR EACH ROW Ñ¡Ïî˵Ã÷´¥·¢Æ÷ΪÐд¥·¢Æ÷£»
Óï¾ä´¥·¢Æ÷ ......
Navicat for xxx ÊÇÒ»¸öÓÅÐãµÄÊý¾Ý¿â¹ÜÀí¿Í»§¶Ë£¬ÓÐ MySQL¡¢Oracle µÈ°æ±¾¡£½¨Òé´ó¼Ò×îºÃÓà Enterprise °æ±¾£¬¹¦ÄÜÈ«ÃæһЩ£¬µ«½ÏÖ®ÓÚÃâ·ÑµÄ Lite °æ£¬ÆóÒµ°æ¿ÉÊÇÒª»¨Òø×ÓÂòµÄ¡£
°²×° Navicat for Oracle ºó£¬Ê×ÏÈÐèÒª½¨Ò»¸ö“Á¬½Ó”£¬×÷Ϊij¸ö¹ÜÀíÈÎÎñµÄ±êʶ£¬ÒòΪ×÷Ϊ¿ ......
ÿһÖÖ²Ù×÷ϵͳ¶¼ÊÇÓɳÉǧÉÏÍò¸ö²»Í¬ÖÖÀàµÄÎļþËù×é³ÉµÄ¡£ÆäÖÐÓÐϵͳ±¾Éí×Ô´øµÄÎļþ£¬Óû§×Ô¼ºµÄÎļþ£¬»¹Óй²ÏíÎļþµÈµÈ¡£ÎÒÃÇÓÐʱºò¾³£Íü¼Çij·ÝÎļþ·ÅÔÚÓ²ÅÌÖеÄÄĸöµØ·½¡£ÔÚ΢ÈíµÄWINDOWS²Ù×÷ϵͳÖÐÒª²éÕÒÒ»·ÝÎļþÊÇÏ൱¼òµ¥µÄÊÂÇ飬ֻҪÔÚ×ÀÃæÉϵã»÷“¿ªÊ¼”£“ËÑË÷”ÖоÍÄÜ°´ÕÕ¸÷ÖÖ·½Ê½ÔÚ ......
Íü¼ÇMySQL ROOTÃÜÂëÊÇÔÚMySQLʹÓÃÖкܳ£¼ûµÄÎÊÌ⡣ûÏëµ½½ñÌì¾ÍÅöµ½ÕâÑùÒ»¸öÎÊÌ⣺ÄÚ²¿µÄmysqlµÄrootÃÜÂë±»ÐÞ¸ÄÁË¡£²éÔÄ×ÊÁÏ£¬ÓÐÈçÏ·½·¨£º Unix&Linux£º
1.ÓÃroot»òÕßÔËÐÐmysqldµÄÓû§µÇ¼ϵͳ£»
2£®ÀûÓÃkillÃüÁî½áÊøµômysqldµÄ½ø³Ì£»
3£®Ê¹ÓÃ--skip-grant-tables²ÎÊýÆô¶¯MySQL Server
shell& ......