oracle-xe-11.2.0-1.0安装使用¶
1. 虚拟机配置信息¶
192.168.178.151:1核1G
2. 创建快照¶
#打开虚拟机时,一定要创建一个快照,以防万一!!!
3. 关闭防火墙¶
getenforce
set enforce 0
iptables -L
iptables -F
4. 安装依赖环境¶
yum install libaio libaio-devel bc man net-tools -y
5. 创建swap文件¶
#(必须大于2G,否则rpm包安装报错!)
dd if=/dev/zero of=/swapfile bs=1024 count=2512000
mkswap /swapfile
free -m
swapon /swapfile
chown root:root /swapfile
chmod 0600 /swapfile
free -m
#配置开机自动挂载swap分区
cp /etc/fstab /etc/fstab.backup_$(date +%N)
echo '/swapfile swap swap defaults 0 0' >> /etc/fstab
swapon -a
swapon -s
6. 创建目录,上传安装包¶
mkdir /server/tools -p
cd /server/tools/
#这里要上传11gxe安装包!!!
ls
7. 解压缩安装包¶
unzip oracle-xe-11.2.0-1.0.x86_64.rpm.zip
8. 安装oracle-xe的rpm包¶
cd Disk1/
ls
rpm -ivh oracle-xe-11.2.0-1.0.x86_64.rpm
9. 配置oracle-xe,设置密码123¶
/etc/init.d/oracle-xe configure #大概1分钟左右
10. 添加环境变量¶
vim /etc/profile
#添加如下信息
# Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/xe; export ORACLE_HOME
ORACLE_SID=XE; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH
TNS_ADMIN=$ORACLE_HOME/network/admin
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi
source /etc/profile
echo $ORACLE_BASE
11. 登录测试¶
id oracle
su - oracle
sqlplus system/123
#执行如下命令查看运行状态
desc v$database;
select open_mode from v$database;
exit
#1.问题:登录时,报错ulimit
[root@151 ~]# su - oracle
Last login: Sun May 23 08:53:23 CST 2021 on pts/0
-bash: ulimit: max user processes: cannot modify limit: Operation not permitted
-bash-4.2$
-bash-4.2$ exit
logout
[root@151 ~]#
[root@151 ~]#
#2.解决办法:修改limits配置文件
[root@151 ~]# vim /etc/security/limits.conf
#添加如下内容即可
[root@151 ~]# tail -5 /etc/security/limits.conf
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
#3.再次登录测试,发现报错消失了!
[root@151 ~]# su - oracle
Last login: Sun May 23 09:15:30 CST 2021 on pts/0
-bash-4.2$
12. 查看运行端口¶
netstat -tunlp|grep 1521
ps -ef|grep smon
13. 再次创建快照¶
#再次创建快照,命名为“安装完oracle11gxe”,以防数据库损坏,不会修复!!!
14.有空尝试将以上步骤写成一个脚本文件,一键安装?¶
原始的安装步骤(略)¶
#0.虚拟机配置信息
192.168.178.151:1核1G
#0.1 打开虚拟机,创建快照
#0.2 关闭防火墙
getenforce
iptables -L
#1.创建目录,上传安装包
mkdir /server/tools -p
cd /server/tools/
ls
#2.解压缩安装包
unzip oracle-xe-11.2.0-1.0.x86_64.rpm.zip
#3.安装依赖环境
yum install libaio libaio-devel bc man net-tools -y
#4.创建swap文件(必须大于2G,否则rpm包安装报错!)
dd if=/dev/zero of=/swapfile bs=1024 count=2512000
mkswap /swapfile
free -m
swapon /swapfile
free -m
#配置开机自动挂载swap分区
cp /etc/fstab /etc/fstab.backup_$(date +%N)
echo '/swapfile swap swap defaults 0 0' >> /etc/fstab
chown root:root /swapfile
chmod 0600 /swapfile
swapon -a
swapon -s
#5.安装oracle-xe
cd Disk1/
ls
rpm -ivh oracle-xe-11.2.0-1.0.x86_64.rpm
#6.配置oracle-xe,密码设置123
/etc/init.d/oracle-xe configure
#6.添加环境变量
vim /etc/profile
# Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/xe; export ORACLE_HOME
ORACLE_SID=XE; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH
TNS_ADMIN=$ORACLE_HOME/network/admin
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi
source /etc/profile
echo $ORACLE_BASE
#7.登录测试
id oracle
su - oracle
sqlplus system/123
#8.查看运行端口(为何没有8080?如何开启网页支持?)
netstat -tunlp|grep 1521
最后更新:
2022-02-20 08:44:07