957251 wrote:Networking configuration can be one of the trickiest part of getting started with Oracle. My advice is to keep it as simple as you can.
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
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
957251 wrote:First connect as SYS, as SYSDBA. Then issue:
Thanks for the quick response. Sure, I already did that, but now that the XE database is recognized, and I test the connection is telling me that the HR account is locked. I tried to unlock it in XE but I do not know how. Do I need to use SQL developer for that? Thanks again.
Now, even thought I have been able to unlock the connection, when I try to connect using the default HR user with the hr password, the error that I get is that it is an invalid set of credentials i.e. 'Invalid username/password. login denied'. I do not know if it is because I had to install the XE database with a different set of credentials (i.e. admin)which are different from my normal credentials under which I run Visual Studio as an applicationDuring the install, you must have set the password and then forgot it.
Can you suggest something for this? Thanks again
957251 wrote:The Getting Started guide seem to cover "scenarios" mentioned in this thread (e.g. how to properly reset HR user).
trying to follow the documentation that is provided, and the scenarios that I am finding were not documented.