-
Is there another log that will list attempted access where there is an error message listing why connection cannot be established? I have a developer trying to set up a connection to an Oracle database but he doesn't show up on the listener log. Another developer is having no problems with the same access. Any ideas how to troubleshoot this?
We use Oracle 8.1.7 on NT.
Thanks.
-
The listener.log will only record successful connections. The developer should trap the error he is getting during the connect phase. Depending on whether you have tracing turned on or not, you might be able to look in the sqlnet.log file on the client for information.
Jeff Hunter
-
1. Can you connect to the database from the server?
2. Can you
Code:
tnsping service_name
sqlplus sys/password@service_name
3. If this fails then check the tnsnames.ora and sqlnet.ora file configurations. If they are correct, try stopping and starting the listener
4. If you can reach the database successfully, then repeat the step 2 from the client system.
5. If that fails, check all the tnsnames.ora files for the configurations to be correct
Sam
Thanx
Sam
Life is a journey, not a destination!
-
2. Can you
Code:
tnsping service_name
sqlplus sys/password@service_name
BTW, do you know that there are cases when you are able to connect, everything is OK but not to tnsping (TNS-03507 failure looking for address) :-)
Do you know when?
-
is that when you change the ip address or the hostname or perhaps the host file ?
Vinit
-
When you tnsping a service name for a non-single instance DB.
-
Originally posted by julian
When you tnsping a service name for a non-single instance DB.
And if that service name is not in tnsnames.ora
Vinit
-
And if that service name is not in tnsnames.ora
:-) Right
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|