【upgrade】oracle10.2.0.1.0升級10.2.0.5.0 for linux

Oracle upgrade version: 10.2.0.1.0à10.2.0.5.0 for Oracle Linux Server release 6.4

1. 檢查資料庫狀態與版本資訊：

[oracle@sam ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Dec 27 15:40:46 2013

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production

With the Partitioning, OLAP and D

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi

PL/SQL Release 10.2.0.1.0 - Production

CORE 10.2.0.1.0 Production

TNS for Linux: Version 10.2.0.1.0 - Production

NLSRTL Version 10.2.0.1.0 – Production

SQL> select open_mode from v$database;

OPEN_MODE

----------

READ WRITE

2. 關閉資料庫：

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL>

3. 對資料庫軟體進行備份

tar -zcvf /10g/app/oracle/product/10.2.0/dbhome_1.tar /10g/app/oracle/product/10.2.0/*

4. 安裝 Oracle 10.2.0.5.0 軟體：

[oracle@test Disk1]$ ./runInstaller

Starting Oracle Universal Installer...

Checking installer requirements...

Checking operating system version: must be redhat-3, SuSE-9, SuSE-10, redhat-4, redhat-5, redhat-6, UnitedLinux-1.0, asianux-1, asianux-2, asianux-3, enterprise-4, enterprise-5 or SuSE-11

Passed

All installer requirements met.

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2013-12-27_03-51-42PM. Please wait ...[oracle@test Disk1]$ Oracle Universal Installer, Version 10.2.0.5.0 Production

此報錯處理方法，有程式未關閉，重啟動再安裝不出現此報錯。

5. 執行root.sh指令碼（使用者root執行）：

[root@test ~]# /10g/app/oracle/product/10.2.0/dbhome_1/root.sh

Running Oracle 10g root.sh script...

The following environment variables are set as:

ORACLE_OWNER= oracle

ORACLE_HOME= /10g/app/oracle/product/10.2.0/dbhome_1

Enter the full pathname of the local bin directory: [/usr/local/bin]:

The file "dbhome" already exists in /usr/local/bin. Overwrite it? (y/n)

[n]:

The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n)

[n]:

The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n)

[n]:

Entries will be added to the /etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root.sh script.

Now product-specific root actions will be performed.

[root@test ~]#

6. 升級資料字典：

[oracle@test ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.5.0 - Production on Mon Dec 27 17:50:44 2013

Connected to an idle instance.

SQL> startup upgrade;

ORACLE instance started.

Total System Global Area 419430400 bytes

Fixed Size 2096728 bytes

Variable Size 121635240 bytes

Database Buffers 289406976 bytes

Redo Buffers 6291456 bytes

Database mounted.

Database opened.

SQL> spool /tmp/upgrade.log

SQL> @?/rdbms/admin/catupgrd.sql

..........日誌略過，完成後可以檢視/tmp/upgrade.log日誌檔案

SQL> select instance_name,status from v$instance;

INSTANCE_NAME STATUS

---------------- ------------

OCM10G OPEN MIGRATE

7. 重新啟動到OPEN狀態並檢查版本資訊：

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area 419430400 bytes

Fixed Size 2096728 bytes

Variable Size 171966888 bytes

Database Buffers 239075328 bytes

Redo Buffers 6291456 bytes

Database mounted.

Database opened.

SQL> select instance_name,status from v$instance;

INSTANCE_NAME STATUS

---------------- ------------

OCM10G OPEN

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi

PL/SQL Release 10.2.0.5.0 - Production

CORE 10.2.0.5.0 Production

TNS for Linux: Version 10.2.0.5.0 - Production

NLSRTL Version 10.2.0.5.0 - Production

SQL>

到此升級到此結束，後繼還將分享OPatch打補丁方法。

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/26148431/viewspace-1066641/，如需轉載，請註明出處，否則將追究法律責任。

【upgrade】oracle10.2.0.1.0升級10.2.0.5.0 for linux

相關文章