Oracle安装采坑记录

Oracle安装记录

数据库课程要安装oracle，记录一下

遇到的问题

先跟着指导书走，注意路径

CentOS 6设置中文

su - root

vi /etc/sysconfig/i18n

更改为

#LANG="en_US.UTF-8"
LANG="zh_CN.UTF-8"

保存重启

检查并安装依赖包

用yum直接安装省的解压光驱的package

rpm -qa | grep binutils
rpm -qa | grep compat-libstdc++
rpm -qa | grep elfutils-libelf-devel
rpm -qa | grep elfutils-libelf
rpm -qa | grep elfutils-libelf-devel-static
rpm -qa | grep gcc
rpm -qa | grep gcc-c++
rpm -qa | grep glibc
rpm -qa | grep glibc-common
rpm -qa | grep glibc-devel
rpm -qa | grep glibc-headers
rpm -qa | grep kernel-headers
rpm -qa | grep ksh
rpm -qa | grep libaio
rpm -qa | grep libaio-devel
rpm -qa | grep libgcc
rpm -qa | grep libgomp
rpm -qa | grep libstdc++
rpm -qa | grep libstdc++-devel
rpm -qa | grep make
rpm -qa | grep numactl-devel
rpm -qa | grep sysstat
rpm -qa | grep unixODBC
rpm -qa | grep unixODBC-devel

yum install -y 所需包名

直接执行这个可以把缺的直接安装完

yum install -y compat-libstdc++-33 elfutils-libelf-devel gcc gcc-c++ glibc-devel
yum install -y ksh libaio-devel numactl-devel
yum install -y unixODBC unixODBC-devel oracleasm oracleasmlib oracleasm-support

安装界面乱码

设置

 export LANG=en-US

Check有问题

按照修复提示执行脚本即可，点击忽略继续

主机ping不通虚拟机

关掉虚拟机防火墙，然后重启解决，还不行就禁用一下vmnet8，然后开启刷新下

service iptables stop
chkconfig iptables off
reboot

加sudo权限

显然切换su很麻烦，加个sudo权限

切换到su，更改sudoer

su - root
vi /etc/sudoers

输入/root找到

root     ALL=(ALL)       ALL

在下面添加一行

root     ALL=(ALL)       ALL
oracle ALL=(ALL)       ALL

启动数据库

lsnrctl start
sqlplus /nolog

SQL> conn /as sysdba 
SQL> startup 
SQL> exit