Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 jobsÅú´¦ÀíÓï¾ä

--oracle jobsÅú´¦ÀíÃüÁî²Î¿¼
qlplus /nolog
connect sys/lee as sysdba
--ÒÔÏÂÁ½¾äÔÚsys(¼´¾ßÓÐdbaȨÏÞµÄÓû§)Óû§ÏÂÖ´ÐÐ
show parameter job_queue_processes;
alter system set job_queue_processes=10;
exit
sqlplus /nolog
connect jcy/jcy
ALTER TABLE T_OA_AFFICHE MODIFY (INPUT_TIME DATE);
ALTER TABLE ......

oracle ¶ªÊ§ÃÜÂë

1¡¢OracleÀïÃæÓû§µÄÃÜÂëÊǽøÐмÓÃܱ£´æµÄ,ËùÒÔÖ»ÄÜÖØÐÂÐÞ¸ÄÉú³ÉеÄÃÜÂë.
ÀûÓÃϵͳ¹ÜÀíÔ±(sys)µÇ¼,½«scottÓû§µÄÃÜÂëÐ޸ļ´¿É
SQL>conn / as sysdba ;
ÒÑÁ¬½Ó¡£
SQL>alter user scott identified by tiger ;
Óû§ÒѸü¸Ä¡£
µ±È»Ò²¿ÉÒÔµ½WEB¶Ë½øÐÐÐ޸ĵØÖ·ÈçÏÂ:
http://localhsot:1158/em(ÏàÓ¦µÄ·þÎñ±Ø ......

±¸·Ý/»Ö¸´OracleÊý¾Ý¿â

1¡¢±¸·ÝÖ¸¶¨µÄ±í¿Õ¼ä
Ê×ÏÈ£¬ÄãҪȷÈÏ×Ô¼ºµçÄÔÉÏÓÐexp.exeÕâ¸ö¶«¶«£¬²ÅÄܽøÐб¸·Ý¹¤×÷¡£
ÎÒÏëÒª±¸·ÝµÄÊÇÓû§ÃûΪcyyµÄ±í¿Õ¼ä£¬±¸·ÝÎļþ´òËã·ÅÔÚDÅÌ£¬²¢ÒÔbackup_oracle.dmpÃüÃû£¬Ë³±ã°ÑÈÕÖ¾ÎļþÒ²±¸·ÝһϺÃÁË¡£
ÔÚÃüÁîÐÐÇÃÈ룺
C:\Documents and Settings\Administrator>exp cyy/cyy@bsrs file=D:\backup_oracle.dmp ......

Oracle±¸·Ý

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