473,574 Members | 2,655 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Questions about Oracle 9i Upgrade

If I want to upgrade the following system :

(1) Oracle 8i RDBMS
(2) Oracle Finance 11.5.2

to :

(1) Oracle 9i RDBMS
(2) Oracle Finance 11.5.8

I have the following questions :
(1) What will the "upgrade" process actually do ? Install a new Oracle 9i
instance and then copy all the records to it from the existing 8i ? Or the
9i CD can detect the 8i automatically and then upgrade it and all the 8i
control files and log files can be kept ?

(2) How about the Oracle Finance upgrade ? Does it need to be done together
with 9i upgrade ? Or there can be an intermediate stage : Oracle Finance
11.5.2 running on Oracle 9i ?
Jul 19 '05 #1
1 4584
"cpchan" <cp******@netvi gator.com> wrote in message news:<bg******* **@imsp212.netv igator.com>...
If I want to upgrade the following system :

(1) Oracle 8i RDBMS
(2) Oracle Finance 11.5.2

to :

(1) Oracle 9i RDBMS
(2) Oracle Finance 11.5.8

I have the following questions :
(1) What will the "upgrade" process actually do ? Install a new Oracle 9i
instance and then copy all the records to it from the existing 8i ? Or the
9i CD can detect the 8i automatically and then upgrade it and all the 8i
control files and log files can be kept ?

(2) How about the Oracle Finance upgrade ? Does it need to be done together
with 9i upgrade ? Or there can be an intermediate stage : Oracle Finance
11.5.2 running on Oracle 9i ?

1)
The migrate utility will discover the old 8i database, and upgrade
it's dictionary to 9i. If you want two databases, you'll need to
create a new 9i datase, export the 8i database, and import it into 9i

2) Please read the release notes and installation instructions

Sybrand Bakker
Senior Oracle DBA
Jul 19 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
2790
by: Greg Lindstrom | last post by:
Greetings- I am running Python 2.3.3 on HP-UX and would like to access an Oracle 9i database. Looking through the vaults, I see 4 or 5 modules that might work and was wondering if anyone is currently hitting Oracle and what are you using. I get to build a new system from the ground up and the powers that be are allowing me to do it in...
6
3543
by: jcwhui | last post by:
I am building an application that accesses to a customer provided Oracle. I was assuming function-based indices in Oracle 8.0+, but I am wrong. It is only avail since 8i. For now, I can only think of introducing another field that stored the result of my function, and then I create an index on it. I prefer not to because: (1) it...
1
2968
by: cpchan | last post by:
According the documentation from Metalink, the following files are required for the Oracle Upgrade from 8.1.6 to 8.1.7 : u0801060.sql c0801060.sql a0801060.sql i0801060.sql utlip.sql However, after install 8.1.7, I could only find 4 of them, but no
4
19974
by: susmita_ganguly | last post by:
Hi I am trying to upgrade from oracle 8i to oracle 9i on the same server ..I don't know much abt migration . Can anyone help me out. Thanks. Susmita
14
7931
by: Ruth | last post by:
Hi All I am not a DBA, but a unix administrator. After our DBA's upgraded from oracle 8.0.5 to oracle 8.1.7.4 on our test server, we have noticed a big slow down in our application (acocobol). From ~10mins to ~45mins. Server info:
19
1918
by: MP | last post by:
I'm interested to learn how to use mdb files via ado/adox via vb6 Since I'm not using Access are those types of questions o.t. here? I see very few ado questions here. But there's a lot more traffic here than the ado groups. :-) Thanks Mark
0
1956
by: anneeny | last post by:
Hi there... My company has implemented Oracle Financials and Project applications in 1999 as a part of Y2K project. Oracle 11.0.3 Applications are implemented in 3-tier configuration as per the details given below:- Database Tier: The database tier consists of Intel Server running Windows 2000. This server is dedicated to host ORACLE...
2
14220
by: Vinod Sadanandan | last post by:
All, Below listed are the new features in Oracle 11g ,please join me in this discussion to generate a testcase and analyze each of the listed features . Precompilers: Additional Array INSERT and SELECT Syntax Support by Pro*C/C++ and Pro*COBOL Precompilers: Dynamic SQL Statement Caching in Pro*C/C++ and Pro*COBOL ...
1
204
by: cpchan | last post by:
If I want to upgrade the following system : (1) Oracle 8i RDBMS (2) Oracle Finance 11.5.2 to : (1) Oracle 9i RDBMS (2) Oracle Finance 11.5.8
0
7814
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7736
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
8249
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7826
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
8107
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6464
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
0
3748
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3756
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2252
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.