- 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.
- 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.
- 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.
Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
Read Where should I post X? if you're not absolutely sure you're posting in the right place.
Please read these before you post! —
Posts may use any of the Perl Monks Approved HTML tags:
You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
- a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
Link using PerlMonks shortcuts! What shortcuts can I use for linking?
See Writeup Formatting Tips and other pages linked from there for more info.
| & || & |
| < || < |
| > || > |
| [ || [ |
| ] || ] ||