Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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×ÊÁϿ⣬ÎÒÃÇÊäÈëÈçÏÂÃüÁî


Ïà¹ØÎĵµ£º

rlwrapʹÓ÷½·¨£¨oracleµÄÖ¸ÁîÉÏÏ·­頁¹¤¾ß£©

rlwrapʹÓ÷½·¨
¹Ø¼ü×Ö: rlwrapʹÓ÷½·¨
ÔÚWindows²Ù×÷ϵͳÉÏ,µ±ÔÚDOSÃüÁî´°¿ÚÖÐÔËÐÐSQL*PlusµÄʱºò,¿ÉÒÔʹÓÃÏòÉÏ,ÏòϼüÀ´Ìø»ØÖ®Ç°ÒѾ­Ö´ÐйýµÄSQLÓï¾ä.Äã¿ÉÒÔ¸ù¾ÝÐèÒªÐÞ¸ÄËûÃÇ,È»ºó°´Enter¼üÖØÐÂÌá½»Ö´ÐÐ.
È»¶ø,µ±ÔÚLinux ShellÖÐÔËÐÐSQL*PlusµÄʱºò,²¢²»Ìṩä¯ÀÀÀúÊ·ÃüÁîÐеŦÄÜ.
ΪÁËÔÚLinuxÖдﵽͬÑùµÄÄ¿µÄ,Ä ......

Solaris10 °²×°Oracle 10g

http://inthirties.com:90/thread-1233-1-1.html
ºÃûÓÐÅöSolarisÁË£¬ÊÖÓÐЩÉúÁË£¬¿´À´ÕæÒª×°¸ösolaris£¬Æ½Ê±¶àÍæÍæ¡£
ÔÚsolarisÉÏ×°Oracle 10gÏÈ¡£
1. ¼ì²é°²×°ÒÀÀµ°ü
¹Ù·½ÒªÇóµÄ°ü
SUNWarc
SUNWbtool
SUNWhea
SUNWlibm
SUNWlibms
SUNWsprot
SUNWtoo
SUNWi1of
SUNWi1cs
SUNWi15cs
SUNWxwfnt
Ö´ÐÐÃüÁî
# p ......

ORACLEÀàËÆsplitº¯ÊýµÄ¹¦ÄÜ

 SELECT ID,
       col_name,
       SUBSTR(col_name, 1, INSTR(col_name || ',', ',', 1, 1) - 1) C1,
       SUBSTR(col_name,
              ......

oracleµÄ¶Áд±í²¢·¢²Ù×÷

 k Ëµ(14:52):
ÎʸöÎÊÌâ ²éѯÊý¾Ý¿â±íµÄʱºò ¸Ã±í»¹ÄÜдÊý¾ÝÂð  Êǰ´ÕÕÅŶӵÄ˳Ðò »¹Êǰ´ÕÕ²Ù×÷µÄʱ¼ä˳Ðò(²»ÖªµÀoracleÈçºÎ´¦ÀíÕâ¸öÎÊÌ⣩  ¼ÙÉèÒ»¸öÇé¿ö£ºÎÒÏÖÔÚÔÚ²éѯ¼Æ·Ñ±í£¨Õâ¸öʱ¼ä¿ÉÄÜÒª»¨10·ÖÖÓ£© 10·ÖÖÓÓÐºÜ¶à¼Æ·ÑÊý¾ÝÒªÈë¼Æ·Ñ±í£¨ÄÇÕâ¸öдÊý¾ÝÊÇÒªµÈÎÒ²éѯÍêÁËÖ®ºó²ÅÄÜдÂ𣩠дÊý¾Ý¿â¿Ï¶¨º ......

Oracle½«±íÊÚȨ¸øÓû§µÄÃüÁî

Oracle½«±íÊÚȨ¸øÓû§µÄÃüÁî
ÃüÁgrant  xxxȨÏÞ on TableA to USERA
grant select,insert,update,delete on ±íÃû to Óû§Ãû
ÀýÈ磺½«test±íµÄ²éѯȨÏÞ¸³ÓèsolidwangÕâ¸öÓû§
grant select on test to solidwang ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ