Topic : Upgradation

What is rolling upgrade?


Answer :

It is a new ASM feature from Database 11g.ASM instances in Oracle database 11g release(from 11.1) can be upgraded or patched using rolling upgrade feature. This enables us to patch or upgrade ASM nodes in a clustered environment without affecting database availability. During a rolling upgrade we can maintain a functional cluster while one or more of the nodes in the cluster are running in different software versions. Rolling upgrade can be used only for Oracle database 11g releases(from 11.1).

Show Answer Discuss

Steps to Upgrade in Oracle ?


Answer :

"Manual upgrade which involves the following steps:
1.Backup the database.
2.In UNIX/Linux environments; set the $ORACLE_HOME and $PATH variables to point to the new 11g Oracle home.
3.Analyze the existing instance using the ""$ORACLE_HOME/rdbms/admin/utlu111i.sql"" script.
4.Start the original database using the STARTUP UPGRADE command and proceed with the upgrade by running the ""$ORACLE_HOME/rdbms/admin/catupgrd.sql"" script.
5.Recompile invalid objects.
6.Restart the database.
7.Run the ""$ORACLE_HOME/rdbms/admin/utlu111s.sql"" script and check the result of the upgrade.
8.Troubleshoot any issues or abort the upgrade."

Show Answer Discuss

"What happens when you give ""STARTUP UPGRADE""?"


Answer :

"$sqlplus ""/as sysdba""
SQL> STARTUP UPGRADE
Note:
----
The UPGRADE keyword enables you to open a database based on an earlier Oracle Database release. It also restricts logons to AS SYSDBAsessions; disables system triggers; and performs additional operations that prepare the environment for the upgrade.
You might be required to use the PFILE option to specify the location of your initialization parameter file.
Once the database is started in upgrade mode; only queries on fixed views execute without errors until after the catupgrd.sql script is run. Before running catupgrd.sql; queries on any other view or the use of PL/SQL returns an error."

Show Answer Discuss

What is the difference between startup Upgrade and Migrate ?


Answer :

Startup migrate:
---------------
Used to upgrade a database till 9i.
Startup Upgrade
---------------
From 10G we are using startup upgrade to upgrade database.

Show Answer Discuss

What happens internally when you use startup upgrade/migrate?


Answer :

It will adjust few database (init) parameters (irrespective of what you have defined) automatically to certain values in order to run upgrade scripts smoothly. In other way..it will issue few alter statements to set certain parameters which are required to complete the upgrade scripts without any issues.

Show Answer Discuss