dspace windows oracle install
½ñÌìÁ˽âÁËһϿªÔ´dspaceÈí¼þ£¬ÏÖ½«°²×°¹ý³Ì×ܽáÈçÏ£º
1¡¢»·¾³ÉèÖÃ
1.1 ÏÂÔØjdk1.6.x²¢°²×°,°²×°Ê±Ñ¡ÔñĬÈÏ°²×°Â·¾¶¼´¿É
Ò»°ãΪ C:\Program Files\Java\jdk1.6.0_10
ÉèÖÃJAVA_HOME,ÉèÖÃCLASSPATHºÍPATH
2¡¢×é¼þ×¼±¸
2.1 ÏÂÔØ×îаæmaven2.2.1
http://www.apache.org/dyn/closer.cgi/maven/binaries/apache-maven-2.2.1-bin.zip
ÏÂÔØÍê½âѹºó·ÅÔÚ%maven%Ŀ¼Ï£¬È»ºóÉèÖÃmavenµÄ»·¾³±äÁ¿
н¨»·¾³±äÁ¿£º±äÁ¿ÃûM2_HOME ±äÁ¿Öµ%maven%
±ÈÈç%maven%ΪD:/maven2.2.1Ôò M2_HOME=D:/maven2.2.1,ͬʱÔÚPATHÖÐÔö ¼Ó%M2_HOME%\bin
2.2 ÏÂÔØ×îаæapache-ant-1.8.0-bin.zip
http://ant.apache.org/bindownload.cgi
ÔØÍê½âѹºó·ÅÔÚ%ant%Ŀ¼ÏÂ,ͬʱÔÚPATHÖÐÔö¼Ó%ant%\bin
2.3 ÏÂÔØ×îаæoracle10g
Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Microsoft Windows (32-bit)
http://download.oracle.com/otn/nt/oracle10g/10201/10201_database_win32.zip
http://download.oracle.com/otn/nt/oracle10g/10201/10201_client_win32.zip
http://download.oracle.com/otn/nt/oracle10g/10201/10201_clusterware_win32.zip
http://download.oracle.com/otn/nt/oracle10g/10201/10201_gateways_win32.zip
ÏÂÔغó¸ù¾ÝÌáʾһ²½Ò»²½½øÐа²×°¡£
°²×°Íê³Éºó£¬µã»÷¿ªÊ¼->ËùÓгÌÐò->Oracle Database 10g Enterprise Edition ->תÖÁÊý¾Ý¿âÖ÷Ò³
ÊäÈëDBAµÄÓû§ÃûºÍÃÜÂë(Ò²¾ÍÊÇÔÚ°²×°Ê±×Ô¼ºÉèµÄÓû§ÃûºÍÃÜÂë)¡£µÇ¼³É¹¦ºó´´½¨Óû§dspaceºÍÃÜÂëdspace
2.4 ÏÂÔØoracleµÄÇý¶¯°üojdbc14.jar
http://www.oracle.com/technology/
Ïà¹ØÎĵµ£º
DSIÊÇData Server
InternalsµÄËõд,ÊÇOracle¹«Ë¾ÄÚ²¿ÓÃÀ´ÅàѵOracleÊۺ󹤳ÌʦʹÓõĽ̲Ä.ÓÉÓÚijÖÖÔÒòÁ÷Â佺þ,
Êܵ½ÖÚ¶àOracle°®ºÃÕßµÄ×·Åõ, ²»¹ýÒªÊǹ¦Á¦²»µ½, ÔĶÁ·´¶øÎÞÒæ. DSI3ÊÇOracle 8ϵÁеÄ, DSI4ÊÇOracle 9ϵÁеÄ.
ÕâÑùµÄÎĵµÉÏͨ³£¶¼Ó¡×Å:Oracle Confidential:For internal Use Only.
DSI301 Advanced S ......
×Ô¶¨Ò庯Êý
--×Ô¶¨Ò庯Êý
CREATE OR REPLACE FUNCTION fn_WFTemplateIDGet
(
TemplateCategoryID NUMBER,
OrganID NUMBER,
TemplateMode NUMBER
)
RETURN NUMBER
IS
......
²©Ñå¿Æ¼¼Oracle erpÃâ·Ñ½²×ù
×÷ΪOracle¹«Ë¾¹Ù·½ÊÚȨÅàѵ»ú¹¹£¬²©ÑåOracle erpרҵÈÏ֤ר¼Ò¿Î³ÌÔÚ±±¾©¡¢ÉϺ£Í¬²½¿ªÕ¹Oracle erpÅàѵ¿Î³Ì¡£
Oracleµç×ÓÉÌÎñÌ×¼þ R12 ²ÆÎñÓ¦ÓÃÈí¼þÄܹ»×Ô¶¯»¯²¢¼ò»¯¿Í»§µÄ²ÆÎñÒµÎñÁ÷³Ì£¬°ïÖúÆóÒµ»ñµÃÆóÒµ·¶Î§ÄÚµÄÈÕ³£ÉÌÎñÖÇÄÜ£¬´Ó¶ø×ö³ö¸üÃ÷Öǵľö²ß¡¢¸Ä½øÔËÓª²¢½ÚÔ¼³É±¾¡£Í³Ò»µÄÊý¾ÝÄ£ÐÍÎªË ......
Oracle Êý¾Ý¿â 11gÃæÏò DBA ºÍ¿ª·¢ÈËÔ±µÄÖØÒªÐÂÌØÐÔ:SecureFiles£º
1¡¢SecureFiles£ºÐ LOB
Á˽âÈçºÎʹÓÃÐÂÒ»´ú LOB£ºSeureFiles¡£SecureFiles ¼¯ÍⲿÎļþºÍÊý¾Ý¿â LOB ·½·¨µÄÓŵãÓÚÒ»Éí£¬¿ÉÒÔ´æ´¢·Ç½á¹¹»¯Êý¾Ý£¬ÔÊÐí¼ÓÃÜ¡¢Ñ¹Ëõ¡¢Öظ´Ïû³ýµÈµÈ¡£
Êý¾Ý¿âפÁô BLOBS »ò OS Îļþ
ÄúÔÚ Oracle Êý¾Ý¿âÖÐ ......
1. ÐÞ¸Äredo log file´óС
SQL> select group#,status from v$log;
SQL> alter database add logfile group 4 'F:\oracle\product\10.2.0\oradata\orcl\REDO04.LOG' size 512m;
SQL> alter system switch logfile;
SQL> select group#,status from v$log;
2. ÐÞ¸Älarge_pool_size´óС
SQL> alter  ......