search
HomeDatabaseMysql TutorialOracle 9i在redhat linux as 2.1上的安装

欢迎进入Oracle社区论坛,与200万技术人员互动交流 >>进入 ORACLE9IAS安装文档 准备工作: 1. 建立oracle用户/组 以root用户登录 #groupadd dba #groupadd oinstall(可选) useradd ?g oinstall ?G dba oracle 2. 检查主机名配置 以root登录 #cd /etc #cp host

欢迎进入Oracle社区论坛,与200万技术人员互动交流 >>进入

ORACLE9IAS安装文档
准备工作:
1. 建立oracle用户/组
以root用户登录
#groupadd dba
#groupadd oinstall(可选)
useradd ?g oinstall ?G dba oracle
2. 检查主机名配置
以root登录
#cd /etc
#cp hosts hosts.bak
#vi hosts
--此文件里每一行格式应为

如我的/etc/hosts文件如下:
127.0.0.1 localhost(确保此行在第一行)
211.155.222.75 host03.sti.gd.cn host03(此行是我加上的,211.155.222.75为机器的IP)
3. 检查内核版本(要求2.4.9或以上版本)
以root登录
#cd /boot/grub
#more grub.conf
4. 检查ksh版本
以root登录
#rpm ?qa |grep pdksh(检查pdksh版本)
如果没有这个包,可以到http://www.rpmfind.net去下载这个rpm包然后安装.
安装方法如下:
#rpm ?ivh pdksh-5.2.14-16.i386.rpm(安装包)
# rpm ?Uvh pdksh-5.2.14-16.i386.rpm(升级包)
5. 检查binutils版本
以root登录
#rpm ?qa|grep binutils此版本应该大于2.11.90.0.8-13,如果小于此版本,需进行升级。
6. 检查glibc版本
以root登录
#rpm ?qa|grep glibc此版本应该大于2.2.4-25,如果小于此版本,需进行升级。
7. 设置ulimits
以root登录。
a) cd /etc/security
b) vi limits.conf
c) 在这个文件里面加入以下两行:@oraclehardnofile65535
@oraclehardnproc65535
d) 保存文件。
注:可以oracle用户检验以上设置:#su ? oracle
$ulimit ?aH

8. 检查内核参数
以root登录
a) #cd /etc
b) #vi sysctl.conf加入以下几行
kernel.sem = 100 32000 100 100
kernel.shmmax = 2147483648
kernel.shmmni = 100
net.ipv4.ip_local_port_range = 1024 65000
fs.file-max = 65536
c) 保存文件并重启机器,验证内核参数。
9. 编辑services,删除LDAP
a) 以root登录
b) #cd /etc
c) vi services
d) 查找到包含389,636端口的行(4行),注释掉这些行
e) 保存文件
10. 给/sbin/fuser做链接
以root登录
a) #cd /bin
b) #ls ?l f*如果fuser不存在,则
c) ln ?s /sbin/fuser fuser
11. 建立/tmp和/tmpdir目录
as root
a) #mkdir /tmp
b) #mkdir /tmpdir
c) #chmod 777 /tmpdir
12. 设置环境变量TMP,TMPDIR
as root
a) #cd /etc
b) #vi profile
加入TMP = /tmp;export TMP
TMPDIR=/tmpdir;export TMPDIR
d) 保存文件。
13 除去所有ORACLE用户的JAVA默认环境
a) 以oracle用户登录
b) $ehco $PTAH
c) 如果你看到“IBMJava2-131”在这里面,那么需要去掉,方法如下
d) $cd /home/oracle
e) $cp .bashrc bashrc.org
f) $cp .bash_profile .bash_profile.org
g) $vi .bashrc
在 #Source global definitions下面, "fi"之后, 加入:
- PATH=/bin:/usr/bin:/usr/local/bin:/usr/local/bin/X11:/usr/X11R6/bin
PATH=$PATH:$HOME/bin
h) 保存文件
i) $vi .bash_profile
在 #User specific environment and startup programs下面, 加入:
PATH=/bin:/usr/bin:/usr/local/bin:/usr/local/bin/X11:/usr/X11R6/bin
ORACLE_HOME=$ORACLE_BASE/mid902
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/local/lib
ORACLE_SID=ias
PATH=$ORACLE_HOME/bin:$ORACLE_HOME/opmn/bin:$ORACLE_HOME/dcm/bin:$PATH
export PATH ORACLE_HOME LD_LIBRARY_PATH ORACLE_SID
(在 "PATH=$PATH:$HOME/bin" 之上.)
保存文件。
安装:
以oracle用户登录,运行runinstaller,然后按提示一步步安装
中途可能会出现的错误:
1、 copy过程中error in ………..jre/1.3.1/bin/i386/green_threads/…此时从另一个窗口手工touch这些文件,然后retry。
2、 link过程中error in invoking ………….sqlplus.mk,此时从另一个窗口以oracle用户打开文件$ORACLE_HOME/bin/genclntsh
找到LD_SELF_CONTAINED = “-z defs”这行,改为
LD_SELF_CONTAINED = “”,保存文件,然后执行./ genclntsh,执行完成后回到安装界面retry.
关于IAS的配置,将在以后推出:)

Oracle 9i在redhat linux as 2.1上的安装

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
MySQL String Types: Storage, Performance, and Best PracticesMySQL String Types: Storage, Performance, and Best PracticesMay 10, 2025 am 12:02 AM

MySQLstringtypesimpactstorageandperformanceasfollows:1)CHARisfixed-length,alwaysusingthesamestoragespace,whichcanbefasterbutlessspace-efficient.2)VARCHARisvariable-length,morespace-efficientbutpotentiallyslower.3)TEXTisforlargetext,storedoutsiderows,

Understanding MySQL String Types: VARCHAR, TEXT, CHAR, and MoreUnderstanding MySQL String Types: VARCHAR, TEXT, CHAR, and MoreMay 10, 2025 am 12:02 AM

MySQLstringtypesincludeVARCHAR,TEXT,CHAR,ENUM,andSET.1)VARCHARisversatileforvariable-lengthstringsuptoaspecifiedlimit.2)TEXTisidealforlargetextstoragewithoutadefinedlength.3)CHARisfixed-length,suitableforconsistentdatalikecodes.4)ENUMenforcesdatainte

What are the String Data Types in MySQL?What are the String Data Types in MySQL?May 10, 2025 am 12:01 AM

MySQLoffersvariousstringdatatypes:1)CHARforfixed-lengthstrings,2)VARCHARforvariable-lengthtext,3)BINARYandVARBINARYforbinarydata,4)BLOBandTEXTforlargedata,and5)ENUMandSETforcontrolledinput.Eachtypehasspecificusesandperformancecharacteristics,sochoose

How to Grant Permissions to New MySQL UsersHow to Grant Permissions to New MySQL UsersMay 09, 2025 am 12:16 AM

TograntpermissionstonewMySQLusers,followthesesteps:1)AccessMySQLasauserwithsufficientprivileges,2)CreateanewuserwiththeCREATEUSERcommand,3)UsetheGRANTcommandtospecifypermissionslikeSELECT,INSERT,UPDATE,orALLPRIVILEGESonspecificdatabasesortables,and4)

How to Add Users in MySQL: A Step-by-Step GuideHow to Add Users in MySQL: A Step-by-Step GuideMay 09, 2025 am 12:14 AM

ToaddusersinMySQLeffectivelyandsecurely,followthesesteps:1)UsetheCREATEUSERstatementtoaddanewuser,specifyingthehostandastrongpassword.2)GrantnecessaryprivilegesusingtheGRANTstatement,adheringtotheprincipleofleastprivilege.3)Implementsecuritymeasuresl

MySQL: Adding a new user with complex permissionsMySQL: Adding a new user with complex permissionsMay 09, 2025 am 12:09 AM

ToaddanewuserwithcomplexpermissionsinMySQL,followthesesteps:1)CreatetheuserwithCREATEUSER'newuser'@'localhost'IDENTIFIEDBY'password';.2)Grantreadaccesstoalltablesin'mydatabase'withGRANTSELECTONmydatabase.TO'newuser'@'localhost';.3)Grantwriteaccessto'

MySQL: String Data Types and CollationsMySQL: String Data Types and CollationsMay 09, 2025 am 12:08 AM

The string data types in MySQL include CHAR, VARCHAR, BINARY, VARBINARY, BLOB, and TEXT. The collations determine the comparison and sorting of strings. 1.CHAR is suitable for fixed-length strings, VARCHAR is suitable for variable-length strings. 2.BINARY and VARBINARY are used for binary data, and BLOB and TEXT are used for large object data. 3. Sorting rules such as utf8mb4_unicode_ci ignores upper and lower case and is suitable for user names; utf8mb4_bin is case sensitive and is suitable for fields that require precise comparison.

MySQL: What length should I use for VARCHARs?MySQL: What length should I use for VARCHARs?May 09, 2025 am 12:06 AM

The best MySQLVARCHAR column length selection should be based on data analysis, consider future growth, evaluate performance impacts, and character set requirements. 1) Analyze the data to determine typical lengths; 2) Reserve future expansion space; 3) Pay attention to the impact of large lengths on performance; 4) Consider the impact of character sets on storage. Through these steps, the efficiency and scalability of the database can be optimized.

See all articles

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Tools

Atom editor mac version download

Atom editor mac version download

The most popular open source editor

SublimeText3 Linux new version

SublimeText3 Linux new version

SublimeText3 Linux latest version

mPDF

mPDF

mPDF is a PHP library that can generate PDF files from UTF-8 encoded HTML. The original author, Ian Back, wrote mPDF to output PDF files "on the fly" from his website and handle different languages. It is slower than original scripts like HTML2FPDF and produces larger files when using Unicode fonts, but supports CSS styles etc. and has a lot of enhancements. Supports almost all languages, including RTL (Arabic and Hebrew) and CJK (Chinese, Japanese and Korean). Supports nested block-level elements (such as P, DIV),

MinGW - Minimalist GNU for Windows

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.

SublimeText3 English version

SublimeText3 English version

Recommended: Win version, supports code prompts!