as5°²×°oracle²½Öè
Ò»:½¨Á¢Óû§,Óû§×é:
groupadd dba
groupadd oinstall
useradd oracle -g oinstall -G dba
passwd oracle
¶þ:ÐÞ¸Ä˵Ã÷,¸ÄΪas4
vi /etc/redhat-release
Ð޸ĺóµÄÄÚÈÝ:
Red Hat Enterprise Linux AS release 4 (Nahant Update 4)
#Red Hat Enterprise Linux Server release 5.4 (Tikanga)
Èý:¸Ähost(²»±Ø,ÍøÉÏËµÍøÂç¼ì²éͨ²»¹ý,Æäʵ¿ÉÒÔ²»½øÐÐÍøÂç¼à²ì,ÔÚ°²×°oracleʱÓÐÒ»²½ÊǼì²é,°ÑÍøÂç¼à²ìµÄ¹´È¥µô¼´¿É)
vi /etc/hosts
Ð޸ĺóµÄÄÚÈÝ:
192.168.10.172 localhost.localdomain localhost
ËÄ:export LC_ALL=en_US(Èç¹ûas5°²×°Ê±ÊÇenglishʱ,²»±Ø)
Îå:ÔÚ/etc/sysctl.confÌí¼Ó
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
# semaphores: semmsl, semmns, semopm, semmni
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default=262144
net.core.rmem_max=262144
net.core.wmem_default=262144
net.core.wmem_max=262144
ʹ֮ÉúЧ:
/sbin/sysctl -p
Áù:ÔÚ/etc/security/limits.confÖÐÌí¼Ó
* soft nproc 2047
* hard nproc 16384
* soft nofile 1024
* hard nofile 65536
Æß:ÔÚ/etc/pam.d/loginÖÐÌí¼Ó
session required /lib/security/pam_limits.so
°Ë:½ûÖ¹secure linux
vi /etc/selinux/config
ÐÞ¸ÄÒÔÏÂÐÐ:
SELINUX=disabled
¾Å:vi ~/.bash_profile
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
PATH=$PATH:$HOME/bin
export PATH
ORACLE_BA
Ïà¹ØÎĵµ£º
ÔÚϵͳʱ¼ä»ù´¡ÉÏÑÓ³Ù5Ãë
¡¡¡¡sysdate+(5/24/60/60)
¡¡¡¡ÔÚϵͳʱ¼ä»ù´¡ÉÏÑÓ³Ù5·ÖÖÓ
¡¡¡¡sysdate+5/24/60
¡¡¡¡ÔÚϵͳʱ¼ä»ù´¡ÉÏÑÓ³Ù5Сʱ
¡¡¡¡sysdate+5/24
¡¡¡¡ÔÚϵͳʱ¼ä»ù´¡ÉÏÑÓ³Ù5Ìì
¡¡¡¡sysdate+5
¡¡¡¡ÔÚϵͳʱ¼ä»ù´¡ÉÏÑÓ³Ù5ÔÂ
¡¡¡¡add_months(sysdate,-5)
¡¡¡¡ÔÚϵͳʱ¼ä»ù´¡ÉÏÑÓ³Ù5Äê
¡¡¡¡add_months ......
¹ØÓÚ°²×°£º
°²×°Oracle10gʱ£¬ËùÊäÈëµÄÈ«¾ÖµÄSIDÃû³ÆÎªtest(¼´Êý¾Ý¿âÃû£¬²»ÄÜ×÷ΪÓû§ÃûÀ´µÇ¼)£¬ÃÜÂëΪtest(¸ÃÃÜÂë¶ÔÓ¦µÄÓû§Îªsystem£¬sysµÈ)¡£
×°Íêºó£¬Èô´ÓÍøÒ³ÉϵǼoracle£¬ÔòÊäÈëurl£ºhttp://localhost:1158/em
ÈôÎÞ·¨ÏÔ ......
Author: rainnyzhong
Date:2010-1-15
1£® Ö¢×´ÃèÊö£º
FALB12´ÓEXCEL IMPORT DATAµ½DB£¬Ô¤¼ÆÊÂÎñ»áÔËÐÐ1¸ö¶àСʱ£¬ÔÚ¿ªÊ¼²Ù×÷ºó40·ÖÖÓ×óÓÒ£¬ORACLE¹ÒËÀ£¬ÈκÎÓû§¶¼²»¿ÉÒÔÔٵǽÁË¡£
2£® ·ÖÎö
£¨1£© ÏÂÃæÊǹÒËÀʱOSµÄ×ÊÔ´×´¿ö£º
09:37:54 up 73 ......
×÷Õߣºeygle |English Version ¡¾×ªÔØÊ±ÇëÒÔ³¬Á´½ÓÐÎʽ±êÃ÷ÎÄÕ³ö´¦ºÍ×÷ÕßÐÅÏ¢¼°±¾ÉùÃ÷¡¿
Á´½Ó£ºhttp://www.eygle.com/archives/2010/01/oracle_dba_notebook.html
½ñÌ죬ÊÕµ½Á˳ö°æÉç¿ìµÝ¶øÀ´µÄ¡¶Oracle DBAÊּǡ·Ò»ÊéµÄ24СʱСÑù£¬Õâ¸öСÑùͨ¹ýÖ®ºó£¬Êé¾Í¿ÉÒÔ³ÉÅúÓ¡Ë¢£¬Ö¸ÈÕ¿É´ýÁË¡£×î¿ìµÄ¹À¼ÆÊÇÏÂÖÜ¿ÉÒÔÉ ......
-- ÐòÁвÙ×÷ --
-- ´´½¨ÐòÁÐ
CREATE SEQUENCE u_sales_SEQ INCREMENT BY 1 START WITH 1 MINVALUE 1 NOCYCLE NOCACHE NOORDER;
-- ²é³öËùÓдæÔÚµÄÐòÁÐ
SELECT * from user_sequences
-- ɾ³ýÐòÁÐ
DROP SEQUENCE U_SALES_SEQ;
-- ²é³öÏÂÒ»¸öÐòÁÐID
SELECT U_SALES_SEQ. ......