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

WINDOWSÏ ORACLE ÕìÌý³ÌÐòÒ쳣ֹͣ¹ÊÕÏ´¦Àí


 WINDOWSÏ ORACLE ÕìÌý³ÌÐòÒ쳣ֹͣ¹ÊÕÏ´¦Àí 
 
WINDOWSÏ ORACLE ÕìÌý³ÌÐòÒ쳣ֹͣ¹ÊÕÏ´¦Àí
¼ÒÀïÓÃÀ´µĄ̈ʽ»úÉÏ×°Á˸öWINDOWSϵÄORACLE 10G,ºÃ¾ÃûÓÃÁË£¬½ñÌì´ò¿ª´òËãÓÃһϣ¬Æô¶¯Êý¾Ý¿â£¬Æô¶¯ÕìÌý£¬¿´×źÜÕý³££¬µ«ÊÇÔÚ¿Í»§¶ËµÄTNSPING
C:\>tnsping homedb
TNS Ping Utility for 32-bit Windows: Version 10.2.0.3.0 - Production on 23-8ÔÂ -2008 22:26:10
Copyright (c) 1997, 2006, Oracle.  All rights reserved.
ÒÑʹÓõIJÎÊýÎļþ:
D:\oracle\product\10.2.0\db\network\admin\sqlnet.ora
ÒÑʹÓà TNSNAMES ÊÊÅäÆ÷À´½âÎö±ðÃû
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.5)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = MY
DB)))
TNS-12541: TNS: ÎÞ¼àÌý³ÌÐò
C:\>
²»¿ÉÄÜ£¬ÎÒ¸Õ²ÅÃ÷Ã÷Æô¶¯ÁËÕìÌý³ÌÐò
ΪÁËÅųýÊDz»ÊÇÎұʼDZ¾TNSNAME.ORAÅäÖõÄÎÊÌâ´ò¿ª¿´ÁËÒ»ÏÂ
ºÍ¼ÒÀïTNSNAMEÏà¹ØµÄÈçÏ£¬¿´À´ÊÇÕýÈ·µÄ
HOMEDB =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.5)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = MYDB)
    )
  )
µÇ¼µ½·þÎñÆ÷ÉÏ¿´ÁËһϣ¬·¢ÏÖÕìÌý³ÌÐò·þÎñÍ£Ö¹ÁË£¬ÄѵÀÎÒ¸Õ²ÅÕæµÄÍü¼ÇÆô¶¯ÕìÌýÁË£¿ÎÒÔÙ´ÎÆô¶¯ÕìÌý£¬È»ºóÔÚ±¾µØ½¨Á¢ÁËHOMEDBµÄÁ¬½Ó´®£¬TNSPING²âÊÔÁËһϣ¬Ã»ÓÐÎÊÌâ¡£
»Øµ½¿Í»§¶Ë£¬TNSPING »¹Êdzö´í£¬Îһص½·þÎñÆ÷ÔÙ´ÎÉÏTNSPING£¬Õâ´ÎÓÐÎÊÌâÁËҲ˵ÎÞÕìÌý£¬´ò¿ª·þÎñ¹ÜÀí£¬·¢ÏÖÕìÌý³ÌÐòÓÖÍ£Ö¹ÁË£¡ÄѵÀÊÇÕìÌý·þÎñÅäµÃÓÐÎÊÌ⣬ÎÒ´ò¿ª·þÎñÆ÷ÉÏlistener.ora£¬¿´ÉÏȥҲû´í¡£
HOMEDB =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.5)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
  )
½Ó×ÅÎÒ·¢ÏÖÎÒÔÚ·þÎñ¹ÜÀíÀïÆô¶¯ÕìÌý·þÎñ£¬¹ýÁË´óÔ¼20ÃëÕìÌý·þÎñ¾Í×Ô¶¯Í£Ö¹ÁË£¬É¶»ØÊ£¿µÚÒ»¼þʾÍÏëµ½¿´¿´ÈÕÖ¾£¬´ò¿ªÈÕÖ¾£¬Ã»ÓÐÈκÎÒì³£´íÎó£¬ÎÞÂÛALTER_HOMEDB.LOGºÍlistener.log¶¼Ã»Óп´³öÒì³£ÄÚÈÝ£¬ÎªÁË¿´µÃ¸üÇå³þÒ»µã£¬ÎÒ½«ÕâÁ½¸öÎ


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

jdbcÁ¬½ÓOracle

      ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
    ½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
    ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
    Ê×ÏÈ£¬Ô ......

ÎÒµÄORACLE RAC INSTALL for LINUX 10.2Ñо¿


ÎÒµÄORACLE RAC INSTALL for LINUX 10.2Ñо¿ 
 
ÎÒµÄORACLE RAC INSTALL for LINUX 10.2Ñо¿
1¡¢´´½¨ÐéÄâ»ú
DB1ÐéÄâ»úÎļþĿ¼ g:\vmtest1 Îļþ´óС8G ÄÚ´æ944M£¨Ô­ÁÂÎÒÖ»ÓÐ2GRAM)
DB2ÐéÄâ»úÎļþĿ¼ E:\vmtest2  Îļþ´óС8G ÄÚ´æ944M
ÔÚDB1ÉÏ´´½¨¹²Ïí´ÅÅÌ£¬
E:\SHARE Îļþ´óС8G
DB2Ò²´´½¨´ÅÅÌ£¬ ......

Oracle¼àÌý³ÌÐòµ±Ç°ÎÞ·¨Ê¶±ðÁ¬½ÓÃèÊö·ûÖÐÇëÇóµÄ·þÎñ

°²×°ºÃÁËÖ®ºó¿ÉÒÔͨ¹ýÕâ¸ö·¾¶ÕÒµ½Ò»¸öÎı¾Îļþ£º
oracle\product\10.2.0\db_1\NETWORK\ADMIN\listener.ora »¹Ò»¸öÔÚͬ·¾¶ÏµÄtnsnames.oraÎļþ£¬ÕâÁ½¸öÎı¾ÖеÄһЩÐÅÏ¢ÒªÒ»ÑùµÄ¡£
  Äã¿´¿´ÎÒµÄÕâÁ½¸öÎı¾ÎļþµÄÐÅÏ¢£º
listener.ora
# listener.ora Network Configuration File:& ......

ORACLE 10.204ÃÜÂëÖØÊÔ´ÎÊýÎÊÌâ


ORACLE 10.204ÃÜÂëÖØÊÔ´ÎÊýÎÊÌâ 
 
ORACLE 10.204ÃÜÂëÖØÊÔ´ÎÊýÎÊÌâ
ORACLE 10.204²¹¶¡ÔöÇ¿ÁËϵͳµÄ°²È«ÐÔ£¬È±Ê¡µÄÃÜÂëÖØÊÔ´ÎÊý¸ÄΪÁË10´Î£¬ÕâÔںܶàÇé¿öÏ£¬»áµ¼ÖÂһЩ¿Í»§±»Ëø¶¨£¬Èç¹ûÏëÐÞ¸ÄÃÜÂëÖØÊÔ´ÎÊý£¬¿ÉÒÔÐÞ¸ÄÏìÓ¦µÄ¸ÅÒªÎļþ£¬Èç¹ûûÓд´½¨Óû§¸ÅÒªÎļþ£¬È±Ê¡µÄ¾ÍÊÇÓÃoracleµÄ¸ÅÒªÎļþ£¬ÐÞ¸ÄÕâ¸ö¸ÅҪΠ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ