¼ÆËã»úÃû¸ÄÁË,µ¼ÖÂ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ÉÏÃæµÄÊý¾ÝÎļþ ÏÖÔÚÎÒÐèÒª°Ñsasµ¼Èëµ½oracle
ÏÖÔÚ°ÑÒ»¸ösasÎļþµ¼Èëµ½Ò»¸öoracleÖеÄÒ»¸ö±íÖÐÎÒÒѾ֪µÀÔõôŪÁË
µ«ÊÇ ÎÒÏÖÔÚÐèÒª°ÑsasÖеÄÁíÒ»¸öÎļþ×·¼Óµ½oracleÖеÄÒ»¸öÓÐÊý¾ÝµÄÒ»¸ö±íÉÏà ......
select sname,(2009-10-05)-birth
from student;
birth×Ö¶ÎÖдæµÄÊdzöÉúÄêÔ£¬Ïë²éѯ³öÀ´µÄ½á¹ûÊÇÄêÁ䣬¸ÃÈçºÎ²éѯ£¿
¼ÓÉÏdatediffº¯ÊýÊÔÊÔ
select sname, to_char(sysdate,'YYYY')- to_char( ......
ÊéÉÏ˵ Ô¼Êø Ò»¹²ÓÐÁ½ÖÖ ÆäÖÐÒ»ÖÖǰ¶ËÔ¼ÊøÈçÏÂÃèÊö
ÓÐһЩ·½·¨¿ÉÒÔÓÃÓÚÖ´ÐÐǰ¶Ë£¨¼´ÓÃÓÚÊäÈëÊý¾ÝµÄÊäÈëÐÎʽÖУ©Ô¼Êø£¨¸ÃÊý¾Ý¿â³ÆÎªÏµÍ³ºó¶Ë£©
ǰ¶ËÔ¼Êø ÊÇʲôÒâ˼£¿
ÄÄλ´ó´óÂé·³ ½âÊÍÏ лл ¡£
......
ConnectÁ¬½ÓûÎÊÌ⣬²éѯÓï¾äÔÚworksheetÀïÄܲé³öÒ»Ìõ£¬µ«ÊÇreturn ocd.ExecuteReader()ȴûÓÐÕâÌõÊý¾Ý£¬Çë½ÌÏÂ
C# code:
string m_ConnectionString = "User ID=DQADMIN;Data Source=MyBASE;Pa ......