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 ......
ƽʱÓõıȽ϶àµÄ£¬¾ÍÊÇNVL£¬Ã»ÔõôÔÚÒâÆäËû¼¸¸ö¡£
NVL ¾Í²»ÓÃ˵ÁË£¬¾ÍÊÇÅжϵÚÒ»¸öÊÇ·ñΪNULL£¬ÊǾÍÓõڶþ¸ö´úÌ棬²»ÊǾͷµ»ØµÚÒ»¸ö¡£
NVL2 Ò²ÊÇÅжϵÚÒ»¸öÊÇ·ñΪNULL£¬µ«ÊÇ·µ»Øֵȴ²»Í¬¡£µÚÒ»¸öΪNULL£¬¾Í·µ»ØµÚÈý¸ö£¬·ñÔò·µ»ØµÚ¶þ¸ö¡£
NULLIF ÅжÏÁ½¸ö²ÎÊýÊÇ·ñÏàµÈ£¬ÏàµÈ·µ»ØNULL£¬·ñÔò·µ»ØµÚÒ»¸ö²ÎÊý¡£
COALESCE Õâ ......
1.oracleÉèÖò»Í¬È¨ÏÞµÄÓû§È¥·ÃÎÊͬһ±í¿Õ¼ä
1.create user testa identified by testa;
2.alter user testa default tablespace users temporary tablespace temp;
3.grant connect to testa;
4.grant select any table to testa;
2.ORACLEÖÐÉèÖÃͬһ¸öÓû§¶ÔÁ½¸ö±í¿Õ¼äµÄȨÏ޵ĴúÂë
alter user Óû§ quota unlimi ......
´Óoracle 9i ¿ªÊ¼£¬ÌṩÁËÒ»¸ö½Ð×ö“¹ÜµÀ»¯±íº¯Êý”µÄ¸ÅÄ¿ÉÒÔÀûÓùܵÀ»¯À´·µ»Ø±íº¯Êý¡£
µ«ÕâÖÖÀàÐ͵ĺ¯Êý£¬±ØÐë·µ»ØÒ»¸ö¼¯ºÏÀàÐÍ£¬ÇÒ±êÃ÷ pipelinedÒÔ¼°²»ÄÜ·µ»Ø¾ßÌå±äÁ¿£¬¶øÊÇÒÔÒ»¸ö¿Õ return ·µ»Ø!
Õâ¸öº¯ÊýÖУ¬Í¨¹ý pipe row () Óï¾äÀ´ËͳöÒª·µ»ØµÄ±íÖеÄÿһÐÐ
ÔÚµ÷ÓÃÕâ¸öº¯ÊýµÄʱºò£¬Í¨¹ý table() ¹Ø¼ ......
oracle¾Þ´ó±íµÄÊý¾Ýɾ³ýµÄ·½·¨£¬20·ÖÖӸ㶨
Ò»¸ö¿Í»§µÄÈÕÖ¾±í£¬ÒѾÓÐ3000¶àǧÍòµÄ¼Ç¼ÁË£¬ÈÝÁ¿´óÔ¼30G£¬´òËãά»¤Ò»Ï£¬¿´ÁËÒ»ÏÂ×ֶΣ¬·¢ÏÖÈÕÖ¾ÊÇ°´ÈÕÆڼǼµÄ£¬´òËãÖ»±£Áô3¸öÔµÄÈÕÖ¾¾ÍºÃÁË¡£
µÚÒ»¸ö˼·£º
°´Ìõ¼þ²é³öÀ´£¬Ö±½ÓDELETE
ÊÔÁËÒ»ÏÂ
delete from NTLS_LOGS where to_char(START ......