Skip to Main Content

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Xquery builder in 11G

803630Dec 13 2010 — edited Dec 13 2010
Hello,

Where is the xquery builder is 11g? I am not able to find.

Thanks.
This post has been answered by Anuj Dwivedi-Oracle on Dec 13 2010
Jump to Answer

Comments

FreddieEssex
Hi,

This is a pretty straight forward upgrade from 11.2.0.2 to 11.2.0.3. You can use the same 11.2.0.3 binaries that are already there or if you want/need then create a separate ORACLE_HOME for your new database.

The upgrade will be transparent to your other 11.2.0.3 databases on the cluster.

What is your question..or did I miss it?
User321378
Dear Freddie,

Thanks for your comments.
do we have any standard procedures, we need to follow for upgrading in 11.2.0.2 to 11.2.0.3?
i have done many standalone DB upgrades , havent done any any cluster DB upgrade. so i dont want to miss out any steps?

please let me know what steps i should follow?
FreddieEssex
Hi,

Use DBUA to make your life easier if you haven't done this before. Presumably your ASM and CRS are already at 11.2.0.3.

From memory, if you are doing an manual upgrade then it's not much different to doing a standalone upgrade.

You set cluster_database=false first, run through the steps and then set cluster_database=true at the end.

You will also need to update the oracle_home for this database to the new home in CRS using:
srvctl upgrade database -d <db_name> -o <oracle_home>
You need to confirm the steps by reading the docs at http://www.oracle.com/pls/db112/portal.portal_db?selected=11&frame=

Also see:
http://docs.oracle.com/cd/E11882_01/install.112/e24660/racinstl.htm#BABJGBHB
http://docs.oracle.com/cd/E11882_01/server.112/e10819/upgrade.htm#BABCEGBC
1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jan 10 2011
Added on Dec 13 2010
5 comments
253 views