Oracle 11g XE issue ORA-12514

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_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 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 - Production


Popular Posts