I'm new with Oracle and looking to get some help.
I'm working with Oracle 9i Enterprise Edition and have setup a database called SYNCTEST. I'm trying to access this database remotely from a database connect program. When I connect on the local machine with only the database name, I can connect with no problem. When I use the IP adress or machine name in front of my database name, I get the following error:
ORA-12154: TNS:could not resolve service name
Once again, I'm new to Oracle. I've checked both the [url removed, login to view] file and been connected to the database in the EM console and see no problem. I just can't quite understand why it won't allow me to make the remote connection. I've done some internet reserach on the above listed error and the solution it gives is not helping.
I'm looking for an experienced Oracle person to help guide me in the right direction and resolve this issue as soon as possible. Thanks!
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.
3) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site).
Windows 2000 Professional