Ora-12154 on Windows 2003 Server
I installed Oracle8.1.7 on Windows 2003 server (IP: 10.128.38.2). But there is a problem now.
I'm trying to create a DB Link to connect another Oracle8 server (IP: 10.128.39.26).
The link creates successfully. But when I try to select * from table_name@db_link, it display ORA-12154: TNS:could not resolve service name.
If I install Oracle8.1.7 on windows 2000 server, this will not happen.
Is this problem caused by 2003 server? How to resolve it?
I searched it from Internet, and tried to resolve it by modify tnsnames.ora, but failed.