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

OracleÊý¾Ý¿â¼àÌýÅäÖÃ

½ü¶Îʱ¼äºÜ¶àÍøÓÑÌá³ö¼àÌýÅäÖÃÏà¹ØÎÊÌ⣬¿Í»§ÖÕ¶Ë(Client)ÎÞ·¨Á¬½Ó·þÎñÆ÷¶Ë(Server)¡£±¾ÎÄÏÖ¶Ô¼àÌýÅäÖÃ×÷Ò»¼òµ¥½éÉÜ£¬²¢Ìá³öһЩ¿Í»§ÖÕ¶ËÎÞ·¨Á¬½Ó·þÎñÆ÷¶ËµÄ½â¾ö˼·£¬Ô¸¶Ô¹ã´óÍøÓÑÓë¶ÁÕßÓÐһЩ°ïÖú¡£
 
Ò»¡¢¼àÌýÆ÷(LISTENER)
¡¡¡¡¼àÌýÆ÷ÊÇOracle»ùÓÚ·þÎñÆ÷¶ËµÄÒ»ÖÖÍøÂç·þÎñ£¬Ö÷ÒªÓÃÓÚ¼àÌý¿Í»§¶ËÏòÊý¾Ý¿â·þÎñÆ÷¶ËÌá³öµÄÁ¬½ÓÇëÇó¡£¼ÈÈ»ÊÇ»ùÓÚ·þÎñÆ÷¶ËµÄ·þÎñ£¬ÄÇôËüÒ²Ö»´æÔÚÓÚÊý¾Ý¿â·þÎñÆ÷¶Ë£¬½øÐмàÌýÆ÷µÄÉèÖÃÒ²ÊÇÔÚÊý¾Ý¿â·þÎñÆ÷¶ËÍê³ÉµÄ¡£
 
¶þ¡¢±¾µØ·þÎñÃû(Tnsname)
¡¡¡¡Oracle¿Í»§¶ËÓë·þÎñÆ÷¶ËµÄÁ¬½ÓÊÇͨ¹ý¿Í»§¶Ë·¢³öÁ¬½ÓÇëÇó£¬ÓÉ·þÎñÆ÷¶Ë¼àÌýÆ÷¶Ô¿Í»§¶ËÁ¬½ÓÇëÇó½øÐкϷ¨¼ì²é£¬Èç¹ûÁ¬½ÓÇëÇóÓÐЧ£¬Ôò½øÐÐÁ¬½Ó£¬·ñÔò¾Ü¾ø¸ÃÁ¬½Ó¡£
±¾µØ·þÎñÃûÊÇOracle¿Í»§¶ËÍøÂçÅäÖõÄÒ»ÖÖ£¬ÁíÍ⻹ÓÐOracleÃû×Ö·þÎñÆ÷(Oracle Names Server)µÈ¡£Oracle³£ÓõĿͻ§¶ËÅäÖþÍÊDzÉÓõı¾µØ·þÎñÃû£¬±¾ÎÄÖнéÉܵÄÒ²Ö÷ÒªÊÇ»ùÓÚ±¾µØ·þÎñÃûµÄÅäÖá£
 
Èý¡¢OracleÍøÂçÁ¬½ÓÅäÖ÷½·¨
¡¡¡¡Åä ÖÃOracle·þÎñÆ÷¶ËÓë¿Í»§¶Ë¶¼¿ÉÒÔÔÚÆä×Ô´øµÄͼÐλ¯OracleÍøÂç¹ÜÀíÆ÷(Oracle Net Manager)ÀïÍê³É£¨Ç¿ÁÒ½¨ÒéÔÚÕâ¸öͼÐλ¯µÄ¹¤¾ßÏÂÍê³ÉOracle·þÎñ¶Ë»ò¿Í»§¶ËµÄÅäÖã©¡£ÔÚWindowsÏ£¬µã»÷“¿ªÊ¼/³ÌÐò/Oracle - OraHome92/Configuration and Migration Tools/Net Manager”Æô¶¯OracleÍøÂç¹ÜÀíÆ÷¹¤¾ß£¬ÔÚLinux/UnixÏ£¬ÀûÓÃnetmgrÃüÁîÀ´Æô¶¯Í¼Ðλ¯OracleÍøÂç¹ÜÀíÆ÷£¬È磺
$ netmgr
WindowsÏÂÆô¶¯Net ManagerͼÐδ°¿ÚÈçÏÂͼʾ£º
 
                                                              ͼ(Ò»)
 
1¡¢ Oracle¼àÌýÆ÷ÅäÖÃ(LISTENER)
¡¡¡¡Èç ͼ(Ò»)ʾ£¬Ñ¡ÖÐÊ÷ÐÎĿ¼ÖмàÌý³ÌÐòÏÔÙµã»÷×óÉϲà“+”°´Å¥Ìí¼Ó¼àÌý³ÌÐò£¬µã»÷¼àÌý³ÌÐòĿ¼£¬Ä¬ÈÏмӵļàÌýÆ÷Ãû³ÆÊÇLISTENER(¸ÃÃû³ÆÒ²¿ÉÒÔ ÓÉÈÎÒâºÏ·¨×Ö·ûÃüÃû)¡£Ñ¡ÖиÃÃû³Æ£¬Ñ¡Öд°¿ÚÓÒ²àÀ¸ÏÂÀ­Ñ¡ÏîÖеē¼àÌýλÖÔ£¬µã»÷Ìí¼ÓµØÖ·°´Å¥¡£ÔÚ³öÏÖµÄÍøÂçµØÖ·À¸µÄЭÒéÏÂÀ­Ñ¡ÏîÖÐÑ¡ÖÐ “TCP/IP”£¬Ö÷»úÎı¾¿òÖÐÊäÈëÖ÷»úÃû³Æ»òIPµØÖ·(È


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

ÔÚOracleÖд´½¨ÊÓͼ£¬ÌáʾÎÞȨÏÞ ORA

 ½ñÌìÔÚ¶Ô±í´´½¨ÊÓͼµÄʱºò£¬Óû§Ìáʾ ORA-01031Óû§È¨ÏÞ²»×ã 
ʹÓÃsystemÓû§¶ÔÆä·ÖÅädbaµÈȨÏÞ£¬ÒÀÈ»ÎÞ·¨´´½¨ÊÓͼ¡£ 
¼ÌÐø¸³ÓèȨÏÞ 
grant select any table to AAA; 
ÊÚÓèÓû§Ñ¯ËùÓбíµÄȨÏÞ 
grant select any dictionary to AAA; 
ÔÙ´ÎÊÚÈ¡Óû§selectÈκÎ×ÖµäµÄȨÏÞ 
......

ÉÐѧÌÃoracle±Ê¼Ç

 µÚÒ»¿Î£º¿Í»§¶Ë
        1. Sql Plus(¿Í»§¶Ë£©£¬ÃüÁîÐÐÖ±½ÓÊäÈ룺sqlplus£¬È»ºó°´ÌáʾÊäÈëÓû§Ãû£¬ÃÜÂë¡£
        2. ´Ó¿ªÊ¼³ÌÐòÔËÐÐ:sqlplus£¬ÊÇͼÐΰæµÄsqlplus.
        3. http://localhost:5560/ ......

oracle ÄÚ´æÊý¾Ý¿â TimesTenÊÔÓñʼǣ¨aix5.3£©

 ×î½ü¹«Ë¾´òËãÔÚÏÂÒ»´ú¼Æ·ÑϵͳÀïÃæʹÓÃÄÚ´æÊý¾Ý¿âµÄ¼¼Êõ£¬ËùÒÔ×÷Ϊ¹«Ë¾µÄÉè¼ÆÈËÔ±Ö®Ò»µÄÎÒ£¬ÔÚoracleÍøÉÏÏÂÁ˸öTimesTen£¬°²×°ÔÚÎÒÃǵIJâÊÔ·þÎñÆ÷ÉÏÃæaix5£¬Õâƪ¶ÌÎÄÖ÷ÒªÊÇÎÒ²Ù×÷Êý¾Ý¿âµÄÒ»¸ö±Ê¼Ç£¬ÏÂһƪ´òËã·¢Ò»¸öc³ÌÐòµÄÀý×ÓºÍÎÒ²âÊԵĽá¹û£¬ºóÐø¿ÉÄÜ»¹»áʹÓÃTimesTen cache of oracleÕâ¸ö²úÆ·£¬Â½ÐøÒ²»á·¢Ò»ÏÂÕâ· ......

תÔØoracle rollupºÍcubeº¯ÊýʹÓÃÐĵÃ

 ×ª×Ô£ºhttp://blog.csdn.net/wangdongzjk/archive/2005/11/18/532424.aspx
ʹØCUBE ROLLUP GROUPING SETS£¨1£©
Ô­ÎÄÒý×Ô£º
¾ÛºÏÊÇÊý¾Ý²Ö¿âµÄ»ù´¡¡£ÎªÁËÌá¸ß¾ÛºÏµÄÐÔÄÜ¡£OracleÌṩÁËGroup By Ìõ¿îµÄÀ©Õ¹¡£
1£® CUBE, ROLLUPÀ©Õ¹
2£® 3¸ögroupingº¯Êý
 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ