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
Ïà¹ØÎĵµ£º
vi /opt/back.sh(oracleÓû§)
#!/bin/ksh
tim=`date +%Y%m%d`
unset USERNAME
#export DISPLAY=0.0.0.0:0.0
#export ORACLE_BASE=/home/oraprod3
#export ORACLE_HOME=/prod/oracle/prod3db/9.2.0
#export ORACLE_SID=PROD3_db
#export LD_LIBRARY_PATH=/prod/oracle/prod3db/9.2.0/lib
#export ORACLE_TERM=vt100 ......
¼Ç¼һÏÂORACLE 10gR2µÄÈí¼þÏÂÔصØÖ·£¬±¸Óá£
ÏÂÔØOTNÉϵÄÕâЩÈí¼þ£¬ÄãÐèÒªÒ»¸öOTNÃâ·ÑÕʺţ¬²»¹ýÈç¹ûͨ¹ýѸÀ×½øÐÐÏÂÔØ£¬¾Í²»ÓõǽOTNÁË£º
Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Microsoft Windows (32-bit)
http://download.oracle.com/otn/nt/oracle10g/10201/10201_database ......
ÔÚORACLEÊý¾Ý¿âÖÐ,ÐèÒª¶ÔSQLÓï¾ä½øÐÐÓÅ»¯µÄ»°ÐèÒªÖªµÀÆäÖ´Ðмƻ®,´Ó¶øÕë¶ÔÐԵĽøÐе÷Õû.ORACLEµÄÖ´Ðмƻ®µÄ»ñµÃÓм¸ÖÖ·½·¨,ÏÂÃæ¾ÍÀ´×ܽáÏÂ
1¡¢EXPLAINµÄʹÓÃ
Oracle RDBMSÖ´ÐÐÿһÌõSQLÓï¾ä£¬¶¼±ØÐë¾¹ýOracleÓÅ»¯Æ÷µÄÆÀ¹À¡£ËùÒÔ£¬Á˽âÓÅ»¯Æ÷ÊÇÈçºÎÑ¡Ôñ(ËÑË÷)·¾¶ÒÔ¼°Ë÷ÒýÊÇÈçºÎ±»Ê¹Óõģ¬¶ÔÓÅ»¯SQLÓï ......
×÷Õߣºeygle |English Version ¡¾×ªÔØʱÇëÒÔ³¬Á´½ÓÐÎʽ±êÃ÷ÎÄÕ³ö´¦ºÍ×÷ÕßÐÅÏ¢¼°±¾ÉùÃ÷¡¿
Á´½Ó£ºhttp://www.eygle.com/archives/2010/01/oracle_dba_notebook.html
½ñÌ죬ÊÕµ½Á˳ö°æÉç¿ìµÝ¶øÀ´µÄ¡¶Oracle DBAÊּǡ·Ò»ÊéµÄ24СʱСÑù£¬Õâ¸öСÑùͨ¹ýÖ®ºó£¬Êé¾Í¿ÉÒÔ³ÉÅúÓ¡Ë¢£¬Ö¸ÈÕ¿É´ýÁË¡£×î¿ìµÄ¹À¼ÆÊÇÏÂÖÜ¿ÉÒÔÉ ......