#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2011
    Posts
    2
    Rep Power
    0

    Oracle 11g client: ORA-12533 illegal ADDRESS Parameter


    Hi,
    I am working on a database application which works as a data access layer. The application uses OCI interface to connect and query to the Oracle Database. This application is certified on Oracle 9i and 10g client and works fine without any issue, but when I am certifying the application on Oracle 11g client, I am getting connection failed problem and following Oracle Error is displayed.

    ORA-12533 illegal ADDRESS Parameter.

    There is no change in the environment setting between Oracle 10g and Oracle 11g.

    Following are the details of the environment

    Version of Oracle 11g client is 11.1.0.6.0
    Version of Oracle Database is 11.1.0.6.0.
    Platform - Solaris 5.9 on sparc v9

    On enabling client trace with support level also does not help. It shows TNS error TNS-12533 illegal ADDRESS Parameter.


    Can any body help me what could be the possible reasons that the connection is failing with Oracle 11g client, while the same is working with Oracle 10g client. As I said there is no environmental difference when performing this test. The only change is ORACLE_HOME setting for the corresponding Oracle client version.

    Thanks.
    sgarg
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2006
    Posts
    165
    Rep Power
    14
    What does
    Code:
    lsnrctl status
    show?
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2011
    Posts
    2
    Rep Power
    0
    Hi,
    This is how the output of the commad 'lsnrctl sttaus' looks like

    C:\Documents and Settings\sgarg>lsnrctl status

    LSNRCTL for 64-bit Windows: Version 11.1.0.6.0 - Production on 14-JUL-2011 12:25
    :32

    Copyright (c) 1991, 2007, Oracle. All rights reserved.

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=vm-oedsdev1.bedford.prog
    ress.com)(PORT=1521)))
    STATUS of the LISTENER
    ------------------------
    Alias LISTENER
    Version TNSLSNR for 64-bit Windows: Version 11.1.0.6.0 - Produ
    ction
    Start Date 08-JUL-2011 08:34:30
    Uptime 5 days 18 hr. 21 min. 2 sec
    Trace Level support
    Security ON: Local OS Authentication
    SNMP OFF
    Listener Parameter File E:\app\oracle\product\11.1.0\db_1\network\admin\listen
    er.ora
    Listener Log File E:\app\oracle\product\11.1.0\db_1\network\log\listener
    .log
    Listener Trace File E:\app\oracle\product\11.1.0\db_1\network\trace\listen
    er.trc
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=vm-oedsdev1.bedford.progress.com)(PO
    RT=1521)))
    Services Summary...
    Service "orcl" has 1 instance(s).
    Instance "orcl", status READY, has 1 handler(s) for this service...
    Service "orclXDB" has 1 instance(s).
    Instance "orcl", status READY, has 1 handler(s) for this service...
    Service "orcl_XPT" has 1 instance(s).
    Instance "orcl", status READY, has 1 handler(s) for this service...
    The command completed successfully

    Thanks,
    sgarg

IMN logo majestic logo threadwatch logo seochat tools logo