½ÌÄãÈçºÎÓÃ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×顣ȻºóÐèÒªÔÚ±¾µØ²ßÂÔÖиø¸ÃÓû§¸³Ò»¸öÅú´¦ÀíȨÏÞ¡£·½·¨ÊÇ£º
¡¡¡¡¿ØÖÆÃæ°å--ÖÎÀí¹¤¾ß--±¾µØ°²È«²ßÂÔ--±¾µØ²ßÂÔ--Óû§È¨Àû
Ïà¹ØÎĵµ£º
LinuxÏÂÆô¶¯oracle10gµÄemºÍisqlplusµÄ·½·¨:
×¢:$ORACLE_HOMEΪoracleµÄ°²×°Â·¾¶
1,ʹÓÃEM(enterprise managment)
1.1Æô¶¯EM
$ORACLE_HOME/bin/emctl start dbconsole
Èç¹û³öÏÖÏÂÃæÏà¹ØÐÅÏ¢,˵Ã÷·þÎñÆô¶¯
Z set to PRC
Oracle Enterprise Manager 10g Database Control Release 10.1.0.3.0
Copyright (c) 1996, 200 ......
Õâ´ÎµÄ¾ÀúÊÇ×Ô¼ºÕÒÀ´µÄ£¬ÔÚ°²×°ÁË10gµÄÄÇ̨»úÉÏÉý¼¶ÏÂÄÚ´æÒ²±ãÄܺöÓÆÄÇȺÓÑ£¬²»¹ýÏëÏ뻹ÊÇÕÛÌÚÏ°ɣ¬¸øÒƵ½ÅäÖúõãµÄServerÉÏÃ棬ËûÃÇÓÃÆðÀ´Ë³ÐÄ£¬ÎÒ×Ô¼ºÒ²ÄÜÕÛÌÚµã¾Ñé¡£
132µÄϵͳÊÇSuSE10.2µÄ£¬Ö®Ç°ÒѾ°²×°ÁËOracle 9i£¬Õâ¾ÍÒâζ×űØÐëÏÈжÔصô9i£¬±¾ÒÔΪ°²×°10gµÄrunInstallerÄܹ»Ð¶Ôصô9i£¬¿É³¢ÊÔÁ˺þö¼ÊdzöÏÖex ......
ÏÖÔÚÔÚWEB Ó¦ÓÃÖÐʹÓ÷ÖÒ³¼¼ÊõÔ½À´Ô½ÆÕ±éÁË£¬ÆäÖÐÀûÓÃÊý¾Ý¿â²éѯ·ÖÒ³ÊÇÒ»ÖÖЧÂʱȽϸߵķ½·¨£¬
ÏÂÃæÁгöÁËOracle, DB2 ¼° MySQL ·ÖÒ³²éѯд·¨¡£
Ò»£ºOracle
select * from (select rownum,name from table where rownum <=endIndex )
where rownum > startIndex
¶þ£ºDB2
DB2·ÖÒ³²éѯ
SELECT * ......
OracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹ÔÓ뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃüÁî¿ÉÒÔ°ÑdmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£ ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓÃÀ´ÕýʽʹÓá£
Ö´Ðл·¾³£º¿ÉÒÔÔÚSQLPLUS.EXE»òÕßDOS£¨ÃüÁîÐУ©ÖÐÖ´Ð ......
²©ÑåÅàѵ²¿ÊÇÄ¿Ç°¹úÄÚΨһµÄ Oracle ¹Ù·½ÊÚȨ ERP ÈÏÖ¤Åàѵ»ú¹¹
Ä¿Ç°£¬Oracle Ó¦ÓÃϵͳÔÚÈ«Çò¿ç¹ú¹«Ë¾µÃµ½¹ã·ºÓ¦Óã¬ÖîÈçÖйúÒƶ¯¡¢ÉîÛÚ»ªÎª¡¢»ôÄáΤ¶û¡¢¿µÃ÷˹Öйú¡¢ÃÀ¹úÂÁÒµ¡¢DHL ºÍ±¦ÐÅÈí¼þµÈÖªÃû¹«Ë¾¡£Îª´Ë£¬Oracle ×Éѯ¹ËÎÊÊÇÈ«ÇòºÍÖйúÊг¡ÉÏ×î½ôȱµÄÈ˲ÅÖ®Ò»¡£Í¨¹ýOracle ÉÌÎñÌ×¼þÈÏÖ¤µÄ×Éѯ¹ËÎ ......