Hi,
In Cloud Control(12.1.0.3) I can connect to my Container database fine but when I try to get into one of the plugable database I get this connection error:
Listener refused the connection with the following error: ORA-12523, TNS:listener could not find instance appropriate for the client connection The Connect Descriptor was (DESCRIPTION=(ADDRESS_LIST = (ADDRESS=(PROTOCOL=tcp)(HOST=trlbpd01.nz.thenational.com)(PORT=44901)))(CONNECT_DATA=(SERVICE_NAME=pdbbpmt2.nz.thenational.com)(INSTANCE_NAME=cdbbpmt.nz.thenational.com)(UR=A)(SERVER=DEDICATED)))
And I know the problem is with the instance name INSTANCE_NAME=cdbbpmt.nz.thenational.com it has the domain name appended to it but the listener is not listening for that eg the listener status is like this.
Services Summary...
Service "cdbbpmt.nz.thenational.com" has 1 instance(s).
Instance "cdbbpmt", status READY, has 1 handler(s) for this service...
Service "cdbbpmtXDB.nz.thenational.com" has 1 instance(s).
Instance "cdbbpmt", status READY, has 1 handler(s) for this service...
Service "pdbbpmt1.nz.thenational.com" has 1 instance(s).
Instance "cdbbpmt", status READY, has 1 handler(s) for this service...
Service "pdbbpmt2.nz.thenational.com" has 1 instance(s).
Instance "cdbbpmt", status READY, has 1 handler(s) for this service...
I have tried a test on the server where I can connect with the same string if I modify the INSTANCE_NAME.
So the question is do I modify the connection string (somehow) or do something on the server side ?
Thanks