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

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


ת£ºhttp://oracle.chinaitlab.com/install/755900.html
        ¼òµ¥À´Ëµ£¬OracleÊý¾Ý¿âµÄ¼àÌýÅäÖðüÀ¨·þÎñÆ÷¶ËµÄÅäÖúͿͻ§¶ËµÄÅäÖ᣷þÎñÆ÷¶ËÊÇͨ¹ý¼àÌýÆ÷¼´LISTENERÀ´Íê³ÉµÄ£¬¶ø¿Í»§¶ËÅäÖÃÓжàÖÖ£¬³£ÓõÄÊDzÉÓñ¾µØ·þÎñÃûÀ´ÅäÖ᣹ØÓÚ¼àÌýÆ÷ºÍ±¾µØ·þÎñÃû£¬Ïêϸ½âÊÍÈçÏ£º
Ò»¡¢¼àÌýÆ÷(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&r


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

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

Oracle Óû§¼°½ÇÉ« ½éÉÜ

Ò». Óû§¹ÜÀí
1.1 ½¨Á¢Óû§£¨Êý¾Ý¿âÑéÖ¤£©
     CREATE USER   DAVE IDENTIFIED BY   pwd
     DEFAULT TABLESPACE users
     TEMPORARY   TABLESPACE temp
     QUOTA 5m ON users;
1.2 ÐÞ¸ÄÓû§ ......

oracleµÄËæ»úÅÅÐò

ÏîÄ¿ÀïÒ»¸ö¹¦ÄÜÒªÓõ½Ëæ»úÅÅÐò£¬µ«ÊǺóÀ´ÓÖÒòΪÊý¾ÝÁ¿´óµÄÔ­Òò£¬Òª·Öҳȥ²éѯÊý¾Ý£¬½á¹ûµ¼Ö²éѯ³öÀ´µÄÊý¾Ý³öÏÖÖØ¸´¡£
Ô­sqlÈçÏÂselect * from ( select row_.*, rownum rownum_ from
(select * from tble order by dbms_random.random) row_ where rownum <= 12) where rownum_ > 10;
 
ºóÀ´½â¾ö°ì·¨£¬²åÈ ......

Ïê½âOracleÓû§½âËøÃüÁîµÄÁ½ÔòʵÏÖ·½·¨


ÔÚ°²×°ÍêOracle 10gÖ®ºó£¬Ïë´ò¿ªsql*plusÀ´Ñ§Ï°£¬È»ºó°´ÕÕÊéÉϵIJ½ÖèÓÃscottÓû§À´Á¬½ÓÊý¾Ý¿â£¬¿ÉÊäÁ˺ü¸´Î¶¼Ìáʾһ¸ö´íÎó¡£
error£º the account is locked
È»ºóÉÏÍø²éÁËÒ»ÏÂÖ®ºó·¢ÏÖÕâ¸öÓû§±»Ëø¶¨ÁË£¬ÖÁÓÚËüΪʲô±»Ëø¶¨£¬¿ÉÄÜÊÇÏÂÃæ¼¸¸öÔ­Òò¡£
1.³¢ÊÔ¶à´ÎµÇ¼δ³É¹¦.(¿ÉÄÜÃÜÂë²»ÕýÈ·)
2.´ËÓû§±»¹ÜÀíÔ±ÊÖ¹¤Ëø¶¨. ......

oracleµÄһЩ»ù±¾Óï·¨ºÍһЩÓÅ»¯ÎÊÌâ

²éѯ£º
select distinct(empno) , name , age  from t_person t where  (t.age between 21 and 25 or name like '%Íõ%') and
  empno like '32%';
¸üУº
 update t_person set name = 'ww' where empno = '321654';
 update t_person set(empno,name,age) = (select empno,name,age f ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ