Re: ORA-12154: TNS: could not resolve service name

Hi,

There are two things. I think when you say _at_comset you are refering to 'comset' database on your server. If this is true you have to setup TNSNAMES.ora in either /etc/ directory or in default directory ie. $ORACLE_HOME/network/admin. Start sql*NET 2 command... lsnrctl start <listener name> (you can find this in listener.ora in the same directory as that of tnsnames.ora, example could be tcplistener/declistener or just listener). My experience tells me that by doing this you will be able to connect to database from server using the command sqlplus uid/pwd_at_comset. For client you have to do the same thing. Make sure SQL*NET 2 is installed
Update TNSNAMES.ora to have the alias for the database (comset) sqlplus uid/pwd_at_comset

If you want to use SQL*NET 1
install sql*NET on server and client both and then try following command sqlplus uid/pwd_at_T:<server_name_or_ip_address>:database_name

Hope this will help you in solving the problem. Received on Sun Aug 25 1996 - 00:00:00 CEST