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
I tried several hours without any luck.
Finally, I tied adding the below to my listener.ora
(SID_NAME = XE)
(ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server)
and restarted the listener: lsnrctl start
and that did it!
SQL*Plus: Release 22.214.171.124.0 Production on Fri Nov 11 16:43:25 2011
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Oracle Database 11g Express Edition Release 126.96.36.199.0 - Production