Re: Oracle architecture question

In our last gripping episode "John Dunn" <JLDunn_at_ukgateway.net> wrote:
> Currently our application consists of datbase tables plus stored
 procedures,
> all of which are held and run on the same machine.
>
> Is it possible to run the stored procedures on another machine and
 access
> the database which would still be on the current machine?
>
> What Oracle software would I need to install on the second machine?
>
> Where would the stored procedures live? still on the database machine?
>
> N.B. We use dbms_job and utl_file pacakages as well.
>
> John
>
>

Stored procedures are just that, stored procedures. They are resident within a database and access data in that database, therefore your stored procedures would be resident on the database server. There is no reason that a remote application cannot call these procedures. You would need, at the very least, Oracle Client on the client machine.

The utl_file output would remain on the database server unless, of course, you remotely mount a directory to the database server and alter the utl_file_dir entry in the init<SID>.ora file to point to this new location. The dbms_job functionality should not be affected, unless, of course, one or more of these jobs utilises utl_file.

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com
http://www.deja.com/