Installing Perl DBD modules for Oracle

Hi,
  I was trying to install perl DBD modules for Oracle database on a server which DOES NOT has Oracle installed. The intention is to connect remotely to the Oracle database server which runs on a different machine. However, I encountered an error during installation saying that can not find Oracle source code on the computer. Does it mean I have to have Oracle source code installed? If so, how can I do that and tell the DBD installer where to find the source code?

Thanks in advance for any help!

wyldsj
wyldsjAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

cadabraCommented:
Do you have Oracle client software (SQL*NET client) installed and configured on the computer ?

Is this a Unix or NT server ?
0
sefaCommented:
Hello,
You cannot install DBD without installng Oracle Server Software.
Because DBD looks for some files which are loaded by the Oracle Server Software.
After installing DBD you can uninstall the DB Server. Then you should install DB in Client Mode.

I hope I could help.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
cadabraCommented:
Oracle client software should be enough, maybe there are specific platforms/ports that have a problem need the Oracle server.

I suggest you do the following (before you resort to installing server software):

1. Install Oracle client software (SQL*NET client) and sqlplus (for testing), some other items will be installed automatically (like Required support files).
2. Configure SQL*NET, so that it connects to the remote server .
3. Test and verify you connect from sqlplus to an account on the remote db.
4. Install DBI
5. Install DBD::Oracle


Cadabra.


to sefa:
On which platform did you experience the need to install the oracle server software as a prerequisite for DBD::Oracle ?

Which OS / Perl version / Oracle version ?
0
JavaScript Best Practices

Save hours in development time and avoid common mistakes by learning the best practices to use for JavaScript.

wyldsjAuthor Commented:
Thanks all! I am going to try it out and let you know the result.
0
sefaCommented:
I experienced this on Solaris 2.6 with Perl 5.005, DBI 1.12, DBD-Oracle 1.03 and Oracle 8i 8.1.5
0
cadabraCommented:
to sefa:
I have not tried the above with oracle 8i, only on Oracle 7.2 --> Oracle 8.0.5 versions.

This could be a problem introduced in 8i (did you have a chance to implement on <8i versions?) generic, or Solaris (which probably means Unix ports) specific.
The question is which components were missing in the client installation (maybe the required support files), and whether they can be selected manually (instead of installing oracle server and removing later).

BTW wyldsj:
Which OS / Perl version / Oracle versions are you using,
and how are you progressing ?
0
sefaCommented:
As I remember DBD-Oracle installtion needed files which are loaded with Pro*C and one more component. I tried to install Oracle client including these components but it didn't work again. So I installed Oracle Server...
0
cadabraCommented:
to sefa:

Do you remember what error messages you were getting when trying to install DBD::Oracle without the Oracle Server ?

I'll be installing a new Solaris 2.6 machine next week, with Oracle 8.0.5 and 8.1.5 and may try fiddling about with this...
0
sefaCommented:
I am sorry I could not remember the error message but I was like
" could not find the _____.lib.so"
I have forgotten the file name...
0
wyldsjAuthor Commented:
So sorry guys, for the long time delay.

I was actually helping my friend to do all these. But because of it's a time-critical project, he couldn't afford to wait so he decided to shift all the perl scripts to the machine running Oracle. But obviously, we still got to get it right.

So if you don't mind, let's leave the question open for another 1 or 2 weeks, during the period I might have time to try the installation.

Otherwise please let me know who I should award the points to :) I will do it right away.

Thanks a lot for your help!
0
cadabraCommented:
Points --> sefa

Sorry, I didn't have a chance to test installing DBD::Oracle on the Solaris machine without the Server software itself, as the Server was needed ASAP.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Perl

From novice to tech pro — start learning today.