This discussion is archived
1 2 Previous Next 18 Replies Latest reply: Jul 14, 2011 1:18 AM by 766938 RSS

Unable to connect to db - ORA-12514 Error

fa77 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points