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

developer suiteÁ´½Óµ½oracle·þÎñÆ÷

Developer SuiteÁ¬½ÓÊý¾Ý¿âµÄÎÊÌ⣬ÀͼݸßÊÖÖ¸µã£¡
µçÄÔÀïÃæÍ¬Ê±×°ÁËOraHome92ºÍDevSuiteHome2£¬Ç°ÕßµÄsql*plusÄÜ·ÃÎÊ£¬ºóÕßµÄÔò²»ÐС£ÊäÈëscott/tigerµÇ½ºóÕßʱ£¬ÎÒÊäÈëÁË"Ö÷»ú×Ö·û´®"ºÅÒԺ󣬱¨´í£º 
  ORA-12154: TNS:ÎÞ·¨½âÎöÖ¸¶¨µÄÁ¬½Ó±êʶ·û

******ÔÚÍøÉÏÕÒÁ˺ܳ¤Ê±¼ä¶¼ÕÒ²»µ½ºÏÊʵĶԲߣ¬ÆäÖÐÓÐÈ˽¨Ò飺
  1.´ò¿ªOC4J listner, È»ºóÔÚdosÃüÁîÖÐÊäÈë'lsnrctl start listener'£¬±¨´íÈçÏ£º
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

Æô¶¯tnslsnr£ºÇëÉÔºò...

Service OracleOraHome92TNSListener already running.
TNS-12560: TNS: ЭÒéÊÊÅäÆ÷´íÎó
TNS-00530: ЭÒéÊÊÅäÆ÷´íÎó
  32-bit Windows Error: 1056: Unknown error
***********************************************************************  

2.¹úÍâÍøÕ¾ÉÏÈ˼ҵĽ¨Òé  
ORA-12154: TNS:could not resolve the connect identifier specified 
Cause: A connection to a database or other service was requested using a connect identifier, and the connect identifier specified could not be resolved into a connect descriptor using one of the naming methods configured. For example, if the type of connect identifier used was a net service name then the net service name could not be found in a naming method repository, or the repository could not be located or reached.

Action: - If you are using local naming (TNSNAMES.ORA file):

- Make sure that "TNSNAMES" is listed as one


Ïà¹ØÎÊ´ð£º

ÇóÖúORACLEÅúÁ¿Çå³ý±íÊý¾ÝµÄÎÊÌâ - Oracle / ¿ª·¢

±ÈÈçÎÒÓÐtestA¡¢testB¡¢testCÈý¸ö±í
ÎÒÏÖÔÚÐèҪдһ¸öÅú´¦Àí»òÕ߽ű¾¸ø±ðÈË ×÷ÓþÍÊÇÖ´ÐÐÕâ¶ÎÓï¾ä¿ÉÒÔÇå³ýÕâÈý¸ö±íÀïÃæµÄÊý¾Ý ¾ÍÊÇÒ»¸ö³õʼ»¯µÄÒâ˼
ÄÄλ¸ßÈ˰ïÖúϰ¡ Ò»¸öÊý¾Ý¿âС°×ÔÚ´ËÇó¾ÈÀ²
SQL code:
......

´ÓORACLEµ½DB2µÄSQLÓï¾äÎÊÌâ

ÏÖÔÚÓÐÒ»ORACLEÖеÄSQLÓï¾ä£¬ÐèÒªÒÆÖ²µ½DB2ÖУ¬ÇëÎʸÃSQL¸ÄÈçºÎд
ORACLEÖУº
select floor(months_between(date1,date2)) from A  
date1,date2·Ö±ðΪ±íÖеÄÁ½¸ö×Ö¶Î £¬¶¼ÎªÈÕÆÚÐÍ 
DB2ÖÐÈçºÎʹÓÃÐ ......

¸ß·ÖÇë½Ì oracle Òì³£µÄ²¶»ñÎÊÌâ

ÎÒÏÈ˵Ã÷Ò»ÏÂÇé¿ö£ºÓÐÒ»¸örec1.batµÃÅú´¦ÀíÎļþÀï±ß´úÂëÈçÏ£º
SET ORACLE_SID=TosmecDB
sqlPLUS /nolog  "@c:\tosmec\sys\syscom\TosmecHotSub1.sql"

TosmecHotSub1.sqlµÄÎļþÄÚÈÝÈçÏ ......

ÇóÖúÒ»¸ö¶¨Ê±Ö´ÐÐoracle´æ´¢¹ý³ÌµÄÎÊÌ⣬Çë´óÏÀ°ïæ

ÎÒÐèÒªÓö¨Ê±Ö´Ðд洢¹ý³Ì£¬µ«ÊÇÎҵĴ洢¹ý³ÌÀïÓõ½µÄ±íÊÇÓÐÁ´½ÓµÄ£¬¾ÍÏñÕâÑù£º
.....from table_name@cxdb_link
Ò²¾ÍÊÇÎÒ½¨Á¢¶¨Ê±Æ÷µÄÊý¾Ý¿âÓë±íËùÔÚµÄÊý¾Ý¿â²»ÊÇÒ»¸ö¿â£¬£¨ÒòΪ±íËùÔÚµÄÊý¾Ý¿âÎÒûÓÐȨÏÞ½¨Á¢¶¨Ê ......

ÓüÇʱ¾²é¿´Oracle¿ØÖÆÎļþ

ÎÒÓõÄÊÇNTϵͳ£¬µ±ÎÒÓüÇʱ¾²é¿´¿ØÖÆÎʼþʱ£¬×ÜÊÇÒ»´ó¶ÑÂÒÂ룬ÎÒ¸ÃÔõÑù²éѯ²¢¸Ä±ä¿ØÖÆÎļþÀïµÄÄÚÈÝÄØ£¿
2½øÖÆ ÓüÇʱ¾´ò¿ªµ±È»ÊÇÂÒÂë¿©

ÄÇÓÃʲô´ò¿ªÄØ£¿ÓÖÔõÑù´ò¿ªÄØ
£¿

¿ØÖÆÎļþÊǶþ½øÖÆÎļþ£¡

Ò»°ã ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ