Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Oracle ·þÎñ½ø³Ì ¼òµ¥½éÉÜ

Oracle ·þÎñ½ø³Ì-¼òµ¥½éÉÜ
ÒÔOrcale10gµÄ°æ±¾ÎªÀý£¬¼òµ¥½éÉÜÏÂOracleµÄ·þÎñ½ø³Ì£¨Windows°æ±¾£© -ganlan¡£
 
1¡¢OracleCSService
  ½ø³Ì£ºocssd.exe
½éÉÜ£ºCluster Synchronization Services (CSS)—Manages the cluster configuration by controlling which nodes are members of the cluster and by notifying members when a node joins or leaves the cluster. If you are using third-party clusterware, then the css process interfaces with your clusterware to manage node membership information.
 Google·­Ò룺¼¯ÈºÍ¬²½·þÎñ£¨css£©-¹ÜÀí¼¯ÈºÅäÖã¬Í¨¹ý¿ØÖƽڵ㣬ÆäÖеijÉÔ±¼¯ÈººÍ֪ͨ³ÉÔ±µ±Ò»¸ö½Úµã¼ÓÈë»òÀ뿪¼¯Èº¡£Èç¹ûÄúÕýÔÚʹÓõÚÈý·½µ³clusterware£¬ÄÇôcssµÄ¹ý³ÌÖеĽçÃæÓëÄúclusterware¹ÜÀí½Úµã³ÉÔ±µÄÐÅÏ¢¡£
 
2¡¢OracleDBConsoleorcl
½ø³Ì£ºnmesrvc.exe
½éÉÜ£ºoem¿ØÖÆÌ¨·þÎñ½ø³Ì£¬dbaÓá£Oracle Enterprise Manager(OracleÆóÒµ¹ÜÀíÆ÷,¼ò³ÆOEM)ÊÇͨ¹ýÒ»×éOracle³ÌÐò£¬Îª¹ÜÀí·Ö²¼Ê½»·¾³ÌṩÁ˹ÜÀí·þÎñ¡£OEM°üÀ¨ÁËÒ»×éDBA¹¤¾ß£¬Ò»¸örepository£¬ÒÔ¼°Ò»¸öͼÐλ¯ÏÔʾµÄ¿ØÖÆÌ¨¡£OEM¿ØÖÆÌ¨Óëÿһ¸ö·þÎñÆ÷ÉϵÄÖÇÄÜ»¯´úÀí(IntelligentAgent)Ïà¶ÔÓ¦¡£
 
3¡¢OracleJobSchedulerORCL
½ø³Ì£ºextjob.exe
½éÉÜ£º¶¨Ê±Æ÷
 
4¡¢OracleOraDb10g_home1iSQL*Plus
½ø³Ì£ºisqlplussvc.exe
½éÉÜ£ºisql*plusµÄ·þÎñ½ø³Ì£¬SQL*PlusÊÇOracleÌṩµÄÒ»¸ö¹¤¾ß³ÌÐò£¬Ëü²»½ö¿ÉÒÔÓÃÓÚÔËÐУ¬µ÷ÊÔSQLÓï¾äºÍPL/SQL¿é£¬¶øÇÒÓÃÓÚ¹ÜÀíOracleÊý¾Ý¿â¡£
 
5¡¢OracleOraDb10g_home1SNMPPeerEncapsulator
½ø³Ì£ºENCSVC.EXE
½éÉÜ£ºagentͨѶÓÃ
 
6¡¢OracleOraDb10g_home1SNMPPeerMasterAgent
½ø³Ì£ºAGNTSVC.EXE
½éÉÜ£ºagentͨѶÓÃ
 
7¡¢OracleOraDb10g_home1TNSListener
½ø³Ì£ºTNSLSNR
½éÉÜ£º¼àÌýÆ÷µÄ·þÎñ½ø³Ì
 
8¡¢OracleServiceORCL
½ø³Ì£ºORACLE.EXE
½éÉÜ£ºÊý¾Ý¿â·þÎñ½ø³Ì
 
°²×°ÍêOracle10gÒÔºó£¬Ò»Ï·þÎñÊÇϵͳĬÈÏ×Ô¶¯Æô¶¯µÄ£º
OracleCSService
OracleDBConsoleorcl
OracleOraDb10g_home1iSQL*Plus
OracleServiceORCL
OracleOraDb10g_home1TNSListener


Ïà¹ØÎĵµ£º

C#½«¿ÕÖµ´«Èëµ½Oracle×Ö¶ÎÀàÐÍΪDatatimeµÄ×Ö¶Î

½ñÌì×öÏîÄ¿µÄʱºò£¬½«null´«ÈëOracleµÄ±íÖУ¬¾ÍÊDz»³É¹¦
¾­¹ý³¢ÊԵóöÁËÁ½¸ö½â¾ö·½°¸£º
1.´«ÈëOracleDateTime.NULL
2.Nullable<DateTime> optime = DBNull.Value; ´«Èëoptime(¿ªÊ¼ÍøÉÏÕҵĴð°¸ÊÇNullable<DateTime> optime = null·¢ÏÖ»¹Êǻᱨ´í) ......

µ¼ÈëOracleʵÀý

--´´½¨Óû§
create user iagent identified by ia
--profile default 
default  tablespace users
temporary tablespace temp;
--account unlock;
 
--ɾ³ýÓû§
drop user iagent cascade;
--ÐÞ¸ÄÓû§ÃÜÂë
  alter  user  iagent  identified   by ia;
--¸ø´´½¨µ ......

oracle ÅäÖø߼¶¸´ÖÆ»·¾³Óöµ½µÄÎÊÌâ

1¡¢ÔÚ±¾»ú69ÉÏ´´½¨Êý¾Ý¿âorcl £¬global_name=orcl£¬Ê¹ÓÃÓï¾ä
alter database rename global_name to orcl.us.oracle.com ÐÞ¸ÄÊý¾Ý¿âµÄÈ«¾ÖÊý¾Ý¿âÃûΪorcl.us.oracle.com
2¡¢ÔÚÐé»ú188ÉÏ´´½¨Êý¾Ý¿âviotest£¬global_name=viotest£¬Ê¹ÓÃÓï¾ä
alter database rename global_name to viotest.us.oracle.com ÐÞ¸ÄÊý¾Ý¿âµÄÈ«¾ÖÊ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ