Óà Navicat for Oracle ¹ÜÀí Oracle10g/11g Êý¾Ý¿â
Navicat for xxx ÊÇÒ»¸öÓÅÐãµÄÊý¾Ý¿â¹ÜÀí¿Í»§¶Ë£¬ÓÐ MySQL¡¢Oracle µÈ°æ±¾¡£½¨Òé´ó¼Ò×îºÃÓà Enterprise °æ±¾£¬¹¦ÄÜÈ«ÃæһЩ£¬µ«½ÏÖ®ÓÚÃâ·ÑµÄ Lite °æ£¬ÆóÒµ°æ¿ÉÊÇÒª»¨Òø×ÓÂòµÄ¡£
°²×° Navicat for Oracle ºó£¬Ê×ÏÈÐèÒª½¨Ò»¸ö“Á¬½Ó”£¬×÷Ϊij¸ö¹ÜÀíÈÎÎñµÄ±êʶ£¬ÒòΪ×÷Ϊ¿Í»§¶Ë£¬Ëü¿ÉÒÔÁ¬½ÓºÍ¹ÜÀíºÜ¶àµÄÊý¾Ý¿â·þÎñÆ÷¡£
ºÍ for MySQL °æ±¾²»Í¬µÄÊÇ£¬Oracle ¹ÜÀíÓÐËüµÄÌØÊâÐÔ¡£Oracle ±ØÐëͨ¹ýËüµÄ OCI
´úÀíº¯Êý¿âÓëÊý¾Ý¿â½øÐÐÁ¬½Ó£¬Navicat µ±È»Ò²ÈƲ»¹ýÕâÒ»µã£¬ËùÒÔ±ØÐëÊ×ÏȽøÐÐ Oracle µÄ oci ÉèÖá£ÅäÖõķ½·¨ÊÇ£¬ÔËÐÐ
Navicat µÄ²Ëµ¥“¹¤¾ß/Ñ¡Ï¬ÅäÖÓÆäËü”·ÖÀàÏ嵀 OCI ²ÎÊý£¬°Ñ OCIÀà¿â£¨¶ÔÓ¦oci.dll£©ÎļþµÄ·¾¶ÊäÈ룬°´“È·¶¨”±£´æ¡£
µ«½ö½öÕâÑù×ö»¹²»¹»£¬ÒòΪÕâÒ»Çж¼ÒÀÀµÓÚÄǸö Oracle µÄ“¼´Ê±¿Í»§¶Ë”Èí¼þ°ü£¬ËùÒÔÐèÒªÏÈÏÂÔØÄǸö InstantClient
Èí¼þ°ü£¬ÉÏÃæ˵µÄ oci.dll Îļþ¾ÍÔÚÕâ¸ö°üÖС£ÏÂÔظÃÈí¼þ°üºó½âѹµ½Ò»¸öÎļþ¼Ð£¬»¹ÐèÒª×öµÄÊÇ£¬Ìí¼Ó»·¾³±äÁ¿ TNS_ADMIN
ÈÃËüµÄÖµµÈÓÚÕâ¸öÎļþ¼ÐµÄ·¾¶£¬ÔÙÔÚϵͳ±äÁ¿ path Ç°¼ÓÉÏÕâ¸öÎļþ¼ÐµÄ·¾¶¡£ÐÞ¸ÄÕâЩÅäÖòÎÊýºó£¬¿ÉÒÔ²»ÓÃÆô¶¯ Windows ϵͳ¡£
ÔÙ¾ÍÊÇÐÞ¸Ä×¢²á±í·¾¶ HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE Ï嵀 NLS_LANG
¼üÖµ£¬Õâ¸ö¼üÖµÏÖÔÚÊÇ NA£¬Òò´Ë將 NLS_LANG µÄÖµ¸ÄΪ SIMPLIFIED CHINESE_CHINA.ZHS16GBK£¬ºÍ
Oracle Êý¾Ý¿â·þÎñÆ÷ÉϵÄÒ»Ö¡£»¹¼ûÓÐÈ˸ɴà°ÑÕâ¸ö NLS_LANG ¼üɾ³ý»ò¸ÄÃû£¬±¾È˲âÊÔÒ²ÊÇ¿ÉÒԵģ¬µ«²»ÖªµÀ»á²»»á´øÀ´±ðµÄÎÊÌâ¡£
ÒÔÉÏËù˵µÄ Oracle InstantClient ÅäÖ÷½·¨£¬±¾È˵ÄÎÄÕ¡¶Windows 2003 Ï PHP5.2.5 + Apache2.2.8 + Oracle10g/11g µÄÅäÖá·£¨http://blog.why100000.com/?p=581
£©ÀïÓиüÏêϸµÄ˵Ã÷£¬ÕâÀïÔÙÖظ´Ò»Ï¡£
OCI ÅäÖúú󣬾ͿÉÒÔÅäÖà Navicat µÄÁ¬½ÓÁË¡£Á¬½ÓÀàÐÍÓÐ Basic ºÍ TNS Á½ÖÖ£¬µ«±¾ÈËÎÞ·¨Åäͨ Basic
ÀàÐÍ£¬¾ÍÅäÖà TNS Á¬½Ó£¬ÕâÐèÒªÔÚ¼´Ê±¿Í»§¶ËÎļþ¼ÐÏ·ÅÒ»¸öÃû×ÖΪ tnsnames.ora µÄÅäÖýâÎöÎļþ£¬ÎļþµÄ¸ñʽÈçÏ£º
# TNSNAMES.ORA Network Configuration File: ……
ORCL10 =
(DESCRIPTION =
Ïà¹ØÎĵµ£º
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 ......
1. ¼ì²éOracleµÄ½ø³Ì
$ ps -ef|grep "ora_"|grep -v grep
oracle 5998 1 0 11:15:59 ? 0:01 ora_j000_PPRD10
oracle 2968 1  ......
±¾ÎĽéÉÜÁË8¸ö³£Óõļà¿ØÊý¾Ýshell½Å±¾¡£Ê×ÏȻعËÁËһЩDBA³£ÓõÄUnixÃüÁÒÔ¼°½âÊÍÁËÈçºÎͨ¹ýUnix CronÀ´¶¨Ê±Ö´ÐÐDBA½Å±¾¡£ÍøÉÏÒ²ÓкöàÀàËƵÄÎÄÕ£¬µ«»ù±¾É϶¼²»ÄÜÕý³£ÔËÐУ¬»¨µãʱ¼äÖØÐÂÕûÀíÁËÏ£¬ÒÔºó¾ÍÄÜÖ±½ÓʹÓÃÁË¡£
Ò»£®Í¬Ê±ÎÄÕ»¹½éÉÜÁË8¸öÖØÒªµÄ½Å±¾À´¼à¿ØOracleÊý¾Ý¿â£º
1.¼ì²éʵÀýµÄ¿ÉÓÃÐÔ
2.¼ì²é¼àÌýÆ÷µ ......
Ò»¡¢Ñ¡ÔñÌâ
¡¡¡¡
¡¡¡¡1.µ±ÄãÖ´ÐÐÒÔϲéѯÓï¾ä:
¡¡¡¡SELECT empno,ename
¡¡¡¡from emp
¡¡¡¡WHERE empno =7782 OR empno =7876;
¡¡¡¡ÔÚWHEREÓï¾äÖУ¬ÒÔÏÂÄĸö²Ù×÷·û¿ÉÒÔÈ¡´úOR£¿
¡¡¡¡A. IN
¡¡¡¡B. BETWEEN ……
¡¡¡¡C. LIKE
¡¡¡¡D. <=
¡¡¡¡E. >=
¡¡¡¡
¡¡¡¡2. ÄĸöʵÏÖ  ......