½ÌÄãÈçºÎÓÃOMSʵÏÖOracleÖÐÊý¾Ý±¸·Ý
ÔÚOracle 9iÖпÉÒÔ·½±ãµÄ°ÑÊý¾Ýµ¼³öΪÎļþ£¬»òÕß´ÓÎļþµ¼È롣ͨ¹ýOracleµÄÖÎÀí·þÎñÆ÷£¨Oracle Management Server£¬OMS£©¿ÉÒÔ·½±ãµÄʵÏÖ£¬Õû¸ö²Ù×÷¹ý³ÌÖÐÓкܶàµØ·½ÐèÒª½âÊÍ˵Ã÷£¬µ«ÊÇÍêÕûµÄÖ¸µ¼×ÊÁϲ»¶à¡£¸÷´óÂÛ̳ÉϺܶàËùνµÄ¸ßÊÖ£¬¶Ô¸ÃÖ÷ÌâµÄ»Ø´ðÍùÍùÊÇ£¬¸ßÊÖÊDz»ÓÃOMSµÄ£¬ÓÃeXP/impl°É¡£¼ÙÈçÄãÖ´Òâ×·ÎÊ£¬Ëû¶à°ë»á¸æËßÄ㣬ÆäʵÎÒÒ²²»ÖªµÀ¡£¼ÙÈçÓÐÒ»·ÝÎĵµ¿ÉÒÔɵ¹ÏʽµÄÖ¸µ¼ËûÃÇÈçºÎÀ´×ö£¬´ó¶àÊýÈË»áÐÀϲÈô¿ñÇÒÈôÎÞÆäʵÄÏÂÔر£´æ£¬»ØÈ¥ÂýÂýÑо¿¡£¶ÔÓÚÕâÑù×ÔÒÔΪ¸ßÊÖµÄÈË£¬Ö»ËÍËûÃÇÁ½¸ö×Ö£º±ÉÊÓ¡£
¡¡¡¡Ê¹ÓÃEntERPrise Manager ConsoleµÇ½µÄʱºò£¬»áÓÐÁ½¸öÑ¡Ï¶ÀÁ¢Æô¶¯ºÍµÇ½µ½Oracle Management Server¡£Ç°Õß¿ÉÒÔÈÃÎÒÃÇÖ´ÐÐһЩÆÕͨµÄÖÎÀí¹¤×÷£¬±ÈÈçÖÎÀíÕÊ»§¡¢Êý¾Ý¿â¶ÔÏóµÈ£¬Ö»ÓкóÕß²ÅÄÜΪÎÒÃÇÌṩ±¸·ÝµÄ¹¦ÄÜ¡£²»¹ýÔڵǽµ½OMS֮ǰ£¬Äã±ØÐëÊ×ÏÈ°²×°OMS·þÎñ¡£
¡¡¡¡Æô¶¯Oracle universal installer£¬²é¿´ÒÑ°²×°²úÆ·£¬Õ¹¿ªOracleÖ÷Ŀ¼--oraHome92£¬¼ÙÈçûÓÐOracle9i Management and integration£¬±íʾÄãÉÐδ°²×°¡£°²×°·½·¨ÊÇ£º
¡¡¡¡ÔÚOracle universal installerµÄ¿ÉÓòúÆ·ÁбíÖУ¬Ñ¡Ôñ°²×°Oracle 9i Management and integration--Oracle Management Server¼´¿É¡£
¡¡¡¡°²×°Íê³Éºó£¬ÄãÐèÒªÅäÖÃÒ»¸öÖÎÀí×ÊÁϿ⣬Æô¶¯£ºConfiguration and Migration tools--Enterprise Manager Configuration Assistant¡£ÔÚÅäÖòÙ×÷ÖÐÑ¡ÔñÅäÖñ¾µØµÄOracle Management Server--´´½¨Ò»¸öеÄ×ÊÁÏ¿âµµ°¸--µäÐÍ¡£ÏµÍ³½«»á´´½¨Ò»¸öÃûΪoemrepµÄÊý¾Ý¿â£¬±£´æÖÎÀíÐÅÏ¢£¬ÆäÖÐÄãÐèÒªÖ¸¶¨sysºÍsystemÕʺŵÄÃÜÂë¡£
¡¡¡¡°²×°Íê³Éºó£¬Æô¶¯Manage Server·þÎñ£¬WindowsÏÂÄã¿ÉÒÔµ½ºǫ́·þÎñÖÐÖ±½ÓÆô¶¯£¬ËüµÄÃû×ÖÊÇOracleOraHome92ManagementServer¡£Í¬Ê±Çë±£Ö¤ÆäËû×Ô¶¯Æô¶¯µÄOracle·þÎñÒ²ÊÇÆô¶¯µÄ¡£
¡¡¡¡È»ºó¿ÉÒÔÓÃEnterprise Manaer ConsoleµÇ½ÁË£¬ÕʺÅsysman ÃÜÂëoem_temp¡£µÚÒ»´ÎµÇ½ºóϵͳ»áÒªÇóÄãÊäÈëеÄsysmanÃÜÂë¡£¼ÙÈçÔڵǽµÄʱºò³öÏÖ”Éí·Ý֤ʵ²»ÕýÈ·”µÄÌáʾ£¬ÇëÈ·ÈÏÄãʹÓõĵǽÕʺÅÊÇsysman£¬¼ÙÈçÕʺÅÎÞÎóȴʼÖÕ³öÏָôíÎó£¬Çëɾ³ý¸Õ²Å½¨Á¢µÄ×ÊÁϿ⣬ÖØн¨Ò»¸ö¡£
¡¡¡¡¼ÙÈçÄãʹÓÃWindows£¬±¸·ÝÊý¾Ý֮ǰ£¬Ê×ÏÈÐèÒª½¨Á¢Ò»¸ö²Ù×÷ϵͳµÄÓû§£¬×¨ÃÅÓÃÓÚOracle±¸·Ý£¬±ÈÈ罨Á¢Óû§oracle_back£¬Á¥ÊôÓÚAdministrator×éºÍora_dba×顣ȻºóÐèÒªÔÚ±¾µØ²ßÂÔÖиø¸ÃÓû§¸³Ò»¸öÅú´¦ÀíȨÏÞ¡£·½·¨ÊÇ£º
¡¡¡¡¿ØÖÆÃæ°å--ÖÎÀí¹¤¾ß--±¾µØ°²È«²ßÂÔ--±¾µØ²ßÂÔ--Óû§È¨Àû
Ïà¹ØÎĵµ£º
¡¡¡¡1£© ÓÃSELECTÓï¾ä´Ó±íÖÐÌáÈ¡²éѯÊý¾Ý¡£Ó﷨Ϊ
¡¡¡¡SELECT [DISTINCT] {column1,column2,…} from tablename WHERE {conditions} GROUP BY {conditions} ORDER BY {expressions} [ASC/DESC];
¡¡¡¡ËµÃ÷£ºSELECT×Ó¾äÓÃÓÚÖ¸¶¨¼ìË÷Êý¾Ý¿âµÄÖÐÄÄЩÁУ¬from×Ó¾äÓÃÓÚÖ¸¶¨´ÓÄÄÒ»¸ö±í»òÊÓͼÖмìË÷Êý¾Ý¡£
¡¡¡¡2£© ......
alter table µÄ¹¦ÄÜÊÇÐ޸ıí¸ñ¡£°üÀ¨ÖØÃûÃü£¬¼Ó¼õ×Ö¶Î,ÐÞ¸Ä×Ö¶ÎÀàÐͺʹóС£¬´¦Àí Ô¼ÊøµÈµÈ¡£±¾Àý×ÓÖ®´¦Àí±íÃûºÍ×ֶΣ¬´úÂëÈçÏ£º
create table liu(a varchar2(20),b number(2))
alter table liu rename to jin
rename jin to cai
alter table cai add c varchar2(30)
alter table cai add (d varchar2(3 ......
×î½üʱ¼ä£¬¸ü»»ÁËÏîÄ¿×飬×î½üͻȻ·¢ÏÖOracle Listener²»ÄÜÆô¶¯¡£ÒÔÇ°·¢ÏÖ²»ÄÜÆô¶¯µÄÔÒòÊÇ£¬ÖØ×°ÁËOracleºóûÓÐɾ³ýÒÔÇ°µÄ×¢²á±í£¬ÒÔÖÁÓÚĬÈÏÆô¶¯·þÎñµÄÃüÁîÎļþÖ¸ÏòµÄÒÀÈ»ÊÇÒÔÇ°µÄλÖã¬ËùÒÔ²»ÄÜÆô¶¯£¬µ«Õą̂µçÄÔµÄOracleÖ»×°ÁËÒ»´Î¡£
×òÌìͻȻ·¢ÏÖ£¬ÔÚlistener.oraÎļþÖеÄHostÅ ......
²©ÑåÅàѵ²¿ÊÇÄ¿Ç°¹úÄÚΨһµÄ Oracle ¹Ù·½ÊÚȨ ERP ÈÏÖ¤Åàѵ»ú¹¹
Ä¿Ç°£¬Oracle Ó¦ÓÃϵͳÔÚÈ«Çò¿ç¹ú¹«Ë¾µÃµ½¹ã·ºÓ¦Óã¬ÖîÈçÖйúÒƶ¯¡¢ÉîÛÚ»ªÎª¡¢»ôÄáΤ¶û¡¢¿µÃ÷˹Öйú¡¢ÃÀ¹úÂÁÒµ¡¢DHL ºÍ±¦ÐÅÈí¼þµÈÖªÃû¹«Ë¾¡£Îª´Ë£¬Oracle ×Éѯ¹ËÎÊÊÇÈ«ÇòºÍÖйúÊг¡ÉÏ×î½ôȱµÄÈ˲ÅÖ®Ò»¡£Í¨¹ýOracle ÉÌÎñÌ×¼þÈÏÖ¤µÄ×Éѯ¹ËÎ ......