| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Sqlplus and connect internal
On Thu, 07 Sep 2000 13:50:25 -0800, Steve O'Donnell wrote:
>Server manager connects OK with connect internal, but sqlplus insists on
>having a password and then fails to connect with the ORA-01031 =
insufficient
>privileges message.
>
>But if I supply sqlplus with a connect internal/password all on the same
>line it connects fine.
I get the same behavior. For example:
SQL> connect internal
Enter password:
ERROR:
ORA-01031: insufficient privileges
SQL> connect internal/oracle
Connected.
I have to believe that this is a bug. BTW, I have a password file, so even Server Manager requires a password.
Here's another oddity that I noticed while experimenting with this. I set remote_login_passwordfile=3Dnone, deleted my password file, and then I stopped and restarted my database service from the control panel. At that point I should have been able to connect internal without a password. Instead, both SQL*Plus and Server Manager prompted me for a password. Then they both rejected whatever password I typed in. The end result was that I was forced to reinstate my password file. That doesn't seem like proper behavior, and at the moment I'm at a loss to explain it.
Jonathan
>Are there two bugs with sqlplus here ?
>
>1. You cannot connect internal if prompted for a password in sqlplus.
>2. sqlplus requires a password for internal but svrmgrl does not.
>
>I suspect this is only a feature on NT.
>
>Has anyone else run into this ?
Received on Mon Sep 11 2000 - 09:02:46 CDT
 |
 |