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

Á¬½ÓÆäËû»úÆ÷µÄoracle.

    LY =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.251)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = ly)
    )
  )
ÕâÊDZðÈ˸øÎÒµÄһЩÅäÖÃÐÅÏ¢£¬ÎÒÏëÁ¬µ½192.168.0.251Õą̂»úÆ÷µÄÊý¾Ý¿â£¬ÎÒµÄoracle°æ±¾ÊÇ10G£¬ºÜ¾ÃûÓùýoracleÁË£¬Âé·³²½ÖèÏêϸһµã£¬Ð»Ð»
½«ËüÃÇÌí¼Óµ½%oracle_home%\NETWORK\ADMINϵÄtnsnames.oraÎļþÖÐ
µÇ¼µÄʱºòÊäÈëÓû§ÃûÃÜÂëºó£¬¿âÃûÌîly

ÒýÓÃ
½«ËüÃÇÌí¼Óµ½%oracle_home%\NETWORK\ADMINϵÄtnsnames.oraÎļþÖÐ
µÇ¼µÄʱºòÊäÈëÓû§ÃûÃÜÂëºó£¬¿âÃûÌîly


¶ÔµÄ

Ò²¿ÉÒÔʹÓÃͼÐι¤¾ßnet manager
net·þÎñÃû£ºLY£¨Ëæ±ãÌîÒ»¸ö¶¼¿ÉÒÔ£©
Ö÷»úÃû£º192.168.0.251
Oracle·þÎñÃû£ºly

Á¬½ÓµÄʱºòҪעÒ⽫windows·À»ðǽ¹Ø±Õ

1¡¢¿ªÊ¼-->oracle-->¼¯³ÉÅäÖùÜÀí-->net manager
2¡¢Ìí¼ÓÍøÂçÅäÖÃ
3¡¢Êý¾Ý¿âʵÀýÃûLY
4¡¢Ä¬ÈÏÁ½²½
5¡¢ÊäÈëÒªÁ¬½ÓµÄipµØÖ·£º192.168.0.251
6¡¢×¢Ò⣺LY_192.168.0.251
7¡¢Íê³É
×¢Ò⣺×îºÃÊÇÓÃÕâ¸ö¿ÉÊÓ»¯½çÃæÀ´ÅäÖ㬶ø²»Òª×Ô¼ºÈ¥ÐÞ¸Ätnsname.oraÎļþ

ÒýÓÃ
1¡¢¿ªÊ¼-->oracle-->¼¯³ÉÅäÖùÜÀí-->net manager
2¡¢Ìí¼ÓÍøÂçÅäÖÃ
3¡¢Êý¾Ý¿âʵÀýÃûLY
4¡¢Ä¬ÈÏÁ½²½
5¡¢ÊäÈëÒªÁ¬½ÓµÄipµØÖ·£º192.168.0.251
6¡¢×¢Ò⣺LY_192.168.0.251


Ïà¹ØÎÊ´ð£º

linux + oracleÓÃXP·ÃÎʲ»ÁË

ÎÒ°²×°Ò»Ì¨redhat linux5+oracle 10gµÄ·þÎñÆ÷£¬±Ê¼Ç±¾£¨XPϵͳ£©°²×°ÁËoracle 10g¿Í»§¶Ë,½á¹ûÀÏÊdzö12560µÄ´íÎó£¬Çë¸ßÊÖÖ¸µãÒ»¶þ£¬

-A RH-Firewall-1-INPUT -m state –state NEW -m tcp -p tcp –dpor ......

OracleÖÐÃèÊöµÄ¿Í»§¶ËÓ¦Óõ½µ×Ö¸µÄʲô?

1.OracleÖÐÃèÊöµÄ¿Í»§¶ËÓ¦Óõ½µ×Ö¸µÄʲô?

2.OracleתÂëʱ,Èç¹û¿Í»§¶ËΪ×Ó¼¯(UASCII)·þÎñ¶ËΪ³¬¼¯(AL32UTF8).
ÄÇÑϸñµÄ½²ÊÇ×Ó¼¯×ª³¬¼¯, ¿ÉÒÔתµÄͨ.
²éѯµÄʱºò³¬¼¯×ª×Ó¼¯ÄDz»¾Í³öÎÊÌâÁËô?
Äĸö»Ø¸öÌ ......

ÇóʹÓÃt-sqlÓï¾ä½«paradoxÊý¾Ýµ¼ÈëoracleµÄ°ì·¨

ʹÓÃt-sqlÓï¾ä½«sqlserver2kÊý¾Ýµ¼ÈëparadoxµÄ¹¦ÄÜÎÒÒÑʵÏÖ£¬ÓõÄÊÇinsert into ... from table in [ODBC][ODBC;Driver=SQL Server...]µÄ°ì·¨£¬µ±ÎÒ×¼±¸Èç·¨ÅÚÖÆÍê³Éparadoxµ¼Èëoracleʱȴ²»ÐУ¬²»±¨´íµ«ÊÇÖ´ÐкóÃ»Ó ......

C# winformµ÷ÓÃoracleº¯Êý·µ»ØÓαê?

ÇëÎÊÒ»ÏÂ,C# winformÖÐͨ¹ýOleDbCommand,Ôõôµ÷ÓÃoracle·µ»ØÓαêÀàÐ͵ĺ¯Êý?¼±!!!


/// <summary>
        /// Ö´Ðдø²ÎÊýµÄ´æ´¢¹ý³Ì·µ»ØÊý¾Ý¼¯
      &nb ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ