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
ÎÒÕâϸ㲻¶®ÁË....
Íû´ó¼Ò°ï°ïæ,¿´¿´ÊÇʲôÔÒòÄØ?
Ïà¹ØÎÊ´ð£º
°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿
1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN
......
SQL code:
declare
v_deptno number(2);
v_dname varchar2(14);
begin
dbms_output.put_line('ÇëÊäÈ벿ÃźźͲ¿ÃÅÃû:');
v_deptno:=&deptno;
v_dname:='&dname';
insert into dept01(deptno,dnam ......