Çó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))
 
Ïà¹ØÎÊ´ð£º
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£
ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ
http://www.oracle.com/technology/software/products/database/index.html
------------------------------------------- ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡
1. Oracle sid ÕýÈ ......
СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿
3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001'
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......