oracle 10gR2 and oracle 11gR1 and oracle 11gR2 在RHEL 5下安
Requirements For Installing Oracle 10gR2 On RHEL_OEL 5 (x86) [ID 419646.1].htm Requirements For Installing Oracle 10gR2 On RHEL 5_OEL 5 (x86_64) [ID 421308.1].htm Requirements for Installing Oracle 10gR2 RDBMS on RHEL 5 on Linux Itanium (i
Requirements For Installing Oracle 10gR2 On RHEL_OEL 5 (x86) [ID 419646.1].htm
Requirements For Installing Oracle 10gR2 On RHEL 5_OEL 5 (x86_64) [ID 421308.1].htm
Requirements for Installing Oracle 10gR2 RDBMS on RHEL 5 on Linux Itanium (ia64) [ID 748378.1].htm
Requirements for Installing Oracle 10gR2 RDBMS on RHEL 5 on zLinux (s390x) [ID 741646.1].htm
Requirements for Installing Oracle 11gR1 32bit RDBMS on RHEL 5 & OEL 5 [ID 438765.1].htm
Requirements for Installing Oracle 11gR1 RDBMS on RHEL 5 on AMD64_EM64T [ID 438766.1].htm
Requirements for Installing Oracle 11gR2 RDBMS on RHEL (and OEL) 5 on 32-bit x86 [ID 880936.1].htm
Requirements for Installing Oracle 11gR2 RDBMS on RHEL (and OEL) 5 on AMD64_EM64T [ID 880989.1].htm
Installing Oracle 10gR2 On RHEL_OEL 5 (x86)时的rpm包要求:
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
sysstat-7.0.0
unixODBC-2.2.11
unixODBC-devel-2.2.11
Note:
As per documentation bug 7680459 , the package libXp-1.0.0-8 is also required to invoke OUI successfully.
所以,libXp-1.0.0-8 包要安装 ,否则在运行./runInstaller时,会报错:
Exception :java.lang.UnsatisfiedLinkError:/u01/product/oracle/jdk/jre/lib/i386/libawt.so: libXp.so.6: cannot open shared object file: No such file or directory
此报错会导致图形界面出不来,导致安装oracle软件失败。
Installing Oracle10gR2 On RHEL 5_OEL 5 (x86_64)时的rpm包要求:
binutils-2.17.50.0.6-2 (x86_64)
compat-db-4.2.52-5.1 (x86_64)
compat-libstdc++-296-2.96-138 (i386)
compat-libstdc++-33-3.2.3-61(x86_64)
compat-libstdc++-33-3.2.3-61 (i386)
control-center-2.16.0-14 (x86_64)
gcc-4.1.1-52 (x86_64)
gcc-c++-4.1.1-52 (x86_64)
glibc-2.5-12 (x86_64)
glibc-2.5-12 (i686)
glibc-common-2.5-12 (x86_64)
glibc-devel-2.5-12 (x86_64)
glibc-devel-2.5-12 (i386)
glibc-headers-2.5-12 (x86_64)
ksh-20060214-1.4 (x86_64)
libaio-0.3.106-3.2 (x86_64)
libgcc-4.1.1-52 (i386)
libgcc-4.1.1-52 (x86_64)
libgnome-2.16.0-6 (x86_64)
libgnomeui-2.16.0-5 (x86_64)
libgomp-4.1.1-52 (x86_64)
libstdc++-4.1.1-52 (x86_64)
libstdc++-devel-4.1.1-52 (x86_64)
libXp-1.0.0-8 (i386)
make-3.81-1.1 (x86_64)
sysstat-7.0.0-3 (x86_64)
Installing Oracle 10gR2 RDBMS on RHEL 5 on Linux Itanium (ia64) 时的rpm包要求:
II. Software:
============
1. Red Hat Enterprise Linux Server 5.x, which is Kernel 2.6.18-8.el5 or newer.
2. Required OS Components (per Release Notes, and Install Guide)
a.) This list is based upon Itanium (ia64) RHEL Server 5.0. When a
newer "update" level is used, the RPM release numbers (such as
2.6.18-8.el5) may be slightly higher (such as 2.6.18-53.el5 or
2.6.18-92.el5). This is fine so long as you are still using RHEL Server 5
RPMs for Itanium (ia64).
b.) binutils-2.17.50.0.6-2.el5.ia64.rpm
c.) compat-libstdc++-33-3.2.3-61.ia64.rpm
aa.) The RHEL 5.0 ia64 and 5.1 ia64 media mistakenly named this same
RPM as:
compat-libstdc33-3.2.3-61.ia64.rpm
d.) elfutils-libelf-0.125-3.el5.ia64.rpm
e.) elfutils-libelf-devel-0.125-3.el5.ia64.rpm
f.) gcc-4.1.1-52.el5.ia64.rpm
g.) gcc-c++-4.1.2-42.el5.ia64.rpm
aa.) The RHEL 5.0 ia64 and 5.1 ia64 media mistakenly named this same
RPM as:
gcc-c4.1.1-52.el5.ia64.rpm
h.) glibc-2.5-12.ia64.rpm
i.) glibc-common-2.5-12.ia64.rpm
j.) glibc-devel-2.5-12.ia64.rpm
k.) glibc-headers-2.5-12.ia64.rpm
l.) libaio-0.3.106-3.2.ia64.rpm
m.) libaio-devel-0.3.106-3.2.ia64.rpm
n.) libgcc-4.1.1-52.el5.ia64.rpm
o.) libstdc++-4.1.2-42.el5.ia64.rpm
aa.) The RHEL 5.0 ia64 and 5.1 ia64 media mistakenly named this same
RPM as:
libstdc4.1.1-52.el5.ia64.rpm
p.) libstdc++-devel-4.1.2-42.el5.ia64.rpm
aa.) The RHEL 5.0 ia64 and 5.1 ia64 media mistakenly named this same
RPM as:
libstdcdevel-4.1.1-52.el5.ia64.rpm
q.) make-3.81-1.1.ia64.rpm
r.) sysstat-7.0.0-3.el5.ia64.rpm
s.) unixODBC-2.2.11-7.1.ia64.rpm
t.) unixODBC-devel-2.2.11-7.1.ia64.rpm
In several cases, multiple architectures of RPMs are provided on the
RHEL media. You only need the "ia64" architectures. For example, you do
not need "glibc-2.5-12.i686.rpm". You only need
"glibc-2.5-12.ia64.rpm".
3. Additional Required OS Components (per the runInstaller OUI)
a.) intentionally blank
4. Additional Required OS Components (per this NOTE)
a.) Please do not rush, skip, or minimize this critical step.
This list is based upon a "default-RPMs" installation of Itanium (ia64)
RHEL Server 5. Additional RPMs (beyond anything known to Oracle) may be
needed if a "less-than-default-RPMs" installation of Itanium (ia64)
RHEL Server 5 is performed. For more information, please refer to Note 376183.1
, "Defining a "default RPMs" installation of the RHEL OS"
b.) Other required RPMs (such as libXp-1.0.0-8.ia64.rpm) will already
be present from this "default-RPMs" installation.
5. Oracle Global Customer Support has noticed a recent trend with
install problems that originates from installing too many RPMs. For
example:
a.) installing your
own JDK version (prior to beginning the Oracle Software “runInstaller”)
is not needed on Linux, and is not recommended on Linux. A pre-existing
JDK often interferes with the correct JDK that the Linux Oracle Software
“runInstaller” will place and use.
b.) installing more than the required version of the gcc / g++ RPMs
often leads to accidentally using (aka enabling or activating) the
incorrect one. If you have multiple RDBMS versions installed on the same
Linux machine, then you will likely have to manage multiple versions of
gcc /g++ . For more information, please see Note 444084.1
, "Multiple gcc / g++ Versions in Linux"
6. All of the RPMs in div II. are on the Red Hat Enterprise Linux 5 Itanium (ia64) distribution media.
7. Command syntax to differentiate between installed
i686 RPMs and installed ia64 RPMs is presented in the "Additional Notes"
div below.
Installing Oracle 10gR2 RDBMS on RHEL 5 on zLinux (s390x)
II. Software:
=========
A. Red Hat Enterprise Linux Server 5 (Update 2 or newer) is required, which is Kernel 2.6.18-92.el5 or newer.
1. This NOTE is based upon x86_64 RHEL Server 5 "update 2". When a
newer "update" level is used, the RPM release numbers (such as
2.6.18-92) may be slightly higher (such as 2.6.18-97). This is fine so
long as you are still using RHEL Server 5 RPMs.
B. Required OS Components (per Release Notes, and Quick Install Guide)
1. intentionally blank
C. Additional Required OS Components (per this NOTE)
1. Please do not rush, skip, or minimize this critical step.
This list is based upon a "default-RPMs" installation of RHEL
Server 5. Additional RPMs (beyond anything known to Oracle) may be
needed if a "less-than-default-RPMs" installation of RHEL Server 5
is performed. For more information, please refer to Note 376183.1
, "Defining a "default RPMs" installation of the RHEL OS"
2.
glibc-devel-2.5-24.s390.rpm
3. libaio-0.3.106-3.2.s390x.rpm
4. sysstat-7.0.2-1.el5.s390x.rpm
5. java-1.4.2-gcj-compat-src-1.4.2.0-40jpp.115.s390x.rpm
6. compat-gcc-34-c++-3.4.6-4.s390x.rpm
7. compat-gcc-34-3.4.6-4.s390x.rpm
8. compat-libstdc++-33-3.2.3-61.s390x.rpm
9. compat-libstdc++-295-2.95.3-85.s390x.rpm
D. Optional X Software Components (per this NOTE)
1. mesa-libGLU-devel-6.5.1-7.5.el5.s390x.rpm
2. mesa-lib-GLw-devel-6.5.1-7.5.el5.s390x.rpm
3. openmotif-devel-2.3.0-0.5.el5.s390x.rpm
E. Oracle Global Customer Support has
noticed a recent trend with install problems that originates from
installing too many RPMs. For example:
1.
installing your own JDK version (prior to beginning the Oracle Software
“runInstaller”) is not needed on Linux, and is not recommended on
Linux. A pre-existing JDK often interferes with the correct JDK that the
Linux Oracle Software “runInstaller” will place and use.
2.
installing more than the required version of the gcc / g++ RPMs often
leads to accidentally using (aka enabling or activating) the incorrect
one. If you have multiple RDBMS versions installed on the same Linux
machine, then you will likely have to manage multiple versions of gcc
/g++ . For more information, please see Note 444084.1
, "Multiple gcc / g++ Versions in Linux"
F. The s390x (64-bit) packages are on the RHEL 5 zLinux
distribution media. The s390 (31-bit) packages are also on the RHEL 5
zLinux distribution media.
G.
Command syntax to differentiate between installed s390 (31-bit) RPMs
and installed s390x (64-bit) RPMs is presented in the "Additional Notes"
div below.
H. Note: s390
(31-bit) packages might require the --force option during installation
if the 64-bit version of the same package is already installed. For
example, "rpm -ivh --force glibc-devel-2.3.4-2.13.s390.rpm" may be
required.
以下的安装需求请见各自的metalink文章:
Requirements for Installing Oracle 11gR1 32bit RDBMS on RHEL 5 & OEL 5
Requirements for Installing Oracle 11gR1 RDBMS on RHEL 5 on AMD64_EM64T
Requirements for Installing Oracle 11gR2 RDBMS on RHEL (and OEL) 5 on 32-bit x86
Requirements for Installing Oracle 11gR2 RDBMS on RHEL (and OEL) 5 on AMD64_EM64T
Requirements For Installing Oracle10gR2 On RHEL 5_OEL 5 (x86_64)

热AI工具

Undresser.AI Undress
人工智能驱动的应用程序,用于创建逼真的裸体照片

AI Clothes Remover
用于从照片中去除衣服的在线人工智能工具。

Undress AI Tool
免费脱衣服图片

Clothoff.io
AI脱衣机

Video Face Swap
使用我们完全免费的人工智能换脸工具轻松在任何视频中换脸!

热门文章

热工具

记事本++7.3.1
好用且免费的代码编辑器

SublimeText3汉化版
中文版,非常好用

禅工作室 13.0.1
功能强大的PHP集成开发环境

Dreamweaver CS6
视觉化网页开发工具

SublimeText3 Mac版
神级代码编辑软件(SublimeText3)

Oracle 打不开的解决办法包括:1. 启动数据库服务;2. 启动监听器;3. 检查端口冲突;4. 正确设置环境变量;5. 确保防火墙或防病毒软件未阻止连接;6. 检查服务器是否已关闭;7. 使用 RMAN 恢复损坏的文件;8. 检查 TNS 服务名称是否正确;9. 检查网络连接;10. 重新安装 Oracle 软件。

解决 Oracle 游标关闭问题的方法包括:使用 CLOSE 语句显式关闭游标。在 FOR UPDATE 子句中声明游标,使其在作用域结束后自动关闭。在 USING 子句中声明游标,使其在关联的 PL/SQL 变量关闭时自动关闭。使用异常处理确保在任何异常情况下关闭游标。使用连接池自动关闭游标。禁用自动提交,延迟游标关闭。

Oracle 数据库分页利用 ROWNUM 伪列或 FETCH 语句实现:ROWNUM 伪列用于通过行号过滤结果,适用于复杂查询。FETCH 语句用于获取指定数量的第一行,适用于简单查询。

Oracle 中,FOR LOOP 循环可动态创建游标, 步骤为:1. 定义游标类型;2. 创建循环;3. 动态创建游标;4. 执行游标;5. 关闭游标。示例:可循环创建游标,显示前 10 名员工姓名和工资。

要停止 Oracle 数据库,请执行以下步骤:1. 连接到数据库;2. 优雅关机数据库(shutdown immediate);3. 完全关机数据库(shutdown abort)。

在CentOS系统上搭建Hadoop分布式文件系统(HDFS)需要多个步骤,本文提供一个简要的配置指南。一、前期准备安装JDK:在所有节点上安装JavaDevelopmentKit(JDK),版本需与Hadoop兼容。可从Oracle官网下载安装包。环境变量配置:编辑/etc/profile文件,设置Java和Hadoop的环境变量,使系统能够找到JDK和Hadoop的安装路径。二、安全配置:SSH免密登录生成SSH密钥:在每个节点上使用ssh-keygen命令

可以通过使用 Oracle 的动态 SQL 来根据运行时输入创建和执行 SQL 语句。步骤包括:准备一个空字符串变量来存储动态生成的 SQL 语句。使用 EXECUTE IMMEDIATE 或 PREPARE 语句编译和执行动态 SQL 语句。使用 bind 变量传递用户输入或其他动态值给动态 SQL。使用 EXECUTE IMMEDIATE 或 EXECUTE 执行动态 SQL 语句。

打开 Oracle 数据库的步骤如下:打开 Oracle 数据库客户端连接到数据库服务器:connect username/password@servername使用 SQLPLUS 命令打开数据库:SQLPLUS
