Printable View
Gurus,
i have set up my listener at client side and tnsnames.ora at client side. I am using oracle 8.1.5. Clients are installed on the client machines. When i try to connect on the server with the same instructions in tnsnames.ora as in client side, it connects. But from the client's machine, it refuses...
Please Advice...
Thanks,
Mohit.
Try to ping the host. Listener is set up on the server and not the client.
listener files are in $ORACLE_HOME/network/admin.
Cheers
Vinit
sorry, i have set up the listener on the server side only. I have also tried pinging. Even the TNSPING is working fine and giving me about 1370ms as time with ok. But still when i try to connect it says target or host object does not exist.
Plz Advise...
Thanks,
Mohit.
What ORA error code do you get upon attempt to connect to the server?
What error message do you get?
Can you show us the contents in your TNSNAMES.ORA file?
How do you try to connect?
connect system/manager@
ora-12545 Connect failed because target host or object does not exist
CONTENTS OF TNSNAMES.ORA
=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=1521))
)
(CONNECT_DATA=
(SERVICE_NAME=)
)
)
I hope this will help.
Thanks,
Mohit.
you should put values for host and service_name, else it won't work ...
You've not mentioned the connect string.
connect user/pw@db
Similarly for your tnsnames -
db=(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=hostname)(PORT=1521))
)
(CONNECT_DATA=
(SERVICE_NAME= db)
)
)
This should solve your problem.
th host names and the service names are there. I've even tried with the ip address and the global db_names. But still the same error persists. but the tnsping gives me result still unable to connect.
Mohit.
Make sure that you have started the correct listener.
Which version of SQLnet are you using?
Maybe SERVICE_NAME should be replaced with SID in the CONNECT_DATA string.
already did that. The same thing's working at the server the same way and the same settings. Just not on the client. Although it has the same settings too
Mohit.
tried that too. The sid without the global name and the global name. Di not give any different result.
Mohit.
You didnt happen to call your server the same name as your sid or instance??
nope. The machine name is like server and the sid name is like orcl and the global name is like orcl.domain
Mohit.
I suppose that you use windows clients. Take a look at the TNS_ADMIN parameter in the registry. Is that the correct path to your TNSNAMES.ORA? Maybe you have more than one ORACLE_HOMES?
What do the error logs say ../network/logs/listner.log
It is the correct path and i only have one oracle home
Mohit.
it gives a description of establish statements with return codes 0 and the name + path of the calling program on the remote machine.
Mohit.
what is the status of your listner LSNRCTL> status and does your listner support services
the listener is supporting services and there are no errors in the status either.
Mohit.
Did you use MTS setting ?
Unistall and reinstall the networking software.
not using mts ...
Mohit.
What kind of option do you use for resolving the service name? Localnaming, hostnaming or what? How does your
NAMES.DIRECTORY_PATH looks like in your SQLNET.ORA file
on the client and on the server?
1) stop and restart the listener, try conection again.
2) If you use MTS (shared connection), try to use dedicated server. Listener sometime stop response to remote shared connection.
I think a point was overlooked.
THe TNSPING took 1300+, but worked.
Best guess is a network issue. The network is so slow the signin is timing out and assuming the server is not there.
Possible causes: 100MB network card on at 10MB network (packet loss), too many switch hops so routing slows response unacceptably..
We have seen similar problems on our network.
sqlnet content
names.directory_path=(tnsnames,hostnames)
both places.
Mohit.
Yes, it can be a network issue as jrpm poined out. Increase the CONNECT_TIMEOUT parameter in LISTENER.ORA. Would it help?Quote:
Originally posted by jrpm
I think a point was overlooked.
THe TNSPING took 1300+, but worked.
Best guess is a network issue. The network is so slow the signin is timing out and assuming the server is not there.
Possible causes: 100MB network card on at 10MB network (packet loss), too many switch hops so routing slows response unacceptably..
We have seen similar problems on our network.
You may have a couple of problems with tnsnames.ora:
- 1. What client software you use (if old version, that use Net8 , not from 8.1.5 then you should have 2 tnsnames.ora files
- 1 in .../network/admin/tnsnames.ora
- 2 in .../net8/admin/tnsnames.ora
- 2. you may try to use 2 aliases in tnsnames.ora
- 1) db_alias1 = ... (service_name = ...)
- 2) db_alias2 = ... (sid = ...)
- 3. if you use alias with oracle domain name:
for example some client software want
full alias name:
user/[email protected]_alias
Try.
hi,
you should also enter a value for SID and GLOBAL_NAME, otherwise you can't connect. If in doubt
login to METALINK and search for tnsnames.
Hi, sorry I have not read everythink but the problem do you have is , if I understood everythink correct:
1) server machine has OS unix
2) client machin has OS Windows
NEVER apply configuration files from UNIX to WINDOWs and forward as they have absolutly different coding, you can't see all characters in your file but they are here, for example you cant see chr(0), chr(10), chr(13).
So solution is: remove tnsnames.ora from your client and create new one. Using Windows tools or manualy, I had the same problem .
Best wishes.
[Edited by kgb on 09-26-2001 at 12:35 PM]Quote:
Originally posted by gooftrap
Gurus,
i have set up my listener at client side and tnsnames.ora at client side. I am using oracle 8.1.5. Clients are installed on the client machines. When i try to connect on the server with the same instructions in tnsnames.ora as in client side, it connects. But from the client's machine, it refuses...
Please Advice...
Thanks,
Mohit.
To better find the point of failure, could you check the following:
File-name: sqlnet.ora
Check what was your
NAMES.DEFAULT_DOMAIN=
SQLNET.EXPIRE_TIME=
If you have the DOMAIN name set as world then you have to use the NAME.WORLD as a service name in your tnsnames.ora file (eg: SID.WORLD)
Sample tnsnames.ora file on the client machine:
SID.WORLD=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1521))
)
(CONNECT_DATA =
(SID = your_sid)
)
)
Then try connecting as from the command prompt/dos prompt:
sqlplus user_name/[email protected]
Looking forward to hear from you...
Sam
(1)if it is nt/w2k server there can be control characters which can cause problem and they are not seen. Look for them and
edit suitably.
(2)the peranthesis are to be verified.. i doubt you have one right peranthesis extra.
(3)if you have multiple listener services stop all and start the correct one.
havent read whole thread but check you hosts file in windows