cx-oracle-users

[cx-oracle-users] Installation of cx_Oracle-4.1.2 for py2.5b1. It worked!!

[Paparipote . <pap...@ho...>]

Hello Anthony:
I wanted to advise you about my first tests of your valuable cx_Oracle with 
python 2.5b1 under windows XP sp2. It worked!!!
1) First I got the InstantClient 10.2 from Oracle Windows from 
http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html 
(a login is required but everybody can subscribe). I knew about this 
download site in your cx-oracle-users Archives.
2) I downloaded: instantclient-basic-win32-10.2.0.2-20060508.zip 
(Necessary), instantclient-sqlplus-win32-10.2.0.2-20060508.zip, 
instantclient-odbc-win32-10.2.0.2-20060508.zip and 
instantclient-basiclite-win32-10.2.0.2-20060508.zip (last three are 
optional).
3) I unzipped all four into a unique folder (c:\ora) and I added this path 
into the Windows system variable "path"
4) Into c:\ora I created: c:\ora\network\admin and into admin I created 2 
files: sqlnet.ora and tnsnames.ora  ; tnsnames.ora contains info of 
connections to Ora databases.
5) I also created a new system variable: ORACLE_HOME to put the path: c:\ora
6) I installed your new Windows cx_Oracle for python25.b1
7) I invoked python and I followed the instructions in your README.TXT
8) I ran the script and It worked!!! I could connect to an Oracle database 
and got its information.
9) Many thanks for your help and product, I will now try with Oracle express 
and I am sure I will not have problems. I am planning to use this in Django 
framework, I am waiting for some adjustments that are applying to the Django 
API; as you know, the django guys are using your product.
I really appreciate your nice work in integrating a powerful DBMS to the 
pyhton community.

_________________________________________________________________
Las mejores tiendas, los precios mas bajos, entregas en todo el mundo, 
YupiMSN Compras: http://latam.msn.com/compras/

Re: [cx-oracle-users] Installation of cx_Oracle-4.1.2 for py2.5b1. It worked!!

[Amaury F. d'A. <ama...@gm...>]

Hello,

2006/7/5, Paparipote . <pap...@ho...>:
> I wanted to advise you about my first tests of your valuable cx_Oracle with
> python 2.5b1 under windows XP sp2. It worked!!!

Good to know... thanks for testing!

> 4) Into c:\ora I created: c:\ora\network\admin and into admin I created 2
> files: sqlnet.ora and tnsnames.ora  ; tnsnames.ora contains info of
> connections to Ora databases.

These files are no more mandatory with Oracle 10, where the database
info can be spelled "server/SID" (then the protocol is tcpip, on port
1521)
ex: connect scott/tiger@localhost/ORCL

> 5) I also created a new system variable: ORACLE_HOME to put the path: c:\ora

I suppose this is needed only to find the tnsnames.ora file.

-- 
Amaury Forgeot d'Arc

Re: [cx-oracle-users] Installation of cx_Oracle-4.1.2 for py2.5b1. It worked!!

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

On 7/5/06, Amaury Forgeot d'Arc <ama...@gm...> wrote:
> Hello,
>
> 2006/7/5, Paparipote . <pap...@ho...>:
> > 4) Into c:\ora I created: c:\ora\network\admin and into admin I created 2
> > files: sqlnet.ora and tnsnames.ora  ; tnsnames.ora contains info of
> > connections to Ora databases.
>
> These files are no more mandatory with Oracle 10, where the database
> info can be spelled "server/SID" (then the protocol is tcpip, on port
> 1521)
> ex: connect scott/tiger@localhost/ORCL
>
> > 5) I also created a new system variable: ORACLE_HOME to put the path: c:\ora
>
> I suppose this is needed only to find the tnsnames.ora file.

Oracle uses the environment variable TNS_ADMIN if you want to specify
a directory different from the ones it normally searches in looking
for the TNS administration files (like tnsnames.ora). As has already
been stated, you can identify a database using the host and its SID
(as above). Oracle generally does not recommend setting the
environment variable ORACLE_HOME on Windows as it can interfere with
multi-homing on that platform and can occasionally cause weirdnesses
of various sorts to appear. All that is needed is for the directory to
be in the PATH environment variable and Oracle does the rest.

> --
> Amaury Forgeot d'Arc
>
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>