Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Oracle 9i Personal Edition

Status
Not open for further replies.

Michael42

Programmer
Joined
Oct 8, 2001
Messages
1,454
Location
US
Does anyone out there have Oracle 9i Personal Edition?

If so:
1. How many users can connect to a system running it?
2. How many oracle user accounts is it limited to?
3. Any other limitations I should know about?

Oracle support could not point me to this info.

Thanks!
 
I haven't used personal Oracle 9i, but I use personal Oracle 8i a lot, and have used it for quite a while. I would assume the constraints are the same between 8i and 9i.

You have to separate what you CAN do from what you are licensed to do - they are different.

Personal Oracle is not intended to be used as a server. It is intended for all connections to be local. You can connect as many times as you want, but they are supposed to be local connections. One exception is that you are allowed to connect remotely for database administration. You will notice that with a Personal Oracle database you do not have an entry for LICENSE_MAX_SESSIONS or LICENSE_MAX_USERS in your parameter file because there are no limits. You can legally have as many accounts and as many local sessions as you want.

That being said, it is possible to connect to Personal Oracle remotely just like with any server edition of Oracle. However you are violating you license agreement if you do this for any reason other than administration.
 
jee,

Thanks very much for your detailed reply.

It was very helpful!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top