LinuxQuestions.org
Latest LQ Deal: Latest LQ Deals
Go Back   LinuxQuestions.org > Forums > Non-*NIX Forums > Programming
User Name
Password
Programming This forum is for all programming questions.
The question does not have to be directly related to Linux and any language is fair game.

Notices


Reply
  Search this Thread
Old 01-22-2005, 03:14 AM   #1
saint_devil
LQ Newbie
 
Registered: Dec 2004
Distribution: saint
Posts: 14

Rep: Reputation: 0
Question Oracle in Linux


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
 
Old 01-24-2005, 06:59 AM   #2
bigearsbilly
Senior Member
 
Registered: Mar 2004
Location: england
Distribution: Void, Debian, Puppy, Raspbian
Posts: 3,476

Rep: Reputation: 222Reputation: 222Reputation: 222
of course.
I don't think it's FREE though
 
Old 01-25-2005, 06:19 AM   #3
davholla
Member
 
Registered: Jun 2003
Location: London
Distribution: Linux Mint 13 Maya
Posts: 728

Rep: Reputation: 32
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 ?).
 
Old 01-25-2005, 07:36 AM   #4
drisay
Member
 
Registered: Sep 2004
Distribution: Slackware 10
Posts: 167

Rep: Reputation: 30
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.
 
Old 02-07-2005, 06:05 AM   #5
nic777
LQ Newbie
 
Registered: Dec 2003
Posts: 23

Rep: Reputation: 15
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
 
Old 02-07-2005, 06:22 AM   #6
bigearsbilly
Senior Member
 
Registered: Mar 2004
Location: england
Distribution: Void, Debian, Puppy, Raspbian
Posts: 3,476

Rep: Reputation: 222Reputation: 222Reputation: 222
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.
 
Old 02-07-2005, 09:21 AM   #7
deiussum
Member
 
Registered: Aug 2003
Location: Santa Clara, CA
Distribution: Slackware
Posts: 895

Rep: Reputation: 32
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.
 
Old 02-07-2005, 10:20 AM   #8
nic777
LQ Newbie
 
Registered: Dec 2003
Posts: 23

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

Thanks
 
Old 02-07-2005, 11:11 AM   #9
jim mcnamara
Member
 
Registered: May 2002
Posts: 964

Rep: Reputation: 36
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.
 
Old 02-08-2005, 04:12 AM   #10
bigearsbilly
Senior Member
 
Registered: Mar 2004
Location: england
Distribution: Void, Debian, Puppy, Raspbian
Posts: 3,476

Rep: Reputation: 222Reputation: 222Reputation: 222
Pro*C
I used to do that for work.

Just the thought of it makes me go cold.
It's horrible
 
Old 02-08-2005, 08:53 PM   #11
chrism01
LQ Guru
 
Registered: Aug 2004
Location: Sydney
Distribution: Centos 6.10, Centos 7.5
Posts: 17,685

Rep: Reputation: 2492Reputation: 2492Reputation: 2492Reputation: 2492Reputation: 2492Reputation: 2492Reputation: 2492Reputation: 2492Reputation: 2492Reputation: 2492Reputation: 2492
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.
 
Old 02-08-2005, 11:25 PM   #12
novice_din
LQ Newbie
 
Registered: Feb 2005
Posts: 12

Rep: Reputation: 0
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...
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Difference between Oracle Server and Oracle Database ganninu Programming 3 02-27-2007 02:06 AM
xhost + as user oracle not working, need to see oracle install GUI enzo250gto Linux - Software 2 02-11-2007 12:27 PM
Oracle 9i client with Oracle 8i server ganninu Programming 1 02-19-2004 05:35 PM
Oracle on Linux santosow Linux - Newbie 1 08-20-2003 02:45 AM
Oracle 9i for Linux Evilone Linux - Software 8 07-28-2003 03:26 PM

LinuxQuestions.org > Forums > Non-*NIX Forums > Programming

All times are GMT -5. The time now is 01:24 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration