Oracle in Linux

saint_devil · 01-22-2005, 02:14 AM

Hello Everyone!
I want to know that can I use Oracle in Programming on Linux Plateform in C or C++ or QT or GTK whatever? If yes then how? Will anybody tell me in which file the oracle saves the database we create and how can we see that?

Thanx

bigearsbilly · 01-24-2005, 05:59 AM

of course.
I don't think it's FREE though

davholla · 01-25-2005, 05:19 AM

There is a free version of Oracle.
If you look around in the Oracle web page you can find it, sadly the oracle web page is not as user friendly as this one (Jeremy have you thought of a new job ?).

drisay · 01-25-2005, 06:36 AM

One place to start would be by looking at the OCI API. It's a connector for c/c++ to oracle. I'm sure there are others out there, but I've never really done much c++.

Oracle saves data in datafiles usually name "tablespace_name".ORA.

Also, if you want a tutorial on installing oracle 10 on a linux distro other then red hat or suse... read the following thread: http://www.linuxforum.com/forums/ind...ic=106000&st=0

It's geared towards slack10, but I'm sure you can use some of the info to get things going.

nic777 · 02-07-2005, 05:05 AM

Quote:

Originally posted by davholla
There is a free version of Oracle.
If you look around in the Oracle web page you can find it, sadly the oracle web page is not as user friendly as this one (Jeremy have you thought of a new job ?).

Can someone please explain the different options to get oracle?

There is an option to buy a license for $40 000 per processor or $800 per named user. However, if you carry on looking, there is a downloadable version of the same software.

What exactly is the license of the downloadable version or is it completely free? Whats the point of buying oracle at such a high price then?

Thanks

bigearsbilly · 02-07-2005, 05:22 AM

Read the license agreement if you need to know :P

It probably stipulates the free version can only be used
from 3 - 4 a.m. in a darkened room with no heating,
whilst sitting on hot teabags.

deiussum · 02-07-2005, 08:21 AM

I could be wrong, but I seem to recall that Oracle was free for development and learning usage only. If you intend to use it as a final product, you are supposed to pay.

It's been awhile since I downloaded Oracle, so you'll want to read their licence agreement to be sure, though.

nic777 · 02-07-2005, 09:20 AM

yep, thats right. The download is for development only and not for commercial/production use like I need it for.

Thanks

jim mcnamara · 02-07-2005, 10:11 AM

To the OP-

Don't mess with OCI unless you want to do php programming - in which case use php.

Pro*C is a C precompiler that lets you embed sql calls directly into C code. It a lot more efficient coding-wise than using OCI.

An Oracle instance (database) is a group of files and processes. Some files are for data, others for read consistency, etc. A pure data file can exist, but you could never read it, because it is probably one or more tablespaces.

bigearsbilly · 02-08-2005, 03:12 AM

Pro*C
I used to do that for work.

Just the thought of it makes me go cold.
It's horrible

chrism01 · 02-08-2005, 07:53 PM

I've written lots of Pro*C (& Pro*FORTRAN), no problem... of course FORTRAN is hard work (at least the F77 ver) compared to C.

novice_din · 02-08-2005, 10:25 PM

you can use Pro*C which is already included when you install Oracle. I know its free for personal use. If you want to use C++, you can download OCL (Oracle Class Library) which is much easier than Pro*C++.

you cannot access the datafiles directly. you can only access the logical process that writes into the database. also all the changes is written first into the redo log before flushing it into the datafiles...