473,657 Members | 2,426 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Using Oracle on Solaris

I need to write a tiny little program which makes use of an Oracle database
on Solaris. Just a single SQL statement. Nice and simple.

Coming from a Windows/SQLServer/ADO background, I'm having a bit of trouble
finding some of the basics.

Given that I already have Oracle and Python installed on the Solaris box,
what else do I need?

A little code snippet would be very handy.

Thanks.
Jul 18 '05 #1
2 1798
> Given that I already have Oracle and Python installed on the Solaris box,
what else do I need?


You'll need a C compiler (Sun's or gcc), and the cx_Oracle module.
Grab the source code at http://www.computronix.com/utilities.shtml
When building the module (see the included instructions), make sure
you've got a working oracle environment (eg 'sqlplus' can be invoked,
and the oracle libraries can be found by the linker...)

The Python Database API is documented at:
http://www.python.org/peps/pep-0249.html

Cheers,

Bernard.

Jul 18 '05 #2
Bernard Delmée :
You'll need a C compiler (Sun's or gcc), and the cx_Oracle module.
Grab the source code at http://www.computronix.com/utilities.shtml
When building the module (see the included instructions), make sure
you've got a working oracle environment (eg 'sqlplus' can be invoked,
and the oracle libraries can be found by the linker...)

The Python Database API is documented at:
http://www.python.org/peps/pep-0249.html

Cheers,

Bernard.


Excellent. Thanks very much.
--
Dale Strickland-Clark
Riverhall Systems Ltd, www.riverhall.co.uk
Jul 18 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
8456
by: rawii | last post by:
I am running on a Sun box and am trying to install the perl tools to connect to Oracle. When I try to install the DBD::Oracle module, I get the following. Please help.. What does is mean and how can I fix it? 33% make Skip blib/lib/DBD/Oracle.pm (unchanged) Skip blib/arch/auto/DBD/Oracle/Oracle.h (unchanged) Skip blib/arch/auto/DBD/Oracle/dbdimp.h (unchanged)
100
9033
by: Peter | last post by:
Company thought DB2 will be better than Oracle. The bottom line is when you do select, the system crash. I think it may take 4-5 years for DB2 to reach Oracle standard. Peter
1
2851
by: tibes | last post by:
Hi there, Where can I download Oracle 9i database for Solaris 8 intel machine? Help please. Thanks --
5
3550
by: cyber-arkitect | last post by:
Hello all: I am a Solaris Unix Administrator with 6+ yrs. of experience in major companies who also has experience with AIX. Since I am good at Unix I would like to move into Oracle world, preferrably as an entry-level DBA. I have started preparing for the first OCA exams but am looking for an entry-level Oracle job. (even if it is an intern its fine for now). How do I break into Oracle world? Although I have Unix certifications, an...
1
2853
by: Crowe | last post by:
Greetings Everyone: Oracle 9i installed on a sun solaris box. No protocol adapters available. I would greatly appreciate any help from the db gurus on this forum. after bringing up the database, i am using the netca (Oracle Net Services Configuration assistant). When i try to create a listener and configure the protocol for that listener, i do not see any available protocols (the available protocols box is empty!!) but, the selected
1
4478
by: Paul | last post by:
Hi: I am totally new in Sun Solaris. I am not sure someone would like to tell me how to rellocate Sun Solaris disk space where oracle installed? I installed Oracle 8i in Sun Solaris and set Oracle main table space called TABLES in unix disk space /dpp/live01. From the following, it's quite easy to see that the disk space of /dpp/live01 is 97%.Therefore how can i move some disk space of SWAP to /dpp/live01 without losing
20
2721
by: antonberg1 | last post by:
Hi, I wonder if it is possible to write a platform independent c-application running as job on a sun solaris multiprocessor machine, connecting to an oracle database and creating a very simple xml-file from the data extracted. Could you maybe give me some advice where to start reading about that theme? Usually I develope windows applications, but this time my software has to run on sun solaris.
1
2061
by: jrefran | last post by:
Hi everyone! I have problem on my DBD:Oracle installation from source code. Does anyone familiar with this kind of error. Please help! I'm completely new with this kind of work item. This is the error during execution of "make". This error was in the last part. ---------------------------------- /usr/local/lib/perl5/5.8.8/sun4-solaris/CORE/proto.h:2089: warning: `__malloc__' attribute dir ective ignored...
2
2072
by: Michael Shilokovsky | last post by:
Srki wrote: Hi. I've got Oracle 8.1.7 EE for Solaris x86 if you interested. Rbear. Please contact me directly if any questions
0
8402
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8829
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
8508
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8608
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
6172
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5633
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4164
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
2733
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
1627
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.