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

[Paul M. <p.f...@gm...>]

On 28 November 2011 18:52, Humberto Ferreira da Luz Junior
<hum...@gm...> wrote:
> The prefix is used by the python framework web2py, I tried removing it, but
> I got the same output.
> The SQL Plus isn't installed in my OS, but I can access this conection
> through SQL Developer with SID = "dese" and I can connect without problems.
> Could this be a python issue?

If you don't have SQLPlus, it sounds like you don't have an Oracle
client installed. SQL Developer is Java-based and uses JDBC, which
does not need a full Oracle client. For Python, you need either an
Oracle client install, or Oracle Instant Client. Both of these have
sqlplus (OK, a minimal instant client setup might not, but it can be
added), so you should first check that you can connect via sqlplus -
if that works, Python should also.

Try the command sqlplus user/password@tnsname (or sqlplus
user/password@//host:port/service if you haven't got tnsnames set up).

If these don't work, get them sorted (this is a purely Oracle issue,
get your local DBA to help if you need to). Once this works, whatever
you used in the sqlplus command should also work in Python.

Paul.