oracle²»Í¬°æ±¾Ö®¼äµÄÇл»
¼òµ¥ÃèÊöÒ»ÏÂÔÚwindowsµÄͬһÓû§Ï£¬°²×°OracleµÄ9i¡¢10gºÍ11gµÄ·½·¨¡£
OracleÔÚwindowsƽ̨ϵݲװÊÇËùÓÐƽ̨ÖÐ×î¼òµ¥µÄ£¬»ù±¾Éϲ»ÐèÒª½øÐÐÈκζîÍâµÄ´¦Àí¾Í¿ÉÒԳɹ¦µÄ°²×°£¬¿ÉÒÔ˵ûÓÐʲô¼¼Êõº¬Á¿¡£
²»¹ýÔÚͬһ̨»úÆ÷µÄͬһ¸öÓû§ÉÏͬʱ°²×°Á½¸ö²»Í¬°æ±¾µÄÊý¾Ý¿â¾ÍÐèÒªÒ»¶¨µÄ¼¼ÇÉÁË¡£ÕâÀï¼òµ¥ÃèÊöÒ»ÏÂÔÚͬʱ°²×°OracleµÄ9i¡¢10gºÍ11gÐèҪעÒâµÄÎÊÌâ¡£
Ê×ÏÈ£¬°²×°°æ±¾ÐèÒª´ÓµÍµ½¸ß¡£Ò²¾ÍÊÇ˵ÏÈ°²×°9iµÄÊý¾Ý¿â£¬È»ºó°²×°10gµÄÊý¾Ý¿â£¬×îºó°²×°11gµÄÊý¾Ý¿â¡£
µÚ¶þ£¬ORACLE_BASE¿ÉÒÔÖ¸¶¨Í¬Ò»¸öĿ¼£¬ORACLE_HOMEÐèÒªÖ¸¶¨²»Í¬µÄĿ¼¡£²ÉÓÃOFA¿ÉÒÔºÜÇáËɵĽâ¾öÕâ¸öÎÊÌâ¡£
µÚÈý£¬ÔڵͰ汾µÄÊý¾Ý¿â°²×°Íê³Éºó£¬×îºÃͨ¹ýÈÎÎñ¹ÜÀíÇø¹Ø±ÕËùÓеÄOracleÏà¹ØµÄÈÎÎñ£¬È»ºóÔÚ°²×°¸ß°æ±¾µÄÊý¾Ý¿â¡£·ñÔò°²×°¹ý³ÌÖУ¬¿ÉÄÜ»áºÍÒѾ°²×°µÄ·þÎñ³öÏÖ³åÍ»£¬±ÈÈçLISNTER·þÎñ¡£
ÔÚÈý¸öÊý¾Ý¿â°²×°È«²¿Íê³Éºó£¬ÉèÖÃÈÎÎñ¹ÜÀíÆ÷ÖÐOracleÏà¹ØµÄÈÎÎñ£¬È·±£³ýÁËÊý¾Ý¿â·þÎñÍ⣬ÆäËûµÍ°æ±¾µÄ·þÎñ¶¼´¦ÓÚÊÖ¹¤×´Ì¬£¬Ö»½«¸ß°æ±¾µÄ·þÎñ´¦ÓÚ×Ô¶¯×´Ì¬¡£
ÓÉÓÚ°²×°µÄÏȺó˳Ðò£¬¸ß°æ±¾µÄORACLE_HOME/binĿ¼ÔÚPATH±äÁ¿µÄÇ°Ã棬Ҳ¾ÍÊÇ˵£¬Èç¹ûÖ´ÐÐsqlplus¡¢rman¡¢expµÈÃüÁîÐй¤¾ßĬÈ϶¼ÊÇÔËÐи߰汾µÄOracle¹¤¾ß¡£Õâ¶ÔÓÚ´ó¶àÊýÇé¿ö²»ÊÇÎÊÌâ¡£
µ±È·ÊµÐèҪʹÓõͰ汾µÄ¹¤¾ßʱ£¬±ÈÈçÐèÒªµÍ°æ±¾µÄexp¹¤¾ß½øÐе¼³ö²Ù×÷£¬Õâ¸öʱºò¿ÉÒÔÔÚÃüÁîÐз½Ê½ÏÂÉèÖÃORACLE_HOME£¬È»ºóÔÚµ÷ÓÃexp¼´¿É£º
E:>sqlplus /nolog
SQL*Plus: Release 11.1.0.6.0 - Production on ÐÇÆÚËÄ 10ÔÂ 25 16:16:13 2007
Copyright (c) 1982, 2007, Oracle. All rights reserved.c
SQL> exit
Èç¹ûÊÇ¿Í»§¶Ë,Çл»ÈçÏÂ:
e:>path d:\oracle10g32\product\10.2.0\client_1\bin
e:>sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on ÐÇÆÚËÄ 10ÔÂ 25 16:16:51 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved
SQL> exit
E:>SET ORACLE_HOME=e:\oracleoracle1020
E:>%ORACLE_HOME%bin sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on ÐÇÆÚËÄ 10ÔÂ 25 16:16:51 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved
SQL> exit
E:>SET ORACLE_HOME=e:\oracleoracle920
E:>SET PATH=e:oracleoracle920bin
E:>sqlplus /nolog
SQL*Plus: Release 9.2.0.4.0 - Produc
Ïà¹ØÎĵµ£º
¿Î³ÌÊ®Èý ʹÓÃ×éºÏÊý¾ÝÀàÐÍ* Óαê²Ù×ÝÊý¾Ý
¡¡¡¡
¡¡¡¡±¾¿ÎÖص㣺
¡¡¡¡1¡¢´´½¨Óû§×Ô¶¨ÒåµÄPLSQL¼Ç¼
¡¡¡¡2¡¢ÀûÓÃ%ROWTYPEÊôÐÔÀ´´´½¨¼Ç¼
¡¡¡¡3¡¢´´½¨PLSQL±í
¡¡¡¡4¡¢ÃèÊö¼Ç¼¡¢±í¡¢¼Ç¼µÄ±íÖ®¼äµÄÇø±ð
¡¡¡¡×¢Ò⣺ÒÔÏÂʵÀýÖбêµã¾ùΪӢÎÄ°ë½Ç
¡¡¡¡Ò»¡¢ºÏ³ÉÊý¾ÝÀàÐÍ
¡¡¡¡1¡¢ÀàÐÍ·ÖΪPLSQL¼Ç¼ºÍPLSQL±í
¡¡¡¡2¡ ......
×÷Õß Haidong Ji ·Òë GoodKid
ÎÒÃǵ±ÖеĴ󲿷ÖÈ˹¤×÷ÔÚÒ»¸öµ¥Ò»µÄ RDBMS ϵͳÖУ¬Èç MSSQL, Oracle, or IBM DB2¡£È»¶ø£¬ÎÒÃÇÈÕÒæ¸Ð¾õµ½£¬ÎÒÃÇÕý´¦ÓÚ²»Í¬µÄÊý¾Ý¿â»·¾³µ±Öв¢ÇÒÐèÒª½â¾öÊý¾ÝµÄ»¥ÓÃÐÔÎÊÌâ¡£
¾¡¹ÜÖ÷ÒªµÄ RDBMS ³§ÉÌÊÔͼȥ×ñѹØϵÊý¾Ý¿âÄ£ÐÍÔÀí£¬²¢ÇÒÓ÷dz£Ð¡µÄ²îÒìȥʵÏÖËüÃÇ¡£ÁíÍ⣬¼¸ºõÖ÷ÒªµÄ ......
µ±ÎÒÃÇÃæ¶Ô Êý°ÙÍòÊýǧÍòÐÐÁеÄÊý¾Ý¿â±íµÄʱºò£¬¶øÄãÓÖÏ£ÍûÄܽ«Êý¾Ý¾¡¿ìµÄµ¼³ö³Étxt¸øÄãµÄÀϰ壬ÓÐÈí¼þ»òÕßÆäËû¶«Î÷µ¼³öÀ´¾ÍÏԵñȽÏÓôÃÆÁË£¬ÒòΪÀÏ°åÒª³ÔÎç·¹ÁË£¬Ëû¿É²»Ï£ÍûÔÚÏ°àµÄʱºò»¹Ìýµ½ÄãÔÚ˵£¬Êý¾ÝÕýÔÚµ¼³öÖС£
ÓÚÊÇÎÒÃÇÀûÓÃÁË£¬ËÙ¶ÈתÈëÕýÌâÁË°¡¡£
ÐèÒªµÄÄ£¿é£º
DBI£»
#!/usr/bin/pe ......
BlobÊÇÖ¸¶þ½øÖÆ´ó¶ÔÏóÒ²¾ÍÊÇÓ¢ÎÄBinary Large ObjectµÄËùд£¬¶øClobÊÇÖ¸´ó×Ö·û¶ÔÏóÒ²¾ÍÊÇÓ¢ÎÄCharacter Large ObjectµÄËùд¡£Óɴ˿ɼûÕâÁ¾¸öÀàÐͶ¼ÊÇÓÃÀ´´æ´¢´óÁ¿Êý¾Ý¶øÉè¼ÆµÄ£¬ÆäÖÐBLOBÊÇÓÃÀ´´æ´¢´óÁ¿¶þ½øÖÆÊý¾ÝµÄ£»CLOBÓÃÀ´´æ´¢´óÁ¿Îı¾Êý¾Ý¡£
ÄÇôÓÐÈ˿϶¨ÒªÎʼÈÈ»ÒѾÓÐVARCHARºÍVARBINARYÁ½ÖÐÀàÐÍ£¬ÎªÊ²Ã´»¹ÒªÔÙÊ ......
http://hi.baidu.com/fyears/blog/item/5ef68ac3feb9a45db219a836.html
select object_id,session_id,locked_mode from v$locked_object;
¡¡¡¡select t2.username,t2.sid,t2.serial#,t2.logon_time
¡¡¡¡from v$locked_object t1,v$session t2
¡¡¡¡where t1.session_id=t2.sid order by t2.logon_time;
alter system ki ......