ããUbuntu12.04 å®è£
Oracle10g å
¨è¿ç¨(å®ç¾)åé®é¢è§£å³åæ³
ããPSï¼æ£å¸¸æ
åµä¸ï¼å®ç¾æ éããå¦æéå°é®é¢ï¼ä¹æ解å³åæ³1.å®è£
ååå¤å·¥ä½
ãã1.1 å°oracleå®ç½ä¸è½½éåèªå·±çµèçoracle软件å
ï¼æçæ¯ï¼Oracle Database 10gRelease 2 (10.2.0.1.0)Enterprise/Standard Edition for Linux x86ä¸çï¼10201_database_linux32.zipå°åï¼
http://www.oracle.com/technetwork/database/10201linuxsoft-097986.html1.2 æ´æ°ubuntu
ãã# apt-get update
ãã# apt-get upgrade
ãã1.3 å®è£
é¢å¤çjavaJDK
ããå¯å¨ãUbuntu软件ä¸å¿ãæOPENjdk,å®è£
OpenJDK å®æåpathè·¯å¾èªå¨è®¾ç½®å¥½äº1.4 å®è£
缺å°çå
并éä½GCCçæ¬
ããapt-get install gcc make binutils lesstif2 libc6 libc6-dev rpm libmotif3 libaio1 alienapt-get install ksh libtool libstdc++5 build-essential compat-libstdc++å¸è½½gcc-4.6,å®è£
gcc-4.4 çæ¬
ããapt-get remove gcc-4.6
ããapt-get install gcc-4.4
ãã1.5 å建oracleç¨æ·
ããç»å½å°rootç¨æ·ä¸æä½ï¼
ãã1.5.1 ä¿®æ¹shell
ããls -l /bin/sh å¦ææ¯dashä¿®æ¹ä¸ºbash
ããrm /bin/sh
ããln -s /bin/bash /bin/sh
ãã1.5.2 å建ç¨æ·åç»åoracleå®è£
è·¯å¾
ããaddgroup oinstall
ããaddgroup dba
ããaddgroup nobody
ããusermod -g nobody nobody
ããadduser oracle
ããusermod -g oinstall -G dba oracle
ããid oracle
ããid nobody
ããmkdir -p /opt/oracle
ããmkdir -p /opt/oradata
ããchown -R oracle:dba /opt/ora*
ããchmod -R 775 /opt/ora*
ãã1.5.3 å建欺éªçæ¬å£°æ
ããvi /etc/redhat-release
ããç¶ååå
¶ä¸å å
¥ Red Hat Linux release 3.1
ãã1.5.4 建ç«é¾æ¥
ããln -s /usr/bin/gcc-4.4 /usr/bin/gcc
ããln -s /lib/i386-linux-gnu/libgcc_s.so.1 /lib/libgcc.s.so.1ln -s /usr/bin/awk /bin/awk
ããln -s /usr/bin/rpm /bin/rpm
ããln -s /usr/bin/basename /bin/basename
ããmkdir /etc/rc.d
ããln -s /etc/rc0.d /etc/rc.d/rc0.d
ããln -s /etc/rc1.d /etc/rc.d/rc1.d
ããln -s /etc/rc2.d /etc/rc.d/rc2.d
ããln -s /etc/rc3.d /etc/rc.d/rc3.d
ããln -s /etc/rc4.d /etc/rc.d/rc4.d
ããln -s /etc/rc5.d /etc/rc.d/rc5.d
ããln -s /etc/rc6.d /etc/rc.d/rc6.d
ããln -s /etc/init.d /etc/rc.d/init.d
ãã1.5.5 æ·»å ç¨æ·å°sudoerå表ä¸
ããvi /etc/sudoers
ããå¨â root ALL=(ALL:ALL) ALLâ ä¸ä¸è¡ ï¼æ·»å ï¼
ããoracle ALL=(ALL:ALL) ALL
ãã1.5.6 ä¿®æ¹å
æ ¸åæ°åç³»ç»åé
ããA ä¿®æ¹/etc/sysctl.confæ件(å¯ä»¥ä¸ç¨ä¿®æ¹)
ããgedit /etc/sysctl.conf
ããæ·»å å¦ä¸å
容ï¼
ããkernel.shmall = 2097152
ããkernel.shmmax = 2147483648
ããkernel.shmmni = 4096
ããkernel.sem = 25 32000 100 128
ããfs.file-max = 65536
ããnet.ipv4.ip_local_port_range = 1024 65000B ä¿®æ¹/etc/security/limits.conf(å¯ä»¥ä¸ç¨ä¿®æ¹)gedit /etc/security/limits.conf
ããæ·»å å¦ä¸å
容ï¼
ãã* soft nproc 2407
ãã* hard nproc 16384
ãã* soft nofile 1024
ãã* hard nofile 65536
ãã说æï¼ä¸è¦å¿äºâ*âå·ï¼å¯ä»¥æ¢æoracle
ããC ä¿®æ¹ubuntuçoracleç¨æ·çç¯å¢åé
ããä¿®æ¹/home/oracle/.profileå/etc/profile两个æ件vi /home/oracle/.profile
ããvi /etc/profile
ããæ·»å å¦ä¸å
容ï¼
ãã#oracle_path start
ããexport ORACLE_HOME=/opt/oracle
ããexport ORACLE_SID=orcl
ããexport ORACLE_OWNER=oracle
ããexport PATH=$PATH:$ORACLE_HOME/bin
ãã#oracle_path end
ãã1.5.7 使åæ°çæ
ããéå¯ç³»ç» æ ç»ç«¯æ§è¡å½ä»¤ sysctl -p
ãã1.5.8 å°ä¸è½½å¥½çoracleå®è£
æ件mvå°/home/oracleä¸ï¼å¹¶è§£åã注érootç¨æ·ï¼ç»å½oracleç¨æ·2.å¼å§å®è£
oracle
ãã2.1 æå¼ç»ç«¯ï¼cdå°/home/oracle/databaseçoracle解åæ件ä¸ï¼æ§è¡ä¸é¢è¿æ¡å½ä»¤./runInstaller -jreLoc /usr/lib/jvm/java-6-openjdk-i386/jrejava-versionæ¯javaçå®è£
çæ¬ï¼è¿ä¸å¥æ¯ä¸ºäºå¨å¾ååè£
oracleæ¯ä¸ä¼åºç°ä¹±ç æè
æ¹æ¡ç¶åå°±åwindowsä¸å®è£
ä¸æ ·çå¾ååå®è£
çé¢ã
ããä¸è¡çè¯ï¼ä½¿ç¨è±æå®è£
çé¢
ããexport LANG=ENGLISTH
ãã./runInstaller
ãã2.2 æç
§ä¸é¢çå¾åæ¥éª¤æä½
ãã
http://www.cnblogs.com/luochengor/archive/2011/08/20/2147041.html2.3 æ§è¡å°é
ç½®é
ç½®èæ¬æ¶
ããåæ¢å°rootä¸ï¼å¨ç»ç«¯ä¸æ§è¡èæ¬
ãã/home/oracle/oralnventory/orainstRoot.sh
ãã/opt/ora10/root.sh
ãã2.4 åºç°oracle database 10g å®è£
å®ææ¶ï¼è®°ä¸ä¸¤ä¸ªURLã
ãã2.5 å®è£
æ°æ®åº
ããå¨ç»ç«¯ä¸æ§è¡å¦ä¸å½ä»¤ï¼
ãã$dbca //å¦æåºç°ä¸æä¹±ç ï¼æ§è¡ä¸é¢å½ä»¤$cd /opt/ora10/bin
ãã$gedit dbca
ããå¨dbcaä¸æ¾å°âJRE_DIR=/opt/ora10/jdk/jreâï¼æ¿æ¢ä¸ºJRE_DIR=/usr/lib/jvm/java-1.6.0-openjdk/jre ï¼ç¶åä¿åéåº$dbca //æ£å¸¸æ¾ç¤ºäº
ãã2.6 æç
§ä¸é¢æ¥éª¤æ§è¡
ãã
http://www.cnblogs.com/luochengor/archive/2011/08/20/2147041.htmlä½æ¯ï¼è¦å°æ°æ®åºåååSIDé½è¦åä¸orcl
ããä¸ç´å°å®è£
å®æã
ãã3. å¯å¨oracle
ããå¨âç»ç«¯â以oracle身份è¿è¡
ããå¯å¨TNSçå¬å¨ï¼$ORACLE_HOME/bin/lsnrctl startï¼$ORACLE_HOME,å°±æ¯oracleçå®è£
ç®å½ï¼/opt/ora10 .ç´æ¥cdï¼è¿å
¥oracleçå®è£
ç®å½ï¼å°binæ件夹ä¸ï¼$lsnrctl start ,ä¹è¡ï¼ã
ããå
³éTNSï¼$ORACLE_HOME/bin/lsnrctl stop
ããå¯å¨sqlplusï¼$ORACLE_HOME/bin/sqlplus /nologå
³ésqlplus:SQL> exit
ãã4. 为äºè½å¤åwindowsä¸ä¸æ ·è½å¤ä½¿ç¨ä¸ä¸é®ç¿»å¨å½ä»¤ï¼è¿éè¦å®è£
rlwrapå
ï¼
ããsudo apt-get install rlwrap
ããç¶åä¿®æ¹oracleç¨æ·ç~/.bashrcæ件å/etc/profileæ件ï¼å¨å
¶æåæ·»å 两è¡ï¼
ããè¿æ ·ä¸ä¸å·¦å³é®å°±å¯ä»¥ä½¿ç¨äºã
ããæåæ¥è§£å³oracleä¸æå符éçé®é¢ãä¸åºæå¤çè¯ï¼å¯å¨oracleä¼åç°ææçä¸æé½æ¯â?âï¼è¦ä¹å°±æ¯ä¹±ç ï¼è¿å
¶å®æ¯æå¡å¨ç«¯å符éå客æ·ç«¯å符éä¸ä¸è´é æçã
ãã解å³æ¹æ³ä¸ºï¼DBA身份è¿å
¥sqlplusï¼åæ¥è¯¢
ããSQL>select userenv(âlanguageâ) from dual;å°æ¥è¯¢ç»æå¤å¶ï¼å¨/etc/bash.bashrcæ件ä¸åå ä¸è¡ï¼export NLS_LANG=âæ¥è¯¢ç»æâï¼éæ°ç»å½é®é¢è§£å³ãä¾å¦ï¼æçæ¥è¯¢ç»æ为SIMPLIFIED CHINESE_CHINA.AL32UTF8ï¼åæ°å ä¸è¡ä¸ºexport NLS_LANG="SIMPLIFIED CHINESE_CHINA.AL32UTF8"ã
ããä½æ¯ææ¶åè¿ä¸ªæ¹æ³ä¸ä¸å®å¥æï¼ä½ å¯ä»¥å°
ããexport NLS_LANG="SIMPLIFIED CHINESE_CHINA.AL32UTF8"export NLS_LANG="SIMPLIFIED CHINESE_CHINA.ZHS16GBK"åå«åå°ä¸¤ä¸ªæ件ä¸å°è¯ä¸ä¸ï¼ä½æ¯ä¸¤ä¸ªæ件åçä¸å®è¦ä¸è´ã
ãã5. å¦ææé®é¢å¯æä¸åè¿ç¨å¤çï¼
ãã5.1
ããé®é¢ï¼è°ç¨makefile 'ï¼ï¼/sqlplus/lib/ins_sqlplus.mk' çç®æ 'install' æ¶åºéã请åé
'/home/oracle/oraInventory/logs/installActions2011-12-06_11-03-18AM.log' 以äºè§£è¯¦ç»ä¿¡æ¯ã
ãã解å³åæ³ï¼$ORACLE_HOME/sqlplus/lib/env_sqlplus.mkæ·»å ä¸è¡ï¼EXPDLIBS=-lclntsh ï¼ç¶åç¹å»âéè¯âæé®ï¼ ok.
ããå
¶å®å®è£
gcc-4.4 以å没æè¿ä¸ªé®é¢ã
ãã5.2
ããé®é¢ï¼è°ç¨makefile 'ï¼ï¼/sysman/lib/ins_sysman.mk' çç®æ 'agent nmo nmb' æ¶åºéã请åé
'ï¼ï¼ /oraInventory/logs/installActions2011-12-06_11-03-18AM.log' 以äºè§£è¯¦ç»ä¿¡æ¯ã
ããåæï¼åé¢éå°çé误å
¶å®æ¬è´¨ä¸æ¯ä¸ä¸ªé®é¢ï¼ä¸»è¦æ¯gccççæ¬é«äºï¼oracle10gçgccæ¯3.4å·¦å³ççæ¬ï¼ä½æ¯ubuntuçå¼åé度æ©å°±ç¨äº4.0以ä¸çæ¬ï¼èä¸ä½ è¿æ æ³aptå®è£
ä½çæ¬è§£å³åæ³ï¼å¸è½½gcc-4.6,å®è£
gcc-4.4 çæ¬
ããapt-get remove gcc-4.6
ããapt-get install gcc-4.4
ãã5.3
ããè°ç¨makefile 'ï¼ï¼/network/lib/ins_net_server.mk' çç®æ 'install' æ¶åºéã请åé
'ï¼ï¼ /oraInventory/logs/installActions2011-12-06_11-03-18AM.log' 以äºè§£è¯¦ç»ä¿¡æ¯ã
ããåæï¼æå¨ç½ä¸æ¾å°äºä¸ç¯ç±»ä¼¼çææ¡£ï¼åè§ï¼ç¹å»æå¼é¾æ¥ï¼ï¼ä½æ¯ææå·¥ç¼è¯è¿æ¯æé®é¢ï¼èä¸å¨oracle10gä¸å¹¶ä¸æ¯ä»ææå°ç-lonsåæ°é®é¢ã
ããè¿æ¯gccçæ¬é®é¢ï¼ææ¾å°è¯è¿å®è£
ä½çæ¬çgccï¼ä½æ¯ä¸å¼å§ç¼è¯å°±æ¥éï¼æ以æ¾å¼äºï¼å¦ææ人è½æåéä½çæ¬ç¯å¢ï¼ç¸ä¿¡ä¸å®è½è§£å³ææé误é®é¢ï¼è¿ä¹æ¯ä¸ºä»ä¹ubuntu 8è½å¾èªç¶æåå®è£
çä¸ä¸ªè§£éã
ããæ¹æ³ï¼ç®åæè¿æ²¡ææ¹æ³ï¼æç
§å
¶.mkæ件ç说æï¼è¿ä¸ªä¸è¥¿å¥½åæ¯æ°æ®åºé¾æ¥æè£æ¶åéæ°é¾æ¥ç¨ç解å³åæ³ï¼å¸è½½gcc-4.6,å®è£
gcc-4.4 çæ¬
ããå¨/usr/bin ä¸åäº /usr/bin/gcc-4.4 ç软é¾æ¥cd /usr/bin
ããln -s /usr/bin/gcc-4.4 /usr/bin/gcc
ãã5.4
ããè°ç¨makefile 'ï¼ï¼/rdbms/lib/ins_rdbms.mk' çç®æ 'all_no_orcl ihsodbc' æ¶åºéã请åé
'ï¼ï¼/oraInventory/logs/installActions2011-12-06_11-07-36-AM.log' 以äºè§£è¯¦ç»ä¿¡æ¯ã
ããåæï¼æ们çä¸ä¸logæ件
ããä¿¡æ¯: Generating BASE ORASDK library...
ããä¿¡æ¯: Creating /opt/ora10/lib/liborasdkbase.so.10.2ä¿¡æ¯: gcc: é误ï¼/lib/libgcc_s.so.1ï¼æ²¡æé£ä¸ªæ件æç®å½gcc: é误ï¼/usr/lib/libstdc++.so.5ï¼æ²¡æé£ä¸ªæ件æç®å½æ们çå°ç»äºæ¯é£ä¸ªé常å¤çé误äºï¼å
¶å®è¿æ¯gccçé®é¢ï¼éæ°ä¸è½½äºlibgcc_s.so.1ï¼å¹¶ä¸éæ°åäºstdc++5çé¾æ¥ï¼ä½æ¯é®é¢è¿æ¯æ´å¤ï¼å 为åªå软é¾æ¥åä¸è½½ä¸ä¸ªå¨æåºæ¯æ²¡æ³è§£å³ææé®é¢çã
ãã解å³åæ³ï¼å®è£
compat-libstdc++-33_3.2.3-48.3_i386.debï¼éè¯ãã
ããå¨ä¸ä¸ªlibgcc_s.so.1软é¾æ¥
ããcd /lib
ããln -s /lib/i386-linux-gnu/libgcc_s.so.1 libgcc.s.so.16. å¼æºå¯å¨
ãã6.1 root ä¸é¢ä¿®æ¹ï¼vi /etc/oratab
ããorc1:/opt/oracle/product/10.2.0/db_1:Y
ããå°N该为Y
ãã6.2 oracle ä¸é¢ä¿®æ¹ï¼
ããcd $ORACLE_HOME/bin
ããvi dbstart
ããæ¾å° ORACLE_HOME_LISTNER è¿è¡ï¼ ä¿®æ¹æ:
ããORACLE_HOME_LISTNER=/opt/oracle/product/10.2.0/db_1æè
ç´æ¥ä¿®æ¹æï¼
ããORACLE_HOME_LISTNER=$ORACLE_HOME
ããæµè¯è¿è¡ dbshut, dbstart çè½å¦å¯å¨oracle æå¡ålisteneræå¡ps -efw | grep ora_
ããlsnrctl status
ããps -efw | grep LISTEN | grep -v grep
ãã6.3 root ä¸å建æ件:
ããvi /etc/rc.d/init.d/oracle10
ãã#!/bin/bash
ãã# chkconfig: 345 99 10
ãã# description: Startup Script for Oracle Databases# /etc/init.d/oracle10
ããexport ORACLE_SID=ym
ãã# export ORACLE_HOME_LISTNER=/data/files/oracle/10g/bin#oracle å®è£
ç®å½
ããexport ORACLE_HOME=/data/files/oracle/10gexport PATH=$PATH:$ORACLE_HOME/bin
ããcase "$1" in
ããstart)
ããsu oracle -c $ORACLE_HOME/bin/dbstart #å¯å¨æå¡su oracle -c $ORACLE_HOME/bin/lsnrctl start #å¯å¨çå¬touch /var/lock/oracle
ããecho "OK"
ãã;;
ããstop)
ããecho -n "Shutdown Oracle: "
ããsu oracle -c $ORACLE_HOME/bin/dbshut #å¯å
³éæå¡su oracle -c $ORACLE_HOME/bin/lsnrctl stop #å
³éçå¬rm -f /var/lock/oracle
ããecho "OK"
ãã;;
ãã*)
ããecho "Usage: 'basename $0' start|stop"
ããexit 1
ããesac
ããexit 0
ããç¶å
ããchmod 775 oracle10
ããchkconfig --add oracle10
ããchkconfig --list oracle10