Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Tnsnames configuration problem
Ok, understood. Yes that extra string at the end of the alias does create problem depending on the OS and version of Oracle. I haven't worked with Oracle 9i, but I would suggest you put ".world" after the alias name in your tnsnames.ora file and check. Also, in other machines that...- JayHind
- Post #4
- Forum: Oracle: All versions
-
Tnsnames configuration problem
I think your main problem is related to the version of Oracle you have installed. Since you have installed Oracle 9.0 CLIENT version, there must be a server installed (either remotly or on the same machine) in order to use the client. Client version can only work when you have a server to...- JayHind
- Post #2
- Forum: Oracle: All versions
-
how to connect to oracle remotely over the 'net
Hi! As long as you put the ip-address of the server in your client's tnsnames.ora it will do an automatic lookup and connect to the server. You don't have to put the name of the server, the ip-address alone is sufficient.- JayHind
- Post #2
- Forum: Oracle: All versions
