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

OracleÒì³£ÎÊÌâ½â¾ö·½°¸


1. ÔÚ´ò¿ªEnterprise Manager Consolʱ±¨´í: "ÕÒ²»µ½Ä¿±êÖ÷»ú";
¡¾½â¾ö·½°¸¡¿¸ÃÎÊÌâÔÚʹÓÃGhostÖÆ×÷µÄϵͳÖг£¼û, ³ö´íÔ­ÒòÊÇOracleÖÐÅäÖõÄÖ÷»úÃû
 ºÍʵ¼ÊµÄÖ÷»úÃû²»Ò»ÖÂ. ½â¾ö·½·¨ÈçÏÂ: 
 (1) Enterprise Manager Consol -> ¹¤¾ß²Ëµ¥ ->·þÎñ¹ÜÀí -> Oracle Net Manager;
 (2) ½«"±¾µØ"µÄ"·þÎñÃüÃû"ºÍ"¼àÌý³ÌÐò"ÏÂÃæ×ÓÏîµÄÖ÷»úÃûÐÞ¸ÄΪºÍ±¾»úÒ»Ö¼´¿É.
2. ¼àÌý³ÌÐòÒì³£½â¾ö·½°¸:
 (1) ´ò¿ªOracle - OraHome90 -> Configuration and Migration Tools -> Net Configuration Assistant;
 (2) ÖØÐÂÅäÖüàÌý³ÌÐò.
3. "OracleÊý¾Ý¿â²»¿ÉÓÃ"ÎÊÌâ½â¾ö·½°¸:
 ¡¾ÎÊÌâÏÖÏó¡¿Oracle·þÎñÕý³£Æô¶¯, Enterprise Manager ConsolÕý³£µÇ¼, µ«ÔÚ´ò¿ªÊý¾Ý¿âµÄ·½°¸Ïîʱ±¨´í:
  "OracleÊý¾Ý¿â²»¿ÉÓÃ";
 ¡¾½â¾ö·½°¸¡¿
  (1) ½øÈëEnterprise Manager Consol;
  (2) Ñ¡Ôñ"Àý³Ì"ÖеÄ"ÅäÖÃ"×ÓÏî;
  (3) ½«"Àý³Ì״̬"ÉèÖÃΪ"´ò¿ª"¼´¿É.


Ïà¹ØÎĵµ£º

oracle ±í½á¹¹µÄÐÞ¸Ä

oracle ±í½á¹¹µÄÐÞ¸Ä
½ñÌì×ܽáϹØÓÚ±íµÄÐÞ¸Ä,·ÀÖ¹ÒÔºóÍü¼Ç,ºÃ¼ÇÐÔ²»ÈçÀñÊÍ·Âð!!!
¸ü¸Ä±íµÄ½á¹¹
1.±à¼­±íµÄ×Ö¶Î
  ÐÞ¸ÄÒ»¸öÁеÄÊý¾ÝÀàÐÍ(Ò»°ãÏÞÓÚÐ޸ij¤¶È£¬ÐÞ¸ÄΪһ¸ö²»Í¬ÀàÐÍʱÓÐÖî¶àÏÞÖÆ):
  Óï·¨:
    ALTER TABLE ±íÃû MODIFY(ÁÐÃû Êý¾ÝÀàÐÍ);
 eg1:
   alter table ......

Oracle»ù´¡Ñ§Ï°±Ê¼Ç

1.sqlplus-----¿ªÆô·þÎñ
2.ÊäÈëÓû§ÃûºÍÃÜÂ루ĬÈÏ3¸öÓû§,×¢Ò⣬ÃÜÂëÊÇ¿ÉÒÔÐ޸ĵģºsystem/manager;scott/tiger;sys/change_on_install£©£¬Á¬½ÓÊý¿â¡£
3.´´½¨±í¿Õ¼ä£º
 create tablespace ±í¿Õ¼äÂß¼­Ãû datafile '±í¿Õ¼äÎļþµÄÎïÀíÂß¼­'
 size Îļþ´óС£¨È磺10m£© autoextend ÊÇ·ñ×Ô¶¯Ôö³¤Îļþ´óС£¨on/off ......

Oracle 11g´æÔÚÃÜÂë¹ýÆÚÎÊÌâ

¡¾Ô­Òò/´¥·¢ÒòËØ¡¿
È·¶¨ÊÇÓÉÓÚoracle11gÖÐĬÈÏÔÚdefault¸ÅÒªÎļþÖÐÉèÖÃÁË“PASSWORD_LIFE_TIME=180Ìì”Ëùµ¼Ö¡£
¡¾Ó°ÏìºÍ·çÏÕ¡¿
Ó°Ïì
ÃÜÂë¹ýÆÚºó£¬ÒµÎñ½ø³ÌÁ¬½ÓÊý¾Ý¿âÒì³££¬Ó°ÏìÒµÎñʹÓá£
ÎÊÌâ·¢ÉúƵÂÊ
Êý¾Ý¿âÃÜÂë¹ýÆÚºó£¬ÒµÎñ½ø³ÌÒ»µ©ÖØÆô»áÌáʾÁ¬½Óʧ°Ü¡£
¡¾½â¾ö·½°¸¡¿
°´ÕÕÈçϲ½Öè½øÐвÙ×÷£º
1¡¢²é ......

Oracle 11gÕʺű»Ëø¶¨

2010-03-12 21:21:26
sqlplusµÇ½¶ÌÏûÏ¢oracleÊý¾Ý¿âʱÌáʾ“ORA-28000: Õʺű»Ëø¶¨”¡£
תÌù£ºhttp://blog.csdn.net/shongyu/archive/2009/06/01/4233260.aspx
È·¶¨ÊÇÓÉÓÚoracle11gÖÐĬÈÏÔÚdefault¸ÅÒªÎļþÖÐÉèÖÃÁË“FAILED_LOGIN_ATTEMPTS=10´Î”£¬µ±ÊäÈëÃÜÂë´íÎó´ÎÊý´ïµ½ÉèÖÃÖµ½«µ¼Ö´ËÎÊÌâ¡£
° ......

ϲ»¶oracleÕâÔò¹ã¸æ

Ô­Á´½Ó£ºhttp://www.oracle.com/webapps/dialogue/dlgpage.jsp?p_ext=Y&p_dlg_id=7731619&src=6817982&Act=4&sckw=APACMK09050910MPP005.GCM.8074.110
ÄÜ·ñÔÚµÚһʱ¼ä
      »ñµÃÐÂÕ½ÂԵķ´À¡Òâ¼û£¿
ÄÜ·ñͨ¹ý¹ÜÀíÄ£ÐÍ
      À´Ô¤²âÒµÎñÊý¾Ý£¿ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ