跟着风哥学习的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已经上线,可通过下图扫一扫进行微信小程序浏览,也可以通过微信搜一搜输入“提灯宝箱”找到我的小程序,如果喜欢,可以和大家分享制作过程。
继续阅读
评论