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

oracle tnsnames.oraÅäÖÃС½á

listener.ora¡¢ tnsnames.oraºÍsqlnet.oraÕâ3¸öÎļþÊǹØϵoracleÍøÂçÅäÖõÄ3¸öÖ÷ÒªÎļþ£¬ÆäÖÐlistener.oraÊǺÍÊý¾Ý¿â·þÎñÆ÷¶Ë Ïà¹Ø£¬¶øtnsnames.oraºÍsqlnet.oraÕâ2¸öÎļþ²»½ö½ö¹Øϵµ½·þÎñÆ÷¶Ë£¬Ö÷ÒªµÄ»¹ÊǺͿͻ§¶Ë¹Øϵ½ôÃÜ¡£
¼ì²é¿Í»§¶ËoracleÍøÂçµÄʱºò¿ÉÒÔÏȼì²ésqlnet.oraÎļþ£º
# SQLNET.ORA Network Configuration File: $ORACLE_HOME/NETWORK/ADMIN/sqlnet.ora
# Generated by Oracle configuration tools.
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, HOSTNAME, ONAMES)
##NAMES.DEFAULT_DOMAIN = us.oracle.com
ÉÏÃæµÄsqlnet.oraÎļþ˵Ã÷£º
SQLNET.AUTHENTICATION_SERVICES= (NTS)——Õâ¸ö±íʾ²ÉÓÃosÈÏÖ¤£¬ÔÚÊý¾Ý¿â·þÎñÆ÷ÉÏ£¬¿ÉÒÔÀûÓÃsqlplus “/ as sysdba”¡£Ò»°ãÕâ¸öÅäÖÃÔÚwindowsÉÏÊÇokµÄ£¬ÔÚunix»·¾³Ï¿ÉÄÜ»áÓÐÎÊÌ⣬һ°ãÔÚunixÏ¿ÉÒÔÈ¥µôÕâ¸öÅäÖá£
NAMES.DIRECTORY_PATH= (TNSNAMES, HOSTNAME, ONAMES)——±íʾ½«Ê×ÏÈÀûÓÃtnsnames½øÐнâÎö£»Èç¹ûtnsnames½âÎö²»µ½£¬½«Ê¹ÓÃhostname½âÎö£»Èç¹ûhostname½âÎö²» µ½£¬½«²ÉÓÃonames½øÐнâÎö¡£
±»×¢Ê͵ôµÄNAMES.DEFAULT_DOMAIN = us.oracle.com——±íʾ²ÉÓÃĬÈϵÄdomain nameΪus.oracle.com£¬ÔÚtnsnames.oraÖÐÈç¹ûÅäÖöÔÓ¦µÄ½âÎö£¬Èç¹ûÔ­À´µÄ±ðÃûoralocal£¬ÄÇô£¬µ±ÆôÓÃÕâ¸ö²ÎÊýºó£¬ÔÚ tnsnamesÖеÄÅäÖÃÒª¸Ä³Éoralocal.us.oracle.com¡£ÔÚʹÓÃtnspingʱ»òÕßsqlplusµÇ¼ʱ£¬Ö»ÐèдǰÃæµÄ±ðÃû£¬Ïµ ͳ»á×Ô¶¯¼ÓÉϺóÃæµÄdomain nameÀ´½øÐнâÎö¡£
¼ì²éÍê±Ïsqlnet.ora£¬Ò»°ã¶¼»á·¢ÏÖÊÇʹÓÃtnsnameÀ´½âÎö±ðÃûµÄ£¬ÄÇô£¬tnsnames.oraÖпÉÒÔÓÐÄÄЩÅäÖÃÖÖÀàÄØ£¿
# TNSNAMES.ORA Network Configuration File: $ORACLE_HOME/NETWORK/ADMIN/tnsnames.ora
# Generated by Oracle configuration tools.
###### Ò»°ãµÄÅäÖà ##################################
ORALOCAL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = oralocal)
    )
  )
###### ÕâÑùÒ²ÐУ¬ÓÃ


Ïà¹ØÎĵµ£º

Connecting Oracle with MS


This article shows how Oracle's Heterogeneous Services can be configured to allow a database to connect to a Microsoft Access database using standard databases links. The method described can be used to connect to MS-Access from about any platform - Unix/ Linux or Windows.
MS-Access 2003 and Orac ......

OracleµÄ ¼òµ¥ÐÐתÁÐ

Ó¦¸ö±¨±íÒªÇó×ö¸ö
ʱ¼ä             Ë«É«Çò£¬  ʤ¸º²Ê¡£¡£¡£¡£¡£
200905     ÏúÁ¿       ÏúÁ¿
200906     ÏúÁ¿       ÏúÁ¿
200907   &n ......

[Oracle] ÖØзÖÎö±íʹÊý¾Ý¿â×Ô¶¯Ñ¹Ëõ±í¡£

oracle11g¾ßÓÐ×Ô¶¯µÄ±íѹËõ¹¦ÄÜ£¬ µ«µ±insertÓï¾äδָ¶¨¾ßÌåµÄÁÐÃûʱ£¬ »áʹÓÃ×Ô¶¯±íѹËõ¹¦ÄÜʧЧ¡£(Èç¸ÃÓï¾ä»áʹµÃ±ít_test²»ÄÜ×Ô¶¯Ñ¹Ëõ: insert into t_test select * from t_test2)
ÁíÍâʹÓÃһЩÍⲿ¹¤¾ß½øÐÐÊý¾Ý×°ÔØ(sqlload)£¬Ò²ÓпÉÄÜʹµÃ±í²»ÄÜ×Ô¶¯Ñ¹Ëõ£¬´ËʱÐèÒªÓÃÒÔÏÂÓï¾ä£¬ÒÔÖØзÖÎö±í£¬·ÖÎöÍê³ÉÖ®ºó£¬¸Ã±í¼´»á ......

Introduction to Oracle Wait Interface notes

     ÎÄÕÂÌáµ½£¬ÓÃCache hit ratioµÄ·½·¨À´¼ì²éORACLEÐÔÄÜÎÊÌâ¹ýʱÁË£¬ÀïÃæÓоä·Ç³£ÐÎÏóµÄ»°£ºÕâÎÞÒìÓÚÒ»¸öÒ½ÉúÖ»ÖªµÀ¸ù¾ÝѪѹµÄÀ´ÖÎÁƲ¡ÈË£¬¶ø²¡ÈËÓÉÓÚÌÛÍ´£¬Éñ¾­ÐË·Ü£¬ÑªÑ¹ÔÚÒ»¸öºÏÀíµÄ·¶Î§ÄÚ£¬Ò½ÉúÈ´¸æËß»¼Õߣ¬Äãû²¡£¬µÈÄãѪѹµÍµÄʱºòÔÙÀ´¡£Í¬ÑùµÄ£¬ÎÒÃDz»Äܽö½ö¸ù¾ÝCache hit ratioÀ´ÅжÏORACLEÊ ......

Oracle¹éµµÄ£Ê½Óë·Ç¹éµµÄ£Ê½ÉèÖÃ

Oracle
¹éµµÄ£Ê½Óë·Ç¹éµµÄ£Ê½ÉèÖÃ
Oracle
µÄÈÕÖ¾¹éµµÄ£Ê½¿ÉÒÔÓÐЧµÄ·ÀÖ¹
instance
ºÍ
disk
µÄ¹ÊÕÏ£¬ÔÚÊý¾Ý¿â¹ÊÕϻָ´Öв»¿É»òȱ£¬ÓÉÓÚ
oracle
³õʼ°²×°Ä£Ê½Îª·Ç¹éµµÄ£Ê½£¬Òò´ËÐèÒª½«ÆäÉèÖÃΪ¹éµµÄ£Ê½£¬ÏÂÃæ¾ÍÆä·½·¨ºÍ²½Öè×öһЩ×ܽᣬËäÈ»¼òµ¥£¬µ«ÕâÊǹÜÀí
oracle
Êý¾Ý¿â±Ø±¸Ö®¹¤£¬¹ÊÓÐÈçϳÂÊö¡£
 
Àý×Ó ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ