Upgrade Oracle10.2.0.1.0 to 10.2.0.4.0 on LinuxAS4

Source: Internet
Author: User
When I got to the server, I tried it. I simply recorded the installation and upgrade process. I also learned from the experts how to install LinuxAS4.7. When I chose LVM

When I got to the server, I tried it. I simply recorded the installation and upgrade process. I also learned from the experts that when installing Linux AS 4.7, I chose LVM.

The new server gave me a try. I simply recorded the installation and upgrade process and learned from the experts.

When installing Linux AS 4.7, you can choose LVM to easily manage the space, increase or reduce the size of the file system, and choose to install all the services at the end of the installation, select the services to install. After the services are installed, the sendmail service is disabled, which may affect the server very much.

Installing Oracle 10 Gb is very easy. After setting the relevant parameters, you can directly install it. There is no problem, but you may encounter the following problems during the upgrade:

Problem 1: An error occurred while upgrading the oracle database. After reading the instructions in English, you must stop all oracle-related services:

$ Emctl stop dbconsole

$ Isqlplusctl stop

$ Lsnrctl stop

Shut down all database instances running in the Oracle home directory, where you need to install the patch set.

You can upgrade the service after you stop it.

Problem 2: After the upgrade, found that the normal startup, startup error: ora-01902 instance termination, force close connection, view the trace file, only to find that the original upgrade to start like this:

SQL> STARTUP UPGRADE

Run the following two scripts:

SQL> @? /Rdbms/admin/utlu102i. SQL

SQL> @? /Rdbms/admin/catupgrd. SQL

After the restart, the system returns to normal.

This article comes from:

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.