| Reasons to upgrade from Oracle 7.3.4 to 9i and beyond. [message #60969] |
Wed, 17 March 2004 08:29  |
Lorraine Ambrosio
Messages: 1
Registered: March 2004
|
Junior Member |
|
|
Can you give me some detailed supporting arguments to upgrade from Oracle RDMBS 7.3.4 to a later version. OS Tru64 Unix 5.1. The obvious reason is the current version is unsupported by Oracle.
I know this issue was discussed on this message board in August 2002 but I wonder what the response would be today.
We're doing a risk assessment of our current configuration to present to our decision makers.
Any help would be appreciated, thanks very much
LAAmbrosio
|
|
|
|
| Re: Reasons to upgrade from Oracle 7.3.4 to 9i and beyond. [message #60995 is a reply to message #60969] |
Thu, 18 March 2004 04:07  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Hi,
Here are a couple of reasons why you might want to upgrade:
1. Oracle 7.3.4 is no longer supported and you cannot buy EMS (Extended Maintenance Support) from Oracle anymore.
2. Nobody can, or would want to help you if you run into problems.
3. You cannot upgrade the Operating System or any other software because it might not be compatible with such an old version of Oracle.
4. The longer you wait, the bigger the effort will be when you finally decide to upgrade.
5. If you run Oracle 7.3.4 you would never find another Oracle job. They may as well put you and your outdated database into the same museum.
Etc.
Best regards.
Frank
|
|
|
|
|
|
| Re: Reasons to upgrade from Oracle 7.3.4 to 9i and beyond. [message #61008 is a reply to message #60995] |
Fri, 19 March 2004 05:28 |
Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida
|
Senior Member |
|
|
>> 5. If you run Oracle 7.3.4 you would never find another Oracle job. They may as well put you and your outdated database into the same museum.
That was funny Frank ...
Anyway, I have heard of people still using 7.3.4 due to OTHER reasons and limitations..Legacy systems and so on.
If your OS/hardware can support you all the way to 9.2.0, then what is the delay here ?? (I dunno much about True64 Unix 5.1...)
Sounds like you are running a HA or critical DB here...
The points put forward by Frank are very intelligent. The most important question you need to ask yourself is if you are using another app in the front end, first find out if that will support Oracle 9.2. This is IF you are using anything.
Happy upgrade.
--
Sanjay
|
|
|
|
| Re: Reasons to upgrade from Oracle 7.3.4 to 9i and beyond. [message #61487 is a reply to message #61008] |
Wed, 28 April 2004 21:47 |
Michael Friedman
Messages: 2
Registered: April 2004
|
Junior Member |
|
|
There are definitely good reasons to upgrade from Oracle 7.3.
The most important is that Oracle 7.3 won’t run on most modern operating systems. As operating systems and hardware move forward in tandem it will become harder and harder for you to find supported operating systems and even hardware platforms.
Moreover, skill sets and product availability are becoming major issues.
For example, let’s say your application is running on 16 bit Developer/2000 1.3 with VBXs.
You could upgrade your database to 8.0, but to do that you would need to upgrade your D2K to 1.3.3 with a late patch set. If you go beyond that you will hit the 32 bit versions of D2K which will not support VBXs.
Upgrading to Oracle 8i may be possible but it was never a certified configuration with 16 bit versions of D2K so it would be risky.
You could convert the VBXs to OCXs and then upgrade further, migrating your database and your client step by step.
Alternatively, you could do a big bang – going all the way to Oracle9i Developer and Oracle 9i and reimplementing the VBX functionality using whatever technology is most appropriate (ie. Oracle9i Developer now supports tabbed pages natively, eliminating one of the main uses of VBXs) but then you would almost certainly end up with significant bugs introduced by the migration process. The resulting system probably would not work at all without substantial fix up work and it is always harder to do fix up work on a system that won’t even start up than on a system that works but not well.
This whole effort would require you to pass through Oracle 8, which is also not supported, and 8i, which will probably be desupported in a year or so now that 10g has been released.
The longer you wait the harder it will be for you to find the people with the necessary skills to do this work and the more expensive they will be. You don’t find many fresh graduates with Developer/2000 experience any more!
BTW, this kind of work is made for outsourcing… if you are interested in cutting your costs to do this migration feel free to discuss with me.
|
|
|
|
| Re: Reasons to upgrade from Oracle 7.3.4 to 9i and beyond. [message #61908 is a reply to message #61487] |
Wed, 09 June 2004 07:34 |
Enrique P. Perez
Messages: 1
Registered: June 2004
|
Junior Member |
|
|
Hello,
Would you mind letting me know if it is possible to migrate an Oracle 7.3.4 database directly to Oracle 9i, or do we have to upgrade first to 8.0/i? The current configuration of our database system is:
Application: Java Script (server-side)
Database: Oracle 7.3.4
Operating System: Solaris 2.6
Web Server: Netscape-Enterprise Webserver 3.6
Could you let me know what steps I would have to follow to upgrade my database to Oracle 9i? I understand that we may have to outsource this effort which is understandable, but I just need to have an overall idea of what is involved in this effort.
I appreciate your help.
Thanks.
Enrique P. Perez
enrique.perez@cox.net
|
|
|
|
| Re: Reasons to upgrade from Oracle 7.3.4 to 9i and beyond. [message #62306 is a reply to message #61908] |
Tue, 13 July 2004 15:00 |
suryakanth
Messages: 1
Registered: July 2004
|
Junior Member |
|
|
Hi there..
I too facing almost same problem. My database version is Oracle 7.3.4 and my forms version is 5.0.
we are working on Tru-64 Unix machine which is a compaq/digital make.(alpha processor version 5.1)
with 512 Mb RAM and 36*3 GB hard disk with raid 5 controller and around 30 users are connect to thru
cat 5.
all the client machines are with 32MB ram and 4.3 GB hard disk on windows/98.
Secondly IF I dont take IDS and upgrade only my database to 9i, will the forms 5.0 will work on 9i.
if so what is the procedure.Just compilation will do or not?
Or If I take IDS along with 9i what is the procedure.Any changes in the code required?
now we are looking for migrating with oracle 9i database and oracle 9i developer suite. is it really possible, if possible plz. let me know the steps to do so.
I have LONG datatype which has signatures(which are stored as an Images in Database),If i move to 9i
how to tackle the LONG Field.
I have around 70 Forms to be compiled.and 7GB data to be migrated to 9i. when you import from 7.3 to 9i what are the problems we may encounter?
if not plz. let me know the reasons to get fail in this regard. I will be very much thankful if any body help in this painful movement.
with regards,
suryakanth
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
