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

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 С֪ʶ ×ܽá(Ò»)


Oracle ÊÇÒ»¸öÅÓ´óµÄϵͳ£¬ÀïÃæµÄ֪ʶµãºÜ¶à£¬ÔÚѧϰµÄʱºò£¬¿´µ½Ò»Ð©ÖªÊ¶µã£¬¾ÍÌùÁËÏÂÀ´£¬¾¡²»ÖªÖÐÌùÁËÕâô¶à£¬¾ÍÏÈ×ö¸öС½á°É¡£ ÀïÃæÓеÄ֪ʶµãÒѾ­µ¥¶ÀÄóöÀ´Ð´³Éµ¥ÆªµÄblog(http://blog.csdn.net/tianlesoftware)ÁË¡£ÓеĻ¹Ã»ÓнøÐÐÕûÀí¡£ ºÃ¼ÇÐÔ²»ÈçÀñÊÍ·£¬²»¹ýÎÒÓõIJ»ÊDZʡ£ ^_^   ......

ORACLE¿ª·¢¹¤¾ß²ßÂÔ½éÉÜ


ORACLE¿ª·¢¹¤¾ß²ßÂÔ½éÉÜ
ºÜ¶àͬѧÎÊÆðÎÒÃÇOracle ERP¶þ´Î¿ª·¢ÒÔºó»áʹÓÃʲôÑùµÄÓïÑԺͿª·¢¹¤¾ß£¿Ê×ÏÈÎÒÃÇÀ´¿´¿´Oracle¿ª·¢¹¤¾ß²úÆ·µÄ²ßÂÔ
Oracle¿ª·¢¹¤¾ßµÄ²ßÂÔÊÇÌṩÄܹ»¿ª·¢»ùÓÚInternetÄ£ÐÍÏÂÆóÒµÓ¦ÓõÄÈí¼þ¿ª·¢¹¤¾ß£¬Òò´ËOracleÌṩÁËÁ½¸ö²¢ÐеĿª·¢¹¤¾ßÒÔ¼°ÐµĿìËÙWeb¿ª·¢¹¤¾ß£º
Ò»£¬»ùÓÚPL/SQLÓïÑÔ»·¾³µÄ´«Í³¿ ......

OracleÈçºÎÖ´ÐÐÅúÁ¿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ÖÐ ......

oracle issue

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µÄ»ù±¾²Ù×÷£«Oracle×Ö¶ÎÀàÐÍ£¨zz£©

ÔÚ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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ