Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

¼ÆËã»úÃû¸ÄÁË,µ¼ÖÂ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 Æô¶¯µÄÎÊÌâ

oracle not available
shared memory realm does not exist
ÇëÎʸßÊÖÕâ¸öÎÊÌâÈçºÎ½â¾ö£¿
http://www.inthirties.com/thread-109-2-1.html

Ö¸¶¨ÏÂORACLE_SID,ORACLE_HOME¿´¿´£¬²»ÐоÍÓÃ1Â¥µÃ·½·¨ÁË..

cm ......

[ÇóÖú] oracleÎÞ·¨Æô¶¯

·þÎñÆ÷ϵ缸Ììºó½ñÌìÉϵ磬Êý¾Ý¿âÈ´ÔõôҲÆð²»ÁËÁË£¬¾ßÌåÇé¿öÈçÏ£º

SQL> startup
ORACLE instance started.

Total System Global Area 5010685952 bytes
Fixed Size      & ......

oracleÀïд¸ö´æ´¢¹ý³ÌÑ­»·²åÈë10ÍòÌõ¼Ç¼

¸ßÊÖ¸ø¸ö´æ´¢¹ý³Ì£¬ÄÜÑ­»·²åÈë10ÍòÌõ¼Ç¼£»ÔÚÏߵȡ£¡£¡£
Ñ­»·²åÈë10ÍòÌõ¼Ç¼£¿ÄܾßÌåµãÂð
ûÃ÷°×

SQL code:

--Á½±íÈç¹ûÒ»ÖÂʱ£º
insert into tableA as select * from tableB;

ÕâÎÊÌâÎʵÄ

ÎÞÃûÀÏ× ......

oracleÖÐÓɳöÉúÄêÔ»ñµÃÄêÁä

select sname,(2009-10-05)-birth
from student;

birth×Ö¶ÎÖдæµÄÊdzöÉúÄêÔ£¬Ïë²éѯ³öÀ´µÄ½á¹ûÊÇÄêÁ䣬¸ÃÈçºÎ²éѯ£¿
¼ÓÉÏdatediffº¯ÊýÊÔÊÔ

select sname, to_char(sysdate,'YYYY')- to_char( ......

¡¾ÇóORACLE°æ±¾ÏÂÔØ¡¿

±¾ÈËϵͳWIN7
Ìý˵ ¿ÉÒÔ×°Oracle10.2.1 ºÍ11
²»ÄÜ×°Oracle9i

Çó¸öÏÂÔØËÙ¶È¿ìµãµÄOracle10.2.1ºÍ11 µÄÁ´½Ó

ллÁË £¨Ö±½ÓÒªÁ¬½Ó£©
sf ²»Áô ºÇºÇ


ÎÒÓÐ10.2µÄ°²×°³ÌÐò£¬ÒªµÄ»°¸øÄã·¢¹ýÈ¥
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ