Re: DBD-Oracle Connection Problem

Hate to say this but if you can connect in any manner it is not really a DBD::Oracle problem.

It is an Oracle problem of some sort. Unfortunetly this sort of problem (can be a real bugger to pin down. It could be anything from the way you have your listener setup to the way your TNSnames.ora file entry is made up?

ORA-12154
is a common bugbeart of all Oracle DBAs.

did find this link for php
http://www.oracle.com/technology/tech/php/htdocs/php_troubleshooting_faq.html

which may help you.

cheers
----- Original Message ----- From: "Darrell Oresky" <doresky@xxxxxxxxxxx>
To: <dbi-users@xxxxxxxx>
Sent: Wednesday, September 12, 2007 8:46 PM
Subject: DBD-Oracle Connection Problem


I am having a problem using DBD-Oracle.

Basic problem - I can only get a connect to work when I fully
specify the connect string, i.e.

"dbi:oracle:host=xxx;port=yyy;sid='zzz' ....

Environment:

Remote connection

Server side - Solaris 9, Oracle 9.2.0.4.0

Client side - Solaris 10 i86pc, Oracle Client 10.2.0.1.0
Perl 5.8.4 (as came installed with Solaris)
DBI 1.58
DBD-Oracle 1.19

SQLPlus works. With no TWO_TASK, and TNS_ADMIN set,

sqlplus x/y@db

works, demonstrating it is finding and using tnsnames.ora.

From a simple Perl program in the same shell, any format of the connect other than
a fully specified connect string results in a ORA-12154 message.

Since SQLPlus is resolving the database name, this seems to imply
the program can not find tnsnames.ora?

Checked the environment in the shell the Perl program runs from - properly set.
Printed environment variables inside the Perl script - properly set.
tnsnames.ora permissions, and all directories, set to 777.
sqlnet.ora specifies TNSNAMES as a connect method.

Turned on DBI trace to level 15. Only interesting message is:

OCIServerAttach (some#, some#, "dbname", 5, 0)
and then ORA-12154 follows.

Any ideas?

Darrell Oresky
doresky@xxxxxxxxxxx




.

Relevant Pages

  • Re: How top actually works
    ... So the next one shows that order by clause has affected the result set ... sort these N rows according to my order by clause. ... Ie. you are telling SQL Server ... This is much the same as with rownum in Oracle, ...
    (comp.databases.ms-sqlserver)
  • Re: "Depreciated" Parameters In SPFILE
    ... however, in case you switch to shared server mode (or, remembering ... and Oracle is able to adjust the value of the parameter ... SORT_AREA_SIZE to 20MB, resulting in the elimination of the sort to ... dedicated server environment. ...
    (comp.databases.oracle.server)
  • Re: Descending indexes in 10g
    ... If you want to give Oracle the option for using ... index rather than doing a simple sort. ... You cannot get a descending column into a primary key ...
    (comp.databases.oracle.server)
  • Re: plan table and TempSpc entry
    ... My computer has 2gB of ram and I am exploring Oracle ... Looks like we used 77MB of temp space in the process of retrieving ... SORT resource Sort statistics ... Total Temp space used: ...
    (comp.databases.oracle.misc)
  • Problem Connecting w Perl/DBD::Oracle as SYSDBA
    ... It is a Linux Red-Hat Advanced Server 2.1 system running ... Oracle 9.2.0.4. ... Some excerpts from the perl program are here.. ... NOT for the other (database BB). ...
    (comp.lang.perl.misc)