Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Upgrade OneSAP Oracle DB from 9i to 10g Using DBUA

Posted on 2008-06-23
8
Medium Priority
?
888 Views
Last Modified: 2013-12-18
Hi,
We will be doing upgradation Using DBUA.
Is there any document to upgrade OneSAP Oracle DB from 9i to 10g. Database is around 2 terabyte.
I would like to know how many man hours it will take?

Regards,
Kailash
0
Comment
Question by:kailash30
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
8 Comments
 
LVL 29

Accepted Solution

by:
MikeOM_DBA earned 2000 total points
ID: 21857695

I have done several upgrade of SAP databases from 9i to 10g and it will take from 4 to 12 hours.
Check the SAP 10g upgrade instructions, you will need to applly some 20+ patches before upgrade.
Also DO NOT USE dbua, do manually using sqlplus:

STARUP UPGRADE PFILE=initdb10g.ora
@?/rdbms/admin/catupgrd.sql

Open in new window

0
 
LVL 29

Expert Comment

by:MikeOM_DBA
ID: 21857709
PS: Ignore typos.
0
 

Author Comment

by:kailash30
ID: 21864288
Hi Mike,
Can you please elaborate on the same.
where can i get the SAP 10g upgrade instructions?
For what the following sql is useful
STARUP UPGRADE PFILE=initdb10g.ora
@?/rdbms/admin/catupgrd.sql

what patches we need to apply ...? is it mentioned in the SAP 10G Upgrade instrucions doc in details?
Please let me know.

Regards,
Kailash
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 29

Expert Comment

by:MikeOM_DBA
ID: 21865589
You get the SAP 10g upgrade instructions from SAP support site.

The STARTUP UPGRADE PFILE=initdb10g.ora is the statement which dbua executes.
The initdb10g.ora is the 10g init.ora file you must prepare with 10g parameters.
All the patches you need to apply are stated in the SAP 10g upgrade instructions which is very very detailed, in fact there are some SAP tasks you will need to perform also.


0
 

Author Comment

by:kailash30
ID: 21872907
Hi Mike,

As you have done the SAN DB upgrade already, do you have the "SAP 10g upgrade instructions " , if you can send it to me then it would be great help for me.
As i am from offshore support i dont have direct access to SAP support.
Please send the document if possible,
may be on my email id :-  shndmlnd@gmail.com
if you have any more suggestions then please let me know.

Regards,
Kailash
0
 
LVL 29

Expert Comment

by:MikeOM_DBA
ID: 21875226

Sorry I only had a hard-copy and discarded it after upgrade.
You need to get it from the client or whomever owns the SAP database.

0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This video shows how to recover a database from a user managed backup
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

722 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question