We have a new machine installed with Solaris 8. I installed oracle 8.0.5 (from a tar file) and everything worked fine. Then I had to downgrade the OS to r7 because an apps will not run in r8. We did that and now we are having some problem with Oracle. Whenever I use svrmgrl to connect to oracle, it prompts for password. I found that I also need to start the listener first - otherwise i would get TNS - no listener. I thought you dont need the listener to be up to connect to a database using svrmgrl!!?? Am i right? I have check....the oracle user is in the dba group. Anything else I am missing? Aside to that problem, I also have another problem with the solaris machine. When I telnet to it, it takes about 1 minute for the login prompt to appear. However, it works fine if I add my pc ip address in the hosts file. Any clue?
01-26-2001, 08:07 AM
do you have the enviroment variable TWO_TASKS set? If it is unset it, it might work
01-27-2001, 04:50 AM
I remember I set that env var after recreating the oracle user in the .profile. When it worked before I did not set. Actually what is it used for? Default database sid?
Thanks. I will try that when I go back to work on Monday.
01-29-2001, 10:21 AM
Pando, Would you please elaborate that what this two_tasks paramter is used for ?.
Thanks and Regards,
01-29-2001, 10:25 AM
You are right. When I unset TWO_TASK it no longer prompts for password when I try to connect internal. Thanks.
But what is it used for?
01-29-2001, 11:30 AM
It sets default SQL*Net connect string defined in tnsnames.ora thats set as part of Environment Setup.
Either you have to undefine it or use diffrent connection string explicitely @xyz to connect, as by default it connects to that whenever you don't specify explicit connect string.