Dbstart problem 2006-05-04 - By Bennett Leve
Jafar,
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
|
|
