Ubuntu10.04ϰ²×°Oracle 10G
	
    
    
	
	
	
	
	
	<!--
		@page { margin: 2cm }
		P { margin-bottom: 0.21cm }
	-->
¹«ÍøÖÕÓÚͨµÄ£¬ÎÒµÄubuntu
Ò²ÖÕÓÚ¿ÉÒÔ¼ÌÐøÊ¹ÓÃÁË¡£¡£¡£
  
	
Ê×ÏȰѱ¾×ÓµÄubuntu
´Ó9.04
Éý¼¶µ½10.04
£¬·¢ÏÖϵͳ±ä³ÉÓ¢ºº»ìÓÃÁË£¬ÖØÑ¡ÓïÑÔÖ§³Ö°üÒ²²»¿ÉÒÔ£¬ÊäÈë·¨Ò²Ìí¼Ó²»ÉÏ£¬µ¹ÊÇûÓÐÍøÉÏÓÐÈËÌáµ½µÄϵͳÏìÓ¦·Ç³£»ºÂýµÄÎÊÌâ¡£°ëÌìδ¹û¾ÍÖ±½ÓÖØ×°ÏµÍ³£¬°æ±¾ÊÇ10.04
¡£
   
Èí¼þµÄ°²×°¶¼±È½ÏÈÝÒס£¿ÉÒÔͨ¹ýÐÂÁ¢µÃÈí¼þ¹ÜÀíÆ÷Ò²¿ÉÒÔÊÇÈí¼þÖÐÐÄÀ´½øÐаüµÄ°²×°£¬ÊäÈë·¨ÓÃscim
£¬ÀïÃæÓÐÎå±Ê£¬¾Í²»ÕÒÆäËüµÄÖ§³ÖÈí¼þ£¬Õâµã×öµÃÒª±È΢ÈíµÄϵͳºÃ¡£
    ·ÖÁ˼¸¸ö²½ÖèÀ´½øÐÐoracle
10g
µÄ°²×°£º
    1
¡¢ÏÂÔØÈí¼þ°ü¡£
   
½øÈëoracle
¹Ù·½Èí¼þhttp://www.oracle.com/technology/global/cn/software/products/database/xe/htdocs/102xelinsoft.html
½øÐÐÈí¼þ°üµÄÏÂÔØ£¬ÏÂÔØoracle-xe-universal_10.2.0.1-1.0_i386.deb
ÒÔ¼°oracle-xe-client_10.2.0.1-1.0_i386.deb
°ü¡£
    2
¡¢½¨Á¢oracle
Óû§¼°»·¾³ÅäÖÃ
    °²×°±ØÐëµÄ°ü
	apt-get install gcc make
binutils lesstif2 libc6 libc6-dev rpm libmotif3 libaio1 libstdc++5
alien
    ´´½¨Óû§
      ΪÁË·½±ãÅäÖã¬Ê¹ÓÃsudo
passwd root
ÃüÁîÅäÖÃroot
¿ÚÁîÒԺ󣬼´¿ÉÒÔʹÓÃroot
Óû§µÇ¼½øÐÐһЩ²Ù×÷¡£
	
ÐèҪΪ°²×°³ÌÐò´´½¨Ò»¸öOracle
Óû§ºÍÁ½¸ö×é.
Ê×Ïȼì²éËüÃÇÊÇ·ñÒѾ´æÔÚ:
	$grep oinstall /etc/group
	$grep dba /etc/group
	$grep nobody /etc/group
	
Èç¹ûËüÃÇ»¹²»ÔÚϵͳÖУ¬ÄÇô´´½¨ËüÃÇ¡£
	$sudo addgroup oinstall
	$sudo addgroup dba
	$sudo addgroup nobody
	$sudo useradd -m -g oinstall -G
dba -p passwd -d /home/oracle -s /bin/bash oracle
	$sudo usermod -g nobody nobody
	
ϵͳ»·¾³ÅäÖÃ
	
Ìí¼ÓÒÔÏÂÐе½
/etc/sysctl.conf 
ÎļþÖÐ:
     Ö´ÐÐsudo gedit
/etc/sysctl.conf
ÃüÁî¶ÔÎļþ½øÐб༡£
	kernel.shmall = 2097152
	kernel.shmmax = 2147483648
	kernel.shmmni = 4096
	kernel.sem = 250 32000 100 128
	fs.file-max = 65536
	net.ipv4.ip_local_port_range =
1024 65000
	
¸üÐÂϵͳ,
ÔËÐÐ:
	$sudo sysctl -p
	
Ìí¼ÓÒÔÏÂÐе½
/etc/security/limits.conf 
ÎļþÖÐ:
	* soft nproc 2407
	* hard nproc 16384
	* soft nofile 1024
	* hard nofile 65536
	
½¨Á¢ÈíÁ¬½Ó:
	$sudo ln -s /usr/bin/awk
/bin/
    
     
	
	
    
    
	Ïà¹ØÎĵµ£º
        
    
    
Oracle ÊÇÒ»¸öÅÓ´óµÄϵͳ£¬ÀïÃæµÄ֪ʶµãºÜ¶à£¬ÔÚѧϰµÄʱºò£¬¿´µ½Ò»Ð©ÖªÊ¶µã£¬¾ÍÌùÁËÏÂÀ´£¬¾¡²»ÖªÖÐÌùÁËÕâô¶à£¬¾ÍÏÈ×ö¸öС½á°É¡£ ÀïÃæÓеÄ֪ʶµãÒѾµ¥¶ÀÄóöÀ´Ð´³Éµ¥ÆªµÄblog(http://blog.csdn.net/tianlesoftware)ÁË¡£ÓеĻ¹Ã»ÓнøÐÐÕûÀí¡£ ºÃ¼ÇÐÔ²»ÈçÀñÊÍ·£¬²»¹ýÎÒÓõIJ»ÊDZʡ£ ^_^   ......
	
    
        
    
    
ORACLE¿ª·¢¹¤¾ß²ßÂÔ½éÉÜ
ºÜ¶àͬѧÎÊÆðÎÒÃÇOracle ERP¶þ´Î¿ª·¢ÒÔºó»áʹÓÃʲôÑùµÄÓïÑԺͿª·¢¹¤¾ß£¿Ê×ÏÈÎÒÃÇÀ´¿´¿´Oracle¿ª·¢¹¤¾ß²úÆ·µÄ²ßÂÔ
Oracle¿ª·¢¹¤¾ßµÄ²ßÂÔÊÇÌṩÄܹ»¿ª·¢»ùÓÚInternetÄ£ÐÍÏÂÆóÒµÓ¦ÓõÄÈí¼þ¿ª·¢¹¤¾ß£¬Òò´ËOracleÌṩÁËÁ½¸ö²¢ÐеĿª·¢¹¤¾ßÒÔ¼°ÐµĿìËÙWeb¿ª·¢¹¤¾ß£º
Ò»£¬»ùÓÚPL/SQLÓïÑÔ»·¾³µÄ´«Í³¿ ......
	
    
        
    
    Òª´´½¨Á½¸öÎļþ
1: runBatch.bat
2: sql.txt
runBatch.bat ÄÚÈÝÈçÏ£º
sqlplus username/password @sql.txt
pause
sql.txtÄÚÈÝÈçÏ£º
spool sql.log
create table t1(cname char(20));
insert into t1(cname) values('test');
select * from t1;
spool off
exit
Ë«»÷runBatch.bat¾Í¿ÉÒÔÅúÁ¿Ö´ÐÐsql.txtÖÐ ......
	
    
        
    
    Yes, sure ! You must be the local admin of this computer, and not a domain user.
Moreover, I'm afraid you cannot install it in a domain, maybe you should (just for testing purposes) try to install a standalone Windows system and try installing Oracle 10g on it.
You know, a RDBMS database server mu ......
	
    
        
    
    ÔÚOracle¹ØÓÚʱ¼äÊôÐԵĽ¨±í
Example:
create table courses(
cid varchar(20) not null primary key,
cname varchar(20) not null,
ctype integer,
ctime date DEFAULT SYSDATE,
cscore float not null
)
insert into courses values('ss01','java',0,TO_DATE('2009-8-28','yyyy-mm-dd'),94)
insert into course ......