打Oracle 10.2.0.3.0補丁前安裝了資料庫,需要執行以下步驟Upgrade資料庫
如果在打Oracle 10.2.0.3.0補丁前安裝了資料庫,資料庫開啟時會報錯,需要執行以下步驟Upgrade資料庫。
7.2.2.2 Upgrading a Release 10.2 Database
After you install the patch set, you must perform. the following steps on every database associated with the upgraded Oracle home:
Note:
If you do not run the catupgrd.sql script. as described in this section and you start up a database for normal operation, then ORA-01092:ORACLE instance terminated. Disconnection forced errors will occur and the error ORA-39700:database must be opened with UPGRADE option will be in the alert log.
1.
Log in as the Oracle software owner user.
2.
For Oracle RAC installations, start listener on each node of the cluster as follows:
$ srvctl start listener -n node
3.
If you are using Automatic Storage Management, start the Automatic Storage Management instance.
4.
For single-instance installations, start the listener as follows:
$ lsnrctl start
5.
For single-instance installations, use SQL*Plus to log in to the database as the SYS user with SYSDBA privileges:
$ sqlplus /nolog
SQL> CONNECT SYS/SYS_password AS SYSDBA
6.
For Oracle RAC installations:
1.
Use SQL*Plus to log in to the database as the SYS user with SYSDBA privileges:
$ sqlplus /nolog
SQL> CONNECT SYS/SYS_password AS SYSDBA
SQL> STARTUP NOMOUNT
2.
Set the CLUSTER_DATABASE initialization parameter to FALSE:
SQL> ALTER SYSTEM SET CLUSTER_DATABASE=FALSE SCOPE=spfile;
3.
Shut down the database:
SQL> SHUTDOWN
7.
Enter the following SQL*Plus commands:
SQL> STARTUP UPGRADE
SQL> SPOOL patch.log
SQL> @?/rdbms/admin/catupgrd.sql
SQL> SPOOL OFF
8.
Review the patch.log file for errors and inspect the list of components that is displayed at the end of catupgrd.sql script.
This list provides the version and status of each SERVER component in the database.
9.
If necessary, rerun the catupgrd.sql script. after correcting any problems.
10.
Restart the database:
SQL> SHUTDOWN
SQL> STARTUP
11.
Run the utlrp.sql script. to recompile all invalid PL/SQL packages now instead of when the packages are accessed for the first time. This step is optional but recommended.
SQL> @?/rdbms/admin/utlrp.sql
Note:
When the 10.2.0.3 patch set is applied to an Oracle Database 10g Standard Edition database, there may be 42 invalid objects after the utlrp.sql script. runs. These objects belong to the unsupported components and do not affect the database operation.
Ignore any messages indicating that the database contains invalid recycle bin objects similar to the following:
BIN$4lzljWIt9gfgMFeM2hVSoA==$0
12.
If you are using the Oracle Recovery Manager catalog, enter the following command:
$ rman catalog username/password@alias
RMAN> UPGRADE CATALOG;
13.
For Oracle RAC installations:
1.
Set the CLUSTER_DATABASE initialization parameter to TRUE:
SQL> ALTER SYSTEM SET CLUSTER_DATABASE=TRUE SCOPE=spfile;
2.
Restart the database:
SQL> SHUTDOWN
SQL> STARTUP
3.
Start any processes that you want to use:
$ srvctl start service -d db_name -s service_name
7.2.2.2 Upgrading a Release 10.2 Database
After you install the patch set, you must perform. the following steps on every database associated with the upgraded Oracle home:
Note:
If you do not run the catupgrd.sql script. as described in this section and you start up a database for normal operation, then ORA-01092:ORACLE instance terminated. Disconnection forced errors will occur and the error ORA-39700:database must be opened with UPGRADE option will be in the alert log.
1.
Log in as the Oracle software owner user.
2.
For Oracle RAC installations, start listener on each node of the cluster as follows:
$ srvctl start listener -n node
3.
If you are using Automatic Storage Management, start the Automatic Storage Management instance.
4.
For single-instance installations, start the listener as follows:
$ lsnrctl start
5.
For single-instance installations, use SQL*Plus to log in to the database as the SYS user with SYSDBA privileges:
$ sqlplus /nolog
SQL> CONNECT SYS/SYS_password AS SYSDBA
6.
For Oracle RAC installations:
1.
Use SQL*Plus to log in to the database as the SYS user with SYSDBA privileges:
$ sqlplus /nolog
SQL> CONNECT SYS/SYS_password AS SYSDBA
SQL> STARTUP NOMOUNT
2.
Set the CLUSTER_DATABASE initialization parameter to FALSE:
SQL> ALTER SYSTEM SET CLUSTER_DATABASE=FALSE SCOPE=spfile;
3.
Shut down the database:
SQL> SHUTDOWN
7.
Enter the following SQL*Plus commands:
SQL> STARTUP UPGRADE
SQL> SPOOL patch.log
SQL> @?/rdbms/admin/catupgrd.sql
SQL> SPOOL OFF
8.
Review the patch.log file for errors and inspect the list of components that is displayed at the end of catupgrd.sql script.
This list provides the version and status of each SERVER component in the database.
9.
If necessary, rerun the catupgrd.sql script. after correcting any problems.
10.
Restart the database:
SQL> SHUTDOWN
SQL> STARTUP
11.
Run the utlrp.sql script. to recompile all invalid PL/SQL packages now instead of when the packages are accessed for the first time. This step is optional but recommended.
SQL> @?/rdbms/admin/utlrp.sql
Note:
When the 10.2.0.3 patch set is applied to an Oracle Database 10g Standard Edition database, there may be 42 invalid objects after the utlrp.sql script. runs. These objects belong to the unsupported components and do not affect the database operation.
Ignore any messages indicating that the database contains invalid recycle bin objects similar to the following:
BIN$4lzljWIt9gfgMFeM2hVSoA==$0
12.
If you are using the Oracle Recovery Manager catalog, enter the following command:
$ rman catalog username/password@alias
RMAN> UPGRADE CATALOG;
13.
For Oracle RAC installations:
1.
Set the CLUSTER_DATABASE initialization parameter to TRUE:
SQL> ALTER SYSTEM SET CLUSTER_DATABASE=TRUE SCOPE=spfile;
2.
Restart the database:
SQL> SHUTDOWN
SQL> STARTUP
3.
Start any processes that you want to use:
$ srvctl start service -d db_name -s service_name
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/11411056/viewspace-733376/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 【UP_ORACLE】如何給Oracle DG打補丁(二)備庫安裝補丁步驟Oracle
- 【UP_ORACLE】如何給Oracle DG打補丁(三)主庫安裝補丁步驟Oracle
- Oracle 檢查當前資料庫CPU和PSU補丁資訊Oracle資料庫
- 「Oracle」Oracle 資料庫安裝Oracle資料庫
- docker 安裝執行mysql資料庫DockerMySql資料庫
- Oracle 資料庫打包安裝Oracle資料庫
- oracle rac資料庫的安裝Oracle資料庫
- vgant 安裝oracle資料庫racOracle資料庫
- MySQL資料庫安裝步驟-WindowsMySql資料庫Windows
- EBS:Oracle 資料庫執行慢SQLOracle資料庫SQL
- Oracle 12c資料庫安裝Oracle資料庫
- Oracle資料庫啟動步驟Oracle資料庫
- Oracle 資料庫執行提示:ORA-00054Oracle資料庫
- 自動同步整個 MySQL/Oracle 資料庫以進行資料分析MySqlOracle資料庫
- kubernetes-部署Oracle資料庫步驟Oracle資料庫
- Magento2 安裝外掛 upgrade 後資料庫沒有新建表資料庫
- Oracle資料庫SQL語句執行過程Oracle資料庫SQL
- 靜默安裝Oracle11g資料庫Oracle資料庫
- 靜默安裝Oracle資料庫11gOracle資料庫
- 使用RPM安裝ORACLE-21c資料庫Oracle資料庫
- 使用RPM安裝ORACLE-19c資料庫Oracle資料庫
- MongoDB資料庫安裝MongoDB資料庫
- Redis 資料庫安裝Redis資料庫
- oricle資料庫安裝資料庫
- GreenPlum資料庫安裝資料庫
- PostgreSQL 資料庫學習 - 0. 資料庫安裝SQL資料庫
- 靜默方式安裝、升級oracle(三): 升級資料庫軟體及資料庫Oracle資料庫
- oracle資料庫使用者建立步驟Oracle資料庫
- Ubuntu 16.04下安裝資料庫Oracle客戶端Ubuntu資料庫Oracle客戶端
- Oracle 11G資料庫單例項安裝Oracle資料庫單例
- CentOS7 安裝Oracle12c資料庫CentOSOracle資料庫
- Ubuntu安裝MySQL資料庫UbuntuMySql資料庫
- tar方式安裝資料庫資料庫
- 達夢資料庫安裝資料庫
- Hbase資料庫安裝部署資料庫
- Pre-Upgrade Utility---下載並執行Oracle資料庫預升級實用程式 (文件 ID 1577379.1)Oracle資料庫
- oracle打補丁回顧Oracle
- Oracle資料庫-----資料庫的基本概念Oracle資料庫
- oracle 備份資料庫,匯出資料庫Oracle資料庫