I was trying to get Oracle 11g XE installed on my Win 7 (x64) PC and ran into the below error:
ERROR: ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
I tried several hours without any luck.
Finally, I tied adding the below to my listener.ora
(SID_DESC =
(SID_NAME = XE)
(ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server)
)
and restarted the listener: lsnrctl start
and that did it!
C:\Users\...>sqlplus system@xe/...
SQL*Plus: Release 11.2.0.2.0 Production on Fri Nov 11 16:43:25 2011
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production
SQL>
