¼ÆËã»úÃû¸ÄÁË,µ¼ÖÂoracle 10g em µÇ¼ÎÊÌâ?
ÈçÔÀ´¼ÆËã»úÃû½Ð "Apple",µÇ¼ʱʹÓà http://apple:1158/em
¶øÏÖÔڸijÉ"red"ÁË,ÎÒÈçºÎµÇ¼ÎÒµÄoracle em
ллÁË.
localhost:1158/em
µÇ¼ÊÔÊÔ£¬¼ÆËã»ú¸ÄÃû¿ÉÄÜ»áÒý·¢Ò»Ð©±ðµÄÎÊÌâ
½ø²»È¥.
Äã¼ì²éÏ£¬·þÎñûÆô¶¯°É
ÂÛ̳ÀïËÑË÷Ï£¬ÀàËÆµÄÌû×Ӻܶà
¿´¿´Õâ¸ö¶ÔÄãÓÐûÓÐÓÃ
Ê×ÏÈÁ˽âhostname
C:\Documents and Settings\capinfo-zcs>hostname
red
´ò¿ªÎļþC:\WINDOWS\system32\drivers\etc\hosts£¬Ôö¼ÓÒ»ÐÐ
127.0.0.1 red
ÖØÐ´ò¿ªÒ»¸öcmd£¬Ö´ÐÐemctl stop dbconsole
È»ºóÖ´ÐÐemctl start dbconsole
IEÖÐÊäÈëhttp://red:1158/em ²âÊÔ
ÒòΪÄã×ÊÁÏ¿â(AWR REPOSITORY)ÀïÃæµÄ ·þÎñÆ÷ÃûºÍem·þÎñÊǰ󶨵Ä,
Èç¹û¸Ä±äÁË·þÎñ²¿Æ÷ÃûÒò¸ÃÊDz»ÄÜʹÓÃÔÀ´µÄ·þÎñÁË,
ÕâÖÖÇé¿öÒ»°ãÐèÒªÖØÐÂÅäÖÃÏÂemÀ´½â¾öÎÊÌâ.
°´ÏÂÃæ²Ù×÷À´×ö
||||||||||||||||||||||||||
2. Stop DB Console:
export ORACLE_HOME= <path to the database home>
export ORACLE_SID= <database SID>
cd $ORACLE_HOME/bin
./emctl stop dbconsole
3. Delete the old dbconsole config files:
cd $ORACLE_HOME
rm -rf <HOSTNAME_SID>*
4. Log in to the database as SYS (not SYSMAN) and run:
SQL> drop user sysman cascade;
SQL> drop role MGMT_USER;
SQL> drop user MGMT_VIEW cascade;
SQL> drop public synonym MGMT_TARGET_BLACKOUTS;
SQL> drop public synonym S
Ïà¹ØÎÊ´ð£º
oracle not available
shared memory realm does not exist
ÇëÎʸßÊÖÕâ¸öÎÊÌâÈçºÎ½â¾ö£¿
http://www.inthirties.com/thread-109-2-1.html
Ö¸¶¨ÏÂORACLE_SID,ORACLE_HOME¿´¿´£¬²»ÐоÍÓÃ1Â¥µÃ·½·¨ÁË..
cm ......
·þÎñÆ÷ϵ缸Ììºó½ñÌìÉϵ磬Êý¾Ý¿âÈ´ÔõôҲÆð²»ÁËÁË£¬¾ßÌåÇé¿öÈçÏ£º
SQL> startup
ORACLE instance started.
Total System Global Area 5010685952 bytes
Fixed Size & ......
¸ßÊÖ¸ø¸ö´æ´¢¹ý³Ì£¬ÄÜÑ»·²åÈë10ÍòÌõ¼Ç¼£»ÔÚÏߵȡ£¡£¡£
Ñ»·²åÈë10ÍòÌõ¼Ç¼£¿ÄܾßÌåµãÂð
ûÃ÷°×
SQL code:
--Á½±íÈç¹ûÒ»ÖÂʱ£º
insert into tableA as select * from tableB;
ÕâÎÊÌâÎʵÄ
ÎÞÃûÀÏ× ......
select sname,(2009-10-05)-birth
from student;
birth×Ö¶ÎÖдæµÄÊdzöÉúÄêÔ£¬Ïë²éѯ³öÀ´µÄ½á¹ûÊÇÄêÁ䣬¸ÃÈçºÎ²éѯ£¿
¼ÓÉÏdatediffº¯ÊýÊÔÊÔ
select sname, to_char(sysdate,'YYYY')- to_char( ......
±¾ÈËϵͳWIN7
Ìý˵ ¿ÉÒÔ×°Oracle10.2.1 ºÍ11
²»ÄÜ×°Oracle9i
Çó¸öÏÂÔØËÙ¶È¿ìµãµÄOracle10.2.1ºÍ11 µÄÁ´½Ó
ллÁË £¨Ö±½ÓÒªÁ¬½Ó£©
sf ²»Áô ºÇºÇ
ÎÒÓÐ10.2µÄ°²×°³ÌÐò£¬ÒªµÄ»°¸øÄã·¢¹ýÈ¥
......