ORACLEµÄÈý¸öÅäÖÃÎļþ½éÉÜ
¸ÅÊö
ÔÚoracle°²×°Ä¿Â¼$HOME/network/adminÏÂ,£¬¾³£¿´µ½sqlnet.ora tnsnames.ora listener.oraÕâÈý¸öÎļþ£¬³ýÁËtnsnames.ora£¬ÆäËûÁ½¸öÎļþÏêϸµÄÓÃ;ºÜ¶àÈ˶¼²»Ì«Á˽⡣
sqlnet.ora ÓÃÔÚoracle client¶Ë£¬ÓÃÓÚÅäÖÃÁ¬½Ó·þÎñ¶ËoracleµÄÏà¹Ø²ÎÊý.
tnsnames.ora ÓÃÔÚoracle client¶Ë£¬Óû§ÅäÖÃÁ¬½ÓÊý¾Ý¿âµÄ±ðÃû²ÎÊý,¾ÍÏñϵͳÖеÄhostsÎļþÒ»Ñù¡£listener.ora ÓÃÔÚoracle server¶Ë£¬ÅäÖÃoracle·þÎñ¶Ë³ÌÐòµÄ¼àÌý°ì·¨£¬±ÈÈçÏÞÖÆijЩipµÈ²ÎÊý¡£
ÔÚ°²×°Ä¿Â¼$HOME/network/admin/samplesÏ£¬»á¿´µ½ÈçÉÏÉϸöÎļþµÄʾÀýÎļþ£¬ÀïÃæ»áÓÐÏà¹Ø²ÎÊýµÄ˵Ã÷ºÍÓ÷¨£¬Èç¹ûÓöµ½Ê²Ã´ÎÊÌ⣬´ó¼Ò¿ÉÒÔ¶ÔÕÕÕâЩʾÀýÎļþÖÐÏà¹Ø²ÎÊýµÄ˵Ã÷½øÐнâ¾ö¡£
Èç¹ûÁ¬½ÓÊý¾Ý¿â³öÁËʲôÎÊÌ⣬ÔÚ±£Ö¤ÍøÂç³öÕý³££¬Ã»ÓзÀ»ðǽ¸ÉÈŵÄÇé¿öÏ£¬²éÕÒÎÊÌâµÄ²½ÖèÊÇ:
1)ÔÚ¿Í»§¶Ë˳Ðò¼ì²ésqlnet.ora£¬tnsnames.oraÊÇÓÐÎÊÌâ¡£
2)ÔÚ·þÎñÆ÷¶Ë¼ì²élistener.oraÅäÖ㬲¢ÇÒ±£Ö¤¼àÌý³ÌÐòÆô¶¯£¬Êý¾Ý¿â·þÎñ¼ÓÔØ¡£
ÈÏʶsqlnet.ora
ÏÂÃæÖ»½²Êö¼¸¸ö³£ÓòÎÊýÅäÖã¬ÏêϸµÄ×ÊÁÏ£¬´ó¼Ò¿ÉÒԲ鿴ʾÀýsqlnet.oraµÃµ½¡£
sqlnet.ora¿ÉÒÔɾ³ý£¬ÕâÑùÔÚoracle¿Í»§¶ËÁ¬½ÓÊý¾Ý¿âµÄʱºò£¬Ä¬ÈϲÉÓÃtnsnames.oraÖеÄÅäÖá£
1).NAMES.DEFAULT_DOMAIN
ÓòÃûdomain¶¨Ò壬ÔÚÄãÓÃsqlplus·ÃÎÊÊý¾Ý¿âµÄʱºò,»áÔÚtns±ðÃûºóÃæ¼ÓÉÏ".domain"
ʾÀý:
sqlnet.oraÖÐ:
NAMES.DEFAULT_DOMAIN=com
tnsnames.oraÖеÄtns¶¨ÒåÈçÏÂ:
local_dev =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.111)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = linuxdb)
)
)
ÔÚ¿Í»§¶ËÖ´ÐÐÃüÁî:sqlplus [email=username/password@local_dev]username/password@local_dev[/email]µÄʱºò£¬»á³öÏÖÈçÏ´íÎóÐÅÏ¢:
"ORA-12154: TNS: ÎÞ·¨´¦Àí·þÎñÃû"»òÕß"ORA-12154: TNS:could not resolve service name"ÕâÑùµÄ´íÎóÐÅÏ¢¡£
ÒòΪsqlplus [email=username/password@local_dev]username/password@local_dev[/email]µÄʱºò£¬½«tns±ðÃû“local_dev”ת»»³ÉÁË“local_dev.com”£¬ËùÒÔlocal_dev.comÔÚtnsnames.oraÖÐÕÒ²»µ½£¬¾Í±¨´íÁË¡£
ÐÞ¸Ätnsnames.oraÖеĶ¨ÒåÈçÏÂ:
local_dev.com =
(DESCRIPTION =
&
Ïà¹ØÎĵµ£º
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
ÕâÒ»ÕÂÖУ¬ÎÒÃǽ«·ÖÎö¹¹³ÉÊý¾Ý¿âºÍʵÀýµÄ8 ÖÖÎļþÀàÐÍ¡£
ÓëʵÀýÏà¹ØµÄÎļþÖ»ÓУº
²ÎÊýÎļþ£¨parameter file£©£ºÕâЩÎļþ¸æËßOracle ʵÀýÔÚÄÄÀï¿ÉÒÔÕÒµ½¿ØÖÆÎļþ£¬²¢ÇÒÖ¸
¶¨Ä³Ð©³õʼ»¯²ÎÊý£¬ÕâЩ²ÎÊý¶¨ÒåÁËijÖÖÄÚ´æ½á¹¹Óжà´óµÈÉèÖá£ÎÒÃÇ»¹»á½éÉÜ´æ´¢Êý¾Ý¿â²Î
ÊýÎļþµÄÁ½ÖÖÑ¡Ôñ¡£
¸ú×ÙÎļþ£¨trace file£ ......
http://www.inthirties.com/thread-757-1-1.html
ºÜÈÙÐÒ£¬±»ÑûÇëΪCSDNѧϰ´ó±¾ÓªÀïµÄOracleÀÏʦ¡£ÓиöÍøÓÑ·¢ÏûÏ¢¹ýÀ´£¬Ò»Æð̽ÌÖÈçºÎѧϰOracle£¬Ò»ÏÂÊǻظ´£¬ºÍ´ó¼ÒÒ»Æð̽ÌÖ¡£
Ê×ÏÈ£¬ÒªÃ÷È·ÄãµÄ·½ÏòºÍÄ¿±ê¡£
¶ÔÓÚOracleÀ´Ëµ£¬Õâ¸öÌåϵÊDZȽÏÅÓ´óµÄ£¬ËùÒÔÃ÷È·Ò»¸öÄ¿±êºÍÄãµÄ·½ÏòÊÇÔÚѧϰǰÐèҪ˼¿¼µÄÎÊÌâ¡£ ¹ÜÀí£¬ ......
Ò»¡¢×¼±¸ÌØÊâÊý¾Ý
create table t_escape(s varchar2(50));
--show define -- define "&" (hex 26)
--show escape -- escape off
set define off
set escape on
insert into t_escape values('string&text');
insert into t_escape values('string\&text');
insert into t_escape values('st ......
СÒý
Oracle RdbmsÊ©ÓÃÁ˸÷ÖÖ²»Í¬ÀàÐ͵ÄËø¶¨»úÖÆ£¬latchµÈÓÚ´ËÖеÄÒ»ÖÖ£¬ÕýÎĽ«¼¯ÖÐÒý¼ûlatch(ãÅ)µÄ¸ÅÄ¶®µÃlatchµÄ¶ÒÏÖ²½Ö貢˵Ã÷»½ÆðlatchĦ²ÁµÄÔµ¹Ê¡£
ʲôÊÇlatch
LatchÊÇÓÃÀ´±£»¤SGAÇøÖй²ÏíÊý¾Ý½á¹¹µÄÒ»ÖÖ´®Ðл¯Ëø¶¨»úÖÆ¡£LatchµÄ¶ÒÏÖÊÇÓë²Ù×÷ϵͳÏà¸ÉµÄ£¬ÓÈÉõºÍÒ»¸ö¹ý³ÌÊDz»ÊÇؽÐèµÈºòÒ»¸ölatch¡¢¼±ÐèµÈº ......