Home » RDBMS Server » Server Administration » upgrade
upgrade [message #290113] Thu, 27 December 2007 08:49 Go to next message
maoro
Messages: 310
Registered: May 2005
Senior Member
hello
we have an oracle 9.2.0.10 on a windows server 2000, with a database named alfa in c:\ora9i as home directory;
we are planing to upgrade to oracle 10g R2
we installed the 10g server in c:\10g on the same windows 200 server

we are planing to use export import in order to upgrade
is it possible to create a database under 10g named also alfa and
import to it ?
we dont want to create a database with a different name , cause database name might be hard coded in the application
in case of yes: please how to do so
any suggestions are really welcomed
thanks

Re: upgrade [message #290114 is a reply to message #290113] Thu, 27 December 2007 09:16 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
The database names can be the same, however, you cannot have two databases with the same SIDs on a single system.

Best would be to create two databases with different SIDs and rename them after the data migration. The following "oradim" options may help: -EDIT -SID and -NEWSID. For details, see http://www.orafaq.com/wiki/Creating_an_Oracle_service_on_Windows
Re: upgrade [message #290137 is a reply to message #290114] Thu, 27 December 2007 10:53 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Copy Pfile or Spfile to new ORACLE_HOME/dbs folder.

step1:
Set Oracle_Home and sid of 9i database.

Delete your existing service by ORADIM command as

C:\oradim - delete -sid sidname

Step2 :
Set You ORACLE_HOME as 10g

create the service as mentioned by FRANK.

You have other option as well.

Backup you database .
drop database.
create new database in 10g with same name and then import.

NOTE: Must try it on test 1st.
Re: upgrade [message #290953 is a reply to message #290137] Wed, 02 January 2008 05:06 Go to previous message
maoro
Messages: 310
Registered: May 2005
Senior Member
thanks a lot
Previous Topic: ORACLE Reports not working after switch from RBO to CBO (9i DB)
Next Topic: Increasing the value of sessions and processess.
Goto Forum:
  


Current Time: Wed Dec 07 22:45:59 CST 2016

Total time taken to generate the page: 0.13124 seconds