linux»·¾³Ï°²×°oracle 11g database·½·¨Ö¸µ¼(Èý)
±¸×¢£º¾¹ýǰÆÚµÄlinuxϵͳ»·¾³µÄÅäÖôÍê³É£¬ÏÂÃæ¾Í¿ªÊ¼°²×°oracleÊý¾Ý¿â¡£oralceÊý¾Ý´ó¼ÒÈ¥oracle¹Ù·½ÍøÕ¾ÉÏÏÂÔØlinux»·¾³Ïµİ汾¡£ºÜÒź¶½ØÍ¼ÉÏ´«²»ÁË¡£
Èý£®Oracle database°²×°¾ßÌå°²×°²½Öè
<1>´´½¨°²×°oracleĿ¼¼°Ö÷Êôµ÷Õû
[root@mylinux oracle]# mv database/ /u01
[root@mylinux u01]# chown -R oracle:oinstall database/
[root@mylinux u01]# ls -l
total 16
drwxr-xr-x 5 oracle oinstall 4096 Oct 7 2008 database
drwxr-xr-x 2 oracle oinstall 4096 Apr 30 10:33 oracle
[root@mylinux u01]#su - oracle
½øÈë°²×°³ÌÐòĿ¼Æô¶¯°²×°³ÌÐò£º
[oracle@mylinux u01]#./runinstallar
ÈçÏÂÄÚÈÝÓÉÓÚ½ØÍ¼ÉÏÔØ²»ÁË£¬¾ßÌå²»ÔÚ˵Ã÷ÁË£¬°²×°·½·¨¸ú
windowsϰ²×°ÀàËÆ£¬½øÐÐÏàÓ¦µÄÉèÖü´¿É£º
££££££££££££££££££££££££££
½øÈëlinuxϵͳͼÐνçÃæ°²×°oracle database ÈçϽØÍ¼²Ù×÷
ÉèÖ÷¾¶
ÕâÒ»²½¼ì²é¹¤×÷£¬Óб¨swap½»»»¿Õ¼ä²»¹»£¬ÐèÒªÔö¼Ó½»»»¿Õ¼ä¡£
DHCPÐèÒªÔö¼ÓÈçÏÂÉèÖãº
[root@mylinux etc]# vi hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
192.168.0.88 mylinux
~
-------------------------------------------------------------------------------------
Ö»°²×°Êý¾Ý¿â²»´´½¨Êý¾Ý¿âʵÀý
ÅäÖà netca ¼àÌýÆ÷£º
Ö´ÐÐdbca´´½¨Êý¾Ý¿â
Òª¸ú»·¾³±äÁ¿ÉèÖÃÏà·û£º
ÉèÖÃÓû§×éµÄ¿ÚÁΪoracle:
ÉèÖÃ×Ö·û¼¯£¬ÒÔÃâ³öÏÖÂÒÂ룺
££££££££££££££££££££££££
ËÄ£®Æô¶¯Êý¾Ý¿âʵÀý
[oracle@mylinux ~]$ sqlplus "/ as sysdba"
SQL*Plus: Release 11.1.0.6.0 - Production on Fri Apr 30 14:18:04 2010
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
&nb
Ïà¹ØÎĵµ£º
×ÜÀÀ
ÓÃiptables -ADC À´Ö¸¶¨Á´µÄ¹æ
Ôò
£¬-AÌí¼Ó -Dɾ³ý -C ÐÞ¸Ä
iptables - [RI] chain rule num rule-specification[option]
ÓÃiptables - RI ͨ¹ý¹æÔòµÄ˳ÐòÖ¸¶¨
iptables -D chain rule num[option]
ɾ³ýÖ¸¶¨¹æÔò
iptables -[LFZ] [chain][option]
ÓÃiptables -LFZ Á´Ãû [Ñ¡Ïî]
iptables -[NX] chain
ÓÃ -NX ......
Ò»¡¢ÒýÑÔ£º
±¾ÎĵµµÄÄÚÈݴ󲿷ÝÄÚÈݶ¼ÊÇ´ÓÍøÉÏÊÕ¼¯¶øÀ´£¬È»ºóÅäºÏһЩеĽØÍ¼£¨Äں˰汾£ºV2.4.19£©¡£ÔÚÿһÅäÖÃÏîºó»áÓÐÒ»¸öÑ¡ÔñÖ¸ÄϵIJ¿·Ý£¬ÓÃÀ´Ö¸µ¼´ó¼ÒÔõôÑù¸ù¾Ý×Ô¼ºµÄÇé¿öÀ´×öÏàÓ¦µÄÑ¡Ôñ£»»¹ÓÐÔÚÿһ¸ö´óÏîºÍÎĵµµÄ×îºó»áÓÐÒ»¸ö¾Ñé̸£¬ËüÊÇһЩ¸ßÊÖÃÇÔÚÓ¦¶ÔÎÊÌâºÍ´¦ÀíÌØÓÐÓ²¼þʱµÄһЩ¾Ñ飨Õâ¸ö»¹µ ......
Õâ¸öÆäʵºÜ¼òµ¥£¬²»¹ý×Ô¼º¾³£Íü¼Ç£¬ËùÒÔ¼ÇÏÂÀ´
sqlplus /nolog£»
connect / as sysdba
alter user sys identified by password£»
alter user system identified by password£» ......
1. select * from t1 left join t2 on t1.c1 = t2.c2
ÊÇ×ó±ßµÄ±í£¨t1£© È«²¿ÏÔʾ£¬t2ûÓеÄÓÃnull´úÌæ¡£ ÓÒÁ¬½ÓÏà·´£¨t2£©
2. £¨+£©µÄÁ¬½ÓʱÁíÒ»¸öÈ«²¿ÏÔʾ¡£
select * from t1 left join t2 on t1.c1 = t2.c2 ºÍ select * from a,b where t1.c1 = t2.c2(+) Ч¹ûÒ»Ñù¡£
3. FULL OUTER JOIN:È«Íâ¹ØÁª
¡¡¡¡SELECT e.last ......
ÓÉÓÚÎÒÔÚÍøÉÏÏÂÔØÁËUbuntu LinuxÀ´°²×°·¢ÏÖÊÖͷû¿Õ°×¹âÅ̼̿cd,ËùÓÐgoogleÁËÏÂÕÒµ½ÁËÈçÏÂÎÄÕ½øÐÐʵ¼ù. ===================½Ì³Ì1========================== ˵µ½°²×°²Ù×÷ϵͳ£¬´ó¶àÊýÈËÊìϤµÄÊÇ´Ó¹âÅÌÒýµ¼£¬Æäʵ´ÓºÜ¶à´æ´¢É豸¶¼¿ÉÒÔʵÏÖϵͳÒýµ¼µÄ¡£ÓÉÓÚLinux²Ù×÷ϵͳµÄ·¢²¼ºÜ¶à£¬¶ø¶àÊýÈ˶¼ÊÇͨ¹ýÍøÂçÏÂÔØ²Ù×÷ϵͳµ ......