Oracle ¿Í»§¶ËÁ¬½Ó·þÎñÆ÷³£¼ûÎÊÌâÖ®
½ñÌì°²×°Èí¼þÒ»Ö±ÔÚ²âÊÔÁ´½Ó²»ÄÜͨ¹ý£¬³öÏÖORA-12154: TNS: could not resolve service name£¬ºóÀ´²Å·¢ÏÖÊÇtnsnames.oraÖÐÓÐÎó¡£²éÕÒÍøÉϵÄ×ÊÁÏ£¬¼Ç¼ÏÂÀ´¡£
ÒªÅųý¿Í»§¶ËÓë·þÎñÆ÷¶ËµÄÁ¬½ÓÎÊÌ⣬Ê×Ïȼì²é¿Í»§¶ËÅäÖÃÊÇ·ñÕýÈ·(¿Í»§¶ËÅäÖñØÐëÓëÊý¾Ý¿â·þÎñÆ÷¶Ë¼àÌýÅäÖÃÒ»ÖÂ)£¬ÔÙ¸ù¾Ý´íÎóÌáʾ½â¾ö¡£ÏÂÃæÁгö¼¸ÖÖ³£¼ûµÄÁ¬½ÓÎÊÌ⣺
1¡¢
ORA-12541: TNS:
ûÓмàÌýÆ÷
ÏÔ¶øÒ×¼û£¬·þÎñÆ÷¶ËµÄ¼àÌýÆ÷ûÓÐÆô¶¯£¬ÁíÍâ¼ì²é¿Í»§¶ËIPµØÖ·»ò¶Ë¿ÚÌîдÊÇ·ñÕýÈ·¡£Æô¶¯¼àÌýÆ÷£º
$ lsnrctl start
»ò
C:\lsnrctl start
2¡¢
ORA-12500: TNS:
¼àÌý³ÌÐòÎÞ·¨Æô¶¯×¨Ó÷þÎñÆ÷½ø³Ì
¶ÔÓÚWindows¶øÑÔ£¬Ã»ÓÐÆô¶¯OracleʵÀý·þÎñ¡£Æô¶¯ÊµÀý·þÎñ£º
C:\oradim –startup -sid myoracle
3¡¢
ORA-12535: TNS:
²Ù×÷³¬Ê±
³öÏÖÕâ¸öÎÊÌâµÄÔÒòºÜ¶à£¬µ«Ö÷Òª¸úÍøÂçÓйء£½â¾öÕâ¸öÎÊÌ⣬Ê×Ïȼì²é¿Í»§¶ËÓë·þÎñ¶ËµÄÍøÂçÊÇ·ñ³©Í¨£¬Èç¹ûÍøÂçÁ¬Í¨£¬Ôò¼ì²éÁ½¶ËµÄ·À»ðǽÊÇ·ñ×èµ²ÁËÁ¬½Ó¡£
4¡¢
ORA-12154: TNS:
ÎÞ·¨´¦Àí·þÎñÃû
¼ì
²éÊäÈëµÄ·þÎñÃûÓëÅäÖõķþÎñÃûÊÇ·ñÒ»Ö¡£ÁíÍâ×¢ÒâÉú³ÉµÄ±¾µØ·þÎñÃûÎļþ(WindowsÏÂÈçD:\oracle\ora92\network\admin
\tnsnames.ora£¬Linux/UnixÏÂ$ORACLE_HOME/network/admin/tnsnames.ora)ÀïÿÏî·þÎñµÄÊ×
ÐзþÎñÃû³ÆÇ°²»ÄÜÓпոñ¡£
5¡¢
ORA-12514: TNS:
¼àÌý½ø³Ì²»ÄܽâÎöÔÚÁ¬½ÓÃèÊö·ûÖиø³öµÄ SERVICE_NAME
´ò¿ªNet Manager£¬Ñ¡ÖзþÎñÃû³Æ£¬¼ì²é·þÎñ±êʶÀ¸ÀïµÄ·þÎñÃûÊäÈëÊÇ·ñÕýÈ·¡£¸Ã·þÎñÃû±ØÐëÓë·þÎñÆ÷¶Ë¼àÌýÆ÷ÅäÖõÄÈ«¾ÖÊý¾Ý¿âÃûÒ»Ö¡£
6¡¢
Windows
ÏÂÆô¶¯¼àÌý·þÎñÌáʾÕÒ²»µ½Â·¾¶
ÓÃ
ÃüÁî»òÔÚ·þÎñ´°¿ÚÖÐÆô¶¯¼àÌýÌáʾÕÒ²»µ½Â·¾¶£¬»ò¼àÌý·þÎñÆô¶¯Òì³£¡£´ò¿ª×¢²á±í£¬½øÈëHKEY_LOCAL_MACHINE/SYSTEM/Current
ControlSet/Services/OracleOraHome92TNSListenerÏ²é¿´ImagePath×Ö·û´®ÏîÊÇ·ñ´æÔÚ£¬Èç¹ûû
ÓУ¬É趨ֵΪD:\oracle\ora92\BIN\TNSLSNR£¬²»Í¬µÄ°²×°Â·¾¶É趨ֵ×öÏàÓ¦µÄ¸ü¸Ä¡£ÕâÖÖ·½·¨Í¬ÑùÊÊÓÃÓÚOracleʵÀý·þÎñ£¬Í¬
ÉÏ£¬ÕÒµ½ÈçͬHKEY_LOCAL_MACHINE/SYSTEM/Current ControlSet/Services/Oracle
ServiceMYORACLEÏ²é¿´ImagePath×Ö·û´®ÏîÊÇ·ñ´æÔÚ£¬Èç¹ûûÓУ¬Ôòн¨£¬É趨ֵΪd:\oracle\ora92
\binORACLE.EXE MYORACLE¡£
ÒÔÉÏÊÇOracle¿Í»§¶ËÁ¬½Ó·þÎñÆ÷¶Ë³£¼ûµÄһЩÎÊÌ⣬µ±È»²»ÄÜÄÒÀ¨ËùÓеÄÁ¬½ÓÒì³£¡£½â¾öÎÊÌâµÄ¹Ø¼üÔÚÓÚ·½·¨Óë˼·£¬¶ø²»ÊÇÿÖÖÎÊÌⶼÓй̶¨µÄ´ð°¸¡£
Ïà¹ØÎĵµ£º
Oracle JOB Ó÷¨Ð¡½á
Ò»¡¢ÉèÖóõʼ»¯²ÎÊý job_queue_processes
¡¡¡¡sql> alter system set job_queue_processes=n;£¨n>0£©
¡¡¡¡job_queue_processes×î´óֵΪ1000
¡¡¡¡
¡¡¡¡²é¿´job queue ºǫ́½ø³Ì
¡¡¡¡sql>select name,description from v$bgprocess;
¡¡¡¡
¡¡¡¡¶þ£¬dbms_job package Ó÷¨½éÉÜ
¡¡¡¡ ......
·½°¸1 ÊÊÓÃÓÚoracle9iÒÔÉÏ£¡
select * from
(select row_number() over(order by sendid desc) rn,m.* from xxt_msgreceive m )
where rn <1010 and rn>=1000
·½°¸2
SELECT * from (SELECT A.*, ROWNUM RN from (SELECT * from xxt_msg where sendstatus=1 order by msgid desc) A WHERE ROWNUM < ......
--°ü
create or replace package pkg_query as
type cur_query is ref cursor;
end pkg_query;
--¹ý³Ì
CREATE OR REPLACE PROCEDURE "PRC_QUERY" (p_tableName
in varchar2, --±íÃû
& ......
============================Question================================
SQL> select * from emp;
EMPID EMPNAME SALARY DEPTID
---------- ----------- ......
1 ¾Û¼¯(cluster)
1.1 ¸ÅÄ
ÓÃÓÚ½«²»Í¬±íÖеÄÊý¾Ý´æ´¢µ½ÏàͬµÄÎïÀíÊý¾Ý¿éÖУ¬ÓÃÓÚ¶à±íÊý¾ÝÐèҪƵ·±½øÐÐÁªºÏ²éѯµÄÇé¿öÏ¡£¶à±íÊý¾Ý´æ´¢ÔÚÏàͬÊý¾Ý¿éºó£¬ÔÚ¶Ô¶Ô±í½øÐÐÁªºÏ²éѯʱ£¬ËùÐè¶ÁÈ¡µÄÎïÀí¿éÊý¼õÉÙ£¬´Ó¶øÌá¸ß²éѯÐÔÄÜ¡£
ÐèҪעÒâµÄÊǶԾۼ¯Öе¥±íµÄ²éѯºÍ¶Ô¾Û¼¯ÖбíÊý¾Ý½øÐÐÐ޸Ļò²åÈëµÈÊÂÎñ²Ù×÷ʱ£¬ÐÔÄܽ«Ê ......