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

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


Ïà¹ØÎĵµ£º

Linux iptableÎĵµ

×ÜÀÀ
ÓÃ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 ......

LinuxÄÚºËÅäÖÃÎĵµ(make menuconfig)

Ò»¡¢ÒýÑÔ£º
    ±¾ÎĵµµÄÄÚÈݴ󲿷ÝÄÚÈݶ¼ÊÇ´ÓÍøÉÏÊÕ¼¯¶øÀ´£¬È»ºóÅäºÏһЩеĽØÍ¼£¨Äں˰汾£ºV2.4.19£©¡£ÔÚÿһÅäÖÃÏîºó»áÓÐÒ»¸öÑ¡ÔñÖ¸ÄϵIJ¿·Ý£¬ÓÃÀ´Ö¸µ¼´ó¼ÒÔõôÑù¸ù¾Ý×Ô¼ºµÄÇé¿öÀ´×öÏàÓ¦µÄÑ¡Ôñ£»»¹ÓÐÔÚÿһ¸ö´óÏîºÍÎĵµµÄ×îºó»áÓÐÒ»¸ö¾­Ñé̸£¬ËüÊÇһЩ¸ßÊÖÃÇÔÚÓ¦¶ÔÎÊÌâºÍ´¦ÀíÌØÓÐÓ²¼þʱµÄһЩ¾­Ñ飨Õâ¸ö»¹µ ......

oracleÍü¼Çsys¡¢systemÃÜÂë½â¾ö

Õâ¸öÆäʵºÜ¼òµ¥£¬²»¹ý×Ô¼º¾­³£Íü¼Ç£¬ËùÒÔ¼ÇÏÂÀ´
    sqlplus /nolog£»
    connect / as sysdba
    alter user sys identified by password£»
    alter user system identified by  password£» ......

Oracle ×óÁ¬½Ó ÓÒÁ¬½Ó

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 ......

´ÓÓ²ÅÌÒýµ¼Linux°²×°³ÌÐò[ÊÕ¼¯]

ÓÉÓÚÎÒÔÚÍøÉÏÏÂÔØÁËUbuntu LinuxÀ´°²×°·¢ÏÖÊÖͷû¿Õ°×¹âÅ̼̿cd,ËùÓÐgoogleÁËÏÂÕÒµ½ÁËÈçÏÂÎÄÕ½øÐÐʵ¼ù. ===================½Ì³Ì1========================== ˵µ½°²×°²Ù×÷ϵͳ£¬´ó¶àÊýÈËÊìϤµÄÊÇ´Ó¹âÅÌÒýµ¼£¬Æäʵ´ÓºÜ¶à´æ´¢É豸¶¼¿ÉÒÔʵÏÖϵͳÒýµ¼µÄ¡£ÓÉÓÚLinux²Ù×÷ϵͳµÄ·¢²¼ºÜ¶à£¬¶ø¶àÊýÈ˶¼ÊÇͨ¹ýÍøÂçÏÂÔØ²Ù×÷ϵͳµ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ