æ£æ¥ç¡¬ä»¶æ¯å¦æ»¡è¶³è¦æ±
1ï¼ç¡®ä¿ç³»ç»æ足å¤ç RAM å交æ¢ç©ºé´å¤§å°ï¼è¿è¡ä»¥ä¸å½ä»¤ï¼
#grep MemTotal /proc/meminfo
#grepSwapTotal /proc/meminfo
注ï¼æéæå° RAM 为 512MBï¼èæéæå°äº¤æ¢ç©ºé´ä¸º 1GBãå¯¹äº RAM å°äºæçäº 2GB çç³»ç»ï¼äº¤æ¢ç©ºé´åºä¸º RAM æ°éç两åï¼å¯¹äº RAM å¤§äº 2GB çç³»ç»ï¼äº¤æ¢ç©ºé´åºä¸º RAM æ°éçä¸å°ä¸¤åã
2ï¼ç¡®ä¿æ足å¤çç£ç空é´ãOracle 10g软件大约éè¦ 2.5GB çå¯ç¨ç£ç空é´ï¼æ°æ®åºåå¦éè³å°1.2Gçç£ç空é´
3ï¼/tmp ç®å½è³å°éè¦ 400MB çå¯ç¨ç©ºé´ã
è¦æ£æ¥ç³»ç»ä¸çå¯ç¨ç£ç空é´ï¼è¿è¡ä»¥ä¸å½ä»¤ï¼
#df-h
æä¹å¨linuxä¸å®è£
oracleæ°æ®åº
æ£æ¥ç³»ç»æ¯å¦å·²å®è£
æéçå¼åå
使ç¨rpm -qaå½ä»¤ï¼ç¡®ä¿ä»¥ä¸å
å·²æåå®è£
ã对äºå
ççæ¬,åªæçæ¬é«äºä¸é¢çé½å¯ä»¥,å¦æä½äºæ¤çæ¬,åè¦å级å¤ç,å¦ä¸:
binutils-2.15.92.0.2-13.EL4
compat-db-4.1.25-9
compat-libstdc++-296-2.96-132.7.2
control-center-2.8.0-12
gcc-3.4.3-22.1.EL4
gcc-c++-3.4.3-22.1.EL44
glibc-2.3.4-2.9
glibc-common-2.3.4-2.9
gnome-libs-1.4.1.2.90-44.1
libstdc++-3.4.3-22.1
libstdc++-devel-3.4.3-22.1
make-3.80-5
pdksh-5.2.14-30
sysstat-5.0.5-1
xscreensaver-4.18-5.rhel4.2
setarch-1.6-1
libaio-0.3.103-3
æä¹å¨linuxä¸å®è£
oracleæ°æ®åº
å建oracleç»åoracleç¨æ·
å建ç¨äºå®è£
åç»´æ¤ Oracle 10g软件ç Linux ç»åç¨æ·å¸æ·ãç¨æ·å¸æ·å°ç§°ä¸º oracleï¼èç»å°ç§°ä¸º oinstallï¼ç¨äºè½¯ä»¶å®è£
ï¼ å dbaï¼ç¨äºæ°æ®åºç®¡çï¼ã
#groupadd oinstall
#groupadd dba
#useradd -m -g oinstall -G dba oracle âporacle (p表示添å å¸å·å¯ç )
å建oracleç®å½å¹¶æ¹åç®å½æé
ç°å¨ï¼å建åå¨ Oracle 10g 软件åæ°æ®åºæ件çç®å½ãæ¬æåå¨å建ç®å½ç»ææ¶æç¨çå½åæ¯ä¾ç¬¦åæä½³çµæ´»ç»æ (OFA) è§èã
以 root ç¨æ·èº«ä»½æ§è¡ä»¥ä¸å½ä»¤ï¼
#mkdir -p /u01/app/oracle # oracleæ ¹ç®å½ï¼-p 表示éå½å»ºç«ç®å½
#mkdir -p /u02/oradata # oracleæ°æ®æ件åæ¾ç®å½
#chown -R oracle:oinstall /u01
#chown -R oracle:oinstall /u02
#chmod -R 775 /u01
#chmod -R 775 /u02
æä¹å¨linuxä¸å®è£
oracleæ°æ®åº
é
ç½®linuxå
æ ¸åæ°
#vi/etc/sysctl.confï¼æ·»å å¦ä¸å
容ï¼
kernel.shmall = 2097152
kernel.shmmax = 2147483648 #æ¤å¤é»è®¤è®¾ç½®ä¸º2Gï¼æ°å¼ä¸è¬è®¾ä¸ºç©çå
åç40~50%
kernel.shmmni = 4096
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
å®æåï¼è¿è¡ä»¥ä¸å½ä»¤æ¿æ´»æ´æ¹ï¼
#sysctlâp
注ï¼Linux å
æ ¸é常åºè²ãä¸å¤§å¤æ°å
¶ä» *NIX ç³»ç»ä¸åï¼Linux å
许å¨ç³»ç»å¯å¨åè¿è¡æ¶ä¿®æ¹å¤§å¤æ°å
æ ¸åæ°ãå®æå
æ ¸åæ°æ´æ¹åä¸å¿
éæ°å¯å¨ç³»ç»ãOracle æ°æ®åº 10g éè¦ä»¥ä¸æ示çå
æ ¸åæ°è®¾ç½®ãå
¶ä¸ç»åºçæ¯æå°å¼ï¼å æ¤å¦ææ¨çç³»ç»ä½¿ç¨çå¼è¾å¤§ï¼åä¸è¦æ´æ¹å®ã
é
ç½®oracleç¨æ·çshelléå¶
#vi /etc/security/limits.conf æ·»å å¦ä¸å
容ï¼
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
#vi /etc/pam.d/login æ·»å å¦ä¸å
容ï¼
session required pam_limits.so
导åºxå¾å½¢çé¢ç»oracleç¨æ·
ç±äºå®è£
æ¶éç¨çæ¯oracleçOUIå¾å½¢åçé¢ï¼éè¦Xæ¯æï¼èé»è®¤oracleç¨æ·æ¯ä¸æ¯æå¾å½¢åæä½çï¼å¿
须以rootç身份导åºXç»oracleç¨æ·ä½¿ç¨ãè¿è¡å¦ä¸å½ä»¤ï¼
#xhost +
access control disabled,clients can connect from any host
åºç°ä»¥ä¸æå表示导åºæåã
æä¹å¨linuxä¸å®è£
oracleæ°æ®åº
oracleç¨æ·ä¸æ§è¡
1.2.1设置ç¯å¢åé
#su âoracle
$vi .bash_profile
å å
¥ä»¥ä¸å
容ï¼
TMP=/tmp
TMPDIR=$TMP
ORACLE_BASE=/u01/app/oracle #oracle æ ¹ç®å½
ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1 #oracle 家ç®å½
ORACLE_SID=orcl #æ ¹æ®å®é
éè¦å½å
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
PATH=$ORACLE_HOME/bin:$PATH
exportTMP TMPDIR ORACLE_BASE ORACLE_HOME ORACLE_SID LD_LIBRARY_PATH PATH
$source .bash_profile #使ç¯å¢åéçæ
2ãå®è£
Oracle
2.1ãä¸è½½å¹¶è§£åoracle软件
ä»Oracleç½ç«ä¸è½½10201_database_linux_x86_32.cpio.gzå°oracleç¨æ·å®¶ç®å½ä¸/home/oracle/ï¼ä¹å¯ä¸ºå
¶ä»ç®å½ï¼ï¼ä½¿ç¨oracleç¨æ·ç»å½åï¼è§£åæ¤æ件ï¼
$startx
$cd /home/oracle
$gunzip 10201_database_linux_x86_64.cpio.gz
$cpio -idmv <10201_database_linux_x86_64.cpio
以ä¸æä½å°Oracleå®è£
æ件解åå°database/ç®å½ã
ï¼æ ¹æ®ä¸è½½çå
çæ ¼å¼ä¸åï¼è§£ååºæ¥åçç®å½æ ¼å¼å¯è½ä¸åãï¼
2.2ãOracle OUIè¿è¡å¾å½¢åå®è£
ï¼æ¨è使ç¨é«çº§å®è£
æ¹å¼ï¼
åæ¢å°database/ç®å½ä¸ï¼è¿è¡ä»¥ä¸å½ä»¤ï¼
$cd database
$./runInstaller
æä¹å¨linuxä¸å®è£
oracleæ°æ®åº
æ£éªæ¯å¦å®è£
æå
æ°æ®åºæ£å¸¸å®è£
ç»æåï¼é»è®¤æ¯å¯å¨çã以oracleç¨æ·èº«ä»½è¿è¡ä»¥ä¸å½ä»¤æµè¯ï¼
$sqlplus/ as sysdba
SQL>selectopen_mode from v$database;
OPEN_MODE
------------------
READ WRITE
è¥åºç°ä»¥ä¸æå说ææ°æ®åºæ£å¨æ£å¸¸è¿è¡ãèªæ¤ï¼æ°æ®åºå®è£
æåã
æä¹å¨linuxä¸å®è£
oracleæ°æ®åº
温馨提示:答案为网友推荐,仅供参考