I am receiving the above error when performing a tnsping or sqlplus connect to a Database I have created on Oracle 817 on Windows 2000.
Despite all efforts to amend the TNSNAMES file and SQLNET.ORA file LISTENER.ORA file I still receive this error. I have created database with a global name of LITTLE, SID = LITTLE.
Services running on WIndows are:-
Oracleora8iTNSListener
OracleServiceLITTLE
Oracleora8iAgent
OracleWebAssistant
LSNRCTL status shows the following:
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 8.1.7.0.0 - Pr
tion
Start Date 20-DEC-2002 09:27:42
Uptime 0 days 2 hr. 52 min. 40 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File c:\ora8i\network\admin\listener.ora
Listener Log File c:\ora8i\network\log\listener.log
Services Summary...
LITTLE has 1 service handler(s)
LITTLE has 1 service handler(s)
PLSExtProc has 1 service handler(s)
dsd01 has 1 service handler(s)
dsdora81 has 1 service handler(s)
Bookmarks