OracleÈçºÎÁ¬½ÓÔ¶³Ìoracle?
±ðÈ˸øÁËÎÒÔ¶³ÌoracleÊý¾Ý¿âµÄÐÅÏ¢£º¹Ì¶¨IP£¬¶Ë¿ÚºÅºÍSID£¬»¹ÓÐÓû§ÃûºÍÃÜÂ룬ËûµÄÊý¾Ý¿âÊÇoracle9i,ÎÒµÄÒ²ÊÇ£¬ÎÒÈçºÎ²ÅÄÜÁ¬½Óµ½ËûµÄÊý¾Ý¿âµÃµ½Êý¾Ý£¬Çë¸ßÊÖ°ïæָµãһϣ¬²»Ê¤¸Ðл£¡
ÎÊÌâûÓнâ¾ö
wildwave£¬ÄúºÃ,¿É²»¿ÉÒÔÁô¸öµç»°Çë½ÌÒ»ÏÂ,¼±ÓÃÕâ¸ö£¬Ð»Ð»À²
Îҵĵ绰ÊÇ£º15934489110
»¹ÓÐÒ»µã£¬ÎÒ²»ÊÇÔÚ¾ÖÓòÍøÖзÃÎÊ£¬¶øÊÇÔÚinternetÍøÖзÃÎÊÄØ£¬Çë´ó¼Ò°ïÏÂæ
ÓÐʲôÎÊÌâ¾ÍÔÚÕâÀï˵°É£¬ÎÒÊÖ»úûµçÁË
»òÕß¿ÉÒÔÇë½Ìtianlesoftware£¬Õâ·½ÃæËû±ÈÎÒÇ¿µÃ¶à
Èç¹ûÊǹ̶¨ip£¬Ó¦¸ÃÒ²¿ÉÒԵġ£È·¶¨¶Ô·½Ïà¹Ø·þÎñ¶¼Õý³£Æô¶¯£¬ÅäÖúÃtnsnames
¾Í¿ÉÒÔÁ¬½Ó
×¢ÒâÍøÂçÎÊÌâ
ÏÈÊÔÊÔÄÜ·ñpingµÃͨ
ÅäºÃtnsname.oraºó£¬
ÓÃtnsping SIDÊÔÏ£¬ÄÜpingͨ¾Í¿ÉÒÔÁ¬ÉÏÁË..
SQL code:
C:\Documents and Settings\user.HQ-TEXT>tnsping DBA
TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 22-10ÔÂ-
2009 19:09:14
Copyright (c) 1997, 2005, Oracle. All rights reserved.
ÒÑʹÓõIJÎÊýÎļþ:
D:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora
ÒÑʹÓà TNSNAMES ÊÊÅäÆ÷À´½âÎö±ðÃû
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = HFCC-KF-
3068)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = DBA.anq
ingren.org)))
OK (30 ºÁÃë)
ÎÒÖØÐÂÏêϸµØËµÃ÷Ò»ÏÂÎÒµÄÎÊÌ⣺
ÎÒÔÚɽÎ÷£¬ÎÒÒª·ÃÎʹ㶫µÄOracle·þÎñÆ÷£¬Ëû¸øÎÒÌṩÁ˹̶¨IP,¶Ë¿ÚºÅÒÔ¼°SID£¬»¹ÓÐÓ
Ïà¹ØÎÊ´ð£º
1.OracleÖÐÃèÊöµÄ¿Í»§¶ËÓ¦Óõ½µ×Ö¸µÄʲô?
2.OracleתÂëʱ,Èç¹û¿Í»§¶ËΪ×Ó¼¯(UASCII)·þÎñ¶ËΪ³¬¼¯(AL32UTF8).
ÄÇÑϸñµÄ½²ÊÇ×Ó¼¯×ª³¬¼¯, ¿ÉÒÔתµÄͨ.
²éѯµÄʱºò³¬¼¯×ª×Ó¼¯ÄDz»¾Í³öÎÊÌâÁËô?
Äĸö»Ø¸öÌ ......
oracle not available
shared memory realm does not exist
ÇëÎʸßÊÖÕâ¸öÎÊÌâÈçºÎ½â¾ö£¿
http://www.inthirties.com/thread-109-2-1.html
Ö¸¶¨ÏÂORACLE_SID,ORACLE_HOME¿´¿´£¬²»ÐоÍÓÃ1Â¥µÃ·½·¨ÁË..
cm ......
3-5ÈË£¬¹¤×÷µØµãÉϺ£ÆÖ¶«Èí¼þÔ°£¬2-3Äê¾Ñ飬ӢÎÄÁ÷Àû£¬ÓÐÒâÕßÇëÁªÏµ38954510-1355£¬15821699737£¬y.ming@live.cn
×Ô¼º¶¥¡£¡£¡£
ûÓÐORACLE ERPµÄ¾Ñé,ÓÐÓÃÓѺÍTIPTOP¾Ñé,Ó¢Óï˵²»ºÃ,¿´»¹ÊÇ¿ÉÒÔ!
²»ÖªµÀÓÐûÓÐ ......
ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿
......
ÎÒÏÖÔÚÔÚ×öÒ»¸öÏîÄ¿£¬Õâ¸öÏîÄ¿µÄÊý¾ÝÁ¿ºÜ´ó£¬¶øÇÒ±íÒ²ºÜ´ó£¬×Ö¶ÎÒ²ºÜ¶à£¬²éѯÌõ¼þÒ²ÊǺܶàµÄ¡£ÏÖÔÚ²éѯÆðÀ´ºÜÂý£¬ÓÅ»¯sqlÓï¾äÊÇÒ»·½Ãæ¡£ÏÖÔÚÓ¦¸ÃÔõôÓÅ»¯oracleÊý¾Ý¿â°¡¡£ÎÒ°ÑÎÒµÄoracleÊý¾Ý¿âµÄһЩ²ÎÊý·¢³öÀ´¸ßÊÖ¿ ......