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

Çóoracle¸ßÊÖ°ïæ°¡£¬¼±

ÓÐûÓÐoracle¸ßÊÖÔÚ°¡  ÎÒÁ¬½Ó±ðÈ˵ÄÊý¾Ý¿â ÀÏÊdz¬Ê± Õ¦»ØÊ°¡?
tnsping 10.132.42.144
TNS Ping Utility for 32-bit Windows: Version 11.1.0.6.0 - Production on 12-2ÔÂ -2010 09:13:54

Copyright (c) 1997, 2007, Oracle.  All rights reserved.

ÒÑʹÓõIJÎÊýÎļþ:
F:\app\fKF22289\product\11.1.0\db_1\network\admin\sqlnet.ora

ÒÑʹÓà EZCONNECT ÊÊÅäÆ÷À´½âÎö±ðÃû
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=10.132.42.144)(PORT=1521))
)
TNS-12535: TNS: ²Ù×÷³¬Ê±
ÏÈ¿´¿´tnspingÓÐûÓÐÎÊÌâ¡£
Èç¹ûÓеϰ£¬¼ì²éÍøÂç

Èç¹ûûÓеϰ
¼ì²éÊDz»ÊÇ·À»ðǽûÓйء£

ÎÒÓÃtnsping ʵÀýÃû——TNS-03505: ÎÞ·¨½âÎöÃû³Æ
ÎÒtnsÅäÖÃÓ¦¸ÃûÎÊÌâ
ÎÒ×Ô¼ºµÄ·À»ðǽÊǹØÁ˵Ä
tnsping IPÄÜÕâÑùÓÃÂð£¿

°ÑÕâ¸öÎļþÈçºÎÅäÖõÄÌùÉÏÀ´¿´¿´
F:\app\fKF22289\product\11.1.0\db_1\network\admin\tnsnames.ora

#¼íÆÒÕ¯
JIANPUZHAI =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.132.42.144)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

JIANPUZHAI =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.132.42.144)(PORT = 1521))
 


Ïà¹ØÎÊ´ð£º

Oracle Êý¾Ýµ¼³öÎÊÌâ - Oracle / ¸ß¼¶¼¼Êõ

exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......

Windows 7 ÔõÑù°²×°Oracle - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷λ´ó¸ç£¬°ï¸öæ¡£

ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ 
http://www.oracle.com/technology/software/products/database/index.html 
------------------------------------------- ......

oracle 9i ×î½ü·¢Ïֵǽ±¨´í - Oracle / »ù´¡ºÍ¹ÜÀí

ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
  ORA-01034:ORACLE not available
  ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡

1. Oracle sid ÕýÈ ......

pl/sql - Oracle / ¿ª·¢

СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿

3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......

sqlÓÅ»¯ - Oracle / »ù´¡ºÍ¹ÜÀí

select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' 
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ