| upgrade to 9i [message #63319] |
Mon, 27 September 2004 08:43  |
sidd
Messages: 130
Registered: May 2003
|
Senior Member |
|
|
|
We are using oracle 8i on unix machine b1 on this 8i we have some databases, say a, b, c databases created and we want to upgrade to only one database to 9i say a. I know it is possible. But is that means I have to install 9i on diff unix box? Or can I run 9i and 8i on same <st1:address><st1:Street>box</st1:Street> b1</st1:address> at same time? And also if anyone can provide me the high level doc about what is involved in upgrading to 9i.
|
|
|
|
| Re: upgrade to 9i [message #63320 is a reply to message #63319] |
Mon, 27 September 2004 09:03  |
Madhu
Messages: 36
Registered: April 2001
|
Member |
|
|
|
you can install 9i on same box , that will put oracle software in different directory i.e., if ora8i_home ends with 8.1.7 ora9i_home will ends with 9.0 ( or whatever) version
|
|
|
|
|
|
| Re: upgrade to 9i [message #63323 is a reply to message #63319] |
Mon, 27 September 2004 11:44 |
croK
Messages: 170
Registered: April 2002
|
Senior Member |
|
|
You can install several oracle software on same server.
Besides, if you plan to migrate oracle 8i db to 9i, it is imperative that oracle9i be installed on same server.
Migration documentation is provided along with Oracle9i Server Installation Media.
Best regards.
Oracle Consultant for hire.
|
|
|
|
| Re: upgrade to 9i [message #63330 is a reply to message #63321] |
Mon, 27 September 2004 20:03 |
TANMAIYEE
Messages: 5
Registered: September 2004
|
Junior Member |
|
|
|
yes you can run as many instances of 9i and 8i provided the machine has good CPU powe and adequate Memory. Typically sum of SGAs of all instances <= 75% of phyiscal memory. You must have installed 9i and 8i software in separate oracle homes (ORACLE_HOME such as /.../8.1.7 & /...9.2/). For Non-RAC, instance = database = ORALCE_SID. These 2 variables determine the the db version and the database(instance) you are currently in. For this type of configurations, manual upgrade process works better for migration
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
