Hi experts!
I have installed DB and its working fine when I try to connect using SQLPLUS.
I am able to start the listener from Windows services....now when I try to connect the same db using TOAD it fails.
I can see listener is up and running but if I check the status using command lsnrctl status I get the following -
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=EMRITDT0272.emaar.ae)(PORT=1523)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
It does not specify the name of my listener here. Strange thing is that after 4-10 times restarting listener, db and my windows machine it works without making any changes to any files.
The DB is hosted on local machine from where I am trying to access toad. The connection will only be success when I see my listener as output in lsnrctl status command.
The error thrown by toad -
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
Any pointers will be appreciated!