Hello everyone,
A few days ago, I was getting this error message (while I was trying to log on my pluggable database) :
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
And I was able to get past this error message by adding the following entry to the listener.ora
file :
(SID_DESC =
(SID_NAME = ORCLPDB)
(ORACLE_HOME = C:\Oracle19c)
)
Now I don't get ORA-12514 anymore. But I am getting a new error message :
ORA-12518:TNS:listener could not hand off client connection.
This message was also written to the log file. In the log file, I also saw :
TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error
64-bit Windows Error: 203: Unknown error
I have done a lot of googling. And I tried closing all user apps but one CMD terminal and
tried to log on again. And I still got ORA-12518. I have also tried to increase the number
of processes from 320 to 800; and still got ORA-12518.
Have you encountered this problem before? How did you fix it? I appreciate any help
you might be able to provide.
Thank you,
cmh