From LAN to Web !!!

[ptreves]

Hello,

I am currently running an Oracle 8.0.5 Database about 1.2 GigaBytes in
size on a Novell 5.1 server.

1) I want to migrate to a Linux Red Hat 8 Server (I know that I have
to upgrade to Linus Red Hat Enterprise 3 (ES)) No questions about
that.

2) I want to upgrade from a 8.0.5 Database to a 9i database. I have
heard there are 3 possible ways of doing this: directly by
import/export, going to 8.0.6 then 9i or going to 8i and then 9i. What
do you think is best ? and why ?

3) I want to go from a Client/Server architecture with about 8 clients
to a Web architecture. I have heard that I would need to purchase iAS
(Internet Application Server) in order to manage multiple
Forms/Reports request at the same time. What can iAS do that I cannot
do with Oracle 8i, Oracle 9i ?

-----
Also, my current Oracle Forms/Reports application uses Parameter Forms
and is based on the RUN_PRODUCT builds. Going to 9i with iAS, what
kind of modifications should I expect to do to my Oracle Forms/Reports
to goto a Web based application ? I have heard that I might have to
modify some Report Triggers ?


My Oracle Forms/Reports is developped in Oracle Forms/Reports 6i.
Would I need to rewrite my application for Oracle 9i ?

Your feedback is appreciated,

Regards,

PT

[Daniel Morgan]

Comments in-line.

ptreves wrote:
Hello, I am currently running an Oracle 8.0.5 Database about 1.2 GigaBytes in size on a Novell 5.1 server. 1) I want to migrate to a Linux Red Hat 8 Server (I know that I have to upgrade to Linus Red Hat Enterprise 3 (ES)) No questions about that.

Not necessary but probably a good idea.
2) I want to upgrade from a 8.0.5 Database to a 9i database. I have heard there are 3 possible ways of doing this: directly by import/export, going to 8.0.6 then 9i or going to 8i and then 9i. What do you think is best ? and why ?

Upgrade in-place in your 8.0.5 after performing a full backup. Then take
it to 9i in one step.
3) I want to go from a Client/Server architecture with about 8 clients to a Web architecture. I have heard that I would need to purchase iAS (Internet Application Server) in order to manage multiple Forms/Reports request at the same time. What can iAS do that I cannot do with Oracle 8i, Oracle 9i ?

iAS is not the database. It is the application server.
----- Also, my current Oracle Forms/Reports application uses Parameter Forms and is based on the RUN_PRODUCT builds. Going to 9i with iAS, what kind of modifications should I expect to do to my Oracle Forms/Reports to goto a Web based application ? I have heard that I might have to modify some Report Triggers ?

You likely will ... expect to invest 2 minutes per parameter form
after the first one.
My Oracle Forms/Reports is developped in Oracle Forms/Reports 6i. Would I need to rewrite my application for Oracle 9i ? Your feedback is appreciated, Regards, PT

Rewrite? Hardly. Just open in 9i and press Ctrl-T.

--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)

[Ana C. Dent]

ptreves wrote:
Hello, I am currently running an Oracle 8.0.5 Database about 1.2 GigaBytes in size on a Novell 5.1 server. 1) I want to migrate to a Linux Red Hat 8 Server (I know that I have to upgrade to Linus Red Hat Enterprise 3 (ES)) No questions about that. 2) I want to upgrade from a 8.0.5 Database to a 9i database. I have heard there are 3 possible ways of doing this: directly by import/export, going to 8.0.6 then 9i or going to 8i and then 9i. What do you think is best ? and why ?

IMPORT/EXPORT must be used because your going between 2 different OSes.
The fewer the steps the better it will be for you.
3) I want to go from a Client/Server architecture with about 8 clients to a Web architecture. I have heard that I would need to purchase iAS (Internet Application Server) in order to manage multiple Forms/Reports request at the same time. What can iAS do that I cannot do with Oracle 8i, Oracle 9i ?

9iAS R2 is filled with many, many, many bugs. Avoid it like the plague!
----- Also, my current Oracle Forms/Reports application uses Parameter Forms and is based on the RUN_PRODUCT builds. Going to 9i with iAS, what kind of modifications should I expect to do to my Oracle Forms/Reports to goto a Web based application ? I have heard that I might have to modify some Report Triggers ?

At a minimum RUN_PRODUCT gets changed RUN_REPORT_OBJECT.
My Oracle Forms/Reports is developped in Oracle Forms/Reports 6i. Would I need to rewrite my application for Oracle 9i ?

From a single 6i source base I also support 9iAS R2 Forms & Reports.

[ptreves]

Hello,

What is my alternative to 9iAS R2 ? going to 10g ??
What do you suggest I do ?

PT

anacedent <anacedent@hotmail.com> wrote in message news:<8OpCc.2965$rn1.317@okepread07>... ptreves wrote: Hello, I am currently running an Oracle 8.0.5 Database about 1.2 GigaBytes in size on a Novell 5.1 server. 1) I want to migrate to a Linux Red Hat 8 Server (I know that I have to upgrade to Linus Red Hat Enterprise 3 (ES)) No questions about that. 2) I want to upgrade from a 8.0.5 Database to a 9i database. I have heard there are 3 possible ways of doing this: directly by import/export, going to 8.0.6 then 9i or going to 8i and then 9i. What do you think is best ? and why ? IMPORT/EXPORT must be used because your going between 2 different OSes. The fewer the steps the better it will be for you. 3) I want to go from a Client/Server architecture with about 8 clients to a Web architecture. I have heard that I would need to purchase iAS (Internet Application Server) in order to manage multiple Forms/Reports request at the same time. What can iAS do that I cannot do with Oracle 8i, Oracle 9i ? 9iAS R2 is filled with many, many, many bugs. Avoid it like the plague! ----- Also, my current Oracle Forms/Reports application uses Parameter Forms and is based on the RUN_PRODUCT builds. Going to 9i with iAS, what kind of modifications should I expect to do to my Oracle Forms/Reports to goto a Web based application ? I have heard that I might have to modify some Report Triggers ? At a minimum RUN_PRODUCT gets changed RUN_REPORT_OBJECT. My Oracle Forms/Reports is developped in Oracle Forms/Reports 6i. Would I need to rewrite my application for Oracle 9i ? From a single 6i source base I also support 9iAS R2 Forms & Reports.

[Ana C. Dent]

ptreves wrote: Hello, What is my alternative to 9iAS R2 ? going to 10g ??

I have no 1st hand experiance with 10gAS, but from what I've
heard, 10gAS is a decent choice.