oracle 11g OEMÎÞ·¨Æô¶¯
ÎÒÔÚ°²×°Íê11gÖ®ºó,×°ÁËĬÈϵÄÊý¾Ý¿âorcl
È»ºóÔËÐÐhttp://Ö÷»úÃû:1158/em ½á¹ûÊÇһƬ¿Õ°×.
ÓÚÎÒÔÚDOSÃüÁîÐÐÖÐ,ÊäÈë
emctl start dbconsole
½á¹ûÌáʾ:Starting Oracle Enterprise Manager 11g Database Control ...ÇëÇóµÄ·þÎñÒѾÆô¶¯.
Õâ˵Ã÷OEMÊÇÆô¶¯³É¹¦Á˵İ¡. ÎÒÔÚ·þÎñÖÐÒ²¿´µ½¸Ã·þÎñȷʵÊÇÆô¶¯×´Ì¬µÄ.
ÎÒÔٴζ¯ÐÐhttp://Ö÷»úÃû:1158/em ½á¹û»¹ÊÇһƬ¿Õ°×.
ÎÒÔÙµ½DOSÃüÁîÐÐÖв鿴OEMµÄ״̬,ÊäÈë
emctl status dbconsole
½á¹ûÌáʾ:
https://Ö÷»úÃû:1158/em/console/aboutApplication
Oracle Enterprise Manager 11g is not running
ÎÒÕâϸ㲻¶®ÁË....
Íû´ó¼Ò°ï°ïæ,¿´¿´ÊÇʲôÔÒòÄØ?
Ïà¹ØÎÊ´ð£º
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾºÜ³ÉÊìÁË
ÒýÓÃ
oracle ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡
1. Oracle sid ÕýÈ ......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN
......
oracleµÄ°²×°ºÍʹÓö¼ºÜÄÑÂð£¿ÔÀ´Ê²Ã´¶¼²»»áʱѧÁËMySQL£¬Ò²Ã»Ôõôѧ¹ý£¬¾Í×Ô¼º×°¼¸´Î£¬Óü¸Ï£¬¾Í´ïµ½ÁË´óÌåÄÜʹÓõij̶ÈÁË£¬¿ÉÊÇoracleµ½ÏÖÔÚ²»»á×°²»»áÓ㬲»»áÅ䣬ÎÒ¾ÍÏë×°¸öoracle£¬È»ºó½¨¸öÊý¾Ý¿â£¬ÀïÃæÓм¸Õ ......