Whenever I open my unix box,after providing username and password I get the following message.
Are you authorised to use this computer as detailed above? (Y)es/(N)o : y
Export: Release 10.2.0.2.0 - Production on Mon May 16 16:00:15 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Username:
Password:
EXP-00056: ORACLE error 12162 encountered
ORA-12162: TNS:net service name is incorrectly specified
EXP-00000: Export terminated unsuccessfully
The session gets automatically connected to oracle and asks for oracle username and pwd.
I have changed my .profile,still the problem pertsists.
Some .??* script is calling oracle to go to a server not configured. Put some debug messages in .profile, like "echo .profile start >/dev/tty", to see if it is there or earlier.
It could also be /etc/profile or even more likely, a file in /etc/profile.d/.
There's a fair chance that the oracle package installed a file, /etc/profile.d/oracle.sh. If it's causing your problem, it would be better to figure out how to solve it without editing the file, since it could be replaced when the package is updated (or will fail to be replaced because it was edited even though it should be replaced).
