SUSE11 SP2下Oracle 11g安装指南-Mysql Tutorial-php.cn

Home

Database

Mysql Tutorial

SUSE11 SP2下Oracle 11g安装指南

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 07, 2016 pm 05:30 PM

参考文档 (1) SUSE 官方安装文档：Oracle database on SLES11 SP2 (PDF) (2) Oracle Online Book：Database Quick Installation

参考文档

(1) SUSE 官方安装文档：Oracle database on SLES11 SP2 (PDF)

(2) Oracle Online Book：Database Quick Installation Guide for Linux x86-64

免费下载地址在（说明：此地址不是FTP，直接点击打开，输入用户名与密码）

用户名与密码都是

具体下载目录在 /2013年资料/7月/7日/SUSE11 SP2下Oracle 11g安装指南

-------------------------------------分割线-------------------------------------

1. 安装操作系统

2. 检查软件包

（1）检查是否缺少需要的软件包

rpm -q binutils \
gcc \
gcc-32bit \
gcc-c++ \
glibc \
glibc-devel \
ksh \
libaio \
libaio-devel \
libstdc++33 \
libstdc++46 \
libstdc++43-devel \
libgcc46 \
libstdc++-devel \
make \
sysstat | grep "not installed"

（2）挂载第一张操作系统光盘，安装缺少的软件包

mount /dev/scd0 /media
rpm -ivh /media/suse/x86_64/sysstat-8.1.5-7.32.1.x86_64.rpm

3. 创建ORACLE用户

groupadd oinstall
groupadd dba
groupadd oper
useradd -m -g oinstall -G dba,oper oracle

4. 修改Oracle用户资源限额

编辑/etc/security/limits.conf文件，在文件的最后追加如下内容：

oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft stack 10240
oracle hard stack 32768

编辑/etc/sysctl.conf文件，在文件最后追加如下内容：

fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 2147483648
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

重启网络使网络配置参数生效

service network restart

输入如下命令使参数在服务器重启后也生效

chkconfig boot.sysctl on

1 软件包检查
在SUSE 11上需要以下的软件包
说明：
在Oracle 11.2.0.2以前，所有的软件包均需安装64位版本和32位版本。
在Oracle 11.2.0.2以后，，除了gcc-32bit以外，其余软件包只需安装64位的版本。

rpm -q binutils \
gcc \
gcc-32bit \
gcc-c++ \
glibc \
glibc-devel \
ksh \
libaio \
libaio-devel \
libstdc++33 \
libstdc++46 \
libstdc++43-devel \
libgcc46 \
libstdc++-devel \
make \
sysstat

2 创建oracle用户
groupadd oinstall
groupadd dba
groupadd oper
useradd -m -g oinstall -G dba,oper oracle

相关阅读：Oracle 11g在SUSE 11上的安装

linux

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

How do you alter a table in MySQL using the ALTER TABLE statement?Mar 19, 2025 pm 03:51 PM

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

How do I configure SSL/TLS encryption for MySQL connections?Mar 18, 2025 pm 12:01 PM

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]

How do you handle large datasets in MySQL?Mar 21, 2025 pm 12:15 PM

Article discusses strategies for handling large datasets in MySQL, including partitioning, sharding, indexing, and query optimization.

What are some popular MySQL GUI tools (e.g., MySQL Workbench, phpMyAdmin)?Mar 21, 2025 pm 06:28 PM

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

How do you drop a table in MySQL using the DROP TABLE statement?Mar 19, 2025 pm 03:52 PM

The article discusses dropping tables in MySQL using the DROP TABLE statement, emphasizing precautions and risks. It highlights that the action is irreversible without backups, detailing recovery methods and potential production environment hazards.

How do you represent relationships using foreign keys?Mar 19, 2025 pm 03:48 PM

Article discusses using foreign keys to represent relationships in databases, focusing on best practices, data integrity, and common pitfalls to avoid.

How do you create indexes on JSON columns?Mar 21, 2025 pm 12:13 PM

The article discusses creating indexes on JSON columns in various databases like PostgreSQL, MySQL, and MongoDB to enhance query performance. It explains the syntax and benefits of indexing specific JSON paths, and lists supported database systems.

How do I secure MySQL against common vulnerabilities (SQL injection, brute-force attacks)?Mar 18, 2025 pm 12:00 PM

Article discusses securing MySQL against SQL injection and brute-force attacks using prepared statements, input validation, and strong password policies.(159 characters)

See all articles