1 2 Previous Next 18 Replies Latest reply: Jul 14, 2011 3:18 AM by krzyhu RSS

    Unable to connect to db - ORA-12514 Error

    fa77
      Hi,
      I jst installed Oracle Database 11g Express Edition Beta. When Im trying to connect, i got following message.

      SQL> conn sys/sys@xe.ora.com
      ERROR:
      ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

      or

      SQL> conn sys/sys@xe
      ERROR:
      ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

      ------- tnsnames
      XE.ORA.COM=
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = oracle.ORA.COM)(PORT = 1521))
      (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = XE.ORA.COM)
      )
      )
      --------
      --------listener
      LISTENER =
      (DESCRIPTION_LIST =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = oracle.ORA.COM)(PORT = 1521))
      )
      )
      --------


      Please help me.
      Thx
        1 2 Previous Next