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

[Anthony T. <ant...@gm...>]

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=E1nchez Provencio
<ma...@bu...> wrote:
> Is ORACLE_HOME defined?
>=20
> El mi=E9, 09-03-2005 a las 14:06 +0100, Klaus Boehm escribi=F3:
> > 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 datab=
ase
> > > on the server (the service name).
> > >
> > > If you installed the Oracle client version 10g, the dsn is simply
> > > dsn =3D "<server>/<service>"
> > >
> > > With a 8i or 9i Oracle client, it's more complicated:
> > > dsn =3D "(DESCRIPTION=3D(ADDRESS=3D(PROTOCOL=3DTCP)(HOST
> > > =3D<server>)(PORT=3D1521))(CONNECT_DATA=3D(SERVICE_NAME=3D<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 ca=
se
> > > 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 use=
rs.
> > > Discover which products truly live up to the hype. Start reading now.
> > > http://ads.osdn.com/?ad_id=3D6595&alloc_id=3D14396&op=3Dclick
> > > _______________________________________________
> > > cx-oracle-users mailing list
> > > cx-...@li...
> > > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
> > >
> > Now i have the correct dsn.
> >
> >
> >   dsn =3D
> > "(DESCRIPTION=3D(ADDRESS_LIST=3D(ADDRESS=3D(PROTOCOL=3DTCP)(HOST=3D'db-=
os.dmg.ewt.de')(PORT=3D1521)))(CONNECT_DATA=3D(SID=3DOSPROD)))"
> >
> > connection =3D cx_Oracle.connect("xxxx", "yyyy", dsn)
> >
> > i get the following error:
> >
> > RuntimeError: Unable to acquire Oracle environment handle
> >
> > have anyone a idea?
> >
> >
> > Klaus
> >
>=20
> -------------------------------------------------------
> 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_id=14396&opclick
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>