Re: Personal Oracle Questions

xtanto_at_hotmail.com (Krist) wrote:

>I am new to Oracle and have some questions about Personal Oracle :
>
>1) If my Customer already have Oracle EE, and now I want to develope
> an application with Personal Oracle, do they have to purchase it ?
> Or it already bundled with Oracle EE ?

Why would they want to run Personal Oracle (PO) when they have EE?

Why do you differenciate between them also? From an application viewpoint, you should not develop differently because you are using PO and not EE.

Of critical importance when developing an Oracle client application, is UNDERSTANDING Oracle. The concepts in EE also apply in PO. Just because the data set is smaller, does not mean that you should throw caution in the wind and just develop away, treating PO like you would MS Access.

Not that you can not do it like that. But your app will not scale to larger data sets. It will be useless for a client who wants to use it against EE - or a client who runs a PO db of several gigs.

>2) Can I run the application in a PC(that use Personal Oracle) from
> another PC ? (suppose they are in same network)

Yes. The app will however need to have the Oracle Client Drivers installed on that other PC.

Connecting apps on other PC's to a copy of PO also running on a PC, is Bad Idea. PO is not intended as a multiuser database. Win95/98/ME is not a server platform.

> Can both run in the same time ?

Yes. By that I assume that you have:
PC1 - app and PO installed
PC2 - app and Oracle Client installed

Both apps can use PO on PC1. However, there are (or used to be) a limit on the number of network connections that PO support (back on Win95 I think that was something like 2 connections). PO is NOT intended as a multiuser database. The operating system is usually also NOT a server platform.

Also, do not think that you can cut cost corners either using PO instead of a proper multiuser Oracle version.

> Do I need Oracle Client for this ?

Yes. Wherever you deploy your app, you need to have an Oracle Client (SQL*NET/NET8) installed to provide your app with the interface into the database.

--
Billy