Skip to Content
Former Member
Jan 09, 2009 at 03:40 AM

upgrade ora 9i to 10g



I am having problem in database upgrade from 9i to 10g.

I started DBUA (database upgrade assistant) and and my 9i database was down .THe DBUA poped up to inform that the DB is not available.

I stated the database and continued the upgrade.Then it prompted that the shared_pool_size is to be increased.I stopped upgrade assistant and made changes in the initsid.ora file and stated the and restated the DBUA.

now the whenever the dbua is stated by me it is giving a message that the

1 ."you dont have operating system authentication and specify a user with sysdba privilegde."

Initially it never asked for user id and password.

Then I give the user id and password and press next

it gives an error

2 ."the oracle home /oracle/C11/920_64 for database "C11" does not exist"

Please note that the existing database and sap is working fine without any problem but DBUA is giving error 1&2.

Please help to resolve this issue.

Kind Regards