Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot
 
PerlMonks  

Re^3: What are DBD::Oracle's dependencies (on Linux)?

by dragonchild (Archbishop)
on Oct 05, 2004 at 17:44 UTC ( [id://396689]=note: print w/replies, xml ) Need Help??


in reply to Re^2: What are DBD::Oracle's dependencies (on Linux)?
in thread What are DBD::Oracle's dependencies (on Linux)?

  1. I was wondering if there was a way to get the C librabries and headers from the Oracle webstite, or do I need to get them off the cd.

    You will want to get them off the CD.

  2. How would I make a script? Is making a script like writing a program?

    Perl is a programming language. Thus, making a Perl script is programming in Perl. I would strongly urge you to read Learning Perl, which you can find at any bookstore.

  3. Where do I locate tnsnames.ora and in what way do i change it?

    tnsnames.ora is an Oracle configuration file that maps database aliases to where they're really located. Only the DBA should ever modify this file. If you want to modify it, you should really talk to your DBA to do so. If you want to see it, it's located in $ORACLE_HOME/network/admin. (Yes, there's that $ORACLE_HOME thing again.)

nguye103 - have you talked to your DBA yet? Do you guys even have a DBA? Working with Oracle is non-trivial. If you're just looking for a database that anyone can administer, I would go with one of the opensource options, like MySQL or PostgreSQL. Oracle is the top-of-the-line mothership of all databases, and requires a lot of knowledge to run it correctly. This is reflected in the amount of crap you have to do just to install DBD::Oracle.

To compare, installing MySQL and DBD::mysql takes about 30 minutes, tops. And, it's even optimized for and meant to be installed on most flavors of Linux. Maybe what you need can be solved by MySQL ...

Being right, does not endow the right to be rude; politeness costs nothing.
Being unknowing, is not the same as being stupid.
Expressing a contrary opinion, whether to the individual or the group, is more often a sign of deeper thought than of cantankerous belligerence.
Do not mistake your goals as the only goals; your opinion as the only opinion; your confidence as correctness. Saying you know better is not the same as explaining you know better.

Replies are listed 'Best First'.
What are DBD::Oracle's dependencies (on Windows)?
by madhusudankapoor (Initiate) on May 14, 2007 at 17:26 UTC
    Can any body help me to find
    What are DBD::Oracle's dependencies (on Windows)?
    I have successfully installed DBD::Oracle on my windows XP based PC
    When I tried to connect to remote Oracle Sever using following code
    # --- Connecting to host my $dbh = DBI->connect('dbi:Oracle:host=myserverIP;sid=ORCL;port=1525' +, 'pfisher', 'password', { RaiseError => 1, AutoCommit => 0 });

    It gives me following error
    DBI connect('host=.....; sid=ORCL;port=1521','pfisher',...) failed: ORA-12541: TNS:no listener (DBD ERROR: OCISer verAttach) at oracleTest.pl line 12
    Can any body help me...........................?????
Re^4: What are DBD::Oracle's dependencies (on Linux)?
by nguye103 (Acolyte) on Oct 05, 2004 at 17:54 UTC
    We do have a DBA... We are currently using Oracle. With windows, we were able to have oracle on the computer and use the oracle database. We now want to use linux to retrieve the oracle database w/o having oracle installed. Are you saying that it would be easier to completely use a new database system then to get DBD::Oracle to work with linux?
      If you didn't have a DBA, it would be easier to get another system running.

      Since you do have a DBA, here's what you want to do:

      1. Have the DBA do a full install of Oracle on the Linux box, software only. He will understand what I am saying. You will not keep this installation for very long.
      2. With your DBA sitting next to you, install DBD::Oracle on the Linux box. It will link against the Oracle installation you did in step 1.
      3. Once DBD::Oracle has been built successfully, delete the Oracle installation from the Linux box.

      You now have DBD::Oracle installed on a box that doesn't have Oracle on it. I've already told you to do this. Where is the confusion?

      Being right, does not endow the right to be rude; politeness costs nothing.
      Being unknowing, is not the same as being stupid.
      Expressing a contrary opinion, whether to the individual or the group, is more often a sign of deeper thought than of cantankerous belligerence.
      Do not mistake your goals as the only goals; your opinion as the only opinion; your confidence as correctness. Saying you know better is not the same as explaining you know better.

        Ok, thank you. I guess I was just confused by all the different suggestions.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://396689]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others admiring the Monastery: (4)
As of 2024-03-29 00:31 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found