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
Ïà¹ØÎĵµ£º
============================Question================================
SQL> select * from emp;
EMPID EMPNAME SALARY DEPTID
---------- ----------- ......
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 ......
Óï·¨£º
select *
from ±íÃû
where Ìõ¼þ1
start with Ìõ¼þ2
connect by prior µ±Ç°±í×Ö¶Î=¼¶Áª±í×Ö¶Î
start withÓëconnect by priorÓï¾äÍê³ÉµÝ¹é¼Ç¼£¬ÐγÉÒ»¿ÃÊ÷Ðνṹ£¬Í¨³£¿ÉÒÔÔÚ¾ßÓвã´Î½á¹¹µÄ±íÖÐʹÓá£
start with±íʾ¿ªÊ¼µÄ¼Ç¼
connect by prior Ö¸¶¨Ó뵱ǰ¼Ç¼¹ØÁªÊ±µÄ×ֶιØϵ
´úÂ룺
--´´½¨²¿Ãű ......
Ò»£®Ïà¹ØµÄ¸ÅÄî
RowidµÄ¸ÅÄrowidÊÇÒ»¸öαÁУ¬¼ÈÈ»ÊÇαÁУ¬ÄÇôÕâ¸öÁоͲ»ÊÇÓû§¶¨Ò壬¶øÊÇϵͳ×Ô¼º¸ø¼ÓÉϵġ£¶Ôÿ¸ö±í¶¼ÓÐÒ»¸örowidµÄαÁУ¬µ«ÊÇ
±íÖв¢²»ÎïÀí´æ´¢ROWIDÁеÄÖµ¡£²»¹ýÄã¿ÉÒÔÏñʹÓÃÆäËüÁÐÄÇÑùʹÓÃËü£¬µ«ÊDz»ÄÜɾ³ý¸ÄÁУ¬Ò²²»ÄܶԸÃÁеÄÖµ½øÐÐÐ޸ġ¢²åÈë¡£Ò»µ©Ò»ÐÐÊý¾Ý²åÈëÊý¾Ý¿â£¬Ôò
rowidÔÚ¸ÃÐ ......