ubuntu 10.04 ϰ²×°oracle 11g
°²×°²½Ö裺
1. °²×°JDK£¬°²×°·½·¨¼û
Ubuntu
10.04ϵĴSUN JAVA¿ª·¢»·¾³
½â¾öÖÐÎÄÂÒÂëÎÊÌ⣬ÔÚjreĿ¼ÏÂ×ÖÌåĿ¼Öн¨Á¢"fallback"Ŀ¼£¬È»ºócopy»òÕßlinkÄãϲ»¶µÄ×ÖÌåÖÁĿ¼ÏÂ.
2. °²×°±ØÒªµÄÈí¼þ°ü
11gËùÐèÒªµÄÈí¼þ°ü²¢²»¶à£¬Ö»Òª°²×°build-essential,rpm,libaio,ksh,libtool,libstdc++5
sudo apt-get install rpm libaio1 ksh libtool libstdc++5 build-essential
3. ÉèÖÃĿ¼½á¹¹ºÍ·ûºÅÁ´½Ó
sudo ln -s /usr/bin/awk /bin/awk
sudo ln -s /usr/bin/rpm /bin/rpm
sudo ln -s /usr/bin/basename /bin/basename
sudo mkdir /etc/rc.d
for i in 0 1 2 3 4 5 6 ; do ln -s /etc/rc$i.d /etc/rc.d/rc$i.d ; done
ÔÚ"/opt"Ŀ¼Ï½¨Á¢Á½¸öĿ¼"/opt/oracle11g/server"£¬"/opt/oracle11g/oradata"£¬"server"ÓÃÓÚ´æ·Å11gµÄ³ÌÐòÎļþ£¬"oradata"ÓÃÓÚ´æ·ÅÊý¾Ý¿âÎļþ¡£ÆäÖÐluyaoweiÊÇÄãϵͳµÇ¼µÄÓû§Ãû
sudo mkdir /opt/oracle11g
sudo mkdir /opt/oracle11g/server
sudo mkdir /opt/oracle11g/oradata
sudo chown luyaowei /opt
sudo chown luyaowei /opt/oracle11g
sudo chown luyaowei /opt/oracle11g/server
sudo chown luyaowei /opt/oracle11g/oradata
4. ÉèÖÃϵͳ²ÎÊý
ÐÞ¸Ä/etc/sysctl.confÎļþ£¬ÔÚĩβÌí¼ÓÏÂÃæÄÚÈÝ
sudo gedit /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
ÐÞ¸Ä/etc/security/limits.conf
sudo gedit /etc/security/limits.conf
Ìí¼ÓÄÚÈÝÈçÏÂ
luyaowei soft nproc 2047
luyaowei hard nproc 16384
luyaowei soft nofile 1024
luyaowei hard nofile 65536
ÐÞ¸Ä/etc/pam.d/login£¬¼ÓÈëÈçÏÂÄÚÈÝ£º
sudo gedit /etc/pam.d/login
Ìí¼ÓÄÚÈÝÈçÏÂ
session required /lib/security/pam_limits.so
session required pam_limits.so
Ö´ÐдúÂë
sudo sysctl -p
ÐÞ¸ÄprofileÎļþ
cdhttp://blog.csdn.net/luyaowei/archive/2010/05/19/56089
Ïà¹ØÎĵµ£º
ÔÚoracleÖд¦ÀíÈÕÆÚ´óÈ«
TO_DATE¸ñʽ
Day:
dd number 12
dy abbreviated fri
day spelled out friday
ddspth spelled out, ordinal twelfth
Month:
mm number 03
mon abbreviated mar ......
Ï£Íû¸ßÊÖ¿ÉÒÔ°ïæһÏ ²»Ê¤¸Ð¼¤
C:\Documents and Settings\Administrator>sqlplus /nolog
SQL*Plus: Release 10.2.0.3.0 - Production on ÐÇÆÚËÄ 5ÔÂ 20 17:23:05 2010
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
SQL> conn system/manager as sysdba;
ÒÑÁ¬½Óµ½¿ÕÏÐÀý³Ì¡£
SQL> ......
×îÐÂoracle ²¹¶¡ÏÂÔØ
ʹÓÃѸÀ×н¨ÈÎÎñÏÂÔØµØÖ·Ìîд
ftp://updates.oracle.com/<patch_num>/p<patch_num>_<version>_<os>.zip
¾Í¿ÉÒÔÏÂÔØµ½ÄãÏëÒªµÄ²¹¶¡ÁË¡£
ÒÔÏÂÊǼ¸¸ö³£Óò¹¶¡µÄÏÂÔØµØÖ·¡£
(10.2.0.3 patch)
ftp://updates.oracle.com/5337014/p5337014_10203_WINNT.zip ftp://updates.o ......
²é¿´Oracle ±í½á¹¹µÄ´´½¨ºÍ×îºóÐÞ¸Äʱ¼ä
SELECT a.owner, a.table_name, created, last_ddl_time
from dba_tables a, SYS.dba_objects b
WHERE a.tablespace_name = 'USERS'
AND a.owner = b.owner
AND a.table_name = b.object_name
AND object_type = 'TABL ......
oracleº¯Êý´óÈ«-Êý×Ö´¦Àíº¯Êý
F.3 Êý×Öº¯Êý
º¯Êý½ÓÊÜNUMBERÀàÐ͵IJÎÊý²¢·µ»ØNUMBERÀàÐ͵ÄÊýÖµ.³¬Ô½º¯ÊýºÍÈý½Çº¯ÊýµÄ·µ»ØÖµ¾«È·µ½36λ.ACOS¡¢ASIN¡¢ATAN¡¢ATAN2µÄ½á¹û¾«È·µ½36λ.
l ABS
Óï·¨: ABS(x)
¹¦ÄÜ: µÃµ½xµÄ¾ø¶ÔÖ ......