Hi, I have Oracle 11g Database Server. I have tried to to use DRCP.
SQL> conn / as sysdba
Connected.
SQL> execute dbms_connection_pool.start_pool();
PL/SQL procedure successfully completed.
It has the following error.
SQL> conn cagmis/cagmis@localhost:1521/meghdoot:pooled
ERROR:
ORA-12523: TNS:listener could not find instance appropriate for the client connection
What may be the reason??
Make sure your *services* are present, eg
SQL> select name from dba_services;
NAME
------------------------------------------
SYS$BACKGROUND
SYS$USERS
db122XDB
db122
Make sure your pool is started and working
SQL> select * from V$CPOOL_STATS
2 @pr
==============================
POOL_NAME : SYS_DEFAULT_CONNECTION_POOL
NUM_OPEN_SERVERS : 4
NUM_BUSY_SERVERS : 0
NUM_AUTH_SERVERS : 0
NUM_REQUESTS : 0
NUM_HITS : 0
NUM_MISSES : 0
NUM_WAITS : 0
WAIT_TIME : 0
CLIENT_REQ_TIMEOUTS : 0
NUM_AUTHENTICATIONS : 0
NUM_PURGED : 0
HISTORIC_MAX : 4
CON_ID : 0
and then try the connection, eg
C:\>sqlplus scott/tiger@localhost:1521/db122:POOLED
SQL*Plus: Release 12.2.0.1.0 Production on Wed May 24 09:33:41 2017
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Last Successful login time: Thu May 04 2017 12:25:30 +08:00
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production