The sqlnet.ora could have a setting in it that the tnsnames.ora uses. For example, the domain may be set in it. If you have a copy of the sqlnet.ora, check and see if there is anything in it that needs to be repeated in the tnsnames.ora.
The program field on v$session should work. It's buggy in that it won't work with if your DB is 8.1.7 and you client isn't, or if the DB is something else and the client is 8.1.7 However, if they are both the same (either both 8.1.7 or both not 8.1.7) that should give the program they are...
We recently went from Oracle 7.3.4 to 8.1.7. All I did was export the repository schema and then import it, and everything went smooth. I don't recall doing anything special. We are using 4.1.5 (yeah, we need to upgrade, I know).
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.