¹ØÓÚlinuxÏÂoracleµÄÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí
1¡£ÔÚlinuxÏ ÎÒµÄoracle OEM½çÃæÎÞ·¨´ò¿ª Ò»Ö±ÌáʾÎÞ·¨Á¬½Ó £¨ÎÒÊäÈëµÄÊÇ http://xxxxx.1156/em£©
2¡£ÊäÈëDBCA ϵͳÌáʾ ÎÞ·¨Á¬½ÓÊý¾Ý¿â
Çë½Ì¸÷λ´óϺ Õâµ½µ×ÊÇʲôÔÒò ÎÒ²éÁ˲»ÉÙ×ÊÁ϶¼ÎÞ·¨½â¾ö
Ò»°ãÇé¿öÏÂĬÈÏΪhttp://xxxxx.1158/em
°²×°µÄʱºòÊÇ·ñÉèÖÃÁËEMµÄ×Ô¶¯Æô¶¯¡£
Èç¹ûÄãÊǸհ²×°µÄoracle¾Í²»ÄÜ´ò¿ªEM£¬ÄÇô¿ÉÄÜÊÇÄã°²×°ÓÐÎÊÌâ¡£
ÎÒ°²×°ºÃÁËÒÔºóÊÇ¿ÉÒÔ´ò¿ªµÄ µ«ÊÇÏÖÔÚÎÞ·¨´ò¿ªÁË ÊǸúÍøÂçÓÐ¹Ø »¹ÊÇʲô ÇëÎÊ´ò¿ªoemÐèÒªÄÄЩÏȾöÌõ¼þ°¡
»¹ÓÐÇë¸÷λ´óϺ°ïÎÒ½â¾öһϵڶþ¸öÎÊÌâ~~~ллÁË~
SQL PLUSÄܹ»Á¬½ÓÊý¾Ý¿â?
Ŷ ²»ºÃÒâ˼ ÊÇÎÞ·¨Á¬½Ó·þÎñÆ÷ ~~~~
·Ç³£¸Ðл ÎÒÈ¥ÊÔÊÔ
Ïà¹ØÎÊ´ð£º
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄÔʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£
ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ
http://www.oracle.com/technology/software/products/database/index.html
------------------------------------------- ......
ÓÃ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
......
×öÍædata guard ºó
ÔÚPrimary·þÎñÆ÷ Ö´ÐÐ
SQL>SELECT SEQUENCE#,APPLIED from V$ARCHIVED_LOG ORDER BY SEQUENCE#;
SEQUENCE# APP
---------- ---
13 NO
13 YES ......