【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
Copyright (c) 1982, 2005, Oracle. All rights reserved.
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
Copyright (C) 1999, 2010, Oracle. All rights reserved.
此報錯處理方法,有程式未關閉,重啟動再安裝不出現此報錯。
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
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- centos7-kernel-upgrade-核心升級CentOS
- 使用 nuxi upgrade 升級現有nuxt專案版本UX
- upgrade 10.2.0.5 to 11.2.0.4 on linuxLinux
- 【UPGRADE】升級到Oracle18c基本步驟參考(留存)Oracle
- Linux升級GCCLinuxGC
- Linux核心升級Linux
- Linux openssh升級8.0Linux
- kali linux升級記Linux
- linux下使用yum upgrade軟體包Linux
- 安裝升級Linux GCC版本LinuxGC
- Linux CentOS升級安裝gitLinuxCentOSGit
- 如何升級 Linux Mint 19.1 為 Linux Mint 19.2Linux
- Ubuntu 16.04 升級Linux 系統核心UbuntuLinux
- [轉載]Linux/Mac go版本升級LinuxMacGo
- 【Linux Ops】如何無痛升級 glibcLinux
- Linux環境下如何升級openssl?Linux
- Linux提權-許可權升級Linux
- Linux核心C語言將升級LinuxC語言
- linux 中 yum makecache 、yum update、yum upgrade的作用Linux
- linux伺服器PHP升級到7Linux伺服器PHP
- Linux 核心準備升級到 Rust 1.77LinuxRust
- Linux平滑編譯升級php至5.5.0Linux編譯PHP
- helm upgrade
- Pre-Upgrade Utility---下載並執行Oracle資料庫預升級實用程式 (文件 ID 1577379.1)Oracle資料庫
- Nacos 爆重大 Bug!!不要升級,不要升級,不要升級
- 11.2.0.4 upgrade to 19.3.0.0
- 2.3.3.3 Application UpgradeAPP
- Truffle 2.0升級3.0升級指南
- glibc 升級導致Linux顯示中文亂碼Linux
- linux openssl升級-從OpenSSL1.0.2K-1.1.1iLinux
- Linux系統安裝及升級kangle+EasyPanelLinux
- 在Linux中,如何進行系統更新和升級?Linux
- 寶塔Linux皮膚最新升級版安裝教程Linux
- oracle 10 rac 升級 10.2.0.1升級到10.2.0.5Oracle
- (十二).NET6 + React :升級!升級!還是***升級!!!+ IdentityServer4實戰ReactIDEServer
- Nginx升級Nginx
- ES升級
- Jenkins升級Jenkins
- 升級pythonPython