File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Oracle/OAS and the fly likes how start the tnslistener / how edit connection string Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Make it so: Java DB Connections & Transactions this week in the JDBC forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "how start the tnslistener / how edit connection string " Watch "how start the tnslistener / how edit connection string " New topic

how start the tnslistener / how edit connection string

muhammad fahim
Ranch Hand

Joined: Dec 17, 2006
Posts: 45
hi master
sir i am useing jsp with oracle
my page give me right result in my system but when i test client system then system give me this error
Database Log In Failed
TNS could not resolve service name
Verify that the TNS name in the connectstring entry of the DAD for this URL is valid.
sir i post my problem in java.sun forum he reply me as under
on your machine where your db is installed, start the tnslistener of your database, make sure that your connection string is pointing to that machine

jdbcracle:thin:@<ip or hostname of machine where your db is installed>: 1521:aamir

please give me idea how i run my page in client system


Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3749

Since this question is not really about JDBC and Oracle specific, moving it to Oracle forum.

[OCA 8 Book] [Blog]
Mark Spritzler

Joined: Feb 05, 2001
Posts: 17276

So in your test environment, where should Oracle be running? Is it just that your DBA set up a test server and that is where your tests should run, or is it an Oracle server version that is running on your local machine? I am assuming that the DBA has a test server. And you just don't have the correct URL for it, or the DBA doesn't have it running, either way you need to go to your DBA.

If it is running local, then you need to read up a bit more on Oracle on how to run the server.


Perfect World Programming, LLC - iOS Apps
How to Ask Questions the Smart Way FAQ
I agree. Here's the link:
subject: how start the tnslistener / how edit connection string
It's not a secret anymore!