Question
1
Replies
39
Views
Posted: October 4, 2017
Last activity: April 6, 2018
Closed
TNS Listener Error when doing Test COnnection for ECT config
In the ECT tool I have configured the Dev DB using the Add COnfig button But I Keep getting the TNS Error : Listener does not currently know of SID given in COnnect descriptor (I have provided the path to ojdbc7.jar and even configured my tnsnames.ora file with the DB configuration.)
The TNS Error states that the your oracle instance is not registered with the listener.
1. First check if your database is started and running.
2. Update your listener.ora file to add the following lines and later restart the listener. After that check the status of listener status using the command "*lsnrctl status*"
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = <SID-NAME>
(ORACLE_HOME = <ORACLE_HOME PATH>)
)
)