DRCP erroring in 11g
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: DRCP erroring in 11g

  1. #1
    Join Date
    May 2008
    Posts
    2

    DRCP erroring in 11g

    Im trtying to get DRCP to work with 11g. the error im getting is ;

    "ORA-12523: TNS:listener could not find instance appropriate for the client
    connection"

    The tnsnames.ora entry is;
    --------------------------------
    o11gtest =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = server)(PORT = 1599))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = o11gtest)
    (SERVER = POOLED )
    )
    )

    If I take the "(SERVER = POOLED " section out then I can connect as you would expect.

    The connection pool is started ;

    1* select POOL_NAME,NUM_OPEN_SERVERS from v$cpool_stats
    SQL> /

    POOL_NAME NUM_OPEN_SERVERS
    ------------------------------ ----------------
    SYS_DEFAULT_CONNECTION_POOL 4

    SQL> select status from dba_cpool_info
    2 /

    STATUS
    ----------------
    ACTIVE

    services in the listener;
    ----------------------------
    Services Summary...
    Service "o11gtest" has 1 instance(s).
    Instance "o11gtest", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
    "DEDICATED" established:0 refused:0
    LOCAL SERVER


    Any ideas? Its starting to drive me nuts...

  2. #2
    Join Date
    May 2008
    Posts
    2
    Worked it out - the database wasnt successfuly registering with the listener. It was odd as when not POOLED I could connect to the database ok. There was some issues with the LOCAL_LISTENER setting I think. It works ok now.

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