We have recently installed Oracle817 on VMS. When I try to connect to the database using sqlplus or oracle forms, I get 'ORA-12545:TNS:name lookup failure' error. Entries in tnsnames.ora and listener.ora are ok. ping and tnsping work fine. However, if I include an entry for this server with the IP address in the /etc/hosts file on the local client machine, it works fine. But there are no entries in this hosts file for other servers (we have 3 servers) which work fine. I would appreciate your help.
These are the listener.ora and tnsnames.ora file entries:
What is the service name of your instance. In the tnsnames.ora file, you might want to consider specifying the service_name instead of the SID_NAME. Can you make a client connection to the server using sqlplus
Regarding the hostname recognetion. consult with your system adminstrator(s) about the DNS looks up configureation and etc.
How did you come to a conclusion that the sqlnet is slow?