Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 892
  • Last Modified:

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

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
kailash30
Asked:
kailash30
  • 4
  • 2
1 Solution
 
MikeOM_DBACommented:

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
 
MikeOM_DBACommented:
PS: Ignore typos.
0
 
kailash30Author Commented:
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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
MikeOM_DBACommented:
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
 
kailash30Author Commented:
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
 
MikeOM_DBACommented:

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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now