Hi all Guru's,

We have baan application with following configuration :

baan iv c4
service pack : 23
localization : is5
database : Oracle 10G 10.1.0.2.0

porting set : 6.1c.07.13 port number PA.3253

Can anybody provide me step by step procedure to upgrade database from Oracle 10g 10.1.0.2.0 to Oracle 10g 10.2.0.4. We are facing a lot of bugs/issue with current oracle rel1.

Thanks,

Abhinav
:confused:

See Doc id 316889.1 which can be found on metalink.

Thanks Han. I already have the document. It have 48 steps. I want 10.2.0.4 instalation on same server with different oracle home so that i will copy my data to new version & later on stop the services of old version. Please guide me how to achive this.

Thnaks again.

Basicly the steps are:

1. stop the service;
2. set your ORACLE_HOME and PATH to the right path (working on command level)
3. create a new service with oradim
4. start the service
5. startup the database with 'startup upgrade'
6. run the catupgr script

Depending on your hardware it should take you not more than about half an hour.
If the scripts tells you that all components are valid than your are done.

Advice you to run the script that oracle provides to check if you database is fit for upgrade (the script name is in the document). Also make sure that you have no invalid objects.

Regards,
Han