Results 1 to 6 of 6
  1. #1
    Join Date
    Apr 2004
    Posts
    8

    Exclamation Unanswered: ORA-1003 & 12518

    Hi Experts,

    Though its not too often, I get ORA-1003 and 12518. I would like to know the cause & remedy for it.

    Thanks.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    12518, 00000, "TNS:listener could not hand off client connection"
    // *Cause: The process of handing off a client connection to another process
    // failed.
    // *Action: Turn on listener tracing and re-execute the operation. Verify
    // that the listener and database instance are properly configured for
    // direct handoff. If problem persists, call Oracle Support.
    // *Comment: The problem can be worked around by configuring dispatcher(s)
    // to specifically handle the desired presentation(s), and connecting
    // directly to the dispatcher, bypassing the listener.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Apr 2004
    Posts
    8

    Question

    Thanks anacedent,

    Can you please describe how to configure it.
    I am having Oracle 9i R2 with an instance on Solaris 8.
    My DB is in Dedicated mode.
    Listener listens on default port - 1521.

    What should I configure to avoid 12518.

    Thanks

  4. #4
    Join Date
    Apr 2003
    Location
    Jagdishpur
    Posts
    146
    Hi,
    Can u post your listener.ora file from $ORACLE_HOME/network/admin. It might be a help to me to understand the reason in better way. Also, i may like to see one DB parameter in ur INIT.ORA..Pls. check this out. What is the value for Parameter "dispatchers". Just confirm this. It should be "(PROTOCOL=TCP)"
    I do not know whether this is default or not. You just test it out & let us know.

    Regards,
    Kamesh Rastogi
    - KR

  5. #5
    Join Date
    Apr 2004
    Posts
    8

    Lightbulb

    Thanks Kamesh,

    FYI: connection is extablished through sql*plus but fires 21518 when tried to connect throuh JDBC. Also I am using WebLogic. DB is in SHARED SERVER mode.

    Here are my listener.ora & init.ora files for your reference.
    ************************************************** ********
    # LISTENER.ORA Network Configuration File: /oracle/product/9.2.0.1/network/admin/listener.ora
    # Generated by Oracle configuration tools.
    SAVE_CONFIG_ON_STOP_LISTENER = TRUE
    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = sol8srv01)(PORT = 1521))
    )
    )
    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = /oracle/product/9.2.0.1)
    (PROGRAM = extproc)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = db01_9i2.com)
    (ORACLE_HOME = /oracle/product/9.2.0.1)
    (SID_NAME = db01_9i2)
    )
    )
    LOGGING_LISTENER = OFF


    ************************************************** ********
    aq_tm_processes=1
    background_dump_dest='/oracle/admin/db01/bdump'
    compatible='9.2.0.0.0'
    control_files='/oracle/oradata/db01/control01.ctl','/oracle/oradata/db01/control02.ctl','/oracle/oradata/db01/control03.ctl'
    core_dump_dest='/oracle/admin/db01/cdump'
    db_block_size=8192
    db_cache_size=33554432
    db_domain='com'
    db_file_multiblock_read_count=16
    db_name='sigma'
    dispatchers='(PROTOCOL=TCP) (SERVICE=si92XDB)','(PROTOCOL=TCP)'
    fast_start_mttr_target=300
    hash_join_enabled=TRUE
    instance_name='db01_9i2'
    java_pool_size=117440512
    job_queue_processes=10
    large_pool_size=67108864
    open_cursors=600
    pga_aggregate_target=25165824
    query_rewrite_enabled='FALSE'
    remote_login_passwordfile='EXCLUSIVE'
    shared_pool_size=67108864
    sort_area_size=524288
    star_transformation_enabled='FALSE'
    timed_statistics=FALSE
    undo_management='AUTO'
    undo_retention=10800
    undo_tablespace='UNDOTBS1'
    user_dump_dest='/oracle/admin/db01/udump'
    processes=500
    parallel_max_servers=8
    sessions=557
    trace_enabled=false
    transaction_auditing=false
    remote_archive_enable=false

    Thanks

  6. #6
    Join Date
    Apr 2003
    Location
    Jagdishpur
    Posts
    146
    Hi Jammu,
    Sorry i do think that i can beat it. I am not using this JDBC. So, probably i am not able to help u. But, i seen some post there on metalink which has some stuff like this for its solution. I could understand it much..Pls. see it there.

    Thanks for ur compilment & sorry as i not able to help u.

    Keep in touch.

    regards,
    Kamesh Rastgoi
    - KR

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •