使用神谕
最重要的是，下载并安装 Oracle 11g 数据库软件安装所需的多个软件包，同时解决软件包之间的依赖关系。请注意，经过 Oracle 验证的 RPM 软件包
最重要的是，下载并安装 Oracle 11g 数据库软件安装所需的多个软件包，同时解决软件包之间的依赖关系请注意，经过 Oracle 验证的 RPM 包可通过 Oracle Unbreakable Linux Network (ULN) 访问，这需要支持合同或从 Oracle 公共 yum 存储库访问。
首先，我们需要将 Linux 计算机配置为能够使用公司代理连接到互联网，我们通过编辑 /etc/profile.d/proxy.sh 文件以及一些环境变量（如 FTP_PROXY）来完成此操作和 HTTP_PROXY
导出 http_proxy=http://test-apache-001-dev.corporateict.domain:8123/
导出 ftp_proxy=http://test-apache-001-dev.corporateict.domain:8123/
导出 no_proxy=.corporateict.domain
导出 HTTP_PROXY=http://test-apache-001-dev.corporateict.domain:8123/
导出 FTP_PROXY=http://test-apache-001-dev.corporateict.domain:8123/
再次以 root 身份登录以调用对环境所做的更改。
然后，我们使用 wget 下载包含存储库位置的文件
[root@kens-orasql-001 yum.repos.d]# wget http://public-yum.oracle.com/public-yum-el5.repo
我们必须更新此文件，并将适用于我们的 Linux 版本的标记的启用=0 行更改为启用=1 – 在我们的例子中，我们使用的是 OEL 5.7，因此我们必须更新这些行：
改变
[ol5_u7_base]
name=Oracle Linux $releasever – U7 – $basearch – base
baseurl=http://public-yum.oracle.com/repo/OracleLinux/OL5/7/base/$basearch/
gpgkey=http://public-yum.oracle.com/RPM-GPG-KEY-oracle-el5
gpgcheck=1
启用=0
到
[ol5_u7_base]
name=Oracle Linux $releasever – U7 – $basearch – base
baseurl=http://public-yum.oracle.com/repo/OracleLinux/OL5/7/base/$basearch/
gpgkey=http://public-yum.oracle.com/RPM-GPG-KEY-oracle-el5
gpgcheck=1
启用=1
然后我们运行 yum update，然后运行 yum install oracle-validated
[root@kens-orasql-002 yum.repos.d]# <strong>yum update</strong> Loaded plugins: rhnplugin, security This system is not registered with ULN. ULN support will be disabled. ol5_u7_base | 1.1 kB 00:00 ol5_u7_base/primary | 1.5 MB 00:07 ol5_u7_base 4605/4605 Skipping security plugin, no data Setting up Update Process No Packages marked for Update
[root@kens-orasql-002 yum.repos.d]# <strong>yum install oracle-validated</strong> Loaded plugins: rhnplugin, security This system is not registered with ULN. ULN support will be disabled. Setting up Install Process Resolving Dependencies --> Running transaction check ---> Package oracle-validated.x86_64 0:1.1.0-14.el5 set to be updated --> Processing Dependency: kernel-uek >= 2.6.32 for package: oracle-validated --> Processing Dependency: libXp.so.6 for package: oracle-validated --> Processing Dependency: /usr/lib/libodbccr.so for package: oracle-validated --> Processing Dependency: /usr/lib64/libodbccr.so for package: oracle-validated --> Processing Dependency: unixODBC-devel for package: oracle-validated --> Processing Dependency: libaio-devel for package: oracle-validated --> Processing Dependency: sysstat for package: oracle-validated --> Processing Dependency: /usr/lib64/libaio.so for package: oracle-validated --> Processing Dependency: /usr/lib/libodbc.so.1 for package: oracle-validated --> Processing Dependency: /usr/lib/libaio.so for package: oracle-validated --> Processing Dependency: compat-gcc-34-c++ for package: oracle-validated --> Processing Dependency: compat-gcc-34 for package: oracle-validated --> Processing Dependency: libdb-4.2.so()(64bit) for package: oracle-validated --> Processing Dependency: libodbc.so.1()(64bit) for package: oracle-validated --> Running transaction check ---> Package compat-db.x86_64 0:4.2.52-5.1 set to be updated ---> Package compat-gcc-34.x86_64 0:3.4.6-4.1 set to be updated ---> Package compat-gcc-34-c++.x86_64 0:3.4.6-4.1 set to be updated ---> Package kernel-uek.x86_64 0:2.6.32-200.13.1.el5uek set to be installed --> Processing Dependency: kernel-firmware >= 2.6.32-200.13.1.el5uek for package: kernel-uek ---> Package libXp.i386 0:1.0.0-8.1.el5 set to be updated ---> Package libaio-devel.i386 0:0.3.106-5 set to be updated ---> Package libaio-devel.x86_64 0:0.3.106-5 set to be updated ---> Package sysstat.x86_64 0:7.0.2-11.el5 set to be updated ---> Package unixODBC.i386 0:2.2.11-7.1 set to be updated ---> Package unixODBC.x86_64 0:2.2.11-7.1 set to be updated ---> Package unixODBC-devel.i386 0:2.2.11-7.1 set to be updated ---> Package unixODBC-devel.x86_64 0:2.2.11-7.1 set to be updated --> Running transaction check ---> Package kernel-uek-firmware.noarch 0:2.6.32-200.13.1.el5uek set to be updated --> Finished Dependency Resolution Dependencies Resolved ====================================================================================================================================================================== Package Arch Version Repository Size ====================================================================================================================================================================== Installing: oracle-validated x86_64 1.1.0-14.el5 ol5_u7_base 24 k Installing for dependencies: compat-db x86_64 4.2.52-5.1 ol5_u7_base 1.6 M compat-gcc-34 x86_64 3.4.6-4.1 ol5_u7_base 4.3 M compat-gcc-34-c++ x86_64 3.4.6-4.1 ol5_u7_base 13 M kernel-uek x86_64 2.6.32-200.13.1.el5uek ol5_u7_base 25 M kernel-uek-firmware noarch 2.6.32-200.13.1.el5uek ol5_u7_base 2.5 M libXp i386 1.0.0-8.1.el5 ol5_u7_base 22 k libaio-devel i386 0.3.106-5 ol5_u7_base 12 k libaio-devel x86_64 0.3.106-5 ol5_u7_base 11 k sysstat x86_64 7.0.2-11.el5 ol5_u7_base 187 k unixODBC i386 2.2.11-7.1 ol5_u7_base 830 k unixODBC x86_64 2.2.11-7.1 ol5_u7_base 835 k unixODBC-devel i386 2.2.11-7.1 ol5_u7_base 743 k unixODBC-devel x86_64 2.2.11-7.1 ol5_u7_base 799 k Transaction Summary ====================================================================================================================================================================== Install 14 Package(s) Upgrade 0 Package(s) Total size: 50 M Is this ok [y/N]: y Downloading Packages: warning: rpmts_HdrFromFdno: Header V3 DSA signature: NOKEY, key ID 1e5e0159 ol5_u7_base/gpgkey | 1.4 kB 00:00 Importing GPG key 0x1E5E0159 "Oracle OSS group (Open Source Software group) " from http://public-yum.oracle.com/RPM-GPG-KEY-oracle-el5 Is this ok [y/N]: y Running rpm_check_debug Running Transaction Test Finished Transaction Test Transaction Test Succeeded Running Transaction Installing : unixODBC 1/14 Installing : compat-gcc-34 2/14 Installing : sysstat 3/14 Installing : compat-db 4/14 Installing : unixODBC 5/14 Installing : unixODBC-devel 6/14 Installing : unixODBC-devel 7/14 Installing : libaio-devel 8/14 Installing : libaio-devel 9/14 Installing : kernel-uek-firmware 10/14 Installing : libXp 11/14 Installing : compat-gcc-34-c++ 12/14 Change references of /dev/hd in /etc/fstab to disk label Installing : kernel-uek 13/14 WARNING: No module ehci-hcd found for kernel 2.6.32-200.13.1.el5uek, continuing anyway WARNING: No module ohci-hcd found for kernel 2.6.32-200.13.1.el5uek, continuing anyway WARNING: No module uhci-hcd found for kernel 2.6.32-200.13.1.el5uek, continuing anyway Installing : oracle-validated 14/14 Installed: oracle-validated.x86_64 0:1.1.0-14.el5 Dependency Installed: compat-db.x86_64 0:4.2.52-5.1 compat-gcc-34.x86_64 0:3.4.6-4.1 compat-gcc-34-c++.x86_64 0:3.4.6-4.1 kernel-uek.x86_64 0:2.6.32-200.13.1.el5uek kernel-uek-firmware.noarch 0:2.6.32-200.13.1.el5uek libXp.i386 0:1.0.0-8.1.el5 libaio-devel.i386 0:0.3.106-5 libaio-devel.x86_64 0:0.3.106-5 sysstat.x86_64 0:7.0.2-11.el5 unixODBC.i386 0:2.2.11-7.1 unixODBC.x86_64 0:2.2.11-7.1 unixODBC-devel.i386 0:2.2.11-7.1 unixODBC-devel.x86_64 0:2.2.11-7.1 Complete! [root@kens-orasql-002 yum.repos.d]#
我们可以看到oracle验证的RPM已经安装了。
[root@kens-orasql-001 yum.repos.d]# <strong>rpm -qa |grep oracle-valid</strong> oracle-validated-1.1.0-14.el5
我们还可以检查并查看用户和组是否也已创建。
[root@kens-orasql-001 yum.repos.d]# <strong>cat /etc/passwd |grep oracle</strong> oracle:x:54321:54321::/home/oracle:/bin/bash [root@kens-orasql-001 yum.repos.d]# <strong>cat /etc/group |grep dba </strong> dba:x:54322:oracle
它还更新了 /etc/security/limits.conf 文件
[root@kens-orasql-001 yum.repos.d]# cat /etc/security/limits.conf # Oracle-Validated setting for nofile soft limit is 131072 oracle soft nofile 131072 # Oracle-Validated setting for nofile hard limit is 131072 oracle hard nofile 131072 # Oracle-Validated setting for nproc soft limit is 131072 oracle soft nproc 131072 # Oracle-Validated setting for nproc hard limit is 131072 oracle hard nproc 131072 # Oracle-Validated setting for core soft limit is unlimited oracle soft core unlimited # Oracle-Validated setting for core hard limit is unlimited oracle hard core unlimited # Oracle-Validated setting for memlock soft limit is 50000000 oracle soft memlock 50000000 # Oracle-Validated setting for memlock hard limit is 50000000 oracle hard memlock 50000000
最后，我们可以看到 /etc/sysctl.conf 也已更新，并添加了一些“Oracle-Validated”设置。
# For 11g, Oracle-Validated setting for fs.file-max is 6815744 # For 10g, uncomment 'fs.file-max = 327679', and comment 'fs.file-max = 6553600' entry and re-run sysctl -p # fs.file-max = 327679 fs.file-max = 6815744 # Oracle-Validated setting for kernel.msgmni is 2878 kernel.msgmni = 2878 # Oracle-Validated setting for kernel.msgmax is 8192 kernel.msgmax = 8192 # Oracle-Validated setting for kernel.msgmnb is 65536 kernel.msgmnb = 65536 # Oracle-Validated setting for kernel.sem is '250 32000 100 142' kernel.sem = 250 32000 100 142 # Oracle-Validated setting for kernel.shmmni is 4096 kernel.shmmni = 4096 # Oracle-Validated setting for kernel.shmall is 1073741824 kernel.shmall = 1073741824 # Oracle-Validated setting for kernel.shmmax is 4398046511104 on x86_64 and 4294967295 on i386 architecture. Refer Note id 567506.1 kernel.shmmax = 4398046511104 # Oracle-Validated setting for kernel.sysrq is 1 kernel.sysrq = 1 # Oracle-Validated setting for net.core.rmem_default is 262144 net.core.rmem_default = 262144 # For 11g, Oracle-Validated setting for net.core.rmem_max is 4194304 # For 10g, uncomment 'net.core.rmem_max = 2097152', comment 'net.core.rmem_max = 4194304' entry and re-run sysctl -p # net.core.rmem_max = 2097152 net.core.rmem_max = 4194304 # Oracle-Validated setting for net.core.wmem_default is 262144 net.core.wmem_default = 262144 # For 11g, Oracle-Validated setting for net.core.wmem_max is 1048576 # For 10g, uncomment 'net.core.wmem_max = 262144', comment 'net.core.wmem_max = 1048576' entry for this parameter and re-run sysctl -p # net.core.wmem_max = 262144 net.core.wmem_max = 1048576 # Oracle-Validated setting for fs.aio-max-nr is 3145728 fs.aio-max-nr = 3145728 # For 11g, Oracle-Validated setting for net.ipv4.ip_local_port_range is 9000 65500 # For 10g, uncomment 'net.ipv4.ip_local_port_range = 1024 65000', comment 'net.ipv4.ip_local_port_range = 9000 65500' entry and re-run sysctl -p # net.ipv4.ip_local_port_range = 1024 65000 net.ipv4.ip_local_port_range = 9000 65500 # Oracle-Validated setting for vm.min_free_kbytes is 51200 to avoid OOM killer vm.min_free_kbytes = 51200
热AI工具
Undresser.AI Undress
人工智能驱动的应用程序，用于创建逼真的裸体照片
AI Clothes Remover
用于从照片中去除衣服的在线人工智能工具。
Undress AI Tool
免费脱衣服图片
Clothoff.io
AI脱衣机
AI Hentai Generator
免费生成ai无尽的。
热门文章
热工具
记事本++7.3.1
好用且免费的代码编辑器
SublimeText3汉化版
中文版，非常好用
禅工作室 13.0.1
功能强大的PHP集成开发环境
Dreamweaver CS6
视觉化网页开发工具
SublimeText3 Mac版
神级代码编辑软件(SublimeText3)
oracle数据库日志会保存多久
May 10, 2024 am 03:27 AM
Oracle 数据库日志的保留期限取决于日志类型和配置，包括：重做日志：由 "LOG_ARCHIVE_DEST" 参数配置的最大大小决定。归档重做日志：由 "DB_RECOVERY_FILE_DEST_SIZE" 参数配置的最大大小决定。在线重做日志：不归档，在数据库重启时丢失，保留期限与实例运行时间一致。审计日志：由 "AUDIT_TRAIL" 参数配置，默认保留 30 天。
oracle中计算两个日期之间天数的函数
May 08, 2024 pm 07:45 PM
Oracle 中计算两个日期之间天数的函数是 DATEDIFF()。具体用法如下：指定时间间隔单位：interval（如 day、month、year）指定两个日期值：date1 和 date2DATEDIFF(interval, date1, date2) 返回天数差
oracle数据库启动步骤顺序为
May 10, 2024 am 01:48 AM
Oracle 数据库启动顺序为：1. 检查前置条件；2. 启动监听器；3. 启动数据库实例；4. 等待数据库打开；5. 连接到数据库；6. 验证数据库状态；7. 启用服务（如果需要）；8. 测试连接。
oracle中interval的用法
May 08, 2024 pm 07:54 PM
Oracle 中的 INTERVAL 数据类型用于表示时间间隔，语法为 INTERVAL <精度> <单位>，可使用加减乘除运算操作 INTERVAL，适用于存储时间数据、计算日期差值等场景。
oracle中某个字符出现的次数怎么看出来
May 09, 2024 pm 09:33 PM
要在 Oracle 中查找字符出现的次数，执行以下步骤：获取字符串的总长度；获取字符所在子字符串的长度；计算字符出现的次数：用总长度减去子字符串长度。
oracle数据库服务器硬件配置要求
May 10, 2024 am 04:00 AM
Oracle 数据库服务器硬件配置要求：处理器：多核，主频至少 2.5 GHz，大型数据库建议 32 核以上。内存：小型数据库至少 8GB，中等规模 16-64GB，大型数据库或高负载工作负载高达 512GB 或更多。存储：SSD 或 NVMe 磁盘，RAID 阵列提高冗余和性能。网络：高速网络（10GbE 或更高），专用网卡，低延迟网络。其他：稳定电源、冗余组件、兼容操作系统和软件、散热和冷却系统。
oracle需要多少内存
May 10, 2024 am 04:12 AM
Oracle 所需内存量取决于数据库大小、活动水平和所需性能水平：用于存储数据缓冲区、索引缓冲区、执行 SQL 语句和管理数据字典缓存。具体数量受数据库大小、活动水平和所需性能水平影响。最佳实践包括设置适当的 SGA 大小、调整 SGA 组件大小、使用 AMM 和监控内存使用情况。
oracle中替换字符串的方法
May 08, 2024 pm 07:24 PM
Oracle 中替换字符串的方法是使用 REPLACE 函数，该函数的语法为：REPLACE(string, search_string, replace_string)。使用步骤：1. 识别要替换的子字符串；2. 确定替换子字符串的新字符串；3. 使用 REPLACE 函数进行替换。高级用法包括：多个替换、大小写敏感、特殊字符替换等。
