本安裝適合Linux桌面操作系統(tǒng)

某業(yè)務(wù)系統(tǒng)最近上線，需要搭建一套Oracle11g數(shù)據(jù)庫(kù)環(huán)境，用于前期測(cè)試。

要求：

操作系統(tǒng)：Oracle Linx 7.6 x86_64

數(shù)據(jù)庫(kù)版本：Oracle11g版本

創(chuàng)建數(shù)據(jù)庫(kù)：itpxdb

字符集：ZHS16GBK

數(shù)據(jù)塊大小：8k

可以遠(yuǎn)程連接，并提供給軟件開(kāi)發(fā)人員使用

Oracle11g安裝過(guò)程

配置hosts

echo "192.168.1.51 lewen51">> /etc/hosts

#關(guān)閉防火墻

systemctl stop firewalld.service

systemctl disable firewalld.service

#創(chuàng)建用戶(hù),組,目錄,權(quán)限

gropadd dba

seradd oracle

passwd oracle

mkdir -p /oracle/app/oracle

chown -R oracle:dba /oracle

chmod -R 775 /oracle

配置ym軟件安裝所需包

mkdir /mnt/linx

mont /dev/cdrom /mnt/linx

cd /etc/ym.repos.d

mkdir bk

mv *.repo bk/

echo "[EL]" >> /etc/ym.repos.d/itpx.repo

echo "name =Linx 7.x DVD" >> /etc/ym.repos.d/itpx.repo

echo "baserl=file:///mnt/linx" >> /etc/ym.repos.d/itpx.repo

echo "gpgcheck=0" >> /etc/ym.repos.d/itpx.repo

echo "enabled=1" >> /etc/ym.repos.d/itpx.repo

cat /etc/ym.repos.d/itpx.repo

安裝：oracle所需軟件包安裝.txt

yum -y install autoconf yum -y install automake yum -y install binutils yum -y install binutils-devel yum -y install bison yum -y install cpp yum -y install dos2unix yum -y install ftp yum -y install gcc yum -y install gcc-c++ yum -y install lrzsz yum -y install python-devel yum -y install compat-db* yum -y install compat-gcc-34 yum -y install compat-gcc-34-c++ yum -y install compat-libcap1 yum -y install compat-libstdc++-33 yum -y install compat-libstdc++-33.i686 yum -y install glibc-* yum -y install glibc-*.i686 yum -y install libXpm-*.i686 yum -y install libXp.so.6 yum -y install libXt.so.6 yum -y install libXtst.so.6 yum -y install libXext yum -y install libXext.i686 yum -y install libXtst yum -y install libXtst.i686 yum -y install libX11 yum -y install libX11.i686 yum -y install libXau yum -y install libXau.i686 yum -y install libxcb yum -y install libxcb.i686 yum -y install libXi yum -y install libXi.i686 yum -y install libXtst yum -y install libstdc++-docs yum -y install libgcc_s.so.1 yum -y install libstdc++.i686 yum -y install libstdc++-devel yum -y install libstdc++-devel.i686 yum -y install libaio yum -y install libaio.i686 yum -y install libaio-devel yum -y install libaio-devel.i686 yum -y install ksh yum -y install libXp yum -y install libaio-devel yum -y install numactl yum -y install numactl-devel yum -y install make -y yum -y install sysstat -y yum -y install unixODBC yum -y install unixODBC-devel yum -y install elfutils-libelf-devel yum -y install redhat-lsb-core view

需要單獨(dú)安裝的包

配置環(huán)境變量

s - oracle

echo "export LANG=en_S" >> ~/.bash_profile

echo "export ORACLE_BASE=/oracle/app/oracle" >> ~/.bash_profile

echo "export ORACLE_HOME=/oracle/app/oracle/prodct/11.2.0/db_1" >> ~/.bash_profile

echo "export ORACLE_NQNAME=itpxdb" >> ~/.bash_profile

echo "export ORACLE_SID=itpxdb" >> ~/.bash_profile

echo "NLS_LANG=AMERICAN_AMERICA.ZHS16GBK;export NLS_LANG" >> ~/.bash_profile

echo "export PATH=$PATH:/oracle/app/oracle/prodct/11.2.0/db_1/bin" >> ~/.bash_profile

sorce ~/.bash_profile

解壓安裝包

s - oracle

cd /oracle

nzip /mnt/hgfs/soft/linx.x64_11gR2_database_1of2.zip

nzip /mnt/hgfs/soft/linx.x64_11gR2_database_2of2.zip

cd database

./rnInstaller -jreLoc /etc/alternatives/jre_1.8.0

出現(xiàn)報(bào)錯(cuò) Error in invoking target 'agent nmhs' of makefile

建議修改前備份原始文件

[oracle@ ~]$ cd $ORACLE_HOME/sysman/lib

[oracle@ lib]$ cp ins_emagent.mk ins_emagent.mk.bak

[oracle@ lib]$ vi ins_emagent.mk

進(jìn)入vi編輯器后 命令模式輸入/NMECTL 進(jìn)行查找，快速定位要修改的行

在后面追加參數(shù)-lnnz11

$(SYSMANBIN)emdctl:

$(MK_EMAGENT_NMECTL) -lnnz11

保存退出后Retry

? Oracle數(shù)據(jù)庫(kù)關(guān)閉

sqlpls "/as sysdba"

shtdown immediate;

exit;

lsnrctl stop

? Oracle數(shù)據(jù)庫(kù)啟動(dòng)

sqlpls "/as sysdba"

startp;

exit;

lsnrctl start

數(shù)據(jù)庫(kù)操作

? 日志路徑

select * from v$diag_info;

? Oracle數(shù)據(jù)庫(kù)登錄

sqlpls "/as sysdba"

? Oracle表空間創(chuàng)建

create tablespace lewen datafile '/oracle/app/oracle/oradata/itpxdb/lewen01.dbf' size 10m;

? Oracle用戶(hù)創(chuàng)建

create ser lewen identified by lewen defalt tablespace lewen;

grant dba to lewen;

? Oracle表創(chuàng)建

conn lewen/lewen;

create table test1(id nmber(12) primary key, name varchar(20)) ;

? Oracle數(shù)據(jù)插入

insert into test1 vales(1,'lewen01');

insert into test1 vales(2,'lewen02');

commit;

? Oracle數(shù)據(jù)查詢(xún)

select * from test1;

總結(jié)

以上是生活随笔為你收集整理的05 Linux快速安装 Oracle11g的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問(wèn)題。

如果覺(jué)得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。