DBI/DBD::Oracle and Oracle 10g
Should it be necessary to recompile DBI and/or DBD::Oracle when upgrading
from Oracle 188.8.131.52.0 to 10.2.0.2.0?
Our DBA's recently did this upgrade, and since then, I've been unable to get
DBI working 100%. The lingering problem is that I cannot select character
fields. If I do "select varchar2_col from random_table" using DBI, I
receive back "ORA-03106: fatal two-task communication protocol error".
Doing "select sy...DBI->connect(dbi:Oracle SUCCESS
I would like to heartly thank all of you for your assistance, esp
David Davisson and Michael Chase. I am finally able to DBI connect to
Oracle 8.0.5 running on Linux 2.1.14-5.0 (RedHat 6.2). In the end it
was something as simple as configuring the DBI->connect statement
correctly. According to "Programming the Perl DBI" by Alligator
Descartes & Tim Bunce (creator of Oracle DBI) there are 3 possible
syntaxes for the command:
In my environment the 1st 2 do not work. I n...Unable to DBI->Connect(dbi:Oracle...)
I have been trying to DBI->connect(dbi:Oracle ...) for several
weeks now and still unable to make the connection. I am running Oracle
8.0.5 on a Linux 2.2.14-5.0 (RedHat 6.2) server. I can ODBC into Oracle
from a client w/ no problem. I can DBI->connect(dbi:MySql ...) w/ no
problem. But when I try to DBI->connect to Oracle I get the message
that it can't load
and that the following does not exist
Both of these do exist and ...Identifying the server connected to via DBI->connect("dbi:Oracle:")
I've written some perl that, given a TNS alias, will get the hostname from
the effective tnsnames.ora file. My problem is I don't know how to get the
hostname if the client's using Oracle*Names. For such a configuration there
is no tnsnames.ora file to parse.
Is there something in DBI or DBD::Oracle that reveals components of the TNS
alias description? If not, is there some API that would allow someone to
retrieve the TNS alias description from 'the master' (i.e., an Oracle*Names
server)? If there is such an API and no one has written a perl wrapper for
it, I'...Oracle 10g database and DBI connectivity
I've got DBI and Apache configured to connect to an Oracle 9.2 database.
I'm considering upgrading the database to 10g.
Not expecting any problems but if anyone has gone that route and are
willing to share any gotchas or additional suggestions i'd certainly
...how to implement login module using Oracle 10g database (logic & Oracle 10g Queries) and how can i use membership and roles with Oracle 10g & VS 2.0
Hi all, Can any one tell me how to implement login module using Oracle 10g database (logic & Oracle 10g Queries) and how can I use membership and roles with Oracle 10g & vs 2.0. , for implement this is it compulsory to install oracle 10g server on the same machine on which I'm implementing this task or otherwise i can use other system as a server (like remote login or client server)
Hi,You should have the Oracle 10g Server or Client In your machine.In Case Client is in your Machine then Server Must be somewhere,that is enough to use.I hope then we ...Oracle 10G Connectivity with DBI and DBD in UNIX
In my application, I am using perl version 5.6.1.
I am currently using Oracle 9i database and I am using DBI and DBD
modules for connecting the application to Oracle .
Current Configuration of DBI and DBD:
Now I need to migrate my application to Oracle 10G.
I would like to know, whether is it necessary to install the latest DBD
(DBD-Oracle v1.18a) to connect to Oracle 10G or is it fine to use the
current version itself.
Also, please let me know, if DBD-Oracle v1.18a is supported with perl
5.6.1 or is upgradation really required.
Thank...DBI:ORACLE with Oracle XE
I can connect to an Oracle XE database with dbi:ODBC using :
$dbh = DBI->connect("dbi:ODBC:PSTORA01", "uid", "pwd") or die DBI::errstr;
But am unable to connect with dbi:ORACLE using :
$dbh = DBI->connect("dbi:Oracle:PSTORA01", "uid", "pwd") or die DBI::errstr;
Each time...DBI Oracle connection
I am on Windows 2000. I've install ActivePerl and got the ppm utility
to work by going to the bin directory and typing ppm3-bin.bat
When I try to install the DBI, I get a error:
ppm> install DBI.pm
Error: connect: Unkown error
Can you direct me on how to work this issue? Thanks
1100 Olive Way, 17th Floor
Try dropping the .pm from the name. So you'd just use 'install DBI'.
Knowmad Services Inc. || Internet Applications & Databa...Problems using an old version of DBI to connect to a remote Oracle 10g database
Appreciate if someone can help me with this.
I have a Solaris 5.6 Generic_105181-33 box on which I have Perl version
I also have Perl modules DBI (version 1.14) and DBD::Oracle (version
1.06 - I think?? - how can I check this?)
I am using the following string to connect to a remote Oracle 10g
my $dbh =3D DBI->connect
("dbi:Oracle:$environment",$nsm_login,$nsm_password) || die "Unable to
...DBI connects to one oracle instance but cannot connect to others
We run Oracle 10g under Linux. There are seven database instances:
prod, tmp1,...,tmp6. The TNSNAMES.ORA file treats all seven instances
(COMMUNITY = tcp.world)
(SERVER = DEDICATED)
(SID = prod)
..... identical segments for the tmp1 - tmp6 instances
I can sqlplus into any instance. I can run a local perl script to
connect to the production instance "prod"....test DBD::Oracle DBI connect('','user/password@database',...) failed: ORA-12154
Content-Type: text/plain; charset=us-ascii
I can connect to the database using sqlplus as user oracle, but not as root.
I can compile DBD::Oracle but not complete the test.
I tried to set variables properly:
TNS_ADMIN=/u/or...dbi:oracle on windows2000 (IIS) Oracle Problem
I have a very similar problem to Bob Reuss where my script works ok on the
DOS command line but fails in the browser. My working environment is just
like his (using Perl/CGI on a windows2000 machine running IIS to connect to
an Oracle DB on a Sun WkStation) except that I use the Oracle Driver instead
of ODBC driver.
However, I did get this error on the browser:
install_driver(Oracle) failed: Can't load
'C:/Perl/site/lib/auto/DBD/Oracle/Oracle.dll' for module DBD::Oracle:
...Severe DBI-Oracle DBI-ODBC Problem
Content-Type: text/plain; charset="US-ASCII"
Emergency assistance - This should never be so difficult! ?
All day working switching between the 2 activestate binary installation
versions from activestate site &amp; DBD/DBI versions.&nbsp; No headway
to oracle via perl DBI.&nbsp; Windows 2k - new system. Everything newly
installed for this PC.&nbsp; I do not see an activestate 6.xx binary at the
activestate site ?&nbsp;&nbsp; Uninterested...[Oracle] DBI: Oracle client libs necessary ??
this is just a question for my understanding:
Does the perl-dbi module depends/needs the oracle client library
installation (at least) or does connecting to oracle databases on
remote hosts work without it ?
It needs at least the Oracle SQL*Net software to connect to remote hosts.
To build, it also needs either Oracle's Pro*C or OCI.
** I normally forward private database questions to the DBI mail lists. **
Give a hobbit a fish and he'll eat fish for a day.
Give a hobbit a ring and he'll eat fish for an age.
----- Original Message -----