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

JIRAµÄ°²×°ÓëÅäÖã¨OracleÊý¾Ý¿â£©

    Ô­ ÎÄ£ºÆ½·²ËêÔ£ºjiraµÄ°²×°£¨oracleÊý¾Ý¿â£©http://www.trucy.org/blog/ray/archives/000927.html
    
    ÒÔÏÂÊÇ»ùÓÚÔ­ÎĵIJ¹³äÍêÉÆºóµÄÄÚÈÝ£º
    JIRAÊÇÒ»¸öÓÅÐãµÄÎÊÌâ(or bugs£¬task£¬improvement£¬new feature )¸ú×Ù¼°¹ÜÀíÈí¼þ¡£
    ËüÓÉAtlassian¿ª·¢£¬²ÉÓÃJ2EE¼¼Êõ.ËüÕý±»¹ã·ºµÄ¿ªÔ´Èí¼þ×éÖ¯£¬ÒÔ¼°È«ÇòÖøÃûµÄÈí¼þ¹«Ë¾Ê¹Óã¬Ëü¿°³ÆÊÇJ2EEµÄBugzilla¡£
    JIRAÌṩÁËÈ«ÃæµÄ¹¦ÄÜ£¬½çÃæÊ®·ÖÓѺ㬿ÉÓÃÐÔÒÔ¼°¿ÉÀ©Õ¹ÐÔ·½Ã涼ʮ·Ö³öÉ«£¬Èç¹û¹ºÂòÉÌÒµ°æÐí¿É£¬»¹¿ÉÒԵõ½JIRAµÄÔ´Â루ÔÚ¿ª·¢Ðí¿ÉЭÒéÏ¿ÉÒÔ¶¨ÖÆ×Ô¼ºµÄJIRAϵͳ£©¡£
    
    ½ñÌìÕÒµ½Ò»ÆªÎÄÕ£¬Ð´µÄÊÇjiraµÄ°²×°£¬µ«ÊÇÊý¾Ý¿âÊÇMS SQL2000£¬ÓÉÓÚ±¾»ú£¬Ö»ºÃÁíÍâѧÔõôÁ´½ÓoracleÊý¾Ý¿â¡£
    ×¢Ò⣺°²×°JIRAµÄ»úÆ÷Òª°²×°oracle¿Í»§¶Ë¡£
    Ê¹Óð汾£ºJIRA 3.6 ÏÂÔØ£ºhttp://www.atlassian.com/software/jira/downloads/binary/atlassian-jira-enterprise-3.6-standalone.zip
    Ò»¡¢°²×°
    1. ÏÂÔØºó½âѹ£¬ÓÉÓÚ½âѹ³öµÄÎļþ¼ÐÃû³Æ¹ý³¤£¬ËùÒÔÐÞ¸ÄÎļþ¼ÐÃû³ÆÎª£ºJIRA_3.6£¬ÒÔÏÂͳһÓôËÃû³Æ£»
    2. ÐÞ¸Ä JIRA_3.6\conf\server.xml ÎļþÖеÄÅäÖã¬ÓÈÆäҪעÒâURL£¬ÈçÏ£º
       a.  driverClassName£º//oracleÊý¾Ý¿âµÄÇý¶¯
            driverClassName="oracle.jdbc.driver.OracleDriver"
       b. url:
            url="jdbc:oracle:thin:@ptserver:1521:jiradb"
            //oracleÊý¾Ý¿âµÄÁ¬½Ó¡£@֮ǰµÄ²»Òª¸ü¸Ä£¬ºóÃæµÄµÚÒ»¸öÊÇoracle°²×°»úÆ÷Ãû£¬1521²»Óñ䣬×îºóÒ»¸öÊÇÊý¾Ý¿âÃû¡£
        c.username:
            username="jirauser"
     &nb


Ïà¹ØÎĵµ£º

RedHatAs5ÏÂOracleË«»úÈȱ¸£¨1£©

    ×î½üÒ»¸öÏîÄ¿µÄʵʩÐèÒªÓõ½
RedHatAs5.0
²Ù×÷ϵͳϵÄ
Oracle
Ë«»úÈȱ¸ÅäÖã¬Ô­ÒÔΪÓÐÉ豸³§ÉÌÒÔ¼°¹«Ë¾ÏµÍ³ÍøÂ粿µÄ¼¼ÊõÖ§³Ö£¬Ë«»úÈȱ¸¾ÍÊÇСÒâ˼£¬Ã»Ï뵽ʵʩ¹ý³ÌÖÐÅöµ½ÁËÐí¶àÆæ¹ÖµÄÎÊÌâ¡£¾­¹ý¶àÌìµÄ¹¥¹Ø£¬ÖÕÓÚÅäÖóɹ¦ÁË£¬¸Ð¾õÐÄÇéÌØ±ðÇáËÉ¡£¾­¹ýÁ½ÖܵÄʵʩ£¬ÎÒÒÔÒ»¸ö
Linux
²ËÄñµÄÉí·Ý£¬³õ²½Á ......

Oracle³õѧÕß±ØÖªµÄ100¸öÒÉÎÊ

1. Oracle°²×°Íê³ÉºóµÄԭʼ¿ÚÁ
¡¡internal/oracle
¡¡¡¡sys/change_on_install
¡¡¡¡system/manager
¡¡¡¡scott/tiger
¡¡¡¡sysman/oem_temp
2. ORACLE9IAS WEB CACHEµÄԭʼĬÈÏÓû§ºÍÃÜÂ룿
administrator/administrator
3. oracle 8.0.5ÈçºÎ½¨Á¢Êý¾Ý¿â£¿
ÓÃorainst¡£¼ÙÈçÓÐmotif½çÃæ£¬Äܹ»ÓÃorainst /m¡ ......

OracleÇý¶¯classes12.jar Óëojdbc14.jarµÄÇø±ð

ÒÔÏÂÊÇOracle JDBC¹Ù·½ÎĵµµÄ˵·¨£º
Ò²¾ÍÊÇËæ±ã·­ÒëһϾÍÀí½âÁË¡£
JDBC Thin for All Platforms
classes12.jar (1,600,090 bytes) - for use with JDK 1.2 and JDK 1.3
Ôڵͼ¶JDK°æ±¾1.2Óë1.3ÖÐʹÓõÄÇý¶¯£¬ËäȻʵ¼ÊÉÏÔÚ1.4£¬1.5ÖÐʹÓô󲿷ÖÇé¿öÒ²ÊÇOKµÄ
classes12_g.jar (2,044,594 bytes) - same as classes12.j ......

oracle systemÃÜÂëÍü¼Ç½â¾ö

1.ÓÃOracleÓû§µÇ½Linux·þÎñÆ÷;
2.ÔÚÖÕ¶Ë´°¿ÚÊäÈë sqlplus /nolog
   [oracle@hylinux ~]$ sqlplus /nolog
    SQL*Plus: Release 10.2.0.1.0 - Production on ÐÇÆÚ¶þ 7ÔÂ 29  14:26:16 2008
    Copyright (c) 1982, 2005, Oracle.  All rights reserved.
& ......

¹ØÓÚoracleµÄ±í¿Õ¼ä£¬·ÖÇø±í£¬ÒÔ¼°Ë÷ÒýµÄ×ܽá


±í¿Õ¼ä£º
OracleµÄUNDOTBS01.DBFÎļþÌ«´óµÄ½â¾ö°ì·¨
1¡¢.½ûÖ¹undo tablespace×Ô¶¯Ôö³¤
alter   database   datafile   'full_path\undotbs01.dbf'   autoextend   off;
2.-- ´´½¨Ò»¸öеÄС¿Õ¼äµÄundo tablespace
create undo tablespace undotBS2 datafile ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ