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
Ïà¹ØÎÊ´ð£º
ÒÔÇ°³ÌÐòºÃºÃµÄ,ÄܽøÐÐÈκβÙ×÷
µ«´Ó×òÌ쿪ʼͻȻÁ¬½ÓÊý¾Ý¿âʧ°Ü,´úÂëÈçÏÂ:
try
{
::CoInitialize(NULL);
hr=m_pConnection.Creat ......
abnormal end of export file
IMP-00028: partial import of previous table rolled back: 3828 rows rolled back
ÓÐûÓÐÒ»ÖÖ·½·¨Èõ¼Èë¼ÌÐø½øÐжø²»Òì³£Ìø³ö»Ø¹ö£¿
ignore=y
Äã² ......
table1:
uID uName
1 СÀî
2 СÕÅ
table2:
pID uID type
1 1 H1
2   ......
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
±íÃû£ºgk_record_new£¨ÕâÊÇÒ»¸ö¿¼ÇÚ±í£¬ËùÓÐÔ±¹¤µÄ¿¼ÇÚÊý¾Ý¶¼´æ·ÅÔÚÕâ¸ö±íÀÖ÷¼üΪ¿¨ºÅºÍʱ¼ä£©
±í½á¹¹£º
¿¨ºÅ£ºNUMBER(10)
»ùÕ¾£ºVARCHAR2(20)
ʱ¼ä£ºDATE
³öÈë±êÖ¾£ºVARCHAR2(1)
±íÊý¾Ý
¿¨ºÅ »ùÕ¾ ʱ¼ä ³ ......