linux 下安装oracle数据库
--linux oracle安装
--在windows下设置网卡信息
设置ip地址 192.168.150.2
--配置linux网卡配置
vim /etc/sysconfig/network-scripts/ifcfg-eth0
DEVICE="eth0"
BOOTPROTO="neno"
HWADDR="00:0C:29:45:3D:55"
NM_CONTROLLED="yes"
ONBOOT="yes"
TYPE="Ethernet"
UUID="43374599-e0fa-4e94-9343-284c10a0e77f"
IPADDR=192.168.150.3
NETMASK=255.255.255.0
需要连接网络时选择桥接模式（网卡Vmnet1选择为自动获取ip），将下面注释项放开，将仅主机模式的配置注释
[root@localhost etc]# cat /etc/sysconfig/network-scripts/ifcfg-eth0 DEVICE=eth0 HWADDR=00:0C:29:F0:C7:1B TYPE=Ethernet UUID=8d32163e-e4c8-4b55-8327-3975c3357bf5 ONBOOT=yes NM_CONTROLLED=yes BOOTPROTO=none IPADDR=192.168.150.6 NETMASK=255.255.255.0 GATEWAY=192.168.150.1 BOOTPROTO=None #BOOTPROTO=static #IPADDR=10.228.18.225 #NETMASK=255.255.252.0 #GATEWAY=10.228.16.1 [root@localhost etc]#
=============
上面时仅主机模式，使用桥接模式时：
BOOTPROTO="static"
IP和子网掩码网关与物理主机保持同步。
=============
--关闭防火墙 selinux等 重启网络服务
service iptables stop
service ip6tables stop
service NetworkManager stop
chkconfig iptables off
chkconfig ip6tables off
chkconfig NetworkManager off
setenforce 0
getenforce --查看
service network restart
--使用xshell连接
--安装oracle数据库
--安装yum
cd /mnt
mkdir /mnt/rhel
cd /etc/yum.repos.d/
rm -rf *
mount /dev/cdrom /mnt/rhel
vi /etc/yum.repos.d/server.repo
[server]
name=yum server
baseurl=file:///mnt/rhel
enabled=1
grpcheck=0
yum repolist
--更新rpm包
rpm -Uvh binutils-*
rpm -Uvh compat-libstdc++-*
rpm -Uvh elfutils-libelf-*
rpm -Uvh elfutils-libelf-devel-*
rpm -Uvh elfutils-libelf-devel-static-*
rpm -Uvh gcc-*
rpm -Uvh gcc-c++-*
rpm -Uvh glibc-*
rpm -Uvh glibc-common-*
rpm -Uvh glibc-devel-*
rpm -Uvh glibc-headers-*
rpm -Uvh kernel-headers-*
rpm -Uvh ksh-*
rpm -Uvh libaio-*
rpm -Uvh libaio-devel-*
rpm -Uvh libgcc-*
rpm -Uvh libgomp-*
rpm -Uvh libstdc++-*
rpm -Uvh libstdc++-devel-*
rpm -Uvh make-*
rpm -Uvh sysstat-*
rpm -Uvh unixODBC-*
rpm -Uvh unixODBC-devel-*
--um安装了旧版本的GPG keys
rpm --import /etc/pki/rpm-gpg/RPM*
--安装rpm依赖包
yum -y install compat-libstdc++* elfutils-libelf-devel* elfutils-libelf-devel-static* gcc-* gcc-c++* libaio-devel* libstdc++-devel* sysstat* unixODBC* unixODBC-devel* libXp* glibc-devel*
--新建目录
mkdir /u01
cd /u01
mkdir software --用sftp上传文件
--上传缺失的依赖包并安装
rpm -ivh pdksh-5.2.14-1.i386.rpm --force --nodeps
--新建用户和组
groupadd oinstall
groupadd dba
useradd -g oinstall -G dba oracle
--在root用户下修改/u01/saftware用户组及权限
chown -R oracle:oinstall software
chmod -R 775 software
--在oracle用户下解压软件
su - oracle
cd /u01/saftware
unzip linux_11gR2_database_1of2.zip
unzip linux_11gR2_database_2of2.zip
--在root下创建家目录根目录
mkdir -p /u01/app/
chown -R oracle:oinstall /u01/app/
chmod -R 775 /u01/app/
--进入oracle用户修改 .bash_profile
vi .bash_profile
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1
export ORACLE_SID=orcl
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
--在root用户下修改内核参数
vi /etc/sysctl.conf
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048586
sysctl -p --使内核参数生效
--修改资源限制
vi /etc/security/limits.conf
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft stack 10240
vi /etc/pam.d/login
session required pam_limits.so
--用oracle用户登陆安装
su - oracle
cd /u01/saftware/database
./runInstaller
--以root身份执行脚本
/u01/app/oraInventory/orainstRoot.sh
/u01/app/oracle/product/11.2/db_1/root.sh
Enterprise Manager Database Control URL - (orcl) :
https://localhost:1158/em
--以oracle用户登陆
su - oracle
sqlplus /nolog
conn scott/tiger
--在oracle用户下启动监听
lsnrctl start
--用plsql连接Oracle
192.168.150.3:1521/orcl
