LinuxQuestions.org
Register a domain and help support LQ
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices

Reply
 
Search this Thread
Old 03-01-2008, 01:33 AM   #1
eentonig
LQ Newbie
 
Registered: Jan 2008
Posts: 26

Rep: Reputation: 15
What do I need to read data from Oracle Database?


Hi,

at work, we have a huge Oracle database which holds information regarding systems I need to manage. However, the webinterface/application that's used to access this data is very slow and limited.

So I would like to use a script to collect some information and store this in a csv file to run some scripts against it.

But what program do I need to install to access the Oracle Database?

I have the servername, port, user & pass, db name, ... I just don't know how to connect to it from my linux machine.
 
Old 03-01-2008, 07:13 PM   #2
Tinkster
Moderator
 
Registered: Apr 2002
Location: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 22,977
Blog Entries: 11

Rep: Reputation: 879Reputation: 879Reputation: 879Reputation: 879Reputation: 879Reputation: 879Reputation: 879
Oracle Instant client (freely downloadable) gives you SQL*Plus, which should do
what you're asking for just fine (provided you're familiar with the database
you're trying to query).


Cheers,
Tink
 
Old 03-02-2008, 12:37 AM   #3
yusufs
Member
 
Registered: Oct 2007
Posts: 162

Rep: Reputation: 30
Quote:
Originally Posted by eentonig View Post
Hi,

at work, we have a huge Oracle database which holds information regarding systems I need to manage. However, the webinterface/application that's used to access this data is very slow and limited.

So I would like to use a script to collect some information and store this in a csv file to run some scripts against it.

But what program do I need to install to access the Oracle Database?

I have the servername, port, user & pass, db name, ... I just don't know how to connect to it from my linux machine.

Hai,

You can always use oracle products to do such activities.. I suggest you to use TOAD.. from where u can just tranfser the datas to any format file like .csv,.xml,xls,txt..


Let me know if you need any help

Thanks
Yusuf
 
Old 03-02-2008, 01:03 AM   #4
eentonig
LQ Newbie
 
Registered: Jan 2008
Posts: 26

Original Poster
Rep: Reputation: 15
Quote:
Originally Posted by yusufs View Post
Hai,

You can always use oracle products to do such activities.. I suggest you to use TOAD.. from where u can just tranfser the datas to any format file like .csv,.xml,xls,txt..


Let me know if you need any help

Thanks
Yusuf
If I go to the TOAD site and download, I get a zip with an .exe file? Isn't there a linux client?
 
Old 03-05-2008, 10:03 AM   #5
Robert0380
Guru
 
Registered: Apr 2002
Location: Atlanta
Distribution: Gentoo
Posts: 1,280

Rep: Reputation: 47
TOAD is actually a Qwest product (a really good one). You should install the Oracle client unless you're planning on using JDBC or similar to connect to the database. The client is a free download from Oracle but installation isn't 100% straight forward if you haven't done it before but it's easier than installing the full blown RDBMS.
 
  


Reply

Tags
oracle, script, sql


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
Shell script to load data to oracle database divyahm Linux - Newbie 2 11-08-2007 09:15 AM
Processing data from a 'foreign' database with mysql, or tools to pre-process data. linker3000 Linux - Software 1 08-14-2007 08:36 PM
LXer: Oracle and Symantec Certify Veritas Data Center Solutions on Oracle(R) Enterprise Linux LXer Syndicated Linux News 0 07-18-2007 06:31 AM
LXer: Oracle(R) Database Standard Edition One and Oracle Enterprise Linux on HP Set New World Record for Price Performance with TPC-C Benchmark LXer Syndicated Linux News 0 06-12-2007 05:01 PM
Difference between Oracle Server and Oracle Database ganninu Programming 3 02-27-2007 01:06 AM


All times are GMT -5. The time now is 12:43 AM.

Main Menu
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
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration