Is $ORACLE_HOME set to the correct path?
If the tnsnames.ora is not in $ORACLE_HOME/network/admin/, is $TNS_ADMIN set
to the actual location of the file?
On 09 Dec 2005 15:37:33 +0200, Claude <[EMAIL PROTECTED]> wrote:
>
> I run locally a client script which fails with the following message:
>
> ORA-12154: TNS:could not resolve service name (DBD ERROR:
> OCIServerAttach) at ...
> DBI::connect('DBI','dbi:Oracle:abc','batman','secret','HASH(0x82d7910)')
> called at ...
>
> The datasource seems ok to me, and I checked from 'tnsnames.ora' that
> the port is set up to the default 1521 and the name is 'abc'.
>
> Any idea of what could be the problem?
> --
> Claude
>
--
It all comes down to a choice really.
You can get busy living, or get busy dying.
--Stephen King
