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½ÇÉ«£¨role£©¾ÍÊÇÒ»×éȨÏÞ£¨privilege£©(»òÕßÊÇÿ¸öÓû§¸ù¾ÝÆä״̬ºÍÌõ¼þËùÐèµÄ·ÃÎÊÀàÐÍ)¡£Óû§¿ÉÒÔ¸ø½ÇÉ«ÊÚÓè»ò¸³ÓèÖ¸¶¨µÄȨÏÞ£¬È»ºó½«½ÇÉ«¸³¸øÏàÓ¦µÄÓû§¡£Ò»¸öÓû§Ò²¿ÉÒÔÖ±½Ó¸øÆäËûÓû§ÊÚȨ¡£
Êý¾Ý¿âϵͳȨÏÞ£¨Dat ......
ÔÚdb2ºÍoracleÖеĶÔÊ÷µÄµÝ¹é²éѯÓï¾ä¡£
±í½á¹¹£º
create table MAIN_NODE (
MLA_ID INTEGER not null , //½ÚµãID
MLA_ROOTID &nb ......
ÎÒµÄ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Ò²´´½¨´ÅÅÌ£¬ ......
¿ØÖÆÎļþºÍREDOLOGͬʱË𻵵ÄORACLEÊý¾Ý¿â»Ö¸´Ò»Àý
Ò»¸ö¿Í»§´òµç»°¸øÎÒ£¬ËµËûÃÇÒ»¸ö²âÊÔÊý¾Ý¿âÆð²»À´ÁË£¬ÈÃÎÒ¹ýÈ¥¿´¿´£¬
µ½¿Í»§ÏÖ³¡·¢ÏÖÊý¾Ý¿âÒѾDOWNÁË£¬ÊÔ×ÅÆô¶¯Ò»ÏÂ
SQL*Plus: Release 10.2.0.3.0 - Production on Tue Oct 7 10:33:29 2008
Copyright (c) 1982, 2006, Oracle. All Rig ......
1. ͨ¹ýv$session£¬v$locked_object²é¿´ËËø¶¨ÁË×ÊÔ´
select t1.sid, t1.serial#, t1.username, t1.logon_time
from v$session t1 , v$locked_object t2
where t1.sid = t2.session_id
order by t1.logon_time
......