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

Oracle 11g 10g ÎÞ·¨Æô¶¯EmµÄ½â¾ö°ì·¨¡£

½â¾öOracle EMÎÞ·¨Æô¶¯
ORACLE 11g, EM ÎÞ·¨Æô¶¯µÄÎÊÌ⣬¿ÉÄÜÊÇIP¸ü¸ÄÁ˵ÄÔ­Òò£¬ËùÒÔÎÒʹÓÃÁËEMCAÃüÁîÖØÐÂÅäÖÃÁËÒ»ÏÂORACLE EM£¬¾ßÌå¹ý³ÌÈçÏ£º
I:\Documents and Settings\geshaoqing>emca -config dbcontrol db -repos recreate
EMCA ¿ªÊ¼ÓÚ 2007-10-12 11:16:40
EM Configuration Assistant 10.2.0.1.0 Õýʽ°æ
°æ ȨËùÓÐ (c) 2003, 2005, Oracle¡£±£ÁôËùÓÐȨÀû¡£
ÊäÈëÒÔÏÂÐÅÏ¢:
Êý¾Ý¿â SID: orcl
ÒÑΪÊý¾Ý¿â orcl ÅäÖÃÁË Database Control
ÄúÒÑÑ¡ÔñÅäÖà Database Control, ÒÔ±ã¹ÜÀíÊý¾Ý¿â orcl
´Ë²Ù ×÷½«ÒÆÈ¥ÏÖÓÐÅäÖúÍĬÈÏÉèÖÃ, ²¢ÖØÐÂÖ´ÐÐÅäÖÃ
ÊÇ·ñ¼ÌÐø? [yes(Y)/no(N)]: y
¼àÌý³ÌÐò¶Ë¿ÚºÅ: 1521
SYS Óû§µÄ¿ÚÁî:
DBSNMP Óû§µÄ¿ÚÁî:
SYSMAN Óû§µÄ¿ÚÁî:
SYSMAN Óû§µÄ¿ÚÁî: ֪ͨµÄµç×ÓÓʼþµØÖ· (¿ÉÑ¡):
֪ͨµÄ·¢¼þ (SMTP) ·þÎñÆ÷ (¿ÉÑ¡):
-----------------------------------------------------------------
ÒÑ Ö¸¶¨ÒÔÏÂÉèÖÃ
Êý¾Ý¿â ORACLE_HOME ................ e:\oracle\product\10.2.0\db_1
Êý ¾Ý¿âÖ÷»úÃû ................ hailang.mshome.net
¼àÌý³ÌÐò¶Ë¿ÚºÅ ................ 1521
Êý¾Ý¿â SID ................ orcl
֪ͨµÄµç×ÓÓʼþµØÖ· ...............
֪ͨ µÄ·¢¼þ (SMTP) ·þÎñÆ÷ ...............
-----------------------------------------------------------------
ÊÇ ·ñ¼ÌÐø? [yes(Y)/no(N)]: y
2007-10-12 11:17:32 oracle.sysman.emcp.EMConfig perform
ÐÅÏ¢: ÕýÔÚ½«´Ë²Ù×÷¼Ç¼µ½ e:\oracle\product\10.2.0\db_1\cfgtoollogs\emca\orcl\emca_2007-
2007-10-12 11:17:37 oracle.sysman.emcp.util.DBControlUtil stopOMS
ÐÅÏ¢: ÕýÔÚÍ£Ö¹ Database Control (´Ë²Ù×÷¿ÉÄÜÐèÒªÒ»¶Îʱ¼ä)...
2007-10-12 11:17:40 oracle.sysman.emcp.EMReposConfig dropRepository
ÐÅÏ¢: ÕýÔÚɾ³ý EM ×ÊÁϵµ°¸¿â (´Ë²Ù×÷¿ÉÄÜÐèÒªÒ»¶Îʱ¼ä)...
2007-10-12 11:24:23 oracle.sysman.emcp.EMReposConfig invoke
ÐÅÏ¢: Òѳɹ¦É¾³ý×ÊÁϵµ°¸¿â
2007-10-12 11:24:24 oracle.sysman.emcp.EMReposConfig createRepository
ÐÅÏ¢: ÕýÔÚ´´½¨ EM ×ÊÁϵµ°¸¿â (´Ë²Ù×÷¿ÉÄÜÐèÒªÒ»¶Îʱ¼ä)...
2007-10-12 11:34:36 oracle.sysman.emcp.EMReposConfig invoke
ÐÅÏ¢: Òѳɹ¦´´½¨×ÊÁϵµ°¸¿â
2007-10-12 11:35:15 oracle.sysman.emcp.util.DBControlUtil startOMS
ÐÅÏ¢: ÕýÔÚÆô¶¯ Database Control (´Ë²Ù×÷¿ÉÄÜÐèÒªÒ»¶Îʱ¼ä)


Ïà¹ØÎĵµ£º

Ò»¸öÊý¾Ý¿â²Ù×÷À࣬ÊÊÓÃÓÚOracle£¬ACCESS,SQLSERVER

     ×î½ü×öÁËÒ»¸öÊý¾ÝÕï¶ÏµÄÏîÄ¿£¬ÀïÃæ×Ô¼ºÐ´ÁËÒ»¸öÊý¾Ý¿âµÄ²Ù×÷À࣬°üº¬£ºÁ¬½ÓÊý¾Ý¿â¡¢¶ÁÊý¾Ý±í¡¢Ö´ÐÐSQL²Ù×÷£¬ÊÍ·ÅÊý¾Ý¿âµÈ×é³É£¬Ï£Íû¶Ô´ó¼ÒÓÐÓã¬ÓÉÓÚˮƽÓÐÏÞ£¬ÈôÓдíÎó»òÕß´úÂë²»×ãµØ·½»¶Ó­Ö¸Õý£¬Ð»Ð»¡£
ADOOperate.H
//////////////////////////////////////////////////////////////////////
// ......

Oracle Data Gurad ÀíÂÛ֪ʶ


RAC£¬ Data Gurad£¬ Stream ÊÇOracle ¸ß¿ÉÓÃÐÔÌåϵÖеÄÈýÖÖ¹¤¾ß£¬Ã¿¸ö¹¤¾ß¼´¿ÉÒÔ¶ÀÁ¢Ó¦Óã¬Ò²¿ÉÒÔÏ໥ÅäºÏ¡£ ËûÃǸ÷×ԵIJàÖØµã²»Í¬£¬ÊÊÓó¡¾°Ò²²»Í¬¡£
RAC ËüµÄÇ¿ÏîÔÚÓÚ½â¾öµ¥µã¹ÊÕϺ͸ºÔؾùºâ£¬Òò´ËRAC ·½°¸³£ÓÃÓÚ7*24 µÄºËÐÄϵͳ£¬µ«RAC ·½°¸ÖеÄÊý¾ÝÖ»ÓÐÒ»·Ý£¬¾¡¹ ......

ʹÓÃoracleµÄһЩ¼¼ÇÉ·½·¨

½«²éѯµÄ½á¹ûÉú³Éµ½ÎļþÖУº
set echo on --ÊÇ·ñÏÔʾִÐеÄÃüÁîÄÚÈÝ
set feedback off --ÊÇ·ñÏÔʾ * rows selected
set heading off --ÊÇ·ñÏÔʾ×ֶεÄÃû³Æ
set verify off --ÊÇ·ñÏÔÊ¾Ìæ´ú±äÁ¿±»Ìæ´úǰºóµÄÓï¾ä¡£fil
set trimspool off --È¥×ֶοոñ
set pagesize 1000 ......

PostgreSQLºÍOracleÓ÷¨ÉϵÄÒ»Ð©Çø±ð

£¨1 £© ×¢ÒâÔö¼ÓÔ¼ÊøÊ±µÄд·¨£¬ºÍORACLE ÂÔÓв»Í¬
Oracle £º
ALTER TABLE SCHEMA.PREFIX_INFO ADD (
CONSTRAINT PK_PREFIX_INFO PRIMARY KEY (INFO_ID));
PostgresQL £º
alter table schema.prefix_info add constraint prefix_info_pkey primary key(info_id);
£¨2 £©ÏµÍ³Ä¬ÈϵÄ×î´óÖµÓëORACLE ²»Í¬
Oracle £ ......

¹ØÓÚOracleµÄsession

¹ØÓÚOracleµÄsession
      1.ÈçºÎ²é¿´session¼¶µÄµÈ´ýʼþ£¿
µ±ÎÒÃǶÔÊý¾Ý¿âµÄÐÔÄܽøÐе÷Õûʱ£¬Ò»¸ö×îÖØÒªµÄ²Î¿¼Ö¸±ê¾ÍÊÇϵͳµÈ´ýʼþ¡£$system_event,v$session_event,v$session_waitÕâÈý¸öÊÓͼÀï¼Ç¼µÄ¾ÍÊÇϵͳ¼¶ºÍsession¼¶µÄµÈ´ýʼþ£¬Í¨¹ý²éѯÕâЩÊÓͼÄã¿ÉÒÔ·¢ÏÖÊý¾Ý¿âµÄһЩ²Ù×÷µ½µ×ÔÚµÈ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ