CentOS 6.0下安装Oracle 11g
一.安装环境: OS:Linux x86 CentOS 6.0DB:Oracle11g R1NETWORK:LAN 二.具体安装步骤 1、检查必备的包使用rpm –q lt;包名gt;来
一.安装环境:
OS:Linux x86 CentOS 6.0
DB:Oracle11g R1
NETWORK:LAN
二.具体安装步骤
1、检查必备的包
使用rpm –q 来查看下列包是否已经安装,以及版本是否符合。
binutils-2.17.50.0.6-2.el5
compat-libstdc++-33-3.2.3-61
elfutils-libelf-0.125-3.el5
elfutils-libelf-devel-0.125
gcc-4.1.1-52
gcc-c++-4.1.1-52
glibc-2.5-12
glibc-common-2.5-12
glibc-devel-2.5-12
glibc-headers-2.5-12
libaio-0.3.106
libaio-devel-0.3.106
libgcc-4.1.1-52
libstdc++-4.1.1
libstdc++-devel-4.1.1-52.e15
make-3.81-1.1
numactl-devel-0.9.8.i386
sysstat-7.0.0
unixODBC-2.2.11
unixODBC-devel-2.2.11
2、添加组和用户,并创建安装目录
groupadd oinstall
groupadd dba
useradd –g oinstall –G dba oracle
passwd oracle
mkdir -p /u01/app/oracle
chown –R oracle:oinstall /u01/
3、编辑内核参数
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 = 1024 65000
net.core.rmem_default = 4194304
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048586
shmmax 最大共享内存,,如果机子有2G内存的话可以设置为2147483648。
执行下面命令使内核参数生效:
/sbin/sysctl –p
4、设置oracle用户的shell limit
vi /etc/security/limits.conf
添加以下内容
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
5、编辑登陆配置文件
vi /etc/pam.d/login
添加下面的语句
session required pam_limits.so或者是
session required /lib/security/pam_limits.so
6、配置IP地址
vi /etc/sysconfig/network-scripts/ifcfg-eth0
内容如下:
DEVICE=”eth0”
NM_CONTROLLED=”yes”
ONBOOT=”yes”
TYPE=Ethernet
BOOTPROTO=static
IPADDR=192.168.1.12
NETWORK=255.255.255.0
GATEWAY=192.168.1.1
PREFIX=24
DEFROUTE=yes
IPV4_FAILURE_FATAL=yes
IPV6INIT=no
NAME=”System eth0”
UUID=5fb06bd0-0bb0-7ffb-45f1-d6edd65f3e03
HWADDR=00:0C:29:F8:C7:79:
7、修改/etc/hosts文件
vi /etc/hosts
添加如下格式的内容
127.0.0.1 hostname localhost
其中hostname可以通过hostname命令查询获得
8、设置环境变量
编辑oracle主目录下的.bash_profile
添加以下内容:
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.1.0/db_1
export ORACLE_SID=orcl
export PATH=$PATH:$ORACLE_HOME/bin
9、执行安装
执行安装要使用oracle用户,不是su – oracle,而是在登录页面使用oracle用户登录
如果遇到乱码可以使用LANG=us_EN.utf-8临时改变系统字符环境。

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

This article explores optimizing MySQL memory usage in Docker. It discusses monitoring techniques (Docker stats, Performance Schema, external tools) and configuration strategies. These include Docker memory limits, swapping, and cgroups, alongside

This article addresses MySQL's "unable to open shared library" error. The issue stems from MySQL's inability to locate necessary shared libraries (.so/.dll files). Solutions involve verifying library installation via the system's package m

The article discusses using MySQL's ALTER TABLE statement to modify tables, including adding/dropping columns, renaming tables/columns, and changing column data types.

This article compares installing MySQL on Linux directly versus using Podman containers, with/without phpMyAdmin. It details installation steps for each method, emphasizing Podman's advantages in isolation, portability, and reproducibility, but also

This article provides a comprehensive overview of SQLite, a self-contained, serverless relational database. It details SQLite's advantages (simplicity, portability, ease of use) and disadvantages (concurrency limitations, scalability challenges). C

This guide demonstrates installing and managing multiple MySQL versions on macOS using Homebrew. It emphasizes using Homebrew to isolate installations, preventing conflicts. The article details installation, starting/stopping services, and best pra

Article discusses configuring SSL/TLS encryption for MySQL, including certificate generation and verification. Main issue is using self-signed certificates' security implications.[Character count: 159]

Article discusses popular MySQL GUI tools like MySQL Workbench and phpMyAdmin, comparing their features and suitability for beginners and advanced users.[159 characters]
