oracle install
1 ¡¢´´½¨Óû§ºÍ×é
/usr/sbin/groupadd oinstall
/usr/sbin/groupadd dba
/usr/sbin/useradd -g oinstall -G dba oracle
2¡¢ÅäÖÃOSºËÐIJÎÊý
1£©±à¼Îļþ /etc/sysctl.conf
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048586
2) ʹºËÐIJÎÊýÉúЧ:
/sbin/sysctl -p
3¡¢ÉèÖÃoracleÓû§µÄshellÏÞÖÆÖµ
1£©Ìí¼ÓÒÔÏÂÐе½Îļþ /etc/security/limits.conf :
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
2£©Ìí¼ÓÒÔÏÂÐе½Îļþ /etc/pam.d/login file, if it does not already exist:
session required pam_limits.so
3£©Ìí¼ÓÒÔÏÂÐе½Îļþ /etc/profile £¨for bash):
if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
&nbs
Ïà¹ØÎĵµ£º
×î½üÒª×öËÑË÷£¬ËùÒÔѧÆðOracleÈ«ÎÄË÷ÒýÀ´ÁË¡£
²Î¿¼ÎÄÕ£ºhttp://www.eygle.com/archives/2005/06/ecieoaoracleeia.html
ÈçºÎʹÓÃOracleÈ«ÎļìË÷¹¦ÄÜ?
×÷Õß:eygle
³ö´¦:http://www.eygle.com/blog
ÈÕÆÚ:June 11, 2005
ä¯ÀÀ´ÎÊý:
890
±¾ÎÄÁ´½Ó:http://www.eygle.com/archives/2005/06/ecieoaoracleeia.html
±¾ÎļòÒª ......
Ò»:oracle°æ±¾½éÉÜ:
oracle8
oracle8i ±íʾ´Ëʱoracle¹«Ë¾½ø¾ü»¥ÁªÍø,i´ú±íInternet
oracle9iºÍoracle8iÀàËÆ
oracle10g°üÀ¨ÏÖÔÚµÄ11gʹÓÃÁËÍø¸ñ¼ÆËã,g´ú±ígrid.
¶þ:oracle10g·þÎñ½éÉÜ:
OracleDBConsoleorcl Õâ¸öÊDzÉÓÃä¯ÀÀÆ÷ʹÓõÄoracleÆóÒµ¹ÜÀíÆ÷ (Ò²¾ÍÊÇÄã°²×°µ¯³öµÄÄǸöÍøÒ³)
OracleOraDb10g_home1iSQ ......
SQL> conn system/oracle
Connected.
SQL> create table scott.t1(id number primary key,name varchar2(10)); --´´½¨²âÊÔ±í
Table created.
SQL> select constraint_name,table_name,constraint_type, --²é¿´ÏàÓ¦ÍêÕûÐÔÔ¼ÊøµÄ״̬
2 status,deferrable,deferred,validated
3 fro ......
·½°¸Ò»£º
ÐÂ×°ÁËϵͳºó£¬·¢ÏÖÔÚµ÷ÊÔ³ÌÐòʱTOMCATÌáʾ8080¶Ë¿ÚÒѱ»Õ¼Óã¬ÓÚÊÇÔËÐÐNETSTAT -ANO²é¿´¶Ë¿ÚʹÓÃÇé¿ö£¬·¢ÏÖ8080¶Ë¿Ú±»ORACLEµÄ¼àÌýÆ÷¸øÕ¼ÓÃÁË£¬ÓÚÊǽáºÏÉÏÍø²éµ½·½·¨£¬½«ORACLE XDBµÄHTTP·þÎñ¶Ë¿Ú¸Ä³É8081£¬ÎÊÌâ½â¾ö¡£
×ܽáһϿɽâ¾öµÄ·½ ......
¸ßÐÔÄÜ Oracle JDBC ±à³Ì
Á˽âÈçºÎÀûÓÃÁ¬½ÓºÍÓï¾ä³ØÌØÐÔÀ´Ìá¸ß Oracle Çý¶¯µÄ JDBC ³ÌÐòµÄÐÔÄÜ¡£
×÷ÕߣºYuli Vasiliev
2009 Äê 4 Ô·¢²¼
ʹÓÃÖîÈçÁ¬½Ó³ØºÍÓï¾ä³ØµÈ³Ø¼¼Êõ¿ÉÒÔÏÔÖøÌá¸ßÊý¾Ý¿âÃܼ¯ÐÍÓ¦ÓóÌÐòµÄÐÔÄÜ£¬ÒòΪÕâÑù¿ÉÒÔʵÏÖ¶ÔÏóÖØÓ㬶øÎÞÐ軨·Ñʱ¼äºÍ×ÊÔ´ÖØÐ´´½¨¶ÔÏó¡£
Èç¹ûÓ¦ÓóÌÐòÓëÊý¾Ý¿âƵ·±½»»¥²¢Ç ......