TWO_TASK is used to set an alias for clients. This should not be set if you are making local connections to a database. Also setting it to NULL is not correct and may lead to problems with some clients. To unset it do:
$ unset TWO_TASK
Or just comment it out. If you do require to set it, you would set it to the value after "@" symbol for connections such as:
$ sqlplus scott@(protected)
Doing this would do the same thing:
$ export TWO_TASK=my_alias $ sqlplus scott
The variable to change the default location of TNS files such as tnsnames.ora would be "TNS_ADMIN" and you set this to the non standard directory where your tnsnames.ora and/or your listener.ora reside. In your example, it appears you are pulling the tnsnames.ora from the default location so there is no need to set this.
Hope this helps.
-Bennett
Hosseinzadeh, Jafar wrote: > Hi all, > > Thank you for those of you who sent me suggestions. The problem is > corrected. > Thank you Tom C for asking about my TWO_TASK var setup. That was the > problem. > > Non working setup: > export > TWO_TASK="/mnt/u1/apps/oracle/product/10.1.0/db_1/network/admin/tnsnames > .ora" > > working setup: > export TWO_TASK= > > or if I comment out the whole thing. > > Regards, > --jh > > >
-- To unsubscribe, email: suse-oracle-unsubscribe@(protected) For additional commands, email: suse-oracle-help@(protected) Please see http://www.suse.com/oracle/ before posting
