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
Ïà¹ØÎĵµ£º
½ñÌì×öÏîÄ¿µÄʱºò£¬½«null´«ÈëOracleµÄ±íÖУ¬¾ÍÊDz»³É¹¦
¾¹ý³¢ÊԵóöÁËÁ½¸ö½â¾ö·½°¸£º
1.´«ÈëOracleDateTime.NULL
2.Nullable<DateTime> optime = DBNull.Value; ´«Èëoptime(¿ªÊ¼ÍøÉÏÕҵĴð°¸ÊÇNullable<DateTime> optime = null·¢ÏÖ»¹Êǻᱨ´í) ......
--´´½¨Óû§
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;
--¸ø´´½¨µ ......
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 ÐÞ¸ÄÊý¾Ý¿âµÄÈ«¾ÖÊ ......