Ora-12520
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 14

Thread: Ora-12520

  1. #1
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681

    Ora-12520

    Hi Friends,

    I got ora-12520 when i connect from client using shared server connect
    to my database. How do I know if my database has correct shared server
    configured?


    Thanks a lot
    Behind The Success And Failure Of A Man Is A Woman

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Oracle9i Net Services Administrator's Guide
    Release 2 (9.2)
    Part Number A96580-02
    Configuring Shared Server
    http://download-east.oracle.com/docs...mts.htm#447168
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    I already followed the instruction setting up the shared server dear (enable dispacthers) , but I still can not connect using the shared server option from the client tnsnames.ora.
    Behind The Success And Failure Of A Man Is A Woman

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    then you didnt follow the instructions did you

  5. #5
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    as far as I know i did ....is there other way to do it? like in gui or browser
    based OEM?
    Behind The Success And Failure Of A Man Is A Woman

  6. #6
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    do you understand english?
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  7. #7
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    On the server
    lsnrctl status
    post the results
    Post also the TNSNAMES entry you use

    Cheers

  8. #8
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    Thanks dear , my hero you are back where have you been?

    LISTENER STATUS
    ==================

    en0(oracle)/home/oracle> lsnrctl status

    LSNRCTL for IBM/AIX RISC System/6000: Version 9.2.0.1.0 - Production on 23-OCT-2
    007 19:17:59

    Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
    STATUS of the LISTENER
    ------------------------
    Alias LISTENER
    Version TNSLSNR for IBM/AIX RISC System/6000: Version 9.2.0.1.
    0 - Production
    Start Date 22-OCT-2007 17:07:32
    Uptime 1 days 2 hr. 10 min. 27 sec
    Trace Level off
    Security OFF
    SNMP ON
    Listener Parameter File /u01/app/oracle/product/9.2.0.1.0/network/admin/listen
    er.ora
    Listener Log File /u01/app/oracle/product/9.2.0.1.0/network/log/listener
    .log
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=en0.maxstack.gov.ph)(PORT=1521)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=en0.maxstack.gov.ph)(PORT=8080))(
    Presentation=HTTP)(Session=RAW))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=en0.maxstack.gov.ph)(PORT=2100))(
    Presentation=FTP)(Session=RAW))
    Services Summary...
    Service "ORA9i.en0" has 2 instance(s).
    Instance "ORA9i", status UNKNOWN, has 1 handler(s) for this service...
    Instance "ORA9i", status READY, has 1 handler(s) for this service...
    Service "ORA9iXDB.en0" has 1 instance(s).
    Instance "ORA9i", status READY, has 1 handler(s) for this service...
    Service "PLSExtProc" has 1 instance(s).
    Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
    The command completed successfully

    ========================
    TNSNAMES.ORA

    IASSVR =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 172.15.0.16)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVER = SHARED)
    (SERVICE_NAME = ora9i.en0)
    )
    )
    Behind The Success And Failure Of A Man Is A Woman

  9. #9
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    Could you please also
    sql> show parameter dispatcher

    and
    ps -ef|grep ora

    10x

  10. #10
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    Thanks again


    SQL> show parameter dispatcher

    NAME TYPE VALUE
    ------------------------------------ ----------- ------------------------------
    dispatchers string (PROTOCOL=TCP) (SERVICE=ORA9iX
    DB)
    max_dispatchers integer 5
    mts_dispatchers string (PROTOCOL=TCP) (SERVICE=ORA9iX
    DB)
    mts_max_dispatchers integer 5
    SQL>


    en0(oracle)/home/oracle> ps -ef|grep ora
    oracle 82042 1 0 20:04:01 - 0:00 oracleORA9i (LOCAL=NO)
    oracle 110686 1 0 Oct 22 - 0:00 ora_lgwr_ORA9i
    oracle 221322 1 0 Oct 22 - 0:01 ora_pmon_ORA9i
    oracle 377020 1 0 Oct 22 - 0:01 ora_dbw0_ORA9i
    oracle 381114 1 0 Oct 22 - 0:04 ora_ckpt_ORA9i
    oracle 385212 1 0 Oct 22 - 0:02 ora_smon_ORA9i
    oracle 389310 1 0 Oct 22 - 0:00 ora_reco_ORA9i
    oracle 393408 1 0 Oct 22 - 0:03 ora_cjq0_ORA9i
    oracle 397506 1 0 Oct 22 - 0:19 ora_qmn0_ORA9i
    oracle 401604 1 0 Oct 22 - 0:00 ora_s000_ORA9i
    oracle 405702 1 0 Oct 22 - 0:00 ora_d000_ORA9i
    oracle 422100 1 0 Oct 22 - 0:00 /u01/app/oracle/product/9.2.0.1
    .0/bin/tnslsnr LISTENER -inherit
    oracle 512072 1 0 16:56:13 - 0:00 oracleORA9i (LOCAL=NO)
    oracle 651510 655532 0 20:04:41 pts/1 0:00 ps -ef
    oracle 655532 528400 0 20:02:50 pts/1 0:00 -ksh
    oracle 667660 655532 0 20:04:41 pts/1 0:00 grep ora
    Behind The Success And Failure Of A Man Is A Woman

Posting Permissions

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



Click Here to Expand Forum to Full Width