Re: [cx-oracle-users] cx_Oracle installation problem / python

[Mark H. <mh...@pi...>]

On 11/28/11 10:19 AM, Humberto Ferreira da Luz Junior wrote:
> I think I'll need your help once more.
> I installed oracle_client and cx_oracle.
>
> When I type "import cx_Oracle" in python shell everything works ok. But when I try to connect to the database I get the following error:
>
>  >>> conn = cx_Oracle.connect('oracle://user/password@ip:port/dese')
>
> Traceback (most recent call last):
>    File "<pyshell#2>", line 1, in <module>
>      conn = cx_Oracle.connect('oracle://user/password@ip:port/dese')
> *DatabaseError: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor*
>
> By what I understood I'd need to create a tnsnames.ora file in ORACLE_HOME/network/admin/ (oracle client path). But after doing this I keep getting the same error.
>
> Does somebody know where or how I should configure the connection?

have you tried one of these forms:

     name/pass@tnsname

     name/pass@//host:1521/instance