ORA-01092: Oracle instance terminated disconnection
ORA-00740: bootstrap process failure.
ORA-39700: database must be opened with Upgrade Option
A few days ago, I upgraded the RedHat Linux as4 + oracle10.2.0.1 from p6810189_10204_linux-x86.zip of Oracle's new kernel to 10.2.0.4. Then, I couldn't open the database and got an error:
Alterlog has the following content:
ORA-39700: database must be opened with Upgrade Option
Thu Feb 28 23:02:49 2008
Error 704 happened during dB open, shutting down Database
User: Terminating instance due to error 704.
Instance terminated by user, pid = 1635
ORA-1092 signalled during: Alter database open...
Follow the prompts, SQL> startup update
The database can be opened and the operation is normal.
However, if the preceding error is still reported after the database is restarted, you must add the update parameter to enable it.
Method 1)
After the database is upgraded, the data dictionary content is modified. You need to run the catalog. SQL and catproc. SQL scripts to update the data dictionary.
The solution is as follows:
SQL> startup upgrade;
SQL> @ ORACLE_HOME \ rdbms \ admin \ catupgrd. SQL;
This script will be executed for a long time. I spent 22 minutes on the VM.
Total Upgrade Time: 00:21:58
After the execution is complete, close the database and start the database in normal mode.
Run the utlrp. SQL script to re-compile some invalid objects.
SQL> startup
SQL> @ ORACLE_HOME \ rdbms \ admin \ utlrp. SQL;
...
OBJECTS WITH ERRORS
-------------------
0
...
ERRORS DURING RECOMPILATION
Method 2: Use the migrate startup option and execute the last SQL statement.
There are two steps to upgrade: Install the upgrade package and upgrade the database.
Steps for upgrading a database:
1. sqlplus logon/as sysdba
2. Confirm the version: select * from v $ version
3. shutdown immediate and then startup migrate (Migration Mode)
4. Run the DB patch script to upgrade the database: SQL> @ $ ORACLE_HOME/rdbms/admin/catpatch. SQL
Method 3 use graphical tools
. 3.1 upgrading a release 10.2 database using Oracle Database Upgrade Assistant
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 Oracle Database Upgrade Assistant as described in this section, then the following errors are displayed: ORA-01092: ORACLE instance terminated.
ORA-39700: database must be opened with UPGRADE option.
|
Log in as the Oracle software owner user.
Set the values for the environment variables$ORACLE_HOME
,$ORACLE_SID
And$PATH
.
For single-instance installations, if you are using Automatic Storage Management, start the Automatic Storage Management instance.
For Oracle single-instance installations, startlistener
As follows:
$ lsnrctl start
Run Oracle Database Upgrade Assistant either in the interactive or noninteractive mode:
Interactive mode:
Enter the following command from the command prompt:
$ dbua
Complete the following steps displayed in the Oracle Database Upgrade Assistant screen:
On the Welcome screen, click Next.
On the Databases screen, select the name of the Oracle Database that you want to update, then click Next.
Note: For Oracle RAC, enterSYS Password to do the upgrade. |
On the Recompile Invalid Objects screen, select the Recompile the invalid objects at the end of upgrade option, then click Next.
If you have not taken the back up of the database earlier, onBackup
Screen, select the I wowould like to take this tool to backup the database option, stipulate the Path, then click Next.
On the Summary screen, check the summary, then click Finish.
On the End of Database Upgrade Assistant's Upgrade Results screen, click Close to exit from Oracle Database Upgrade Assistant.
Note: If you are upgrading a database having dbcontrol configured in non-secure mode, after upgrade dbconsole will run in secure mode. |
Noninteractive mode:
Enter the following command to upgrade Oracle Database using Oracle Database Upgrade Assistant in noninteractive mode:
$ dbua -silent -dbname $ORACLE_SID -oracleHome $ORACLE_HOME -sysDBAUserName UserName -sysDBAPassword SYS_password -recompile_invalid_objects true
If you are using the Oracle Recovery Manager catalog, enter the following command:
$ rman catalog username/password@aliasRMAN> UPGRADE CATALOG;
For Oracle RAC installations, start any database services that you want to use by entering the following command:
$ srvctl start service -d db_name -s service_name