linux下oracle10g 安装里用的是redhat linux as 5 和oracle10g1、先打系统补丁[root@oracle rpm]# rpm -ivh libXp-*warning: lib
首页 → 数据库技术
背景:
阅读新闻
Linux下Oracle 10g 安装环境配置
[日期:2012-02-08] 来源:Linux社区 作者:yujin2010good [字体:]
linux下Oracle10g 安装里用的是RedHat linux as 5 和oracle10g
1、先打系统补丁
[root@oracle rpm]# rpm -ivh libXp-*
warning: libXp-1.0.0-8.i386.rpm: Header V3DSA signature: NOKEY, key ID 82fd17b2
Preparing... ########################################### [100%]
1:libXp ########################################### [ 50%]
2:libXp-devel ########################################### [100%]
[root@oracle rpm]#
2、修改操作系统核心参数
vi /etc/sysctl.conf
kernel.msgmax = 65536
# Controls the maximum shared segment size,in bytes
kernel.shmmax = 536870912
# Controls the maximum number of sharedmemory segments, in pages
kernel.shmall = 2097152
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range =1024 65000
net.core.rmem_default = 1048576
net.core.rmem_max = 1048576
net.core.wmem_default = 262144
net.core.wmem_max = 262144
用下面这个命令就不需要重启了
/sbin/sysctl -p
设置shell调用限制
vi/etc/security/limits.conf
* soft nproc 2047
* hard nproc 16384
* soft nofile 1024
* hard nofile 65536
vi /etc/pam.d/login
session required pam_limits.so
下面来建组建用户
[root@oracle rpm]# groupadd oinstall
[root@oracle rpm]# groupadd dba
[root@oracle rpm]# useradd -g oinstall -gdba -m oracle
[root@oracle rpm]# passwd oracle
Changing password for user oracle.
New UNIX password:
BAD PASSWORD: it does not contain enoughDIFFERENT characters
Retype new UNIX password:
passwd: all authentication tokens updatedsuccessfully.
[root@oracle rpm]# mkdir /opt/ora10g
[root@oracle rpm]# mkdir/opt/ora10g/product
[root@oracle rpm]# mkdir/opt/ora10g/oradata
[root@oracle rpm]# chown -R oracle:oinstall/opt/ora10g
[root@oracle rpm]# su - oracle
[oracle@oracle ~]$ vi .bash_profile
PATH=$PATH:$HOME/bin
export TMP=/tmp
export TMPDIR=$TMP
export ORACLE_BASE=/opt/ora10g
exportORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
export ORACLE_SID=orcl
export ORACLE_TERM=xterm
export PATH=/usr/sbin:$PATH
export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib64:/usr/lib64:/usr/local/lib64:/usr/x11R6/lib64
exportCLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
export LD_ASSUME_KERNEL=2.6.18
export NLS_LANG="SIMPLIFIEDCHINESE_CHINA.UTF8"
umask 022
if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit –u 16384 –n 65536
fi
fi
# modify /etc/redhat-release
echo '#Red Hat Enterprise Linux Server release 5.3 (Tikanga)
redhat-4' > /etc/redhat-release
[oracle@oracle ~]$ source .bash_profile
然后把软件拷贝到我门建的目录/opt/app
xhost +
su - oracle
[oracle@oracle database]$ LANG=C
[oracle@oracle database]$ ./runInstaller
Oracle手工建库
Oracle 行级锁与表级锁
相关资讯 Oracle基础教程
图片资讯
本文评论 查看全部评论 (0)
评论声明
最新资讯
本周热门
Linux公社简介 - 广告服务 - 网站地图 - 帮助信息 - 联系我们
本站(LinuxIDC)所刊载文章不代表同意其说法或描述,仅为提供更多信息,,也不构成任何建议。
Copyright © 2006-2011 Linux公社 All rights reserved 浙ICP备06018118号

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

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

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]


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

SublimeText3 Linux new version
SublimeText3 Linux latest version

MinGW - Minimalist GNU for Windows
This project is in the process of being migrated to osdn.net/projects/mingw, you can continue to follow us there. MinGW: A native Windows port of the GNU Compiler Collection (GCC), freely distributable import libraries and header files for building native Windows applications; includes extensions to the MSVC runtime to support C99 functionality. All MinGW software can run on 64-bit Windows platforms.

SAP NetWeaver Server Adapter for Eclipse
Integrate Eclipse with SAP NetWeaver application server.

VSCode Windows 64-bit Download
A free and powerful IDE editor launched by Microsoft

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