I have tried to install Toad on a windows 2003 server with a 9.2 oracle database.
I set up the database but when I try and connect to sqlplus/toad I get ora-12154: TNS: could not resolve service name....
The only difference I can find with this setup is that when I go to deveice manager - services there is no Ora92TNSnameslistener in the list. There has also been no TNS entry in Oracle\ora92\network\admin\.
I've manually put:
(ADDRESS = (PROTOCOL = TCP)(HOST = gbsflatest)(PORT = 1521))
(CONNECT_DATA = (SID = PLAYP1))
but still no joy.
When I try:
I get lsnrctl for 32-bit windows.......
starting tnslsnr: please wait..
Failed to open service <OracleOraHome92TNSListener>, error 1060
STATUS of the Listener..........
The listener supports no services
any ideas what Im doing wrong?