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

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


Ïà¹ØÎĵµ£º

OracleÖеÄNullÖµ½âÎö

         ÓÐÈË×ܽáÁËÊý¾Ý¿âÖÐNullÖµµÄ¸ÅÄ±È½Ï¾«Á¶£¬ÕªÂ¼ÈçÏ£º
NullÊÇÊý¾Ý¿âÖÐÌØÓеÄÊý¾ÝÀàÐÍ£¬µ±Ò»Ìõ¼Ç¼µÄij¸öÁÐΪNull£¬Ôò±íʾÕâ¸öÁеÄÖµÊÇδ֪µÄ¡¢ÊDz»È·¶¨µÄ¡£¼ÈÈ»ÊÇδ֪µÄ£¬¾ÍÓÐÎÞÊýÖֵĿÉÄÜÐÔ¡£Òò´Ë£¬Null²¢²»ÊÇÒ»¸öÈ·¶¨µÄÖµ¡£
ÕâÊÇNullµÄÓÉÀ´¡¢Ò²ÊÇNullµÄ»ù´¡£¬ËùÓк ......

oracle ±Ê¼Ç V Ö®´¥·¢Æ÷ (TRIGGER)

 ´¥·¢Æ÷ trigger
·ÖÀࣺǰ´¥·¢£¬ºó´¥·¢
      Ðд¥·¢Æ÷£¬Óï¾ä´¥·¢Æ÷
Ðд¥·¢Æ÷ÓëÓï¾ä´¥·¢Æ÷µÄÇø±ð£º
Ðд¥·¢Æ÷ÒªÇóµ±Ò»¸ö DML Óï¾ä²Ù×÷Ó°ÏìÊý¾Ý¿âÖеĶàÐÐÊý¾Ýʱ£¬¶ÔÓÚÆäÖеÄÿ¸öÊý¾ÝÐУ¬Ö»ÒªËüÃÇ·ûºÏ´¥·¢Ô¼ÊøÌõ¼þ£¬¾ù¼¤»îÒ»´Î´¥·¢Æ÷,FOR EACH ROW Ñ¡Ïî˵Ã÷´¥·¢Æ÷ΪÐд¥·¢Æ÷£»
Óï¾ä´¥·¢Æ÷ ......

linux³£ÓÃsvnÃüÁî

        1¡¢½«Îļþcheckoutµ½±¾µØĿ¼
svn checkout path£¨pathÊÇ·þÎñÆ÷ÉϵÄĿ¼£©
ÀýÈ磺svn checkout svn://192.168.1.1/pro/domain
¼òд£ºsvn co
        2¡¢Íù°æ±¾¿âÖÐÌí¼ÓеÄÎļþ
svn add file
ÀýÈ磺svn addtest.php(Ìí¼Ótest.php)
s ......

linuxÏÂhistory£¨ÀúÊ·£©ÃüÁîÓ÷¨Ïê½â

 
Èç¹ûÄã¾­³£Ê¹Óà Linux ÃüÁîÐУ¬ÄÇôʹÓà history£¨ÀúÊ·£©ÃüÁî¿ÉÒÔÓÐЧµØÌáÉýÄãµÄЧÂÊ¡£±¾ÎĽ«Í¨¹ýʵÀýµÄ·½Ê½ÏòÄã½éÉÜ history ÃüÁîµÄ15¸öÓ÷¨¡£
1. ʹÓà HISTTIMEFORMAT ÏÔʾʱ¼ä´Á
µ±Äã´ÓÃüÁîÐÐÖ´ÐÐ history ÃüÁîºó£¬Í¨³£Ö»»áÏÔʾÒÑÖ´ÐÐÃüÁîµÄÐòºÅºÍÃüÁî±¾Éí¡£Èç¹ûÄãÏëÒª²é¿´ÃüÁîÀúÊ·µÄʱ¼ä´Á£¬ÄÇô¿ÉÒÔÖ´ÐУº
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ