¹ØÓÚ IBM Tivoli Storage ManagerÔÚOracleÖеÄÓ¦ÓÃ
¡¶oracle´óÐÍÊý¾Ý¿âϵͳÔÚAIX/unixÉϵÄʵսÏê½â¡·ÌÖÂÛ23£º¹ØÓÚTivoli storage manage¡£ÎÄƽ Õâ¶ÎÈÕ×Ó¼äÓÐÈô¸ÉÕâ±¾ÊéµÄÅóÓÑÀ´ÓʼþÌÖÂÛTSMµÄÎÊÌ⣬ÒÔ¼°ÊDz»ÊÇÒªÉÏTSM±¸·ÝϵͳµÄÎÊÌâ¡£ÉõÖÁ°Ñ·½°¸·¢¹ýÀ´ÇëÎÒ¿´¿´£¬°Ñ¹Ø£¡Ð»Ð»Ð»Ð»´ó¼ÒµÄÐÅÈΣ¬¶ÔÕâ¸ö¶«Î÷ÎÒÒ²ÊÇÕ¾ÔÚ×îÖÕÓû§µÄ½Ç¶ÈÀ´¿´µÄ£¬ÕâÀïÎÒÃÇÌÖÂÛÌÖÂÛ£¬ÁÄÁÄ¡£ ÏÔÈ»£¬ºÃµÄ¼Æ»®ÊÇÈÝÔֵĹؼü£¬Êý¾Ý±¸·ÝÊDZ£Ö¤ÒµÎñÕý³£ÔËÐеı£Ö¤¡£Èç¹ûÕýÈ·±£»¤£¬ÔòÉ豸¹ÊÕÏ¡¢ÈËΪ´íÎó¡¢×ÔÈ»ÔÖº¦¶¼»áµ¼ÖÂÊý¾ÝµÄ¶ªÊ§¡£ Tivoli TSM£¬Tivoli Storage ManagerÊÇÒ»¸öClient/Server½á¹¹µÄ¿çƽ̨¿çÍøÂ籸·Ý¡¢»Ö¸´¼°´æ´¢¹ÜÀíÈí¼þ¡£·ÖΪÁ½¶Ë£ºTSM Client£¬Ö÷Òª¹¦ÄÜÊÇÏòTSM ServerÌṩÐèÒª±¸·ÝµÄÊý¾Ý£¬»òÕß·´Ïò²Ù×÷£»TSM Server£¬Ôò¸ºÔð¹ÜÀíTSM ClientµÄ±¸·ÝÊý¾Ý¡¢±¸·Ý²ßÂÔ¼°¹ÜÀíÁ¬½ÓÔÚTSM ServerÉϵĴ洢²úÆ·£¬ÀýÈç´ø¿â¡£
TSM¿ÉÒÔÉèÖÃ×Ô¶¯±¸·ÝºÍ»Ö¸´»úÖÆ£¬ ±¸·ÝϵͳÉèÖÃÍê³Éºó£¬Ó¦ÓÃϵͳ¾Í¿ÉÒÔÔÚÖ¸¶¨Ê±¼ä°ÑÖƶ¨±¸·ÝÊý¾ÝË͵½TSM·þÎñÆ÷Öб¸·Ý¡£ÈçÐè»Ö¸´£¬ÔòTSM Client¶ËֻҪͨ¹ýͼÐνçÃ棬»òÖ±½Ó·¢³öÖ¸Áî»Ö¸´¼´¿É¡£TSM Server»á×Ô¶¯´Ó´ø¿âÖÐÈ¡³öÎļþ£¬½»¸øTSM Client¡£Èç¹û±¸·Ý´Å´ø²»ÔÚ´Å´ø¿âÖУ¬TSM Server»áÌáʾϵͳ¹ÜÀíÔ±²åÈë´Å´ø¡£
TSM¿ÉÒÔÖ´ÐÐÔÚÏß±¸·Ý£¬ÀýÈç¶ÔOracleÊý¾Ý¿âµÄ±¸·Ý¡£Í¨¹ýTSM Connect Agent¹¤¾ß£¬TSM¿ÉÒÔ±¸·ÝÕýÔÚ´ò¿ªµÄÊý¾Ý¿â¡£¶ø¶ÔÒ»°ãµÄÎļþϵͳ£¬TSMÉõÖÁÄܹ»±¸·Ý´ò¿ªµÄÎļþ¡£ TSMµÄÒýÇæÊÇÒ»¸ö¹ØϵÊý¾Ý¿â£¬Æä´¦ÀíÄÜÁ¦ºÍËÑË÷ËÙ¶ÈÊÇTSMÐÔÄܽϺõÄÔÒò¡£
OracleµÄ±¸·Ý¿ÉÒÔÔÚÏßÈȱ¸£¬Ò²¿ÉÒÔÀ䱸£¬ÎÞÂÛOracle°ÑÊý¾Ý´æ´¢ÔÚÎļþϵͳ£¬»¹ÊÇÔÚÂãÉ豸ÉÏ¡£Í¬ÑùµØ£¬¶ÔÓÚInformix»òÕßSybaseÊý¾Ý¿âTSMͬÑùÖ§³Ö¡£ÎÒ×öµÄһЩÊý¾Ý¿âÔËάÖУ¬ºÜ¶àÓû§¶¼Ôںܳɹ¦µÄÔËÐÐ×Å¡£ ×ÜÖ®£¬Ê¹ÓÃTSM²»´í¡£¹ØÓÚTSMµÄÅäÖÃϸ½Ú£¬Çë²Î¼ûÏÂÃæµÄÁ´½Ó£º http://publib.boulder.ibm.com/infocenter/tivihelp/v1r1/index.jsp Ò²Çë²Î¼û£º http://www.usedb.cn/
Ïà¹ØÎĵµ£º
[root@localhost bin]# pwd
/usr/local/bin
[root@localhost bin]# ls
coraenv dbhome oraenv
[root@localhost bin]#
[root@localhost etc]# ls -la ora*
-rw-r--r-- 1 root root 60 2008-09-19 oraInst.loc
-rw-rw-r-- 1 oracle oinstall 731 2008-09-19 or ......
¾¹ýÁ½ÌìµÄµ¹ÌÚÖÕÓÚÔÚmacÉÏ×°ºÃoracle10g ÁË¡£ÕâÏÂÍêÃÀÁË++
½Ì³ÌÍøÉÏÓкܺã¬×Ô¼ºÒ²²»¼ÇµÃ²ÎÕÕ¹ý¶àÉÙƪÁË¡£
Ö»¼ÇÏÂ×Ô¼ºÅöµ½µÄÎÊÌâµã¡£
1,×éÎÊÌâ¡£
ÍêÈ«ÊǸöÈËʹÓã¬ËùÒÔÎÒûÓл¨ÄǸöÏй¤·òȥн¨Ò»´ó¶Ñ×éºÍÓû§£¬
Ïà·´£¬ÎÒ¾ÍÊÇÄõ±Ç°Óû§×°µÄ£¬Ö»²»¹ý£¬°Ñµ±Ç°Óû§Ò²¼ÓÈëÁËROOT×飬Õâ¸ö±È½ÏºÝ¡£
2£¬ÓеĽ ......
ÍêÈ«¸ÉµôOracleËÀËø½ø³Ì
1.²éÄĸö¹ý³Ì±»Ëø:
²éV$DB_OBJECT_CACHEÊÓͼ:SELECT * from V$DB_OBJECT_CACHE WHERE OWNER='¹ý³ÌµÄËùÊôÓû§' AND CLOCKS!='0';
2. ²éÊÇÄÄÒ»¸öSID,ͨ¹ýSID¿ÉÖªµÀÊÇÄĸöSESSION:
²éV$ACCESSÊÓͼ:SELECT * from V$ACCESS WHERE OWNER='¹ý³ÌµÄËùÊôÓû§' AND NAME='¸Õ²Å²éµ½µÄ¹ý³ÌÃû';
3. ²é³öSI ......
µÍ³É±¾»ñÈ¡OracleÏà¹ØÈÏÖ¤£¬È«Ãæ¿ìËÙÕÆÎÕOracle¼¼Êõ
ÔÚÆóҵȺÌåÖУ¬È«Çò500Ç¿£¬ÓÐ98%ÔÚʹÓÃOracle¼¼Êõ£»È«ÇòÊ®´óÒøÐоù²ÉÓÃÁËOracleÓ¦ÓÃϵͳ£¬ÔÚÖйú£¬ÅÅÃûÇ°20λµÄÒøÐж¼ÔÚʹÓÃOracle¼¼Êõ£»ÔÚͨÐÅÁìÓò£¬È«Çò20¼Ò¶¥¼¶Í¨ÐŹ«Ë¾È«²¿¶¼ÔÚʹÓÃOracleÓ¦ÓòúÆ·¡£ÔÚÖйú£¬ËùÓеĵçÐÅÓªÔËÉ ......
ADO ʹÓà ORACLE provider FOR OLE DB Çý¶¯Ê±
µ÷Óô洢¹ý³ÌÐèÒª·µ»ØÓαêʱ£¬ÔÚÁ¬½Ó×Ö·û´®ÖÐÔö¼Ó
PLSQLRSet=1 ²ÎÊý¡£
´æ´¢¹ý³ÌÖеÄÓα겻ÐèÒª¸¶³õʼֵ
Èç:
sp1: TADOStoredProc;
sp1.Close;
sp1.ProcedureName := 'pkg_ScanList_By_JobNo.sp_GetScanList';& ......