作者:boean
(1)安装linux ,所由服务都不选择,只是选择安装开发工具,不要安装防火墙,不然有的端口没打开会提示
连接超时.
(2)打开终端,执行如下命令,检查安装包,没有的都要安装(一般在dis2 和dis3上)
rpm -q make gcc glibc compat-db compat-gcc compat-gcc-c++ compat-libstdc++ compat-libstdc++
-devel openmotif21 setarch libaio
(3)创建 Oracle 组和用户帐户
例如:
# /usr/sbin/groupadd oinstall
# /usr/sbin/groupadd dba
# /usr/sbin/useradd -m -g oinstall -G dba oracle
# id oracle
uid=501(oracle) gid=501(oinstall) groups=501(oinstall),502(dba)
设置 oracle 帐户的口令:
passwd oracle
(4)创建目录
例如:
# mkdir -p /oracle
# chown -R oracle:oinstall /oracle
# chmod -R 775 /oracle
(5)配置 Linux 内核参数,修改后不用重启动更新: /sbin/sysctl -p
第一种:打开/etc/sysctl.conf 复制如下内容
kernel.shmall = 2097152
kernel.shmmax = 2147483648
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.wmem_default=262144
net.core.rmem_max=262144
net.core.wmem_max=262144
6。检查需要安装一下包
make-3.79.1
gcc-3.2.3-34
glibc-2.3.2-95.20
compat-db-4.0.14-5
compat-gcc-7.3-2.96.128
compat-gcc-c++-7.3-2.96.128
compat-libstdc++-7.3-2.96.128
compat-libstdc++-devel-7.3-2.96.128
openmotif21-2.1.30-8
setarch-1.3-1
# rpm -qa | grep make gcc glibc compat openmotif21 setarch
硬件需求
内存和交换空间
Available RAM Swap Space Required
Between 1024 MB and 2048 MB 1.5 times the size of RAM
Between 2049 MB and 8192 MB Equal to the size of RAM
More than 8192 MB 0.75 times the size of RAM
磁盘空间
1。5G (不包括数据库)
检查硬件
内存
# grep MemTotal /proc/meminfo
交换空间
# grep SwapTotal /proc/meminfo
磁盘空间
# df -ah
(7)oracle 用户的环境变量
以 oracle 身份登录,并通过在 .bash_profile 或 .profile(bash 或 ksh)中添加以下行,将
ORACLE_BASE 添加到登录配置文件(直接gedit /home/oracle/.bash_profile)
增加下列内容:
export ORACLE_BASE=/oracle
export ORACLE_HOME=$ORACLE_BASE/10.2.0/db_1
export ORACLE_SID=orcl
export PATH=$PATH:$ORACLE_HOME/bin
执行
source /home/oracle/.bash_profile
如果远程安装,需要启动cygwin
执行
# startx
然后在打开的窗口里输入
# xhost +
然后在oracle安装的机器上运行
# export DISPLAY=192.168.1.170:0.0
(8)解压缩oracle 10g安装盘,然后新建终端,运行 /runInstaller (注意大小写)
复制到/work/目录,并解压
# unzip 10201_database_linux32.zip
# cd database
# ./runInstaller
安装过程中,
选择高级安装
在选择安装类型中,选择定制
安装过程中需要以root身份运行
/oracle/oraInventory/orainstRoot.sh
/oracle/10.2.0/db_1/root.sh
安装完毕后。
需要运行dbca来创建数据库
# dbca
创建数据库
(9)创建实例,起动数据库
(10)让oracle 跟随linux 一起启动.
root 登录,在 /etc/rc.d/init.d 下创建名为dbora,编辑增加以下内容
=================================================
#!/bin/bash
#参考http://staff.in2.hr/denis/oracle/10g1install_fedora3_en.html#n4_4
# chkconfig: 0356 95 1
# description: init script to start/stop oracle database 10g, TNS listener, EMS
#
#
# match these values to your environment:
export ORACLE_BASE=/oracle
export ORACLE_HOME=$ORACLE_BASE/10.2.0/db_1
export ORACLE_SID=orcl
export PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_USER=oracle
# see how we are called:
case $1 in
start)
su - "$ORACLE_USER" -c "$ORACLE_HOME/bin/dbstart"
su - "$ORACLE_USER" -c "$ORACLE_HOME/bin/emctl start dbconsole"
;;
stop)
su - $ORACLE_USER -c "$ORACLE_HOME/bin/lsnrctl stop"
su - $ORACLE_USER -c "$ORACLE_HOME/bin/dbshut"
su - $ORACLE_USER -c "$ORACLE_HOME/bin/emctl stop dbconsole"
;;
*)
echo "Usage: $0 {start|stop}"
;;
esac
==========================
打开终端执行:
chown oracle.oinstall /etc/rc.d/init.d/dbora
chmod 755 /etc/rc.d/init.d/dbora
使用chkconfig 设置运行权限
chkconfig dbora reset
检查
chkconfig --list dbora
结果如下:
ora10 0:off 1:off 2:off 3:on 4:off 5:on 6:off
注意:当系统不在 runlevels 3 and 5时,使用
service dbora start 启动服务.
service dbora stop 停止服务.
(11)修改$ORACLE_HOME/bin/dbstart
# Set this to bring up Oracle Net Listener
ORACLE_HOME_LISTNER=$ORACLE_HOME
如果没有ASM(自动存储),就把那一节内容删除,ASM要在加载实例前,先加载.
(12)重新启动计算机 ,就可以了,启动会比较慢,因为要自动启动em,database,listener,agent
常用手动控制数据库命令
打开em
emctl start dbconsole
关闭em
emctl stop dbconsole
启动listener
lsnrctl start <监听名>(默认是LISTENER,可省略)
关闭
lsnrctl stop
启动emagent
emctl start agent
关闭
emctl stop agent
启动实例
sqlplus /nolog
conn / as sysdba
startup
关闭
shutdown immediate
测试数据库是否通
tnsping <本地服务名>
========================================
常见问题:
网页界面上的按钮出现“口口”的乱码
解决方案:
1.停止服务,emctl stop dbconsole;
2.把相关目录(RHEL4里面是/etc/java/)下的font.properties用
font.properties.zh_CN.Redhat8.0替换(或font.properties.zh,只要是中文简体就可以。);
3.删除
$ORACLE_HOME/oc4j/j2ee/oc4j_applications/applications/em/em/cabo/images/cache/zhs中的gif文件
;
4.重起服务(最好是重启服务器) emctl start dbconsole;
/etc/oratab的内容
orcl:/oracle/10.2.0/db_1:Y
=====================================================
以下的 J2EE 应用程序已经配置, 并且可用下面列出的 URL 来访问。
iSQL*Plus URL:
http://database:5560/isqlplus
iSQL*Plus DBA URL:
http://database:5560/isqlplus/dba
Enterprise Manager 10g Database Control URL:
http://database:1158/em
\==========================================
常用linux命令
df -h
ps -A
top
free
cat /proc/meminfo
uname
grep MemTotal /proc/meminfo
grep SwapTotal /proc/meminfo
hostname
88.2.186.* 于 2007-05-23 15:58:56发表:
3cda05e505dadc91ecce6161f46f34d6 http://sensationx.udxpzb.net/2005-08-15.html http://comfort-monster.ynfqkm.net/2005-09-20.html 2005 09 22.html http://fortsonia.utwikd.net/2005-08-14.html 2005 07 08.html 2005 08 12.html http://spicyfish.ynfqkm.net/2005-08-25.html 2005 09 24.html 2005 08 27.html http://colgadero.pbcqvd.net/2005-07-25.html e7000c4d06986984b665ec9d15ae719a
85.85.96.* 于 2007-05-21 20:53:16发表:
55282ba38591eb39326b24eedbcd24c3 http://cracco-peck-ristorante-milano-sito-ufficiale.osjckd.org/ http://little-taver-kingo-radio-freccia.weejwl.org/ http://telefilm-annuncio-alice-linda-lavin.ynoxmw.org/ http://massimo-rosso-castel-san-pietro.shqsxs.org/ http://prove-caccia-starne-2007-pasian-prato.csapok.org/ http://video-porno-free-formato-zip.ynoxmw.org/ http://foto-camera-carica-batteria-canon.csapok.org/ http://hotel-5-stelle-in-liguria.weejwl.org/ http://campionato-2005-2006-dell-emilia-romagna.shqsxs.org/ http://ristorante-sant-andrea-a-montorfano.weejwl.org/ 417a8203d1b04948a6eb96aa4fb99866
201.245.250.* 于 2007-05-21 03:36:06发表:
ba3d04772c692e5c0d6b3a5908345bb1 2005 07 12.html http://gobidrives.qsogkn.net/2005-07-22.html http://fairbornnaturalfoods.udxpzb.net/2005-08-19.html http://atvencyclopedia.ynfqkm.net/2005-07-23.html 2005 09 06.html http://live-fisting.iuwexi.net/2005-08-16.html 2005 07 17.html http://street-majik.utwikd.net/2005-08-28.html http://horoscopefrancais.smhiru.net/2005-08-06.html 2005 09 28.html b242eb585f2503f10c8eb79a53604d31
190.30.132.* 于 2007-05-18 07:30:16发表:
59852d634ba283974bcbb877d797ee2c http://video-porno-guardare-online-gratis.osjckd.org/ http://trucco-pc-gratis-giovanna-d-arco.csapok.org/ http://sentenza-consiglio-stato-determinazione-confini-comunale.vzlvrv.org/ http://boulevard-of-broken-dreams-traduzione.csapok.org/ http://traduttore-automatico-on-line-giapponese-gratis.shqsxs.org/ http://crescita-economica-uso-indiscriminato-risorsa.nofnhx.org/ http://maschera-faccia-percezione-fisionomia-vita-arte.csapok.org/ http://gas-materia-prima-produzione-idrogeno.osjckd.org/ http://giocare-online-the-sims-2.shqsxs.org/ http://ospiti-zecchino-d-oro-2006-2007.osjckd.org/ af5e5529e610c2f14667e2377e4b1e8c
84.121.145.* 于 2007-05-16 22:00:11发表:
116ba8c543d7737c68af9054ba3857ce http://meglio-turbo-benzina-o-diesel.znuawz.biz/ http://confronto-bmw-x3-toyota-rav-4.hfnghd.biz/ http://ospedale-oncologico-mater-dei-bari.znuawz.biz/ http://struttura-sistema-competitivo-modello-concorrenza-allargata.znuawz.name/ http://monumento-funebre-clemente-xiv-canova.hfnghd.name/ http://universita-la-sapienza-scienza-politica.hfnghd.name/ http://indicizzazione-posizionamento-neo-motore-ricerca.hfnghd.co.in/ http://calendario-max-giorgia-palmas-2006.znuawz.biz/ http://graduatoria-dei-disabile-collocamento-napoli.hfnghd.co.in/ http://computer-acer-aspire-modelli-vecchio.znuawz.net/ c5b410f967c066628d7832ce0ac5b28e
81.172.19.* 于 2007-05-16 07:02:52发表:
e732e8072b5ba34a1e7b56e5908e4888 http://lampa-bottone.hzqpsj.com/ http://nomos-pascolare.fflnuc.biz/ http://edvige-fenech-jpg.hzqpsj.com/ http://fitzroy-lanciano-festa-istituto-scientifico.fflnuc.name/ http://cassa-rurale-ed-artigiana-di-binasco.fflnuc.co.in/ http://atinom-it-orario-index-asp.hzqpsj.com/ http://ricetta-potage-pisello.hzqpsj.com/ http://lapin-stampato.fflnuc.name/ http://discoteca-eclisse-marsala-it.fflnuc.co.in/ http://blocco-cad-facciata-ventilata.hzqpsj.com/ e1c77cc030a7259f186177a086fb8a83
201.211.1.* 于 2007-05-14 22:57:56发表:
26cfffae9bfc910bb0545e36b0002046 http://case-in-legno-in-romania.xjpled.co.in/ http://l-agenzia-di-viaggio-bti.nvdset.net/ http://telefonino-sagem-my-c5-2v.nvdset.biz/ http://ciao-scrivo-ormai-tutto-tace.nvdset.net/ http://fibra-tessile-peso-specifico-fibra-metallica.nvdset.net/ http://telefono-cellulare-samsung-ultra-video-f500.xjpled.co.in/ http://amore-peccaminoso-bacio-ultimo-blog.xjpled.biz/ http://didattica-per-le-scuola-materne.nvdset.name/ http://aliquota-d-imposta-assicurazione-trasporto.nvdset.biz/ http://non-vi-e-virtu-cosi-grande.xjpled.name/ 8115d97afce6272748d3203e407b2c31
84.122.123.* 于 2007-05-13 22:48:45发表:
47eb72fc5e68db6e5db28d5f7c87ba34 http://cerco-video-porno-gratis-da-vedere.ctvbxm.biz/ http://prenotazione-hotel-villa-sant-angelo.obuvie.co.in/ http://centro-per-l-impiego-puglia.obuvie.name/ http://neri-per-caso-le-ragazze.ctvbxm.biz/ http://immagini-sulla-lavorazione-della-carta.obuvie.biz/ http://come-si-costruisce-una-bomba.ctvbxm.com/ http://casa-riposo-anziano-comune-abbiategrasso.ctvbxm.net/ http://al-di-la-dei-sogni.obuvie.name/ http://galleria-di-immagini-sesso-gratuite.ctvbxm.net/ http://the-producers-una-gaia-commedia-neonazista.obuvie.co.in/ a647f0935ac9b246ffd2471206f1cc7e
201.239.242.* 于 2007-05-13 10:35:50发表:
6249494a8fcffda369b1fd66283e1131 http://gazzetta-ufficiale-15-11-2006.klkhba.co.in/ http://driver-modem-pirelli-discus-netgate.ujttwc.net/ http://italiano-mondo-sergio-de-gregorio.klkhba.biz/ http://pagamento-on-line-bonifico-bancario.ujttwc.net/ http://carta-collezione-yu-gi-oh.ujttwc.biz/ http://documento-valutazione-dei-rischi-dvr-consip.ujttwc.biz/ http://trasporto-conto-proprio-conto-terzi.ujttwc.biz/ http://manifestazione-partecipato-rtl-102-5.klkhba.name/ http://trucco-gta-liberty-city-stoies.klkhba.biz/ http://obbligo-certificato-medico-allergia-alimentare-scuola.ujttwc.net/ 784faf42bbc6bc8e3eef9ef627ced6bc
72.140.119.* 于 2007-05-12 18:46:34发表:
51589f8f0ec67cdb1cd70dfedc1e5feb http://due-parti-di-idrogeno-per-una.aqnfrs.net/ http://can-you-imagine-forever-young-testo.uqqaqa.info/ http://collegio-t-s-r-m-lazio.tpuskc.info/ http://commento-secondo-canto-divina-commedia.sjuvcf.net/ http://borsa-pronto-canon-eos-400d.uqqaqa.info/ http://programma-per-creare-codici-fiscali.ycfrzc.net/ http://bella-bionda-occhiale-culo-divisa.sjuvcf.info/ http://stadio-giuseppe-meazza-di-san-siro.jnonib.net/ http://numero-escono-frequenti-ruota-roma.jnonib.net/ http://manga-cartone-animato-immagine-download.uwvdff.info/ d9a31e90dfa815b241581cfa56f7d9b0
85.155.37.* 于 2007-05-12 04:18:26发表:
2326a53d7632ce2d5d27cf59b7c94c6f http://sospensione-dal-lavoro-e-dalla-retribuzione.wvnhzs.info/ http://ditta-comunale-roma-manutenzione-caldaia.lvrsgc.net/ http://harry-potter-ordine-fenice-news.xhzpsl.info/ http://giochi-java-gratis-per-samsung.unhbej.net/ http://assicurazione-auto-telefonica-friuli-venezia-giulia.lvrsgc.net/ http://film-fratello-sole-e-sorella-luna.ycfrzc.info/ http://teoria-inquisizione-spagnola-regno-sicilia.uwvdff.net/ http://si-scrive-biglietto-augurio-natale.wxkbfx.info/ http://barche-a-vela-in-sicilia.ycfrzc.info/ http://patch-aggiornamento-championship-manager-03-04.ycfrzc.info/ e851160535cf163ca98e2cabd77393d9
84.127.211.* 于 2007-05-10 14:39:38发表:
ef1ed136dde8c50631f3d00feebd5060 http://epson-lettore-diapo-perfection-1250.cbcmld.net/ http://opposizione-cartella-esattoriale-avviso-mora.sjuvcf.net/ http://memory-card-multimedia-card-lettore.cbcmld.net/ http://masterizzare-dvd-computer-scaricare-disco-gratis.uqqaqa.info/ http://permessi-di-soggiorno-come-lavoratore-autonomo.unhbej.info/ http://legge-regione-toscana-n-20-2006.sjrmzh.info/ http://it-www-turismo-lombardia-it.uwvdff.info/ http://canto-2-guerra-mp3-inglese.sjuvcf.net/ http://site-www-donneinviaggio-com-elena-vaccarino.ycfrzc.net/ http://sfondo-windows-xp-computer-gratis.rfqhyn.net/ 6ea61d011241fc97c6cd95e85f270196
190.39.45.* 于 2007-05-09 04:50:07发表:
2e235f7ae7111a7a49ddbaa79dfd4fd3 http://titolo-dottore-o-dottore-magistrale.tpuskc.net/ http://sito-esaurito-giuseppe-castiglia-it.qncqss.net/ http://cara-mia-ex-articolo-31.cbcmld.info/ http://contraddittorio-metodo-ricerca-verita-processo-penale.wpktse.net/ http://marquez-si-congeda-un-genio.esitxq.info/ http://circolare-17-febbraio-2006-n-8.fneces.net/ http://consorzio-nord-est-societa-cooperativa-azione.xhzpsl.net/ http://foto-troia-nuda-al-mare.bhjrbx.info/ http://auto-intestate-moglie-separazione-corso.aqnfrs.info/ http://convertitore-da-wmv-a-mpg.bhjrbx.info/ c30356c496a34fc36d31054e2275bbe2
190.73.228.* 于 2007-05-08 18:11:48发表:
23e902b0f00fdf4e5cccbd21b3aa0a68 http://negozio-online-pagamento-30-giorno.owlybp.info/ http://mancato-uso-riscaldamento-centralizzato-spese.lvrsgc.info/ http://facolta-di-psicologia-a-bari.drlrmm.net/ http://causale-versamento-bonifico-legge-449-1997.oovbhv.info/ http://astrologia-tema-natale-punto-morte.kpcmsw.info/ http://fotografo-campagna-stampa-quotidiano-periodico-bmw.kpcmsw.info/ http://giulia-ponsi-del-grande-fratello.uqqaqa.net/ http://caesar-iv-on-line-originale.johlma.info/ http://ristorante-gourmet-bergamo-citta-alta.nxlnkr.info/ http://configurare-modem-router-adsl-michelangelo-wave.wsgcxb.net/ ad9883469ac620e72a2c30c2417cb4d3
24.139.142.* 于 2007-05-08 04:19:28发表:
9b7a333862e123764599b85939475aac http://manuale-istruzione-canon-ixus-900.avborz.info/ http://rinnovo-patente-guida-cat-b.fneces.net/ http://url-http-radio-rai-puntare-info.aphvga.info/ http://che-cosa-e-il-protocollo.fneces.net/ http://composizione-chimica-ottoni-al-manganese.wpktse.net/ http://sito-internet-gratis-video-scopata-amatoriale.zqxhac.net/ http://visita-medico-legale-sospensione-patente.esitxq.info/ http://san-francisco-vivanda-porta-via.xhzpsl.net/ http://agente-termini-preavviso-codice-contratto.fneces.net/ http://rita-calderoni-nuda-film-delirio-caldo.qncqss.net/ 26ebd8669f82ff2d680fe0e97ba7427c
190.38.157.* 于 2007-04-17 20:33:48发表:
http://3c4d12d1ec924f118f634a2eccdf0bdb-t.ghoiou0.info 3c4d12d1ec924f118f634a2eccdf0bdb http://3c4d12d1ec924f118f634a2eccdf0bdb-b1.ghoiou0.info 3c4d12d1ec924f118f634a2eccdf0bdb http://3c4d12d1ec924f118f634a2eccdf0bdb-b3.ghoiou0.info 196c3da0ce3e9a23267e7eab02ad2b11
222.40.161.* 于 2006-07-22 18:52:45发表:
太过分了,这是少爷我写的,你竟然吧作者写成你,真过分