Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Óû§¶¼ÓÐÒ»¸öÃû×ֺͿÚÁî,²¢ÓµÓÐһЩÓÉÆä´´½¨µÄ±í¡¢ÊÓͼºÍÆäËû×ÊÔ´¡£Oracle½ÇÉ«£¨role£©¾ÍÊÇÒ»×éȨÏÞ£¨privilege£©(»òÕßÊÇÿ¸öÓû§¸ù¾ÝÆä״̬ºÍÌõ¼þËùÐèµÄ·ÃÎÊÀàÐÍ)¡£Óû§¿ÉÒÔ¸ø½ÇÉ«ÊÚÓè»ò¸³ÓèÖ¸¶¨µÄȨÏÞ£¬È»ºó½«½ÇÉ«¸³¸øÏàÓ¦µÄÓû§¡£Ò»¸öÓû§Ò²¿ÉÒÔÖ±½Ó¸øÆäËûÓû§ÊÚȨ¡£
    Êý¾Ý¿âϵͳȨÏÞ£¨Dat ......

OracleµÄ¼¸¸öNULLº¯Êý

ƽʱÓõıȽ϶àµÄ£¬¾ÍÊÇNVL£¬Ã»ÔõôÔÚÒâÆäËû¼¸¸ö¡£
NVL ¾Í²»ÓÃ˵ÁË£¬¾ÍÊÇÅжϵÚÒ»¸öÊÇ·ñΪNULL£¬ÊǾÍÓõڶþ¸ö´úÌ棬²»ÊǾͷµ»ØµÚÒ»¸ö¡£
NVL2 Ò²ÊÇÅжϵÚÒ»¸öÊÇ·ñΪNULL£¬µ«ÊÇ·µ»Øֵȴ²»Í¬¡£µÚÒ»¸öΪNULL£¬¾Í·µ»ØµÚÈý¸ö£¬·ñÔò·µ»ØµÚ¶þ¸ö¡£
NULLIF ÅжÏÁ½¸ö²ÎÊýÊÇ·ñÏàµÈ£¬ÏàµÈ·µ»ØNULL£¬·ñÔò·µ»ØµÚÒ»¸ö²ÎÊý¡£
COALESCE Õâ ......

oracleȨÏÞÎÊÌ⼯ºÏ

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 ±íº¯Êý

´Óoracle 9i ¿ªÊ¼£¬ÌṩÁËÒ»¸ö½Ð×ö“¹ÜµÀ»¯±íº¯Êý”µÄ¸ÅÄ¿ÉÒÔÀûÓùܵÀ»¯À´·µ»Ø±íº¯Êý¡£
µ«ÕâÖÖÀàÐ͵ĺ¯Êý£¬±ØÐë·µ»ØÒ»¸ö¼¯ºÏÀàÐÍ£¬ÇÒ±êÃ÷ pipelinedÒÔ¼°²»ÄÜ·µ»Ø¾ßÌå±äÁ¿£¬¶øÊÇÒÔÒ»¸ö¿Õ return ·µ»Ø!
Õâ¸öº¯ÊýÖУ¬Í¨¹ý pipe row () Óï¾äÀ´ËͳöÒª·µ»ØµÄ±íÖеÄÿһÐÐ
ÔÚµ÷ÓÃÕâ¸öº¯ÊýµÄʱºò£¬Í¨¹ý table() ¹Ø¼ ......

oracle¾Þ´ó±íµÄÊý¾Ýɾ³ýµÄ·½·¨£¬20·ÖÖӸ㶨


oracle¾Þ´ó±íµÄÊý¾Ýɾ³ýµÄ·½·¨£¬20·ÖÖӸ㶨 
 
Ò»¸ö¿Í»§µÄÈÕÖ¾±í£¬ÒѾ­ÓÐ3000¶àǧÍòµÄ¼Ç¼ÁË£¬ÈÝÁ¿´óÔ¼30G£¬´òËãά»¤Ò»Ï£¬¿´ÁËÒ»ÏÂ×ֶΣ¬·¢ÏÖÈÕÖ¾ÊÇ°´ÈÕÆڼǼµÄ£¬´òËãÖ»±£Áô3¸öÔµÄÈÕÖ¾¾ÍºÃÁË¡£
µÚÒ»¸ö˼·£º
°´Ìõ¼þ²é³öÀ´£¬Ö±½ÓDELETE
ÊÔÁËÒ»ÏÂ
delete from NTLS_LOGS  where to_char(START ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ