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

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È«ÎÄË÷Òý

×î½üÒª×öËÑË÷£¬ËùÒÔѧÆð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 ³õ²½Ñ§Ï°±Ê¼Ç


Ò»:oracle°æ±¾½éÉÜ:
oracle8
oracle8i ±íʾ´Ëʱoracle¹«Ë¾½ø¾ü»¥ÁªÍø,i´ú±íInternet
oracle9iºÍoracle8iÀàËÆ
oracle10g°üÀ¨ÏÖÔÚµÄ11gʹÓÃÁËÍø¸ñ¼ÆËã,g´ú±ígrid.
 
¶þ:oracle10g·þÎñ½éÉÜ:
OracleDBConsoleorcl Õâ¸öÊDzÉÓÃä¯ÀÀÆ÷ʹÓõÄoracleÆóÒµ¹ÜÀíÆ÷ (Ò²¾ÍÊÇÄã°²×°µ¯³öµÄÄǸöÍøÒ³)
OracleOraDb10g_home1iSQ ......

ORACLEʹÓÃEXCEPTIONS±í²éѯ³ö±íÖÐÖØ¸´¼Ç¼

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 ......

½â¾öOracle 9iºÍTomcat¶Ë¿Ú³åÍ»(×ªÔØ)


    ·½°¸Ò»£º
    ÐÂ×°ÁËϵͳºó£¬·¢ÏÖÔÚµ÷ÊÔ³ÌÐòʱTOMCATÌáʾ8080¶Ë¿ÚÒѱ»Õ¼Óã¬ÓÚÊÇÔËÐÐNETSTAT -ANO²é¿´¶Ë¿ÚʹÓÃÇé¿ö£¬·¢ÏÖ8080¶Ë¿Ú±»ORACLEµÄ¼àÌýÆ÷¸øÕ¼ÓÃÁË£¬ÓÚÊǽáºÏÉÏÍø²éµ½·½·¨£¬½«ORACLE XDBµÄHTTP·þÎñ¶Ë¿Ú¸Ä³É8081£¬ÎÊÌâ½â¾ö¡£
 
    ×ܽáһϿɽâ¾öµÄ·½ ......

¸ßÐÔÄÜ Oracle JDBC ±à³Ì

¸ßÐÔÄÜ Oracle JDBC ±à³Ì
Á˽âÈçºÎÀûÓÃÁ¬½ÓºÍÓï¾ä³ØÌØÐÔÀ´Ìá¸ß Oracle Çý¶¯µÄ JDBC ³ÌÐòµÄÐÔÄÜ¡£

×÷ÕߣºYuli Vasiliev
2009 Äê 4 Ô·¢²¼
ʹÓÃÖîÈçÁ¬½Ó³ØºÍÓï¾ä³ØµÈ³Ø¼¼Êõ¿ÉÒÔÏÔÖøÌá¸ßÊý¾Ý¿âÃܼ¯ÐÍÓ¦ÓóÌÐòµÄÐÔÄÜ£¬ÒòΪÕâÑù¿ÉÒÔʵÏÖ¶ÔÏóÖØÓ㬶øÎÞÐ軨·Ñʱ¼äºÍ×ÊÔ´ÖØÐ´´½¨¶ÔÏó¡£
Èç¹ûÓ¦ÓóÌÐòÓëÊý¾Ý¿âƵ·±½»»¥²¢Ç ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ