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

ÊÖ¹¤ÅäÖÃOracle 10G Enterprise Manage

ÊÖ¹¤ÅäÖÃOracle 10G Enterprise Manage
×î½üÔÚѧϰ°²×°Êý¾Ý¿âµÄʱºò£¬ÓÃÁ˶àÖÖ·½·¨´´½¨£¬Èçdbca´´½¨£¬ÊÖ¹¤´´½¨£¬ÓÃÄ£°æ´´½¨µÈµÈ£¬µ±ÓÃdbca´´½¨Êý¾Ý¿âµÄʱºò£¬Ã»ÓÐÑ¡Ôñ“ʹÓÃEnterprise ManagerÅäÖÃÊý¾Ý¿â”£¬Ôì³ÉºóÀ´ÏëÓÃem²»ÄÜʹÓ㬱ØÐèÓõ½ÊÖ¹¤ÅäÖÃem²ÅÄÜʹÓã¬ÏÂÃæ¾Í½éÉÜÁ½ÖÖµ¥ÊµÀý»·¾³ÊµÏÂemÅäÖÆ¡£
µÚÒ»ÖÖ·½·¨£¬ÓÃdbcaÅäÖÃem£¬Ò²ÊÇ×î¼òµ¥µÄ·½·¨¡£
ÔÚÃüÁîÌáʾ·ûÏÂÊäÈëdbca,³öÏÖ"Database Configuration Assistant »¶Ó­Ê¹ÓÃ"½çÃæ£¬µãÏÂÒ»²½£¬Ñ¡ÔñÅäÖÃÊý¾Ý¿â£¬ÔÚµãÏÂÒ»²¿£¬Ñ¡ÔñÒªÅäÖÆemµÄÊý¾Ý¿â£¬È»ºóÔÚµãÏÂÒ»²½£¬°Ñ"ʹÓÃEnterprise ManagerÅäÖÃÊý¾Ý¿â"Ñ¡Ïî´òÉϹ³£¬ÒòΪÊÇÅäÖÆµ¥ÊµÀýµÄ£¬ËùÒÔÑ¡Ôñ"ʹÓÃDatabase Control¹ÜÀíÊý¾Ý",ÏÂÃæÁ½¸öÑ¡ÏîÆôÓõç×ÓÓʼþ֪ͨºÍÆôÓÃÿÈÕ±¸·Ý¸ù¾Ý×Ô¼ºÇé¿öÑ¡Ôñ£¬ÔÚµãһϲ¿£¬°Ñ"Enterprise Manager ×ÊÁϵµ°¸¿â"ҲѡÔñÆðÀ´£¬·ñÔò²»ÄÜʹÓÃem,ÔÚµãÏÂÒ»²½£¬È»ºóÌáʾÐèÒªÉèÖÃDBSNMPºÍSYSMANÁ½¸öÓû§ÉèÖÿÚÁ¸ù¾Ý×Ô¼ºÇé¿öÀ´ÉèÖÃÊÇ·ñ¿ÚÁîÉèÖóÉÒ»Ñù£¬»¹ÊÇ·Ö¿ªÉèÖá£ÔÚµãһϲ½£¬ÔÚµãÍê³É£¬¾Í³öÏÖÅäÖÆÊý¾Ý¿âÌáʾÐÅÏ¢¿ò£¬µÈÅäÖÆÍê³É¾ÍÍ˳ödbca£¬Íê³ÉÊý¾Ý¿âemÅäÖÆ¡£
Óŵ㣺ʹÓÃÕâÖÖ·½·¨¼òµ¥£¬·½±ã£¬Ò²²»ÈÝÒ×ÅäÖôíÎ󣬲»ÐèÒª¼Ç×¢¸´ÔÓÃüÁһ°ãÅäÖÆ¶¼Äܳɹ¦¡£
ȱµã£ºÔÚ²»ÄÜʹÓÃdbca»·¾³µ±ÖоͲ»ÄÜʹÓÃÁË£¬ÔÚlinuxϹ¤ÊÖ´´½¨Êý¾Ý¿âÊDz»ÄÜÓÃdbcaÅäÖÆ£¬dbcaÒ²²»ÄÜɾ³ýem
×ÊÁÏ¿â´æºÍÈ¡ÏûDatabase ControlÅäÖÆ¡£
µÚ¶þÖÖ·½·¨£¬ÓÃemcaÅäÖÃem
emcaÊÇÒ»¸öÃüÁîÌáʾ·û£¬Ê¹ÓøñʽºÍ·½·¨ÔÚÃüÁîÌáʾ·ûÏÂÊäÈëemca,ÆÁÄ»ÉÏ»á³öÏÖemcaʹÓðïÖú¡£
ÃüÁî°ïÖúÈçÏ£º
emca [²Ù×÷] [ģʽ] [Êý¾Ý¿âÀàÐÍ] [±ê¼Ç] [²ÎÊý]
³£ÓÃÒÔÏÂÁ½¸öÃüÁî:
emca -config dbcontrol db -repos create                ´´½¨em×ÊÁϿⲢͬʱÅäÖÆDatabase Control
emca -deconfig dbcontrol db -repos drop                ɾ³ýDatabase Control²¢Í¬Ê±É¾³ýem×ÊÁÏ¿â
ÎÒµÄÀí½âÈçÏÂ:
[²Ù×÷] ¶ÔÓ¦µ½-configºÍ-deconfig Òâ˼ÊÇÅäÖÆÒâ˼¡£×¢Òâ"-"²»ÄÜÉÙ
[ģʽ] ¶ÔÓ¦µ½dbcontrol£¬Òâ˼ÊÇDatabase Control
[Êý¾Ý¿âÀàÐÍ] ¶ÔÓ¦µ½ db ,Òâ˼ÊÇÊý¾Ý¿â,¶ÔÊý¾Ý¿â (°üÀ¨Ê¹Óà ASM µÄÊý¾Ý¿â) Ö´ÐÐÅäÖòÙ×÷
[±ê¼Ç] ÕâÀïûÓС£
[²ÎÊý] ¶ÔÓ¦µ½-repos createºÍ-repos drop,Òâ˼´´½¨em×ÊÁÏ¿âºÍɾ³ýµ±Ç°em×ÊÁÏ¿â
Èç¹ûÎÒÃÇûÓÐÅäÖÆ¹ýDatabase ControlҲûÓÐem×ÊÁϿ⣬ÎÒÃÇÊäÈëÈçÏÂÃüÁî


Ïà¹ØÎĵµ£º

db2,oracle,mysql³£ÓÃÃüÁî±È½Ï


¡¶oracle,db2,mysqlÀà±È¡·×÷ΪÈýÖÖÊý¾Ý¿âÒ»¸öÀà±È£¬Ä¿µÄÔÚÓÚͨ¹ýÀà±È£¬Á˽âÏÖÔÚÊý¾Ý¿âÏàËÆµãÓëÒìͬµã£¬Í¬Ê±¿ÉÒÔ°ïÖú´ó¼ÒÔÚÁ˽âÒ»ÖÖÊý¾Ý¿â£¬Äܹ»Ñ¸ËÙµØÑ§»áÆäËûÊý¾Ý¿â¡£³õ²½¶¨ÒåΪoracle,db2,mysqlÈýÖÖÊý¾Ý¿â£¬ÒÔºó¿ÉÄÜ»¹ÊÇ×·¼Óinformix,sysbase,sql serverµÈÊý¾Ý¿â¡£
±¾Æª×÷ΪÊׯª£¬Ä¿µÄÊÇÈôó¼Ò¶ÔÕâÈýÖÖÊý¾Ý¿â³£ÓõÄÖªÊ ......

Oracle °Ù·Ö±È

ÈÕǰÓöµ½Ò»¸öÎÊÌ⣬ÐèÒª¶ÔÔÚOracleÊý¾Ý¿âÖвéѯ³öÀ´µÄÊýÖµ½øÐбÈÂʵļÆËã¡£ÀàËÆÓÚÈçϵÄSQL£º
Select Round((discount/Amount),2) from dual;
ÕâÑùËã³öÀ´µÄÊý×Ö¿ÉÒÔÂú×ã¾ø´ó²¿·ÖµÄÐèÇó¡£µ«ÊǶÔÓÚ²»µ½1µÄÊý×Ö£¬ÎÊÌâ³öÀ´ÁË......ÏÔʾµÄÀàËÆÓÚ .45Ñù×ÓµÄÊý¾Ý¡£0.45Ç°ÃæµÄ0²»¼ûÁË¡£
ÒÔÏÂ×ܽáÁËÁ½ÖÖ·½·¨À´½â¾öȱ0µÄÎÊÌâ¡£
µÚ ......

Oracle Óαê

·¢ÏÖһƪ¹ØÓÚÓαêµÄÎÄÕ£¬¸Ð¾õдµÄºÜ²»´í£¬ÏÈÊÕ²ØÁË£»µ«ÊÇÀïÃæÓÐһЩ´íÎó£¬=ÓÐʱ¼äÁËÔÙÕûÀíһϡ£
--------
ÎÒÃǽ«ÌÖÂÛ¸÷ÖÖÓÃÓÚ·ÃÎÊORACLEÊý¾Ý¿âµÄDDLºÍTCLÓï¾ä¡£ 
²éѯ 
    SELECTÓï¾äÓÃÓÚ´ÓÊý¾Ý¿âÖвéѯÊý¾Ý£¬µ±ÔÚPL/SQLÖÐʹÓÃSELECTÓï¾äʱ£¬ÒªÓëINTO×Ó¾äÒ»ÆðʹÓ㬲éѯµÄ·µ»ØÖµ±»¸³Ó ......

´´½¨OracleÊý¾Ý¿â£¨ÒÔOracle10gΪÀý£©

´´½¨OracleÊý¾Ý¿â£¨ÒÔOracle10gΪÀý£©
ÓÐÁ½ÖÖ´´½¨Êý¾Ý¿âµÄ·½Ê½£¬Ò»ÖÖÊÇÒÔÃüÁîÐнű¾·½Ê½£¬¼´ÊÖ¶¯·½Ê½´´½¨£»ÁíÒ»ÖÖÊÇÀûÓÃOracleÌṩµÄÊý¾Ý¿âÅäÖÃÏòµ¼À´´´½¨¡£±¾ÆªÖ÷Òª½éÉÜÔÚUnixºÍWindowsÏÂÒÔÃüÁîÐнű¾·½Ê½´´½¨OracleÊý¾Ý¿â¡£
     Ò»¸öÍêÕûµÄÊý¾Ý¿âϵͳ£¬Ó¦°üÀ¨Ò»¸öÎïÀí½á¹¹¡¢Ò»¸öÂß¼­½á¹¹¡¢Ò»¸öÄÚ´ ......

oracle database system parameters on sol9

* start Oracle *
set noexec_user_stack=1
set msgsys:msginfo_msgmax=65535
set msgsys:msginfo_msgmnb=65535
set msgsys:msginfo_msgmap=258
set msgsys:msginfo_msgmni=1792
set msgsys:msginfo_msgssz=32
set msgsys:msginfo_msgtql=1792
set msgsys:msginfo_msgseg=32767
set shmsys:shminfo_shmmax=4294967 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ