Shulou(Shulou.com)06/01 Report--

Upgrading from oracle for windows 11.2.0.1 to 11.2.0.4 is simple, but there are still a lot of details to pay attention to, otherwise there may be unpredictable disasters.

There are two ways to upgrade oracle for windows 11.2.0.1 to 11.2.0.4. One is off-machine upgrade, which involves database backup. You can use expdp and rman; II.

It is a local upgrade, and you should also make a database backup to prevent fallback after upgrade failure. This blog records a local upgrade process of oracle database, for reference only, if there is any improper connection

Be corrected.

Environment:

Operating system version: windows server 2008R2

Original version of database: oracle 11.2.0.1

Database upgrade version: oracle 11.2.0.4

Upgrade process:

1. Basic check of database server and database information

2. Backup before database upgrade

3. Pre-upgrade processing of database

4. Install the new version of database software

5. Use dbua to upgrade the database

6. Check the database components and invalid objects after upgrade

7. Accept business access verification

Upgrade record

1. Basic check of database server and database information

-- View operating system disk space

-- View host-level database snooping and database service status

-- check the database alarm log to make sure you don't upgrade with disease.

-- View the status of each component of the database

-- View invalid objects in the database, not less than after upgrade, to avoid unnecessary tearing

2. Backup before database upgrade

-- this oracle 11.2.0.1 to 11.2.0.4 upgrade is a local upgrade without rebuilding the library, and the downtime window is long enough, so use expdp logical backup, standby command.

Expdp\ "/ AS SYSDBA\" directory=zhul dumpfile=expdp_orcl_full_20180117_%U.dmp logfile=expdp_orcl_full_20180117.log

Filesize=80g parallel=4 full=y

-- backup the operating system path variable. The upgrade operation will modify the path variable, resulting in abnormal connection of other oracle clients on the server.

-- backup parameter files and control files

3. Pre-upgrade processing of database

-- processing the database recycle bin

-- handle invalid objects. If they cannot be compiled, they will still be invalid after upgrade.

-- query database non-default parameters, especially hidden parameters, which will be deleted when upgrading

Col name for a20

Col value for a40

Select num,name,value FROM V$PARAMETER where isdefault='FALSE'

4. Install the new version of database software

The installation of the new version of the database software is basically the next step

If you don't have a metalink account, you need to cancel "I hope" and then leave the email.

-- if there is no metalink, and the database is not connected to the external network on the intranet, the software update will be skipped.

-- Select the installation type of database software: single instance

-- because it is a local database upgrade, no library is built: only the database software is installed

-- check after the new version of the software is installed

5. Use dbua to upgrade the database

-- cmd dbua calls database upgrade agent

-- deal with the database according to the advice of the assistant before upgrading, have been processed and skipped, click the previous step, and then click the next step in the next figure.

-- because it is an in-situ upgrade, the database files are not moved during the upgrade process.

-- it is best to specify the flashback zone for database upgrade. The flashback zone is larger and faster.

-- upgrade summary, it is necessary to save

-- start the upgrade

-- as a result of the upgrade, the EM upgrade failed. It is not recommended to enable EM in the production library. If you really need it, you can rebuild it.

6. Check the database components and invalid objects after upgrade

-- View database monitoring

-- View database components

-- View invalid objects, reduced from 41 to 38, no increase

-- View database instance status

7. Accept business access verification

Upgrade completed

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.