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/
Ïà¹ØÎĵµ£º
ÏÖÔÚµÄÏîÄ¿±È½Ï½ô£¬¼ÓÉÏ×Ô¼ºÒ²±È½ÏÀÁ£¬ÊµÔÚÊǓûʱ¼ä”д°¡£¬ºÇºÇ£¬×òÌì¿´µ½Ò»ÆªÍ¦ºÃµÄOracle´æ´¢¹ý³ÌµÄÀý×Ó£¬ÕýºÃ×î½üÒªÓã¬×ª¹ýÀ´´ó¼ÒÒ»Æð·ÖÏíһϣ¬Ð»Ð»£¨³¿¹âӳϼ£©£¬Ô×÷µØÖ·£ºhttp://blog.csdn.net/xuyabao/archive/2008/03/20/2200205.aspx¡£
--------------------×Ô¶¨Ò庯Êý¿ªÊ¼--------------------
......
²©Ñå¿Æ¼¼Oracle erpÃâ·Ñ½²×ù
×÷ΪOracle¹«Ë¾¹Ù·½ÊÚȨÅàѵ»ú¹¹£¬²©ÑåOracle erpרҵÈÏ֤ר¼Ò¿Î³ÌÔÚ±±¾©¡¢ÉϺ£Í¬²½¿ªÕ¹Oracle erpÅàѵ¿Î³Ì¡£
Oracleµç×ÓÉÌÎñÌ×¼þ R12 ²ÆÎñÓ¦ÓÃÈí¼þÄܹ»×Ô¶¯»¯²¢¼ò»¯¿Í»§µÄ²ÆÎñÒµÎñÁ÷³Ì£¬°ïÖúÆóÒµ»ñµÃÆóÒµ·¶Î§ÄÚµÄÈÕ³£ÉÌÎñÖÇÄÜ£¬´Ó¶ø×ö³ö¸üÃ÷Öǵľö²ß¡¢¸Ä½øÔËÓª²¢½ÚÔ¼³É±¾¡£Í³Ò»µÄÊý¾ÝÄ£ÐÍÎªË ......
ʹÓÃunrecoverable´´½¨±í
create table new_emp as select * from emp unrecoverable;
create table new_emp as select * from emp nologging;
ÍÆ¼öʹÓÃlogging»òÕßnologging.
½«±íÒÆ¶¯µ½ÐµÄÊý¾Ý¶Î»òеıí¿Õ¼ä
ͨ¹ýÒÆ¶¯À´ÊµÏÖ´æ´¢²ÎÊýµÄÐÞ¸Ä
alter table emp move storage(initial 1m next 512k mimexte ......
http://www.puschitz.com/InstallingOracle10g.shtml
ÎÒÓõÄÊÇCentos5.4
DVD¹âÅ̰²×°µÄlinux²Ù×÷ϵͳ£¬°²×°linuxµÄʱºòÑ¡ÉÏ¿ª·¢¹¤¾ß£¬Xmanager,ÓëÊý¾Ý¿âÏà¹ØµÄ°ü¡£
²Ù×÷ϵͳ°²×°Íê³ÉÖ®ºóÐèÒª½øÐÐһϵÁеÄÅäÖòÅÄܰ²×°oracle10g£¬ÏÂÃæ°Ñ
Ö÷Òª²½Öè¼Ç¼ÏÂÀ´¡£
1.°²×°Íê²Ù×÷ϵͳ֮ºó»¹ÊÇÓÐЩ°üûÓа²×°£¬È»¶ø°²×°oracle10 ......
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  ......