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

ORACLEѧϰÖгöÏÖµÄÎÊÌ⣨³ÖÐø¸üÐÂÖУ©

ORACLEѧϰÖгöÏÖµÄÎÊÌ⣨³ÖÐø¸üÐÂÖУ©
1¡¢ ORA:12545 ÒòÄ¿±êÖ÷»ú»ò¶ÔÏó²»´æÔÚ£¬Á¬½Óʧ°Ü
   
ÍøÉϲο¼µÄ½â¾ö°ì·¨
1.ËÑË÷ÄãµÄoracle°²×°Ä¿Â¼£¬ÕÒµ½ÕâÁ©¸öÎļþ tnsnames.ora ºÍ listener.ora ¼Çס¾Í¸ÄÕâÁ©¸öÎļþ¾ÍÐÐÁË£¬»¹ÓÐÒ»¸ö´óдµÄTNSNAMES.ORA²»ÓùÜËü¡£ËûÃǵÄ·¾¶ÈçÏ£ºÈç E:\oracle\ora92\network\admin  ÕâÊÇÎҵķ¾¶ ÄãµÄ¿Ï¶¨ºÍÎҵIJ»Ò»Ñù£¬µ«ÄÜÕÒµ½ÕâÁ©¸öÎļþ¾ÍÐÐÁË,ËûÃÇÔÚͬһ¸öĿ¼À±à¼­ÕâÁ©¸öÎļþ£¬°ÑÀïÃæµÄHost= µÄµØ·½¸ÄΪÄãµÄ¼ÆËã»úÃû¾ÍÐÐÁË¡£×¢ÒâÓжà¸ö£¬¿´×ÐϸÁË¡£»òÕ߸ijÉIP,Ï´θÄÁËIP×¢ÒâÔÙÐÞ¸ÄҪͳһ
2.Èç¹ûÕâʱµÇ½µÄ»°£¬¿Ï¶¨»áÌáʾÄãûÓмàÌýÆ÷£¬ÄÇÊǼàÌýµÄ·þÎñûÓпª£¬µ½¼ÆËã»úµÄ·þÎñ½øÈë·þÎñµÄ·½·¨£º¿ØÖÆÃæ°å-¡µ¹ÜÀí¹¤¾ß-¡µ·þÎñ£¨Á©¸ö³ÝÂÖµÄÄǸöͼ±ê£©£¬È»ºóÕÒµ½OracleOraHome92TNSListenerÕâ¸ö·þÎñ£¬°ÑËüÆô¶¯ÁË£¬¾ÍºÃÁË¡£
2¡¢ORA_12541 £ºÃ»ÓмàÌýÆ÷
    ÕÒµ½lsnrctl.exe(${ORACLE_HOME}/ binÏÂÃæ)   È»ºólsnrctl   start


Ïà¹ØÎĵµ£º

jdbcÁ¬½ÓOracle

      ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
    ½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
    ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
    Ê×ÏÈ£¬Ô ......

oracle SQLÐÔÄÜÓÅ»¯

£¨1£©      Ñ¡Ôñ×îÓÐЧÂʵıíÃû˳Ðò(Ö»ÔÚ»ùÓÚ¹æÔòµÄÓÅ»¯Æ÷ÖÐÓÐЧ)£º
ORACLEµÄ½âÎöÆ÷°´ÕÕ´ÓÓÒµ½×óµÄ˳Ðò´¦Àífrom×Ó¾äÖеıíÃû£¬from×Ó¾äÖÐдÔÚ×îºóµÄ±í(»ù´¡±í driving table)½«±»×îÏÈ´¦Àí£¬ÔÚfrom×Ó¾äÖаüº¬¶à¸ö±íµÄÇé¿öÏÂ,Äã±ØÐëÑ¡Ôñ¼Ç¼ÌõÊý×îÉٵıí×÷Ϊ»ù´¡±í¡£Èç¹ûÓÐ3¸öÒÔÉϵıíÁ¬½Ó²éѯ, ÄÇ ......

Oracle ÓÅ»¯ÅäÖà ÊÕ²Ø

Êý¾Ý¿âϵͳºÍ²Ù×÷ϵͳһÑù£¬ÔÚ¼ÆËã»úÉÏ°²×°³É¹¦ºó£¬»¹ÐèÒª½øÒ»²½ÅäÖúÍÓÅ»¯£¬´Ó¶øʹÆä¾ßÓиüÇ¿´óµÄ¹¦ÄܺÍÔËÐÐÔÚ×î¼Ñ״̬¡£Èç¹ûÔÚÉè¼Æ½×¶ÎÒòΪ¸÷ÖÖÒòËØûÓнøÐнÏΪºÏÀíµÄÅäÖúͼƻ®£¬ÄÇô¾ÍÐèÒªÔÚºóÆÚ¶ÔÊý¾Ý¿âϵͳ½øÐÐÓÅ»¯¡£
Êý¾Ý¿âϵͳÐÔÄܵÄÓÅ»¯£¬³ýÁËÔÚÉè¼Æ½×¶Î¶ÔÆäÂß¼­´æ´¢½á¹¹ºÍÎïÀí´æ´¢½á¹¹Éè¼Æ½øÐÐÓÅ»¯£¬Ê¹Ö®ÔÚÂú×ã ......

Oracle ÀÛ¼ÓºÍʵÏÖ

============================Question================================
SQL> select * from emp;
     EMPID EMPNAME                  SALARY     DEPTID
---------- ----------- ......

Oracle AWRËÙ²é

 SQL> SQLPLUS / AS SYSDBA
SQL> exec dbms_workload_repository.create_snapshot
SQL> exec:snap_id:=dbms_workload_repository.create_snapshot
SQL> var snap_id number
SQL> print snap_id
SQL> @?/rdbms/admin/awrrpt.sql
OracleAWRËÙ²é
 
1.²é¿´µ±Ç°µÄAWR±£´æ²ßÂÔ
select * fro ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ