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.0
²Ù×÷ϵͳϵÄ
Oracle
Ë«»úÈȱ¸ÅäÖã¬ÔÒÔΪÓÐÉ豸³§ÉÌÒÔ¼°¹«Ë¾ÏµÍ³ÍøÂ粿µÄ¼¼ÊõÖ§³Ö£¬Ë«»úÈȱ¸¾ÍÊÇСÒâ˼£¬Ã»Ï뵽ʵʩ¹ý³ÌÖÐÅöµ½ÁËÐí¶àÆæ¹ÖµÄÎÊÌâ¡£¾¹ý¶àÌìµÄ¹¥¹Ø£¬ÖÕÓÚÅäÖóɹ¦ÁË£¬¸Ð¾õÐÄÇéÌØ±ðÇáËÉ¡£¾¹ýÁ½ÖܵÄʵʩ£¬ÎÒÒÔÒ»¸ö
Linux
²ËÄñµÄÉí·Ý£¬³õ²½Á ......
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 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 ......
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µÄUNDOTBS01.DBFÎļþÌ«´óµÄ½â¾ö°ì·¨
1¡¢.½ûÖ¹undo tablespace×Ô¶¯Ôö³¤
alter database datafile 'full_path\undotbs01.dbf' autoextend off;
2.-- ´´½¨Ò»¸öеÄС¿Õ¼äµÄundo tablespace
create undo tablespace undotBS2 datafile ......