¹ØÓÚoracle·þÎñ
OracleOraHome92Agent
OracleOraHome92ClientCache
OracleOraHome92HTTPServer
OracleOraHome92PagingServer
OracleOraHome92SNMPPeerEncapsulator
OracleOraHome92SNMPPeerMasterAgent
·Ö±ðÊÇ:
Agent´úÀí, OEMÈý²ã¹ÜÀíʱÓëOMS½øÐеǼǴ¦¹µÍ¨;
¿Í»§¶ËÐÅÏ¢Cache;
ÌṩWeb·þÎñ;
BP»ú֪ͨ·þÎñ,±ÈÈçÊý¾Ý¿âÓÐÎÊÌâ, ¿É´«ºô¹ÜÀíÔ±;
Á½¸öSNMPÐÒéÏà¹Ø·þÎñ
1.OracleDBConsoleorcl oem¿ØÖÆ̨µÄ·þÎñ½ø³Ì
2.OracleJobSchedulerORCL ¶¨Ê±Æ÷µÄ·þÎñ½ø³Ì
3.OracleOraDb10g_home1iSQL*Plus isql*plusµÄ·þÎñ½ø³Ì
4.OracleOraDb10g_home1TNSListener ¼àÌýÆ÷µÄ·þÎñ½ø³Ì
5.OracleServiceORCL Êý¾Ý¿â·þÎñ½ø³Ì
Ïà¹ØÎĵµ£º
ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬ÔÀ´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......
Æô¶¯xxService ¸úÒ»¸öxxxListener µÄ·þÎñ
怬Oracle Application Express
Oracle Application Express (Oracle APEX) ÊÇÒ»¸öÓÃÓÚ Oracle Êý¾Ý¿âµÄ¿ìËÙ Web Ó¦ÓóÌÐò¿ª·¢¹¤¾ß¡£½öƾ½è Web ä¯ÀÀÆ÷ºÍÓÐÏ޵ıà³Ì¾Ñ飬¾ÍÄÜ¿ìËÙ¿ª·¢ºÍ²¿Êð³ö°²È«µÄרҵӦÓóÌÐò¡£
http://localhost:8080/apex
ÊäÈëÓû§Ãû(Sys ......
ÒÔsystem»òÆäËû¹ÜÀíÔ±µÇ¼ ´´½¨Oracle¹Ü¿ØĿ¼
CREATE DIRECTORY hc_name_data_dir AS 'c:\ora\external\hc_name\';
CREATE DIRECTORY hc_name_log_dir AS 'c:\ora\external\hc_name\'; È·ÈÏ
SELECT * from dba_directories WHERE directory_name like '%HC%'; ÊÚÓèĿ¼ÏàӦȨÏÞ¸øÐèÒª´´½¨Í ......
È·ÈÏÉÁ»ØÆôÓÃÖÐ
SHOW PARAMETER RECYCLEBIN; ÆôÓÃÉÁ»Ø
ALTER SYSTEM SET RECYCLEBIN = ON; ÉÁ»ØDROPµÄ±í
FLASHBACK TABLE xxx TO BEFORE DROP; ³¹µ×Çå³ýDROPµÄ±í,½«²»ÄÜÔÙÉÁ»Ø.
PURGE TABLE xxx; Ö±½Ó³¹µ×DROPµô±í
DROP TABLE xxx PURGE; Çå¿ÕËùÓÐDROPµÄ±í
PURGE RE ......
ÔÚORACLE Êý¾Ý¿âµÄ¿ª·¢»·¾³ºÍ²âÊÔ»·¾³ÖУ¬Êý¾Ý¿âµÄÈÕ־ģʽºÍ×Ô¶¯¹éµµÄ£Ê½Ò»°ã¶¼ÊDz»ÉèÖõģ¬ÕâÑùÓÐÀûÓÚϵͳӦÓõĵ÷Õû£¬Ò²ÃâµÄÉú³É´óÁ¿µÄ¹éµµÈÕÖ¾Îļþ½«´ÅÅÌ¿Õ¼ä´óÁ¿µÄÏûºÄ¡£µ«ÔÚϵͳÉÏÏߣ¬³ÉΪÉú²ú»·¾³Ê±£¬½«ÆäÉèÖÃΪÈÕ־ģʽ²¢×Ô¶¯¹éµµ¾ÍÏ൱ÖØÒªÁË£¬ÒòΪ£¬ÕâÊDZ£Ö¤ÏµÍ³µÄ°²È«ÐÔ£¬ÓÐЧԤ·ÀÔÖÄѵÄÖØÒª´ëÊ©¡£ÕâÑù£¬Í¨¹ý¶¨Ê ......