oracle over having,How to connect to localhost having Oracle XE 11.2g

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