Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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


Ïà¹ØÎÊ´ð£º

ÖªµÀÔõô°Ñsasµ¼ÈëoracleµÄ½øÀ´¿´¿´

ÎÒÏÖÔÚÓÐһЩsasÉÏÃæµÄÊý¾ÝÎļþ ÏÖÔÚÎÒÐèÒª°Ñsasµ¼Èëµ½oracle
ÏÖÔÚ°ÑÒ»¸ösasÎļþµ¼Èëµ½Ò»¸öoracleÖеÄÒ»¸ö±íÖÐÎÒÒѾ­ÖªµÀÔõôŪÁË
µ«ÊÇ ÎÒÏÖÔÚÐèÒª°ÑsasÖеÄÁíÒ»¸öÎļþ×·¼Óµ½oracleÖеÄÒ»¸öÓÐÊý¾ÝµÄÒ»¸ö±íÉÏà ......

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

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

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

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

OracleµÄǰ¶ËÔ¼ÊøÊÇʲôÒâ˼

ÊéÉÏ˵ Ô¼Êø Ò»¹²ÓÐÁ½ÖÖ ÆäÖÐÒ»ÖÖǰ¶ËÔ¼ÊøÈçÏÂÃèÊö
ÓÐһЩ·½·¨¿ÉÒÔÓÃÓÚÖ´ÐÐǰ¶Ë£¨¼´ÓÃÓÚÊäÈëÊý¾ÝµÄÊäÈëÐÎʽÖУ©Ô¼Êø£¨¸ÃÊý¾Ý¿â³ÆÎªÏµÍ³ºó¶Ë£©

ǰ¶ËÔ¼Êø ÊÇʲôÒâ˼£¿

ÄÄλ´ó´óÂé·³ ½âÊÍÏ лл ¡£ ......

Á¬½Ó±¾µØOracle,ÔÚ³ÌÐò²éѯ²»³öÊý¾Ý

ConnectÁ¬½ÓûÎÊÌ⣬²éѯÓï¾äÔÚworksheetÀïÄܲé³öÒ»Ìõ£¬µ«ÊÇreturn ocd.ExecuteReader()ȴûÓÐÕâÌõÊý¾Ý£¬Çë½ÌÏÂ


C# code:

string m_ConnectionString = "User ID=DQADMIN;Data Source=MyBASE;Pa ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ