在RedHat企业版5.8上安装Oracle 10g 笔记,注意:在redhat 企业版5首行写上ldquo;127.0.0.1 主机名 主机别名rdquo;检查是通不过
注意事项:
Que1:一般而言,在配置内核参数(gedit /etc/sysctl.conf)时,我们只需要修改kernel.shmmax.
1 为物理内存的一半:
物理内存grep MemTotal /proc/meminfo
2 单位是字节。(B)
3 RedHat上建议不要超过4G
4 shmmax内核参数定义单个共享内存段的最大值,如果该参数设置小于Oracle SGA设置,,那么SGA就会被分配多个共享内存段,引发性能下降。为了避免多个共享内存段,我们可以修改shmmax内核参数,使SGA存在于一个共享内存段中。
Que2:在先决性条件检查时,有且仅允许一个warning(swap),网络配置也是可以的忽略的。否则,后面的问题会出现的非常的莫名其妙,一箩筐哈。
Que3:基本的包要先装上去,然后缺少哪个包再去iso镜像安装盘或者cd里面的server或packages文件夹去强行安装。而且os版本最好不要太新了。
强行安装rpm包命令是:rpm –ivh --nodeps 名称
Que4:网络配置检查相关 su – root gedit /etc/hosts(os是静态配置的情况如下)
格式:
“本机IP 主机名 主机别名”
注意:在redhat 企业版5首行写上“127.0.0.1 主机名 主机别名”检查是通不过的。
一般步骤:
1 挑包:
setarch-2* make-3* glibc-2* libaio-0* compat-libstdc++-33-3*
compat-gcc-34-3* compat-gcc-34-c++-3* gcc-4* libXp-1*
openmotif-2* compat-db-4*
2 修改os版本:
Gedit /etc/redhat-release
redhat-4
#Red Hat Enterprise Linux Server release 5.4 (Tikanga)
因为oracle 的官方只支持到RHEL4为止,所以要修改版本说明。把Red Hat Enterprise Linux Server release 5.4 (Tikanga)这一行注释掉,前面加上一行redhat-4。当然oracle安装完成后要修改回来。redhat-4 必须为redhat-release文件的第一行,否则安装时还会报警告。
3、修改内核参数:
Gedit /etc/sysctl.conf
增加到文件最下面:
kernel.shmall = 2097152
kernel.shmmax = ******(根据自己物理内存多大而定)
kernel.shmmni = 4096
# semaphores: semmsl, semmns, semopm, semmni
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default=262144
net.core.rmem_max=262144
net.core.wmem_default=262144
net.core.wmem_max=262144
4、建立安装Oracle需要的用户、组及目录
(1)新增组和用户:
groupadd oinstall
groupadd dba
useradd -g oinstall -G dba oracle
passwd oracle
(2)创建Oracle的安装目录,并把权限付给oracle用户:
mkdir -p /u01/app/oracle/product/10.2.0/db_1
chown -R oracle.oinstall /u01
5、设置oracle用户的shell limit
#vi /etc/security/limits.conf
增加下面的内容到文件 /etc/security/limits.conf 文件中:
* soft nproc 2047
* hard nproc 16384
* soft nofile 1024
* hard nofile 65536
增加下面的内容到文件 /etc/pam.d/login 中,使shell limit生效:
session required /lib/security/pam_limits.so

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

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 strategies for handling large datasets in MySQL, including partitioning, sharding, indexing, and query optimization.

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

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.

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

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.

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


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

DVWA
Damn Vulnerable Web App (DVWA) is a PHP/MySQL web application that is very vulnerable. Its main goals are to be an aid for security professionals to test their skills and tools in a legal environment, to help web developers better understand the process of securing web applications, and to help teachers/students teach/learn in a classroom environment Web application security. The goal of DVWA is to practice some of the most common web vulnerabilities through a simple and straightforward interface, with varying degrees of difficulty. Please note that this software

EditPlus Chinese cracked version
Small size, syntax highlighting, does not support code prompt function

Dreamweaver CS6
Visual web development tools

SublimeText3 Chinese version
Chinese version, very easy to use

MantisBT
Mantis is an easy-to-deploy web-based defect tracking tool designed to aid in product defect tracking. It requires PHP, MySQL and a web server. Check out our demo and hosting services.
