Showing posts with label ORA-12514. Show all posts
Showing posts with label ORA-12514. Show all posts

Friday, November 11, 2011

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