wyldsj
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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 ?
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 ?
ASKER
Thanks all! I am going to try it out and let you know the result.
I experienced this on Solaris 2.6 with Perl 5.005, DBI 1.12, DBD-Oracle 1.03 and Oracle 8i 8.1.5
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 ?
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 ?
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...
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...
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...
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...
" could not find the _____.lib.so"
I have forgotten the file name...
ASKER
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!
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!
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.
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.
Is this a Unix or NT server ?