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

oracle manager database control invalid¡¡start

Æô¶¯“OracleDBConsole”ʱ£­£­£­³öÏÖ“Agent process exited abnormally during initialization.”
ÔÚÔËÐÐ"emctl start dbconsole "¡¡·¢ÏÖÊÇÕÒ²»µ½Ö¸¶¨Îļþ,ÔÚÍøÉÏÕÒÁËÒ»ÏÂÔ­Òò, ¸ü¸ÄµÄÖ¸¶¨Îļþ¼ÐµÄÃû³Æ£¬µ«»¹ÊDz»ÄÜÆô¶¯·þÎñ£¬½á¹ûÈÏÕæ¿´ÁËһϣ¬ÊÇCTRL+C,CTRL+V È»ºó²ÅÆô¶¯³É¹¦£¬ËùÒÔÌض¨Ð´ÏÂÀ´£¬¼Ç¼ÏÂÀ´ÕâЩÐÅÏ¢£»
D:\oracle\product\10.2.0\db_1\localhost_ORCL10G ---CTRL+C,CTRL+VÔÚͬһĿ¼£¬È»ºó¸ü¸ÄÎÄʧ¼ÐÃûΪ“¼ÆËã»úÃû_ORCL10G”
D:\oracle\product\10.2.0\db_1\oc4j\j2ee\OC4J_DBConsole_localhost_ORCL10G---CTRL+C,CTRL+VÔÚͬһĿ¼£¬È»ºó¸ü¸ÄÎļþ¼ÐÃû“OC4J_DBConsole_¼ÆËã»úÃû_ORCL10G”
£­£­£­


Ïà¹ØÎĵµ£º

ORACLE JOBºÍ´æ´¢¹ý³ÌµÄÏà¹Ø²éѯ

²é¿´Ïà¹ØjobÐÅÏ¢
¡¡¡¡1¡¢Ïà¹ØÊÓͼ
¡¡¡¡dba_jobs
¡¡¡¡all_jobs
¡¡¡¡user_jobs
¡¡¡¡dba_jobs_running °üº¬ÕýÔÚÔËÐÐjobÏà¹ØÐÅÏ¢ ¡¡
²é¿´´æ´¢¹ý³Ì packageµÈÏà¹Ø¹ý³Ì
select * from user_source where text like '%Òª²éµÄÄÚÈÝ%' ......

ORACLE´ó±íɨÃè²Ù×÷½â¾ö·½°¸

ºÜ¶àÅóÓÑÔÚʹÓÃORACLE½øÐкǫ́Êý¾Ý´æ´¢Ê±¶¼¿ÉÄÜÓöµ½ÕâÑùµÄÎÊÌ⣬ÄľÍÊÇ£¬Éè¼ÆµÄÊý¾Ý¿âÖв»¿É±ÜÃâµÄÓÐÒ»Á½¸ö±È½Ï´óµÄÊý¾Ý±í£¬ÓÐʱ¿ÉÄܸü¶à£¬Èç¹û¶ÔÕâЩÊý¾Ý±íÖ»½øÐÐINSERT²Ù×÷£¬ÄÄ»¹±È½ÏºÃһЩ£¬¿ÉÊÇÈç¹ûÒª¾­³£½øÐÐÊý¾Ý¸üУ¨UPDATE£©ºÍÊý¾ÝÑ¡È¡£¨SELECT£©£¬ÔÚÊý¾ÝÁ¿±È½ÏÉÙʱ£¬³ÌÐò»¹ÄܹýµÄÈ¥£¬Èç¹ûÊý¾ÝÁ¿Ò»´ó£¬ÉÏÁË°ÙÍòÊýÁ¿ ......

oracle×îÖØÒªµÄ9¸ö¶¯Ì¬ÐÔÄÜÊÓͼ

v$session + v$session_wait (ÔÚ10gÀ﹦Äܱ»ÕûºÏ,´ÕºÏËã1¸ö°É.)
v$process
v$sql
v$sqltext
v$bh (¸üÄþÔ¸ÊÇx$bh)
v$lock
v$latch_children
v$sysstat
v$system_event
°´×é·ÖµÄ¼¸×éÖØÒªµÄÐÔÄÜÊÓͼ
1¡£System µÄ over view
v$sysstat , v$system_event , v$parameter
2¡£Ä³¸ösession µÄµ±Ç°Çé¿ö
v$process , ......

ORACLE³£¼ûÎÊÌâ1000ÎÊ(Ö®Æß)

ORACLEÄÚ²¿º¯Êýƪ
¡¡¡¡ 255. CHARTOROWID(CHAR)
¡¡¡¡ ½«°üº¬ÍⲿÓï·¨ROWIDµÄCHAR»òVARCHAR2Êýֵת»»ÎªÄÚ²¿µÄ¶þ½øÖÆÓï·¨,²ÎÊýCHAR±ØÐëÊÇ°üº¬ÍⲿÓï·¨µÄROWIDµÄ18×Ö·ûµÄ×Ö·û´®.
¡¡¡¡ SELECT NAME from BSEMPMS WHERE ROWID=CHARTOROWID('AAAAfZAABAAACp8AAO');
¡¡¡¡ NAME : LEIXUE
¡¡¡¡ 256. CONVERT(CHAR,DEST_CHA ......

ORACLE³£¼ûÎÊÌâ1000ÎÊ(Ö®°Ë)

9I¹ÜÀíµÄV$ÊÓͼ¡£
¡¡¡¡281. V$ACCESS
¡¡¡¡ÏÔʾµ±Ç°±»Ëø¶¨µÄÊý¾Ý¿âÖеĶÔÏó¼°ÕýÔÚ·ÃÎÊËûÃǵĻỰ.
¡¡¡¡282. V$ACTIVE_INSTANCES
¡¡¡¡Îªµ±Ç°°²×°µÄÊý¾Ý¿âÖгöÏÖµÄËùÓÐʵÀý½¨Á¢´ÓʵÀýÃûµ½ÊµÀýºÅµÄÓ³Ïñ.
¡¡¡¡283. V$ACTIVE_SESS_POOL_MTH
¡¡¡¡ËùÓлµÄ»á»°³Ø×ÊÔ´·ÖÅä·½·¨.
¡¡¡¡284. V$AQ
¡¡¡¡µ±Ç°Êý¾Ý¿âÖеĶÓÁеÄͳ¼ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ