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

Ïê½âLinuxÏÂOracleµÄ¾²Ä¬°²×°


ÔÚÄ³Ð©ÌØÊâµÄÇé¿öÏ£¬ÈçÒòÎªÍøÂç»òÕßXÅäÖõĹØÏµÎÞ·¨Á¬½Óµ½X server»òÕßÖ÷»úÉÏûÓÐX£¬¾Í¿ÉÒÔʹÓþ²Ä¬°²×°µÄ·½Ê½°²×°Êý¾Ý¿â£¬Í¬ÑùÈç¹ûÐèÒª´ó¹æÄ£²¿Êð£¬Ôò¾²Ä¬°²×°½«»á´ó´ó¼õÇáDBAµÄÖØ¸´ÀͶ¯Á¦£¬¶øÇÒ¾²Ä¬°²×°²»ÐèÒªX£¬´Ó°²×°Ð§ÂÊ  
ÔÚÄ³Ð©ÌØÊâµÄÇé¿öÏ£¬ÈçÒòÎªÍøÂç»òÕßXÅäÖõĹØÏµÎÞ·¨Á¬½Óµ½X server»òÕßÖ÷»úÉÏûÓÐX£¬¾Í¿ÉÒÔʹÓþ²Ä¬°²×°µÄ·½Ê½°²×°Êý¾Ý¿â£¬Í¬ÑùÈç¹ûÐèÒª´ó¹æÄ£²¿Êð£¬Ôò¾²Ä¬°²×°½«»á´ó´ó¼õÇáDBAµÄÖØ¸´ÀͶ¯Á¦£¬¶øÇÒ¾²Ä¬°²×°²»ÐèÒªX£¬´Ó°²×°Ð§Âʼ°×ÊÔ´Õ¼ÓÃÉ϶¼±ÈͼÐλ¯OUIµÄ·½Ê½ÓÐÓÅÊÆ¡£
1¡¢¾²Ä¬°²×°OracleÈí¼þ
OracleµÄ¾²Ä¬°²×°ÐèÒªÓõ½Ò»¸öresponseÎļþ£¬Õâ¸öÎļþ¿ÉÒÔͨ¹ýÊÂÏÈʹÓÃOUIÂ¼ÖÆ£º
Ö´ÐÐÒÔÏÂÃüÁȻºóÔÚOUIÖиù¾ÝÌáʾִÐа²×°Êý¾Ý¿âÈí¼þµÄ²Ù×÷
$./runInstaller –record –destinationFile /tmp/install_database.rsp ×¢Ò⣺
£¨1£©Â¼Öƹý³ÌÖÐÑ¡ÔñÖ»°²×°Êý¾Ý¿âÈí¼þ²»´´½¨Êý¾Ý¿â
£¨2£©µ±°²×°½çÃæµ½´ï×îºóÒ»²½Ê±Ñ¡Ôñcancel
Â¼ÖÆ³É¹¦ºó£¬¾Í¿ÉÒÔʹÓòúÉúµÄÏìÓ¦Îļþ»Ø·ÅÕû¸ö°²×°¹ý³ÌÁË£º
£¨1£©Ö´ÐÐÒÔÏÂÃüÁĬ°²×°OracleÊý¾Ý¿âÈí¼þ
$./runInstaller –silent –responseFile /tmp/install_database.rsp £¨2£©°²×°Íê³ÉºóÖ´ÐÐÒÔϽű¾
#. $ORACLE_BASE/oraInventory/orainstRoot.sh #. $ORACLE_HOME/root.sh
×¢Ò⣺Èç¹ûOUIÔÚ¾²Ä¬°²×°Ê±²úÉú´íÎó£¨ÀàËÆOUI-10037µÈ´íÎ󣩣¬Ôò¾²Ä¬°²×°»áÖÐÖ¹£¬³öÏÖÕâÖÖÇé¿öÇë¼ì²éÏà¹ØÄ¿Â¼È¨ÏÞ¼°Óû§¡¢×éÊÇ·ñÒѾ­´´½¨£»Èç¹ûPrereqChecks½×¶ÎÓÐЩҪÇóûÓÐÂú×㣬OUIĬÈÏ»áºöÂÔ¶ø¼ÌÐø°²×°(ûÓÐÅäÖÃÄں˲ÎÊýºÍÎïÀíÄÚ´æ²»×㣬ȱ°üÇé¿öûÓÐʵÑé)£¬ËùÒÔ½¨ÒéÔÚ¾²Ä¬°²×°Ö®Ç°ÏÈ×ö¼ì²éÒÔÃâ°²×°³öÏÖʧ°Ü¡£
2¡¢DBCA¾²Ä¬°²×°Êý¾Ý¿â
ÓÃDBCA´´½¨Ò»¸öÖÖ×ÓÊý¾Ý¿â:
(1) ´´½¨³õʼÊý¾Ý¿âµÄʱºòÑ¡ÔñCustom DatabaseÄ£°å
(2) ½¨ÒéʹÓÃFile System´æ´¢»úÖÆ
(3) Êý¾ÝÎļþµÄ´æ·ÅµØµã½¨ÒéÑ¡Ôñ
Use Oracle-Managed Files Database Area: {ORACLE_BASE}/oradata
(4) Äڴ潨ÒéÑ¡ÔñCustom£¬Ö¸¶¨SGAºÍPGA´óС
(5) ×Ö·û¼¯¸ù¾Ýʵ¼ÊÐèÒªÉ趨
(6) Êý¾Ý¿â´´½¨Ñ¡ÏîÀïÃæÑ¡ÔñCreate Database
(7) ´´½¨Ó¦ÓóÌÐòÐèÒªµÄ±í¿Õ¼äºÍÓû§£¬µ¼Èë³õʼÊý¾Ý
ÓÃDBCA¸ù¾ÝÖÖ×ÓÊý¾Ý¿â´´½¨Ò»¸öÄ£°å£º
(1) Æô¶¯DBCA£¬Ñ¡ÔñManage Templates
(2) °´ÕÕÌáʾ´´½¨Ò»¸öÄ£°å£¬´´½¨ºóµÄÄ£°åÎļþ:$ORACLE_HOME/assistants/dbca/templates
/{Ä£°åÃû.dbc}
½«Oracle DB°²×°ÅÌÀïÃæresponseĿ¼ÏµÄdbca.rsp¿½±´µ½±¾»úÉÏ
ÐÞ¸Äd


Ïà¹ØÎĵµ£º

ÔÚlinuxÏÂʵÏÖweb qqµÄ×ÀÃæ»¯


´´½¨×ÀÃæÍ¼±ê
Ŀǰ½«ÍøÂçÓ¦ÓÃÀ©Õ¹µ½×ÀÃæÊÇÒ»¸öÇ÷ÊÆ£¬´æÔÚןܶà½â¾ö·½°¸£¬±¾ÎÄÒÔ Mozilla Prism ΪÀý£¬ÀàËÆµÄ·½·¨Í¬ÑùÊÊÓÃÓÚ Google Chrome ¡£
1. µ½ Mozilla Prism µÄÍøÕ¾ÉÏÏÂÔØ Prism£¬µã»÷ Download Now Ö®ºó»áÌáʾÓÐÁ½ÖÖ£¬Ò»ÖÖÊÇÒÔ Mozilla Firefox À©Õ¹µÄ·½Ê½£¬ÊʺÏÒѾ­°²×°ÓÐ Firefox µÄÅóÓÑ£»Ò»Ö ......

Linux manÃüÁîµÄʹÓ÷½·¨

man¾ÍÊÇmanualµÄËõд£¬ÓÃÀ´²é¿´ÏµÍ³ÖÐ×Ô´øµÄ¸÷Öֲο¼Êֲᡣ
Ò»¡¢ËµÃ÷
1£¬ÊÖ²áÒ³·ÖΪºÃ¼¸¸ö²¿·Ö£¬ÈçÏÂËùʾ£º
1 Executable programs or shell commands
2 System calls (functions provided by the kernel)
3 Library calls (functions within program libraries)
4 Special files (usually found in /dev)
5 File fo ......

Óà Navicat for Oracle ¹ÜÀí Oracle10g/11g Êý¾Ý¿â


    Navicat for xxx ÊÇÒ»¸öÓÅÐãµÄÊý¾Ý¿â¹ÜÀí¿Í»§¶Ë£¬ÓÐ MySQL¡¢Oracle µÈ°æ±¾¡£½¨Òé´ó¼Ò×îºÃÓà Enterprise °æ±¾£¬¹¦ÄÜÈ«ÃæÒ»Ð©£¬µ«½ÏÖ®ÓÚÃâ·ÑµÄ Lite °æ£¬ÆóÒµ°æ¿ÉÊÇÒª»¨Òø×ÓÂòµÄ¡£
    °²×° Navicat for Oracle ºó£¬Ê×ÏÈÐèÒª½¨Ò»¸ö“Á¬½Ó”£¬×÷Ϊij¸ö¹ÜÀíÈÎÎñµÄ±êʶ£¬ÒòΪ×÷Î ......

oracle raw device create tablespace

  
[root@vmfs sysconfig]# lvdisplay |grep db_d
  LV Name                /dev/db_v4/db_d_22
  LV Name                /dev/db_v4 ......

OracleÎÂϰÓëÈëÃÅ

SQL Server¿ª·¢ÕßOracle¿ìËÙÈëÃÅ http://kb.cnblogs.com/a/853694 ¼òµ¥¸ÅÄîµÄ½éÉÜ 1. Á¬½ÓÊý¾Ý¿â
S:    use mydatabase
O:    connect username/password@DBAlias
       conn username/password@DBAlias 2. ÔÚOracleÖÐʹÓÃDual, DualÊÇO ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ