oracle 10g EMÖÐûÓÐdata guard manager¹¦ÄÜ
win2003£¬oracle 10.2.0.1.0£¬°²×°ºóÔÚEMÖÐûÓÐdata guard manager¹¦ÄÜ£¬ÔÚÒ³ÃæÉϲ¿Ö»ÓÐÒ»¸ö¡¾Êý¾Ý¿â¡¿µÄtabÒ³£»¿´ÁË¿´oracle emÎĵµÉÏ˵ÊÇÓ¦¸ÃÓÐtargets°¡deployments°¡µÈµÈµÄ¡£
ÔÚemÖÐÅäÖÃdataguardµÄ¹¦ÄÜ£¬»¹ÐèÒªµ¥¶À°²×°Ê²Ã´×é¼þÂð£¿
ÁíÍ⣬ÄǸöOracle Enterprise Manager 10g Grid ControlÊǸöʲô¶«¶«£¬Ôõô¾¹È»ÓÐ1¸ö¶àG£¿
³õѧoracle¹ÜÀí£¬ÎÊÌâºÜ¶à°¡ºÜ¶à£¬°¦£¡
Êǵģ¬ÔÙ²¹³äÒ»µãÎÊÌâÃèÊö£¬ÎÒÊÇÔÚvpc2007ÐéÄâ»ú+win2003ÏÂĬÈϰ²×°µÄ£¬×°ÍêºóemµÄ¶Ë¿ÚºÅÊÇ1158
ÎÒÃ÷°×ÁË£¬ÔÀ´oracle10gµÄ ÆóÒµ¹ÜÀíÆ÷·ÖΪ2²¿·Ö£ºem database consoleºÍem grid control£¬ÆäÖÐdb consoleµÄ°²×°³ÌÐò´ò°üÔÚÁËoracle10g°²×°ÅÌÖУ¬Ö»ÓÐÒ»²¿·Ö¹ÜÀí¹¦ÄÜ£»em gcÐèÒªµ¥¶ÀÏÂÔØ°²×°³ÌÐò£¨http://www.oracle.com/technology/software/products/oem/index.html£©£¬ÌṩÆóÒµ¹ÜÀíÆ÷µÄËùÓй¦ÄÜ£¬¶ødataguardµÄ´´½¨¹ÜÀí¹¦ÄÜÕýÊÇÔÚem gcÖвÅÌṩµÄ¡£
Ïà¹ØÎÊ´ð£º
°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿
1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
ÎÒÔÚ´´½¨Êý¾Ý¿âµÄʱºòÓõÄÃû×ÖΪoracle10£¬µ«ÊÇ´´½¨ºÃºó£¬ÔÚĬÈϵÄĿ¼ÏÂÏÔʾµÄÃû³ÆÈ´ÊÇoracle10g£¬ÕâÊÇΪʲô£¿
Äã¿´µÄ 10gÊǰ²×°Ä¿Â¼°É
SQL> select name from v$database;
NAME
---------
ORCL
......
ÔÚÖ´ÐаüµÄʱºòÒýÓÃoracle spatial¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏÂ
Errors in file
/user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902:
error in executing ODCIIndexStart() routine ORA-0 ......
СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿
3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......
select sum£¨a.t)from ta a group by ta.a,ÕâÌõÓï¾ä½«±ítaÖеÄÊý¾Ý°´ÕÕa×ֶηÖ×é»ã×Üt×ֶΡ£
½á¹û±ÈÈ磺
3 30
4 50
ÎÒÏëµÃµ½Õâ¸ö½á¹û£º
1 0
2 0
3 30
4 50
5 0
Õâ¸ö½á¹û£¬ÇëÎÊsqlÓï¾äÔõôд£¿¶àл
nobody ......