[新手教程]ORACLE11g单机服务端部署—详细篇

跟着风哥学习的oracle，单独搭建的虚拟机环境进行的实操部署，以下为实际操作步骤。

（一）搭建要求

操作系统：Oracle Linux 7.6 x86_64
数据库版本：Oracle11g版本
创建数据库：itpuxdb
字符集：ZHS16GBK
数据块大小：8k

（二）配置hosts文件

hosts echo "10.127.1.51 tdxs51">> /etc/hosts

（三）关闭防火墙

systemctl stop firewalld.service 
systemctl disable firewalld.service

（四）创建用户,组,目录,权限

groupadd dba
useradd oracle
passwd oracle
mkdir -p /oracle/app/oracle
chown -R oracle:dba /oracle
chmod -R 775 /oracle

（五）配置本地yum源

mkdir /mnt/linux
mount /dev/cdrom /mnt/linux
cd /etc/yum.repos.d
mkdir bk
mv *.repo bk/
echo "[EL]" >> /etc/yum.repos.d/itpux.repo
echo "name =Linux 7.x DVD" >> /etc/yum.repos.d/itpux.repo
echo "baseurl=file:///mnt/linux" >> /etc/yum.repos.d/itpux.repo
echo "gpgcheck=0" >> /etc/yum.repos.d/itpux.repo
echo "enabled=1" >> /etc/yum.repos.d/itpux.repo
cat /etc/yum.repos.d/itpux.repo

（六）配置oracle依赖包

yum -y install binutils-2.17.50.0.6
yum -y install compat-libstdc++-33-3.2.3
yum -y install elfutils-libelf-0.125
yum -y install elfutils-libelf-devel-0.125
yum -y install elfutils-libelf-devel-static-0.125
yum -y install gcc-4.1.2
yum -y install gcc-c++-4.1.2
yum -y install glibc-2.5-24
yum -y install glibc-common-2.5
yum -y install glibc-devel-2.5
yum -y install glibc-headers-2.5
yum -y install kernel-headers-2.6.18
yum -y install ksh-20060214
yum -y install libaio-0.3.106
yum -y install libaio-devel-0.3.106
yum -y install libgcc-4.1.2
yum -y install libgomp-4.1.2
yum -y install libstdc++-4.1.2
yum -y install libstdc++-devel-4.1.2
yum -y install make-3.81
yum -y install sysstat-7.0.2
yum -y install unixODBC-2.2.11
yum -y install unixODBC-devel-2.2.11
yum -y install binutils-2.17.50.0.6
yum -y install compat-libstdc++-33-3.2.3
yum -y install elfutils-libelf-0.125
yum -y install elfutils-libelf-devel-0.125
yum -y install elfutils-libelf-devel-static-0.125
yum -y install gcc-4.1.2
yum -y install gcc-c++-4.1.2
yum -y install glibc-2.5-24
yum -y install glibc-common-2.5
yum -y install glibc-devel-2.5
yum -y install glibc-headers-2.5
yum -y install kernel-headers-2.6.18
yum -y install ksh-20060214
yum -y install libaio-0.3.106
yum -y install libaio-devel-0.3.106
yum -y install libgcc-4.1.2
yum -y install libgomp-4.1.2
yum -y install libstdc++-4.1.2
yum -y install libstdc++-devel-4.1.2
yum -y install make-3.81
yum -y install sysstat-7.0.2
yum -y install unixODBC-2.2.11
yum -y install unixODBC-devel-2.2.11

（七）配置环境变量

su - oracle

echo "export LANG=en_US" >> ~/.bash_profile
echo "export ORACLE_BASE=/oracle/app/oracle" >> ~/.bash_profile
echo "export ORACLE_HOME=/oracle/app/oracle/product/11.2.0/db_1" >> ~/.bash_profile
echo "export ORACLE_UNQNAME=itpuxdb" >> ~/.bash_profile
echo "export ORACLE_SID=itpuxdb" >> ~/.bash_profile
echo "NLS_LANG=AMERICAN_AMERICA.ZHS16GBK;export NLS_LANG" >> ~/.bash_profile
echo "export PATH=$PATH:/oracle/app/oracle/product/11.2.0/db_1/bin" >> ~/.bash_profile

source ~/.bash_profile

解压安装包 su - oracle

cd /oracle

unzip /mnt/hgfs/soft/linux.x64_11gR2_database_1of2.zip
unzip /mnt/hgfs/soft/linux.x64_11gR2_database_2of2.zip

cd database

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

出现报错 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

进入vi编辑器后 命令模式输入/NMECTL 进行查找，快速定位要修改的行 在后面追加参数-lnnz11

$(SYSMANBIN)emdctl:
$(MK_EMAGENT_NMECTL) -lnnz11

保存退出后Retry

（八）Oracle数据库关闭

sqlplus “/as sysdba”
shutdown immediate;
exit;
lsnrctl stop

（九）Oracle数据库启动

sqlplus “/as sysdba”
startup;
exit;
lsnrctl start

（十）数据库安装完成后续操作

数据库日志路径

select * from v$diag_info;

Oracle数据库登录

sqlplus “/as sysdba”

Oracle表空间创建

create tablespace tdxs datafile '/oracle/app/oracle/oradata/itpuxdb/tdxs01.dbf' size 10m;

Oracle用户创建

create user tdxs identified by tdxs default tablespace tdxs; grant dba to tdxs;

Oracle表创建

conn tdxs/tdxs;
create table itpuxt1(id number(12) primary key, name varchar(20)) ;

Oracle数据插入

insert into itpuxt1 values(1,'tdxs01');
insert into itpuxt1 values(2,'tdxs02');
commit;

Oracle数据查询

select * from itpuxt1;

另外微信小程序对接wordpress已经上线，可通过下图扫一扫进行微信小程序浏览，也可以通过微信搜一搜输入“提灯宝箱”找到我的小程序，如果喜欢，可以和大家分享制作过程。