Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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


Ïà¹ØÎĵµ£º

ÔÚdosÏÂ oracle exp/imp and import .sql

1.
¿ªÊ¼-->ÔËÐÐ-->cmd-->
.µ¼³öÊý¾Ý
exp help=y ²é¿´°ïÖú
exp rbt/rbt@ora10 file=c:\db.dmp full=y °´EnterÖ´ÐÐ
 .³É¹¦Ö´ÐС£¡£¡£
.µ¼ÈëÊý¾Ý
imp help=y ²é¿´°ïÖú
impÓÉÓµÓÐDBAȨÏÞµÄÓû§eXPÖ´ÐÐ.
imp kxself2/kxself2@ora10  full=y  file=c:\db.dmp
»ò
Imp username/password file=f ......

Oracle SQL LoaderµÄÏêϸÓï·¨

Oracle
SQL
Loader
µÄÏêϸÓï·¨
Oracle
   SQL
   Loader
µÄÏêϸÓï·¨
  
  SQL
*LOADER
ÊÇ
ORACLE
µÄÊý¾Ý¼ÓÔØ¹¤¾ß£¬Í¨³£ÓÃÀ´½«²Ù×÷ϵͳÎļþÇ¨ÒÆµ½
ORACLE
Êý¾Ý¿âÖС£
SQL
*LOADER
ÊÇ´óÐÍÊý¾Ý
  
 
²Ö¿âÑ¡ÔñʹÓõļÓÔØ·½·¨£¬ÒòΪËüÌṩÁË×î¿ì ......

µ¼Èë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 RACµÄ½ø³ÌÃÇ

GSD global services daemon (GSD)
ÓëracµÄ¹ÜÀí¹¤¾ßdbca srvctl
oem½øÐн»»¥£¬ÓÃÀ´Íê³ÉʵÀýµÄÆô¶¯¹Ø±ÕµÈ¹ÜÀíÈÎÎñ¡£
ΪÁ˱£Ö¤ÕâЩ¹ÜÀí¹¤¾ßÔËÐÐÕý³£±ØÐëÔÚËùÓеĽڵãÉÏÏÈstart
gsd,²¢ÇÒÒ»¸öGSD½ø³ÌÖ§³ÖÔÚ
Ò»¸ö½ÚµãµÄ¶à¸örac.gsd½ø³ÌλÓÚ$ORACLE_HOME/binĿ¼Ï£¬ÆälogÎļþ
Ϊ$oracle_home
/srvm/log/gsdaemon.log
À ......

OracleÄÚ´æ½á¹¹ÓëʵÀý¼°Æä¹ÜÀí

OracleÄÚ´æ½á¹¹ÓëʵÀý¼°Æä¹ÜÀí
1¡¢  ÄÚ´æ½á¹¹£º
OracleÊý¾Ý¿âµÄ×ÜÌå½á¹¹ÈçÏÂͼ£º
ÿ¸öOracleÊý¾Ý¿â¶¼ÊÇÓÉOracle Instance£¨ÊµÀý£©ÓëÊý¾Ý¿â£¨Êý¾ÝÎļþ£¬¿ØÖÆÎļþ¡¢ÖØ×öÈÕÖ¾Îļþ£©×é³É£¬ÆäÖÐËùνʵÀý¾ÍÊÇÓû§Í¬Êý¾Ý¿â½»»¥µÄý½é£¬Óû§Í¨¹ýÓÚÒ»¸öʵÀýÏàÁ¬À´²Ù×÷Êý¾Ý¿â¡£¶øÊµÀýÓÖÊÇÓÉͳһµÄÄÚ´æ½á¹¹£¨SGA£¬PGA£¬UGA£©ºÍ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ