Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

²»°²×°Oracle¿Í»§¶ËÁ¬½ÓOracle

Ô­À´Á¬½ÓORACLE×ÜÊÇҪװORACLE¿Í»§¶Ë£¬Í¦Âé·³µÄ£¬Ò»·½ÃæÒª´øORACLEµÃÅÌ£¬ÁíÒ»·½Ã棬װÕâô´óµÃ¶«Î÷Ò²ÈÃÈ˺ܲ»Ë¬¡£Oracle´Ó10g¿ªÊ¼Ð³öÁËÒ»¸öInstant Client£¬ÊÇÕë¶ÔWINDOWSƽ̨µÄ£¬²»Óð²×°¿Í»§¶Ë¾Í¿ÉÒÔÁ¬½ÓOracleÊý¾Ý¿â¡£Instant ClientÊÇÒ»¸ö½ÏΪÇáÁ¿¼¶µÄ¿Í»§°ü£¬Êµ¼ÊÊÇÒ»¸özipÎļþ£¬40¶àM£¬²»ÐèÒª°²×°£¬Ö±½Ó½âѹËõ£¬¿ÉÒԺͳÌÐòÒ»Æð´ò°ü£¬²»¹ýĿǰ²»ÄÜÁ¬½Ó8.1.7.4֮ǰµÄÊý¾Ý¿â¡£
1¡¢ÏÂÔØÏàÓ¦µÄ³ÌÐò£»
http://www.oracle.com/technology/global/cn/software/tech/oci/instantclient/htdocs/winsoft.html?_template=/ocom/print£¨ÖÐÎĵģ©
http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html£¨Ó¢Îĵģ©
2¡¢½«Oracle Instatnt Client½âѹÖÁD:\instantclient
3¡¢½«Oracle ODBC½âѹÖÁD:\instantclient
4¡¢ÉèÖÃϵͳ»·¾³±äÁ¿£»
NLS_LANG = AMERICAN_AMERICA.ZHS16GBK(»òSIMPLIFIED CHINESE_CHINA.ZHS16GBK)
TNS_ADMIN = D:\instantclient
LD_LIBRARY_PATH = D:\instantclient£¨¸Ã±äÁ¿¿ÉÄÜ¿ÉÒÔÊ¡ÂÔ£©
SQL_PATH = D:\instantclient
Oracle_home= D:\instantclient
Path = % Path %; D:\instantclient
5¡¢ÔÚD:\instantclientÖÐÓÃÌí¼ÓÈçÏÂÄÚÈݵÄÎļþ,ÎļþÃûΪtnsnames.ora
 
# tnsnames.ora Network Configuration File: D:\instantclient\tnsnames.ora
# Generated by Oracle configuration tools.
ORB =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = local)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orb)
    )
  )
Òª°²×°ODBCµÄ»°ÏÂÔØInstant Client Package – ODBC£¬½âѹµ½D:\instantclient·¾¶Ï£¬È»ºóÔÙÃüÁîÌáʾ·ûÖÐÊäÈëodbc_install.exe¡££¨¼ÇµÃµ±Ç°Ä¿Â¼Ò»¶¨ÒªÊÇodbc_install.exeËùÔÚµÄĿ¼£¬Òª²»»á³ö´í£©
³£ÉèµÄ×Ö·û¼¯£º
Set nls_lang=simplified chinese_china.zhs16cgb231280
Set nls_lang=simplified chinese_china.ZHS16GBK
Set nls_lang=simplified chinese_china.Utf8
 ±¸×¢£º
instantclient-basic-win32-11.1.0.6.0.zip    -Õâ¸öÊÇÖ§³ÖOracle 9i ÒÔÉϵİ棨²»°üÀ¨Oracle9i£©
instantclie


Ïà¹ØÎĵµ£º

ORACLE¹ÜÀíÔ±ÃÜÂ붪ʧ½â¾ö·½°¸

1¡¢OracleÀïÃæÓû§µÄÃÜÂëÊǽøÐмÓÃܱ£´æµÄ,ËùÒÔÖ»ÄÜÖØÐÂÐÞ¸ÄÉú³ÉеÄÃÜÂë.


ÀûÓÃϵͳ¹ÜÀíÔ±(sys)µÇ¼,½«scottÓû§µÄÃÜÂëÐ޸ļ´¿É

SQL>conn / as sysdba ;


ÒÑÁ¬½Ó¡£

SQL>alter user scott identified by tiger
;


Óû§ÒѸü¸Ä¡£

µ±È»Ò²¿ÉÒÔµ½WEB¶Ë½øÐÐÐ޸ĵØÖ·È ......

oracle µÄ left/right joinÓë(+)µÄÒ»¸öÇø±ð

»ù±¾´ÓÀ´²»ÓÃleft/right join
Ò»¸öÏîÄ¿±»ÆÈÒªÓñðÈËдµÄ sql
±¾´òËã¸ÄдһÏ£¬Ìá¸ßЧÂÊ
·¢ÏÖ£º
¡¾1¡¿
select * from  a
left outer join  b on a.id= b.id AND ...1...
 where ...2...
Óë
¡¾2¡¿
select * from  a , b 
 where a.id= b.id(+)
A ......

ÔÚOracleÖвéѯ±íµÄ´óСºÍ±í¿Õ¼äµÄ´óС

ÓÐÁ½ÖÖº¬ÒåµÄ±í´óС¡£Ò»ÖÖÊÇ·ÖÅä¸øÒ»¸ö±íµÄÎïÀí¿Õ¼äÊýÁ¿£¬¶ø²»¹Ü¿Õ¼äÊÇ·ñ±»Ê¹Ó᣿ÉÒÔÕâÑù²éѯ»ñµÃ×Ö½ÚÊý£º
select segment_name, bytes
from user_segments
where segment_type = 'TABLE';
»òÕß
   Select Segment_Name,Sum(bytes)/1024/1024 from User_Extents Group By Segment_Name
ÁíÒ»ÖÖ±íʵ¼ÊÊ¹Ó ......

WEBLOGICÁ¬½ÓOracle RAC µÄ¸ºÔؾùºâ²âÊÔ


Òª½øÐÐѹÁ¦²âÊÔ£¬Öмä¼þʹÓÃWEBLOGIC 816
£¬Êý¾Ý¿â°æ±¾Îª11.1.0.6 RAC
£¬Ñ¹Á¦²âÊÔ¹¤¾ßΪLOADRUNNER 8.0
¡£²âÊÔµ¥ÊµÀýÓëRAC
»·¾³¸÷¸ö½ÚµãµÄ¸ºÔØÇé¿ö¡£
 
 
ÔÚWEBLOGIC
ÉÏÅäÖÃÁËÒ»¸ö¶à³Ø£¬ÀûÓÃWEBLOGIC
ÌṩµÄ¸ºÔؾùºâ²ßÂÔ£¬½«²¢·¢¾ùºâµÄ·Ö±ðµ½Á½¸ö½ÚµãÉÏ¡£
µ«ÊDzâÊÔ·¢ÏÖ£¬Ò»µ©ÔËÐÐ
ÁËÒ»¶Îʱ¼ä£¬ËùÓе ......

Oracle±¸·Ý

±¸·ÝµÄ·½·¨
    ORACLEÊý¾Ý¿âÓÐÈýÖÖ±ê×¼µÄ±¸·Ý¡£µ¼³ö/µ¼Èë(EXPORT/IMPORT) ¡¢À䱸·Ý¡¢Èȱ¸·Ý¡£
    µ¼³ö±¸·ÝÊÇÒ»ÖÖÂß¼­±¸·Ý£¬ÕâÖÖ·½·¨°üÀ¨¶ÁȡһϵÁеÄÊý¾Ý¿âÈÕÖ¾£¬²¢Ð´ÈëÎļþÖУ¬ÕâЩÈÕÖ¾µÄ¶ÁÈ¡ÓëÆäËù´¦Î»ÖÃÎ޹ء£
    À䱸·ÝºÍÈȱ¸·ÝÊÇÎïÀí±¸·Ý(Ò²³ÆµÍ¼¶±¸·Ý)£¬ËüÉæ¼°µ½ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ