ÊÖ¹¤ÅäÖÃ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×ÊÁϿ⣬ÎÒÃÇÊäÈëÈçÏÂÃüÁî
Ïà¹ØÎĵµ£º
1. select * from emp;
2. select empno, ename, job from emp;
3. select empno ±àºÅ, ename ÐÕÃû, job ¹¤×÷ from emp;
4. select job from emp;
5. select distinct job from emp;
6. select distinct empno, job from emp;
˵Ã÷:ÒòΪ¹ÍÔ±±àºÅ²»Öظ´, ËùÒÔ´Ëʱ֤Ã÷ËùÓеÄÁÐûÓÐÖØ¸´,ËùÒÔ²»ÄÜÏû ......
author£ºskate
time£º2010/03/16
µ±ÏµÍ³³öÏÖÐÔÄÜÆ¿¾±Ê±£¬¾¡Á¿½ÏÉÙ²»±ØÒªµÄ×ÊÔ´ÏûºÄ£¬×îºó¾ÍÊÇÆ½ºâcpu£¬Äڴ棬io£¬networkµÈ×ÊÔ´£¬Ê¹Êý¾Ý¿â
¿ÉÒÔÎȶ¨µÄÔËÐС£
oracleÊý¾Ý¿âÓÅ»¯µÄ¸ù±¾ÊÇ
1.¾¡Á¿¼õÉÙ×ÊÔ´ÏûºÄ£¬ÀýÈçÓÅ»¯sql£¬¼õÉÙsql±¾ÉíµÄ×ÊÔ´ÏûºÄ
2.Èç¹ûÎÞ·¨½øÒ»²½¼õÉÙ×ÊÔ´µÄÏûºÄ£¬ÄǾÍÈÃÊý¾Ý¾¡Á¿¿¿½ücpu£¬Ò²¾ÍÊǰÑÊý¾Ý ......
·¢ÏÖһƪ¹ØÓÚÓαêµÄÎÄÕ£¬¸Ð¾õдµÄºÜ²»´í£¬ÏÈÊÕ²ØÁË£»µ«ÊÇÀïÃæÓÐһЩ´íÎó£¬=ÓÐʱ¼äÁËÔÙÕûÀíһϡ£
--------
ÎÒÃǽ«ÌÖÂÛ¸÷ÖÖÓÃÓÚ·ÃÎÊORACLEÊý¾Ý¿âµÄDDLºÍTCLÓï¾ä¡£
²éѯ
SELECTÓï¾äÓÃÓÚ´ÓÊý¾Ý¿âÖвéѯÊý¾Ý£¬µ±ÔÚPL/SQLÖÐʹÓÃSELECTÓï¾äʱ£¬ÒªÓëINTO×Ó¾äÒ»ÆðʹÓ㬲éѯµÄ·µ»ØÖµ±»¸³Ó ......
´óÐÍÏîÄ¿¿ª·¢ÖУ¬³£ÓõÄÊý¾Ý¿â£¬µ±ÊôOracle¡£µ«Oracle
¿Í»§¶Ë°²×°¾ÍÒªÒ»ÕŹâÅÌ£¬Ìå»ýºÜ´ó¡£¶øÇÒ°²×°ºó£¬»ù±¾ÉϾÍÓÃ2¸ö¹¦ÄÜ£ºTNSÅäÖ÷þÎñÃû£¬SqlPlus¡£ÔÚ¿ª·¢¹ý³ÌÖУ¬´óÁ¿Ê¹ÓÃToadºÍPL/SQL
Developer¡£Òò´Ë£¬Oracle¿Í»§¶Ë°²×°ÅÌ£¬½ö½öÊDZ»×÷Ϊһ¸öÇý¶¯¶øÐèÒª£¬¸ù±¾Ã»±ØÒª×°ÄÇô´óµÄ¿Õ¼ä¡£Òò´Ë£¬±¾Îĸø³öÁËÈçºÎʹÓþ«¼òµÄ
......