957251 wrote:
Hi 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 advanceNetworking configuration can be one of the trickiest part of getting started with Oracle. My advice is to keep it as simple as you can.
When you installed XE it should have created a TNSNAMES.ORA for you in the XE home. (/NETWORK/ADMIN)
Start by copying that TNSNAMES.ORA over to the /Network/Admin