URGENT!!! Ora: Target Host Or Object Does not EXIST

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.