Solved

COSTS OF ORACLE - how much does database cost, and what software do i need?

Posted on 2004-10-11
13
4,768 Views
Last Modified: 2013-12-11
Hi,

I am working in my first role since graduating using databases, and am about to implement a db for my company - the question is, how much does it cost for a company of 12 employees, most in London, one in Paris and soon an office in New York to implement an Oracle Database?

What do I need - just Oracle (9i?) database standard edition? and the licenses for 12 users at about £80 each (according to Oracles website)

I have Oracle installed at home, for my study, but would not know how to implement in this business environment. we have a server what would the recommended spec for this be if the system was to run oracle? and if someone could give me a very basic overview of how the db would be used by the french staff / new york based staff i would be grateful. We have a vpn that the french staff use at the moment. I know database design, implementation etc, but not as a corporate networked system - i hope this makes sense!

Your help is appreciated,

Emma
0
Comment
Question by:emmy21
  • 4
  • 3
  • 2
  • +2
13 Comments
 
LVL 23

Expert Comment

by:seazodiac
Comment Utility
do you need replication mechanism once you set up office in NEw yOrk?

if not, Oracle standard edition might be able to fill the bill.
Oracle9i or 10g standard edition is very cheap , I am 100%percent sure they are under 1000USD ...(700 or sth to be accurate).

but enterprise edition is a huge bump-up.
0
 
LVL 23

Expert Comment

by:seazodiac
Comment Utility
emmy:

it's hard decision for outsider, you will need to examine your particular situation and assess the database needs from oracle.

in the meanwhile this will help you tremendously as to what feature each of oracle database edition offers:

http://www.oracle.com/technology/products/oracle9i/pdf/o9i_family_features.pdf
0
 

Author Comment

by:emmy21
Comment Utility
ok, thanks i havent read the link yet, but i am not sure about replication, we would need the database to be operable in all offices, i think at the moment the shared drive is accessed by vpn, so would i work with oracle over the vpn using oracle client? is that part of oracle database?
0
 
LVL 23

Expert Comment

by:seazodiac
Comment Utility
Sure you can use Oracle client through VPN.

--->is that part of oracle database?

I am not sure of your question. Oracle client is free...
0
 

Author Comment

by:emmy21
Comment Utility
oh ok. I am going to hear back from a software company tomorrow about a full quote, I am just wondering how big the task would be as a first undertaking using oracle - i know oracle and pl/sql better but MS Access seems less frightening in some way, although i do not know VB.

I will read the pdf file you sent me, I think the database will be a crucial asset to the company which is growing, and could get more international offices, and I know Oracle and that it can produce good reports - iyt is just a case of being able to cope with setting up the client and vpn so that it is available remotely 24/7 in paris/new york.  I have played about with php and got my oracle database running through the browser, and i am a fast learner. do you think it is wise to approach with oracle or does Access sound more suited?

ps i know its difficult with limited info about me and the system
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 23

Accepted Solution

by:
seazodiac earned 168 total points
Comment Utility
No brainer! Oracle... Access, arghhhh, just not serious enough.
Oracle is even good for market pitches...
remember when your salesman out there saying your company data is hosted on Oracle as opposed to MS access...
your coporate image...you go figure...
0
 
LVL 47

Assisted Solution

by:schwertner
schwertner earned 166 total points
Comment Utility
Using Oracle you will get an reliable DataBase.
You can begin using the Standart Edition.
The communication lines between U.K. and U.S.A work fast and the
client/server model is quite good at the beginning.
You can upgrade the version in the future when you feel need.

You have also to think about the person who will be the Oracle DBA.
If this person are you - think about additional education.
If not - think about hiring an appropriate DBA. I can help you.
Oracle need maintenance - it is very important. Do not believe
myths like "Oracle 10g - selfmanaging database". Even experienced
DBAs experience diffucties to install and upgrade this monster.
0
 

Author Comment

by:emmy21
Comment Utility
Thank you, do you think the dba stuff will be significantly easier using MS Access? I have a computig degree focused on db, and have just started MSc Database Systems which i am told closely follows the oracle certification programme, even working from oracle handouts etc.

do you recommend oracle over access in my situation?
0
 
LVL 9

Assisted Solution

by:konektor
konektor earned 166 total points
Comment Utility
0
 
LVL 47

Expert Comment

by:schwertner
Comment Utility
Ouuuu! MS Access!!!!!!! It is designed for SOHO (Small office Home Office)! Look at the price. The difference is like between Mini Cooper and Mercedes. Oracle is really expensive, but it is great - reliable, scalable, . But ... if the volumes of your data is low, you do not fear data damages and loss, the scalability of your application is not a problem .. you can try with MS Access.

Oracle, let us say, Enterprise DBMS, for big corporations, for big data volumes, it runs on every OS. The keypoint is that it runs not only on laptops, but it runs on mini (SUN,AIX, Eserver, HP) and on mainfraims. The migration from one machine to other is not a big problem (from software point of view).

If you have not experienced DBA staff - it is possible to help. I am in Europe, I think your office is in UK, another Experts here may be also can be involved.
0
 
LVL 22

Expert Comment

by:Helena Marková
Comment Utility
I agree with comments above - use Oracle. Also price is now lower for small offices than 1 - 2 years ago. It is similar to Microsoft SQL Server.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now