Re: [cx-oracle-users] connect from a remote box

[Klaus B. <k....@ew...>]

My client OS is Debian woody.
Oracle Client is 9i.
cx_Oracle-4.1-9i-py23-1.i386.rpm

Now i have defined the ORACLE_HOME Variable.

i have a new error message:


cx_Oracle.DatabaseError: ORA-12545: Connect failed because target host or object 
does not exist

i have a tcpdump running on my nic:

tcpdump -i eth0 dst port 1521

but i see no traffic on eth0

it seems there is no try from the remote host to connect to
the db-server.

> If the suggestions already given in this thread are not enough to
> solve the problem we'll need to know the client OS, the version of the
> Oracle client that you are using and the version of cx_Oracle that you
> are using.
> 
> On Wed, 09 Mar 2005 14:24:07 +0100, Marcos Sánchez Provencio
> <ma...@bu...> wrote:
> 
>>Is ORACLE_HOME defined?
>>
>>El mié, 09-03-2005 a las 14:06 +0100, Klaus Boehm escribió:
>>
>>>ama...@ub... wrote:
>>>
>>>>Klaus Boehm wrote:
>>>>
>>>>
>>>>>i try to connect to a oracle db.
>>>>>this db runs on another server.
>>>>>now i have problem with the connect string.
>>>>>
>>>>>connect([user, password, dsn, mode, handle, pool, threaded, twophase])
>>>>>
>>>>>how looks the dsn if i try to connect from a remote box?
>>>>
>>>>
>>>>If you know how to connect with sql*plus, you've already typed a
>>>>connection string like "<user>/<password>@<dsn>". So it's easy.
>>>>
>>>>
>>>>Else, you must know the name of the server, and the name of the database
>>>>on the server (the service name).
>>>>
>>>>If you installed the Oracle client version 10g, the dsn is simply
>>>>dsn = "<server>/<service>"
>>>>
>>>>With a 8i or 9i Oracle client, it's more complicated:
>>>>dsn = "(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST
>>>>=<server>)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=<service>)))"
>>>>(All in one string, you may add spaces if you want)
>>>>You may want to have a (short) alias for this long string, in this case
>>>>you must edit the tnsnames.ora file. But this is another story.
>>>>
>>>>Hope this helps,
>>>>
>>>>--
>>>>Amaury Forgeot d'Arc
>>>>
>>>>
>>>>
>>>>
>>>>-------------------------------------------------------
>>>>SF email is sponsored by - The IT Product Guide
>>>>Read honest & candid reviews on hundreds of IT Products from real users.
>>>>Discover which products truly live up to the hype. Start reading now.
>>>>http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
>>>>_______________________________________________
>>>>cx-oracle-users mailing list
>>>>cx-...@li...
>>>>https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>>>>
>>>
>>>Now i have the correct dsn.
>>>
>>>
>>>  dsn =
>>>"(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST='db-os.dmg.ewt.de')(PORT=1521)))(CONNECT_DATA=(SID=OSPROD)))"
>>>
>>>connection = cx_Oracle.connect("xxxx", "yyyy", dsn)
>>>
>>>i get the following error:
>>>
>>>RuntimeError: Unable to acquire Oracle environment handle
>>>
>>>have anyone a idea?
>>>
>>>
>>>Klaus
>>>
>>
>>-------------------------------------------------------
>>SF email is sponsored by - The IT Product Guide
>>Read honest & candid reviews on hundreds of IT Products from real users.
>>Discover which products truly live up to the hype. Start reading now.
>>http://ads.osdn.com/?ad_ide95&alloc_id396&opclick
>>_______________________________________________
>>cx-oracle-users mailing list
>>cx-...@li...
>>https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>>
> 
> 
> 
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from real users.
> Discover which products truly live up to the hype. Start reading now.
> http://ads.osdn.com/?ad_ide95&alloc_id396&op=click
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
> 


-- 
---------------------------------------------
Klaus Boehm
Systemadministrator
ewt gmbh
D-86152 Augsburg, Volkhartstr. 4-6
Phone:  +49.(0)821.3106-319
Fax: +49.(0)821.310660-319
mailto:k....@ew...
http://www.ewt.de
http://www.surf-club.de
---------------------------------------------