Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 ÐÐתÁÐÎÊÌâ


Êý¾Ý¿â²éѯÖÐÄÑÃâ»áÓöµ½ÐÐÁÐת»»µÄÇé¿ö£¬ÕªÁÐһЩ½Ï¾«µäµÄ½â¾ö·½°¸
--####################################################################
Ò»¡¢²ÉÓÃSQL decodeºÍPL/SQLº¯ÊýʵÏÖ
--####################################################################
1¡¢¹Ì¶¨ÁÐÊýµÄÐÐÁÐת»»
Èç
student subject grade
---- ......

oracle 10g°²×°ÖгöÏÖÎÊÌâ½â¾ö¹ý³Ì

      ÔÚ°²×°oracleµÄDBCA¹ý³ÌÖУ¬ÔÚ´´½¨²¢Æô¶¯oracleʵÀý£¨´´½¨¿Ë¡Êý¾Ý¿â£¬½ø¶ÈÌõÔÚ45%£©¾Í½øÐв»ÏÂÈ¥ÁË£¬ÖØ×°Á˼¸´ÎÖÕÓÚÕÒµ½ÎÊÌâµÄÖ¢½áÁË£¬½â¾ö¹ý³ÌÈçÏ£º
      1¡¢×°Á˼¸±é¾ÍÊÇÄǸöÎÊÌ⣬ÎÒͻȻÏëµ½Òª¿´¿´°²×°ÈÕÖ¾¡£
      2¡¢ÊÇÔÚ´´½ ......

oracleÆô¶¯ºÍ¹Ø±Õ

Êý¾Ý¿âµÄÆô¶¯ÓÐÈýÖÖ£º
1
£º
startup nomount

       
ÕâÖÖ¹ý³ÌÓÖ³ÆΪ£º·Ç°²×°Æô¶¯
     
   
Æô¶¯¹ý³ÌΪ£ºÆô¶¯
oracle
ʵÀý£¬²»¼ÓÔØÊý¾Ý¿â£¬²»´ò¿ªÊý¾Ý¿â¡£ÔÚÕâ¸ö¹ý³ÌÖÐÖ»ÐèÒª
init.ora
³õʼ»¯²ÎÊýÎļþ£¬Öؽ¨¿ØÖÆÎļþ£¬¼´Æô¶¯ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ