ÊÖ¹¤ÅäÖÃ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×ÊÁϿ⣬ÎÒÃÇÊäÈëÈçÏÂÃüÁî
Ïà¹ØÎĵµ£º
rlwrapʹÓ÷½·¨
¹Ø¼ü×Ö: rlwrapʹÓ÷½·¨
ÔÚWindows²Ù×÷ϵͳÉÏ,µ±ÔÚDOSÃüÁî´°¿ÚÖÐÔËÐÐSQL*PlusµÄʱºò,¿ÉÒÔʹÓÃÏòÉÏ,ÏòϼüÀ´Ìø»ØÖ®Ç°ÒѾִÐйýµÄSQLÓï¾ä.Äã¿ÉÒÔ¸ù¾ÝÐèÒªÐÞ¸ÄËûÃÇ,È»ºó°´Enter¼üÖØÐÂÌá½»Ö´ÐÐ.
È»¶ø,µ±ÔÚLinux ShellÖÐÔËÐÐSQL*PlusµÄʱºò,²¢²»Ìṩä¯ÀÀÀúÊ·ÃüÁîÐеŦÄÜ.
ΪÁËÔÚLinuxÖдﵽͬÑùµÄÄ¿µÄ,Ä ......
ORACLE 10 ѧϰ±Ê¼Ç-µÚ4¿Î-ÃüÁî¡£
1.commit;rollback;
2.select * from dictionary;
describe dba_users;
select * from dba_users;
select name from v$controlfile;
3.
alter database drop logfile group 3
select archiver from v$instance;
alter tablespace userdata read only;
4.
select tablespace_nam ......
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;
˵Ã÷:ÒòΪ¹ÍÔ±±àºÅ²»Öظ´, ËùÒÔ´Ëʱ֤Ã÷ËùÓеÄÁÐûÓÐÖØ¸´,ËùÒÔ²»ÄÜÏû ......
´æ´¢¹ý³Ì¾ÍÊÇ×÷Ϊ¿ÉÖ´ÐжÔÏó´æ·ÅÔÚÊý¾Ý¿âÖеÄÒ»¸ö»ò¶à¸öSQLÃüÁî¡£
¶¨Òå×ÜÊǺܳéÏó¡£´æ´¢¹ý³ÌÆäʵ¾ÍÊÇÄÜÍê³ÉÒ»¶¨²Ù×÷µÄÒ»×éSQLÓï¾ä£¬Ö»²»¹ýÕâ×éÓï¾äÊÇ·ÅÔÚÊý¾Ý¿âÖеÄ(ÕâÀïÎÒÃÇ̸ֻSQL Server)¡£Èç¹ûÎÒÃÇͨ¹ý´´
½¨´æ´¢¹ý³ÌÒÔ¼°ÔÚASPÖе÷Óô洢¹ý³Ì£¬¾Í¿ÉÒÔ±ÜÃ⽫SQLÓï¾äͬASP´úÂë»ìÔÓ ......
´óÐÍÏîÄ¿¿ª·¢ÖУ¬³£ÓõÄÊý¾Ý¿â£¬µ±ÊôOracle¡£µ«Oracle
¿Í»§¶Ë°²×°¾ÍÒªÒ»ÕŹâÅÌ£¬Ìå»ýºÜ´ó¡£¶øÇÒ°²×°ºó£¬»ù±¾ÉϾÍÓÃ2¸ö¹¦ÄÜ£ºTNSÅäÖ÷þÎñÃû£¬SqlPlus¡£ÔÚ¿ª·¢¹ý³ÌÖУ¬´óÁ¿Ê¹ÓÃToadºÍPL/SQL
Developer¡£Òò´Ë£¬Oracle¿Í»§¶Ë°²×°ÅÌ£¬½ö½öÊDZ»×÷Ϊһ¸öÇý¶¯¶øÐèÒª£¬¸ù±¾Ã»±ØÒª×°ÄÇô´óµÄ¿Õ¼ä¡£Òò´Ë£¬±¾Îĸø³öÁËÈçºÎʹÓþ«¼òµÄ
......