Re: [cx-oracle-users] AIX Oracle 11gR2 Patchlevel 11.2.0.1.1
Brought to you by:
atuining
From: BOCKHOLD, L. \(MEAIS\) <Lar...@ai...> - 2010-07-09 07:47:28
|
> Hi, > I am using > cx_Oracle 5.0.2 und python 2.6.4 to access Oracle 10g (Client HPUX B.11.11 U 9000/785 4042425557) > works fine. > > We will upgrade our Database to AIX Oracle 11gR2 Patchlevel 11.2.0.1.1with load balance. > Do I have to change something ? > How do Iconnect now ? > > Example: > JAVA-App > =============== > JDBC-Thin-Clients (JAVA 1.5.x) folgender oder ähnlicher Ansatz funktioniert (=> reine Konfigurations- u. keine Codeänderung): > Ansatz: > jdbc:oracle:thin:@<HOST>:1521:<SID> > must be now: > jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on) > (ADDRESS=(PROTOCOL=TCP)(HOST=host1) (PORT=1521)) > (ADDRESS=(PROTOCOL=TCP)(HOST=host2) (PORT=1521)) > (CONNECT_DATA=(SERVICE_NAME=service))) > > How do I realize this in cx_Oracle Connect ? > Old is now and works fine: > """ > export ORACLE_HOME=/do/pro/P/oracle/102 > export NLS_CHARACTERSET=WE8ISO8859p9 > export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data > export TNS_ADMIN=$MEAIS/tools/DXM-methods/etc/network/admin > dbConnection = cx_Oracle.connect(<user>/<passwd>@odexn.world) > """ > But now I want the Load Balancing like in java explained above. > > Possible ? > Do I need to built cx_Oracle 5.0.3 ? > > Thanks in advance > Lars > > > > > Lars Bockhold > on behalf of Misdorf Engineering and IT-Solutions GmbH & Co. KG > Subcontractor for Functional and Data Support Germany - IDOB2 > (AIRBUS Operations GmbH) > > Phone: +49 (0) 40 743 67837 > Phone: +49 (0) 421 538 6121 > Mobile: +49 (0) 151 58246174 > Mailto:Lar...@ai... > > > The information in this e-mail is confidential. The contents may not be disclosed or used by anyone other than the addressee. Access to this e-mail by anyone else is unauthorised. If you are not the intended recipient, please notify Airbus immediately and delete this e-mail. Airbus cannot accept any responsibility for the accuracy or completeness of this e-mail as it has been sent over public networks. If you have any concerns over the content of this message or its Accuracy or Integrity, please contact Airbus immediately. All outgoing e-mails from Airbus are checked using regularly updated virus scanning software but you should take whatever measures you deem to be appropriate to ensure that this message and any attachments are virus free. |