Just came across about this new listener-to-sid issue when we upgraded the oracle DB to 12c version.
initially when we were using oracle verison 11 i did not see this issue. As we moved to oracle 12c i saw application is behaving weidly with below error.
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
solution:-
we need to add an entry in the listener.ora file and reload the listener to take effect.
USE_SID_AS_SERVICE_LISTENER_NAME=ON
Hope this Helps......
initially when we were using oracle verison 11 i did not see this issue. As we moved to oracle 12c i saw application is behaving weidly with below error.
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
solution:-
we need to add an entry in the listener.ora file and reload the listener to take effect.
USE_SID_AS_SERVICE_LISTENER_NAME=ON
Hope this Helps......
No comments:
Post a Comment