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±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
ÔÚdb2ºÍoracleÖеĶÔÊ÷µÄµÝ¹é²éѯÓï¾ä¡£
±í½á¹¹£º
create table MAIN_NODE (
MLA_ID INTEGER not null , //½ÚµãID
MLA_ROOTID &nb ......
²ì¿´listener.log È·ÈÏûÓÐÎÊÌâ
# find / -name listener.log
/home/oracle/app/OraHome_1/network/log/listener.log
λÖÃÔÚ$ORACLE_HOME/network/log/listener.log
TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production on 29-DEC-2009 15:12:15
Copyright (c) 1991, 2007, Oracle. All ......