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±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
Ò». Óû§¹ÜÀí
1.1 ½¨Á¢Óû§£¨Êý¾Ý¿âÑéÖ¤£©
CREATE USER DAVE IDENTIFIED BY pwd
DEFAULT TABLESPACE users
TEMPORARY TABLESPACE temp
QUOTA 5m ON users;
1.2 ÐÞ¸ÄÓû§
......
ÏîÄ¿ÀïÒ»¸ö¹¦ÄÜÒªÓõ½Ëæ»úÅÅÐò£¬µ«ÊǺóÀ´ÓÖÒòΪÊý¾ÝÁ¿´óµÄÔÒò£¬Òª·Öҳȥ²éѯÊý¾Ý£¬½á¹ûµ¼Ö²éѯ³öÀ´µÄÊý¾Ý³öÏÖÖØ¸´¡£
ÔsqlÈçÏÂselect * from ( select row_.*, rownum rownum_ from
(select * from tble order by dbms_random.random) row_ where rownum <= 12) where rownum_ > 10;
ºóÀ´½â¾ö°ì·¨£¬²åÈ ......
ÔÚ°²×°ÍêOracle 10gÖ®ºó£¬Ïë´ò¿ªsql*plusÀ´Ñ§Ï°£¬È»ºó°´ÕÕÊéÉϵIJ½ÖèÓÃscottÓû§À´Á¬½ÓÊý¾Ý¿â£¬¿ÉÊäÁ˺ü¸´Î¶¼Ìáʾһ¸ö´íÎó¡£
error£º the account is locked
È»ºóÉÏÍø²éÁËÒ»ÏÂÖ®ºó·¢ÏÖÕâ¸öÓû§±»Ëø¶¨ÁË£¬ÖÁÓÚËüΪʲô±»Ëø¶¨£¬¿ÉÄÜÊÇÏÂÃæ¼¸¸öÔÒò¡£
1.³¢ÊÔ¶à´ÎµÇ¼δ³É¹¦.(¿ÉÄÜÃÜÂë²»ÕýÈ·)
2.´ËÓû§±»¹ÜÀíÔ±ÊÖ¹¤Ëø¶¨. ......
²éѯ£º
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 ......