OCM_简化安装Oracle10.2.0.1.0以及升级为10.2.0.2.0
OCM_简化安装Oracle10.2.0.1.0以及升级为10.2.0.2.0
一，，这里主要使用Oracle-validated包来简化安装oracle软件的一些配置。
二，安装10.2.0.1.0的oracle数据库软件。
三，升级10.2.0.2.0的oracle数据库软件。
推荐阅读：
CentOS 6.3(x32)下安装Oracle 10g R2
Linux-6-64下安装Oracle 12C笔记
一、配置本地yum环境
1.创建介质装载目录/media/disk:
[root@ocm1 ~]# mkdir /media/disk
2.插入OEL DVD光盘
3.装载目录:
[root@ocm1 ~]# mount /dev/cdrom /media/disk/
mount: block device /dev/cdrom is write-protected, mounting read-only
[root@ocm1 ~]#
4. 创建yum 配置文件：
[root@ocm1 ~]# cd /etc/yum.repos.d/
[root@ocm1 yum.repos.d]# ll
total 0
[root@ocm1 yum.repos.d]# vi public-yum-el5.repo
[oel5]
name=Oracle Liunx server 5.4 i386 dvd
baseurl=file:///media/disk/Server/
gpgcheck=0
enabled=1
[root@ocm1 yum.repos.d]# cat public-yum-el5.repo
[oel5]
name=Oracle Liunx server 5.4 i386 dvd
baseurl=file:///media/disk/Server/
gpgcheck=0
enabled=1
二、安装oracle-validated软件包
5.正式安装oracle-validated软件包环境，使用yum install oracle-validated 命令:
使用oracle-validated包来配置oracle搭建所需的系统环境。
这个是oracle linux特有的包，减少大家在搭建oracle时安装各种系统包，调整系统参数，建用户和组等。
[root@ocm1 yum.repos.d]#yum install oracle-validated
Loaded plugins: security
oel5 | 1.1 kB 00:00
oel5/primary | 795 kB 00:00
oel5 2278/2278
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package oracle-validated.i386 0:1.0.0-18.el5 set to be updated
--> Processing Dependency: compat-gcc-34 for package: oracle-validated
--> Processing Dependency: libXp for package: oracle-validated
--> Processing Dependency: elfutils-libelf-devel for package: oracle-validated
--> Processing Dependency: libstdc++-devel for package: oracle-validated
--> Processing Dependency: libaio-devel for package: oracle-validated
--> Processing Dependency: gdb for package: oracle-validated
--> Processing Dependency: glibc-devel for package: oracle-validated
--> Processing Dependency: sysstat for package: oracle-validated
--> Processing Dependency: unixODBC for package: oracle-validated
--> Processing Dependency: kernel-headers for package: oracle-validated
--> Processing Dependency: glibc-headers for package: oracle-validated
--> Processing Dependency: unixODBC-devel for package: oracle-validated
--> Processing Dependency: gcc-c++ for package: oracle-validated
--> Processing Dependency: gcc for package: oracle-validated
--> Processing Dependency: compat-db for package: oracle-validated
--> Processing Dependency: compat-gcc-34-c++ for package: oracle-validated
--> Running transaction check
---> Package compat-db.i386 0:4.2.52-5.1 set to be updated
---> Package compat-gcc-34.i386 0:3.4.6-4 set to be updated
---> Package compat-gcc-34-c++.i386 0:3.4.6-4 set to be updated
---> Package elfutils-libelf-devel.i386 0:0.137-3.el5 set to be updated
--> Processing Dependency: elfutils-libelf-devel-static-i386 = 0.137-3.el5 for package: elfutils-libelf-devel
---> Package gcc.i386 0:4.1.2-46.el5 set to be updated
--> Processing Dependency: libgomp >= 4.1.2-46.el5 for package: gcc
---> Package gcc-c++.i386 0:4.1.2-46.el5 set to be updated
---> Package gdb.i386 0:6.8-37.el5 set to be updated
---> Package glibc-devel.i386 0:2.5-42 set to be updated
---> Package glibc-headers.i386 0:2.5-42 set to be updated
---> Package kernel-headers.i386 0:2.6.18-164.el5 set to be updated
---> Package libXp.i386 0:1.0.0-8.1.el5 set to be updated
---> Package libaio-devel.i386 0:0.3.106-3.2 set to be updated
---> Package libstdc++-devel.i386 0:4.1.2-46.el5 set to be updated
oel5/filelists | 2.3 MB 00:00
---> Package sysstat.i386 0:7.0.2-3.el5 set to be updated
---> Package unixODBC.i386 0:2.2.11-7.1 set to be updated
---> Package unixODBC-devel.i386 0:2.2.11-7.1 set to be updated
--> Running transaction check
---> Package elfutils-libelf-devel-static.i386 0:0.137-3.el5 set to be updated
---> Package libgomp.i386 0:4.4.0-6.el5 set to be updated
--> Finished Dependency Resolution
Dependencies Resolved
===============================================================================================
Package Arch Version Repository Size
===============================================================================================
Installing:
oracle-validated i386 1.0.0-18.el5 oel5 15 k
Installing for dependencies:
compat-db i386 4.2.52-5.1 oel5 1.7 M
compat-gcc-34 i386 3.4.6-4 oel5 4.1 M
compat-gcc-34-c++ i386 3.4.6-4 oel5 11 M
elfutils-libelf-devel i386 0.137-3.el5 oel5 24 k
elfutils-libelf-devel-static i386 0.137-3.el5 oel5 66 k
gcc i386 4.1.2-46.el5 oel5 5.2 M
gcc-c++ i386 4.1.2-46.el5 oel5 3.4 M
gdb i386 6.8-37.el5 oel5 3.4 M
glibc-devel i386 2.5-42 oel5 2.0 M
glibc-headers i386 2.5-42 oel5 614 k
kernel-headers i386 2.6.18-164.el5 oel5 1.0 M
libXp i386 1.0.0-8.1.el5 oel5 22 k
libaio-devel i386 0.3.106-3.2 oel5 11 k
libgomp i386 4.4.0-6.el5 oel5 70 k
libstdc++-devel i386 4.1.2-46.el5 oel5 2.9 M
sysstat i386 7.0.2-3.el5 oel5 170 k
unixODBC i386 2.2.11-7.1 oel5 830 k
unixODBC-devel i386 2.2.11-7.1 oel5 743 k
Transaction Summary
===============================================================================================
Install 19 Package(s)
Update 0 Package(s)
Remove 0 Package(s)
Total download size: 37 M
Is this ok [y/N]:y
Downloading Packages:
-----------------------------------------------------------------------------------------------
Total 2.2 GB/s | 37 MB 00:00
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : kernel-headers 1/19
Installing : glibc-headers 2/19
Installing : glibc-devel 3/19
Installing : libstdc++-devel 4/19
Installing : compat-gcc-34 5/19
Installing : unixODBC 6/19
Installing : compat-gcc-34-c++ 7/19
Installing : libXp 8/19
Installing : compat-db 9/19
Installing : sysstat 10/19
Installing : libgomp 11/19
Installing : gcc 12/19
Installing : gcc-c++ 13/19
Installing : gdb 14/19
Installing : unixODBC-devel 15/19
Installing : libaio-devel 16/19
Installing : elfutils-libelf-devel 17/19
Installing : elfutils-libelf-devel-static 18/19
Installing : oracle-validated 19/19
Installed:
oracle-validated.i386 0:1.0.0-18.el5
Dependency Installed:
compat-db.i386 0:4.2.52-5.1 compat-gcc-34.i386 0:3.4.6-4
compat-gcc-34-c++.i386 0:3.4.6-4 elfutils-libelf-devel.i386 0:0.137-3.el5
elfutils-libelf-devel-static.i386 0:0.137-3.el5 gcc.i386 0:4.1.2-46.el5
gcc-c++.i386 0:4.1.2-46.el5 gdb.i386 0:6.8-37.el5
glibc-devel.i386 0:2.5-42 glibc-headers.i386 0:2.5-42
kernel-headers.i386 0:2.6.18-164.el5 libXp.i386 0:1.0.0-8.1.el5
libaio-devel.i386 0:0.3.106-3.2 libgomp.i386 0:4.4.0-6.el5
libstdc++-devel.i386 0:4.1.2-46.el5 sysstat.i386 0:7.0.2-3.el5
unixODBC.i386 0:2.2.11-7.1 unixODBC-devel.i386 0:2.2.11-7.1
Complete!
更多详情见请继续阅读下一页的精彩内容：
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
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
1658
14
1415
52
1309
25
1257
29
1231
24
When might a full table scan be faster than using an index in MySQL?
Apr 09, 2025 am 12:05 AM
Full table scanning may be faster in MySQL than using indexes. Specific cases include: 1) the data volume is small; 2) when the query returns a large amount of data; 3) when the index column is not highly selective; 4) when the complex query. By analyzing query plans, optimizing indexes, avoiding over-index and regularly maintaining tables, you can make the best choices in practical applications.
Can I install mysql on Windows 7
Apr 08, 2025 pm 03:21 PM
Yes, MySQL can be installed on Windows 7, and although Microsoft has stopped supporting Windows 7, MySQL is still compatible with it. However, the following points should be noted during the installation process: Download the MySQL installer for Windows. Select the appropriate version of MySQL (community or enterprise). Select the appropriate installation directory and character set during the installation process. Set the root user password and keep it properly. Connect to the database for testing. Note the compatibility and security issues on Windows 7, and it is recommended to upgrade to a supported operating system.
MySQL: Simple Concepts for Easy Learning
Apr 10, 2025 am 09:29 AM
MySQL is an open source relational database management system. 1) Create database and tables: Use the CREATEDATABASE and CREATETABLE commands. 2) Basic operations: INSERT, UPDATE, DELETE and SELECT. 3) Advanced operations: JOIN, subquery and transaction processing. 4) Debugging skills: Check syntax, data type and permissions. 5) Optimization suggestions: Use indexes, avoid SELECT* and use transactions.
Can mysql and mariadb coexist
Apr 08, 2025 pm 02:27 PM
MySQL and MariaDB can coexist, but need to be configured with caution. The key is to allocate different port numbers and data directories to each database, and adjust parameters such as memory allocation and cache size. Connection pooling, application configuration, and version differences also need to be considered and need to be carefully tested and planned to avoid pitfalls. Running two databases simultaneously can cause performance problems in situations where resources are limited.
RDS MySQL integration with Redshift zero ETL
Apr 08, 2025 pm 07:06 PM
Data Integration Simplification: AmazonRDSMySQL and Redshift's zero ETL integration Efficient data integration is at the heart of a data-driven organization. Traditional ETL (extract, convert, load) processes are complex and time-consuming, especially when integrating databases (such as AmazonRDSMySQL) with data warehouses (such as Redshift). However, AWS provides zero ETL integration solutions that have completely changed this situation, providing a simplified, near-real-time solution for data migration from RDSMySQL to Redshift. This article will dive into RDSMySQL zero ETL integration with Redshift, explaining how it works and the advantages it brings to data engineers and developers.
The relationship between mysql user and database
Apr 08, 2025 pm 07:15 PM
In MySQL database, the relationship between the user and the database is defined by permissions and tables. The user has a username and password to access the database. Permissions are granted through the GRANT command, while the table is created by the CREATE TABLE command. To establish a relationship between a user and a database, you need to create a database, create a user, and then grant permissions.
Laravel Eloquent ORM in Bangla partial model search)
Apr 08, 2025 pm 02:06 PM
LaravelEloquent Model Retrieval: Easily obtaining database data EloquentORM provides a concise and easy-to-understand way to operate the database. This article will introduce various Eloquent model search techniques in detail to help you obtain data from the database efficiently. 1. Get all records. Use the all() method to get all records in the database table: useApp\Models\Post;$posts=Post::all(); This will return a collection. You can access data using foreach loop or other collection methods: foreach($postsas$post){echo$post->
MySQL: The Ease of Data Management for Beginners
Apr 09, 2025 am 12:07 AM
MySQL is suitable for beginners because it is simple to install, powerful and easy to manage data. 1. Simple installation and configuration, suitable for a variety of operating systems. 2. Support basic operations such as creating databases and tables, inserting, querying, updating and deleting data. 3. Provide advanced functions such as JOIN operations and subqueries. 4. Performance can be improved through indexing, query optimization and table partitioning. 5. Support backup, recovery and security measures to ensure data security and consistency.
