How to connect to localhost having Oracle XE 11.2g
960254Sep 5 2012 — edited Sep 6 2012Hi all, I am just beginning to familiarize with the integration of Oracle and .Net apps.
I wanted to build a simple app that connects to a newly installed oracle db express 11g.
I do have a tnsnames.ora file configured containing the following
localhost=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=127.0.0.1)
(PORT=1521)
)
(CONNECT_DATA=
(SERVICE_NAME=localhost)
)
)
when I select the 'Run SQL*Plus Script' menu item from within the Tools main menu item in visual studio 2010, I am able to
see the 'localhost' in the 'Data source name' dropdown. However, when I try to test the connection using
the credentials that I used for the 'system' user name, I get an error saying:
ORA-12514: TNS:listener does not currently know of service
requested in connect descriptor
How can I configure the local listener.ora file to be able to connect successfully?
Thanks in advance