建站
咨詢
售后
建站咨詢
新聞中心
這里有您想知道的互聯(lián)網(wǎng)營(yíng)銷解決方案
Redhat5安裝oracle10g啟動(dòng)測(cè)試-創(chuàng)新互聯(lián)
安裝環(huán)境： redhat5.5 VirtualBox4.3.12 oracle10g
在虛擬機(jī)環(huán)境下，直接安裝的是帶圖形界面redhat5.5-server，便于后來(lái)方面安裝oracle
一 安裝部分
1. 安裝前的包檢查
采用iso光盤掛載作為 yum源安裝
[rhel-server] name=local server baseurl=file:///mnt/cdrom/Server //掛載光盤文件為yum源 enabled=1 gpgcheck=0 gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-redhat-release安裝如下的包，注意版本號(hào)和包依賴
binutils-2* elfutils-libelf-0* elfutils-libelf-devel-0* elfutils-libelf-devel-static-0* setarch-2* make-3* glibc-2* glibc-devel-2* glibc-common-2* glibc-header-* libaio-0* libaio-devel-0* compat-libstdc++-33-3* kernel-headers-* ksh-* compat-gcc-34-3* compat-gcc-34-c++-3* libgcc-4* libstdc++-4* libstdc++-devel-4* libgomp-4* gcc-4* gcc-c++-4* libXp-1* libXt openmotif22-* compat-db-4* sysstat-7* unixODBC-2* unixODBC-devel-2* rpm -q binutils elfutils-libelf elfutils-libelf-devel elfutils-libelf-devel-static setarch make glibc glibc-devel glibc-common glibc-headers libaio libaio-devel compat-libstdc++-33 kernel-headers ksh compat-gcc-34 compat-gcc-34-c++ libgcc libstdc++ libstdc++-devel libgomp gcc gcc-c++ libXp libXt openmotif compat-db sysstat unixODBC unixODBC-devel2.修改系統(tǒng)參數(shù)
內(nèi)核參數(shù) /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.rmem_max=262144 net.core.wmem_default=262144 net.core.wmem_max=262144sysctl -p 使參數(shù)生效
關(guān)閉seLinux /etc/selinux/config
SELINUX=disabled設(shè)置oracle用戶的shell limit /etc/security/limits.conf
oracle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 1024 oracle hard nofile 65536oracle10g 只支持到了redhat-4， 修改/etc/redhat-release
redhat-43. 創(chuàng)建Oracle用戶組 及目錄
groupadd -g 500 dba groupadd -g 501 oinstall useradd -g oinstall -G dba -s /bin/bash -u 501 oracle passwd oracle mkdir -p /oracle/app/oracle/product/10.2/db_1 chown -R oracle:oinstall /oracle chmod -R 775 /oracle4. 修改oracle用戶 .bash_profile
export ORACLE_BASE=/oracle/app/oracle export ORACLE_HOME=$ORACLE_BASE/product/10.2/db_1 export ORACLE_SID=bi4db export PATH=$PATH:$ORACLE_HOME/bin export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib export CLASSPATH5.解壓安裝
unzip 10201_database_linux64.zip ./runInstaller // 遇到?jīng)]有執(zhí)行權(quán)限文件 chmod +x xxx
二、進(jìn)程啟動(dòng)
1.oracle監(jiān)聽(tīng)器listener
lsnrctl start lsnrctl stop /oracle/app/oracle/product/10.2/db_1/bin/tnslsnr LISTENER -inherit2.oracle OEM啟動(dòng)
emctl start dbconsole emctl stop dbconsole http://192.168.30.6:1158/em sys/pwd sysdba登陸3.isql*plus的啟動(dòng)
isqlplusctl start isqlplusctl stop4. 數(shù)據(jù)庫(kù)啟動(dòng)停止
[oracle@dbtest 10201_database_linux64]$ sqlplus SQL*Plus: Release 10.2.0.1.0 - Production on Thu Jun 26 14:54:36 2014 Copyright (c) 1982, 2005, Oracle. All rights reserved. Enter user-name: / as sysdba Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production With the Partitioning, OLAP and Data Mining options SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup ORACLE instance started. Total System Global Area 444596224 bytes Fixed Size 2021408 bytes Variable Size 138414048 bytes Database Buffers 297795584 bytes Redo Buffers 6365184 bytes Database mounted. Database opened. SQL>三、測(cè)試scott/tiger
解鎖scott用戶，登陸測(cè)試
SQL> conn scott; Enter password: ERROR: ORA-28000: the account is locked SQL> conn system; Enter password: Connected. SQL> SQL> alter user scott account unlock; User altered. SQL> show user; USER is "SCOTT"另外有需要云服務(wù)器可以了解下創(chuàng)新互聯(lián)cdcxhl.cn，海內(nèi)外云服務(wù)器15元起步，三天無(wú)理由+7*72小時(shí)售后在線，公司持有idc許可證，提供“云服務(wù)器、裸金屬服務(wù)器、高防服務(wù)器、香港服務(wù)器、美國(guó)服務(wù)器、虛擬主機(jī)、免備案服務(wù)器”等云主機(jī)租用服務(wù)以及企業(yè)上云的綜合解決方案，具有“安全穩(wěn)定、簡(jiǎn)單易用、服務(wù)可用性高、性價(jià)比高”等特點(diǎn)與優(yōu)勢(shì)，專為企業(yè)上云打造定制，能夠滿足用戶豐富、多元化的應(yīng)用場(chǎng)景需求。
網(wǎng)頁(yè)標(biāo)題：Redhat5安裝oracle10g啟動(dòng)測(cè)試-創(chuàng)新互聯(lián)
分享鏈接：http://www.dlmjj.cn/article/deddes.html
