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

ÔÚubuntu ϰ²×°Oracle 11g

root@hardy:~# cd /bin
root@hardy:/bin# ls -l /bin/sh
lrwxrwxrwx 1 root root 4 2008-04-28 19:59 /bin/sh -> dash
root@hardy:/bin# ln -sf bash /bin/sh
root@hardy:/bin# ls -l /bin/sh
lrwxrwxrwx 1 root root 4 2008-05-01 22:51 /bin/sh -> bash
# echo "Red Hat Linux release 4" > /etc/redhat-release
root@hardy:/bin# cd
root@hardy:~# pwd
   /root
root@hardy:~# addgroup oinstall
   Adding group `oinstall' (GID 1001) ...
   Done.
root@hardy:~# addgroup dba
   Adding group `dba' (GID 1002) ...
   Done.
root@hardy:~# addgroup nobody
   Adding group `nobody' (GID 1003) ...
   Done.
root@hardy:~# usermod -g nobody nobody
root@hardy:~# useradd -g oinstall -G dba -p password -d /home/oracle -s /bin/bash oracle
root@hardy:~# passwd -l oracle
   Password changed.
root@hardy:~# mkdir /home/oracle
root@hardy:~# chown -R oracle:dba /home/oracle
root@hardy:~# ln -s /usr/bin/awk /bin/awk
root@hardy:~# ln -s /usr/bin/rpm /bin/rpm
root@hardy:~# ln -s /usr/bin/basename /bin/basename
root@hardy:~# mkdir /etc/rc.d
root@hardy:~# for i in 0 1 2 3 4 5 6 S ; do ln -s /etc/rc$i.d /etc/rc.d/rc$i.d ; done
root@hardy:~# mkdir -p /u01/app/oracle
root@hardy:~# chown -R oracle:dba /u01
root@hardy:~#
ÐÞ¸Äetc/sysctl.confÎļþ,ÔÚĩβÔö¼Ó£º
fs.file-max = 65535
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 1024 65535
net.core.rmem_default = 1048576
net.core.rmem_max = 1048576
net.core.wmem_default = 262144
net.core.wmem_max = 262144
ÐÞ¸Ä/etc/security/limits.confÎļþ,ÔÚĩβÔö¼Ó£º
oracle soft nproc 2047
oracle hard nproc 16383
oracle soft nofile 1023
oracle hard nofile 65535
ΪÁËÇ¿ÖÆÊ¹ÓøղÅÎÒÃÇÔö¼ÓµÄ¶«Î÷£¬ÐÞ¸Ä/etc/pam.d/loginÎļþĩβ£º
session required /lib/security/pam_limits.so
session required pam_limits.so
# sysctl -p
ÏÖÔÚ½«oracle11gµÄ°²×°°ü½âѹµ½/home/oracle/install/Ŀ¼Ï¡£È»ºó½øÈ


Ïà¹ØÎĵµ£º

64λwin7°²×°Ê¹ÓÃPL/SQL developerÁ¬½ÓOracle 10g±¸Íü

ÔÚÍøÉÏËÑË÷Á˰ëÌ죬Ö÷ÒªÔ­ÒòÊÇoci.dllÊÇ64λµÄ,¶øPL/SQL developerÖ»ÓÐ32λµÄ,ÔÚʹÓÃ64λoci.dllÎļþʱ³ö´í.
ÔÚÍøÉÏÕÒÁ˺ܶà×ÊÁÏ,×î·½±ãµÄ½â¾ö·½°¸ÈçÏÂ:
1.µ½oracle¹ÙÍøÏÂÔØOracle InstantClient,ÎÒϵÄÊÇinstantclient-basiclite-win32-10.2.0.4.zip,°ÑËü½âѹËõµ½
oracle°²×°Ä¿Â¼productÏÂ,ÆäÖл¹ÓÐÒ»¸öĿ¼Ϊ10.2.0. ......

OracleÐÔÄÜÓÅ»¯ÓëDelphi´úÂë

OracleÐÔÄÜÓÅ»¯ÓëDelphi´úÂë

¸ÕѧÁ˵ãoracle·½ÃæµÄ֪ʶ£¬¸Ð¾õÒÔǰд´úÂëֻƾϲºÃд£¬ÍêȫûÓÐÉԵÓÉ£¬µ¼ÖÂÔÚÄÚÐÐÈË¿´À´£¬Ð´µÄ¶¼ÊÇÀ¬»ø´úÂ룬ÏÖÔھͰÑѧµ½µÄһЩ¶«Î÷д³öÀ´£¬Ò²ËãÊǸø¸ÕÈëÃŵÄÅóÓÑÒ»µã°ïÖú°É¡£
ÒÔǰ£¬Ð´Êý¾Ý¿â·ÃÎÊ´úÂ룬¸Ð¾õºÜ¼òµ¥£¬²»¾ÍÊÇsqlÓï¾äÂËùÒÔʲôÓï¾ä¶¼ÊÇÕâÑùд£º
A£º
 
......

Oracle 10g ÒªµãÕûÀí Ö® Ë÷Òý

Ë÷Òý
1 ¸ÅÊö
  Ë÷ÒýÊÇÒ»ÖÖÊ÷×´½á¹¹¡£
  Ë÷Òý·ÖΪÂß¼­Éè¼ÆºÍÎïÀíʵÏÖ¡£
  Âß¼­Éè¼Æ·ÖΪ£ºµ¥ÁÐË÷Òý¡¢¸´ºÏË÷Òý¡¢Î¨Ò»ÐÔË÷ÒýºÍ·ÇΨһÐÔË÷Òý¡¢»ùÓÚº¯ÊýµÄË÷Òý¡£
  ÎïÀíʵÏÖ·ÖΪ£º·ÖÇøË÷Òý¡¢·Ç·ÖÇøË÷Òý¡¢BÊ÷Ë÷Òý¡¢ÕýÏòË÷Òý¡¢·´ÏòË÷Òý¡¢Î»Í¼Ë÷Òý¡£
  ΩһË÷ÒýÊÇË÷ÒýÁÐÖµ²»ÄÜÖØ¸´µÄË÷Òý£¬·ÇΩһË÷Òý ......

³£ÓÃSQLÓï¾ä£¨Oracle£©(ת)

ORACLEÖÐ×ֶεÄÊý¾ÝÀàÐÍ
   ×Ö·ûÐÍ    char        ·¶Î§  ×î´ó2000¸ö×Ö½Ú ¶¨³¤
               char(10)   'ÕÅÈý' ºóÌí¿Õ¸ñ6¸ö°Ñ10¸ö×Ö½Ú²¹Âú  'ÕÅÈý &nb ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ