| 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
Well I have an NT 8.0.4 database with SQL*Plus 8.0.4.0.0. and
8.1.6.0.0.-(Along with OEM 2.1)
With the 8.0.4 version I get ORA-01031: insufficient privileges. But with the 8.1.6 version it connects fine, and I can startup and shutdown my instance. This leads me to believe it's not a platform problem, but a version problem, or maybe a mix of the two. (Which version of SQL*Plus were you using Stephen?)
SQL*Plus never used to support an internal connect pre 8.X anyway did it? So maybe it was added around 8.0.4.x.x? Anymore insights?
Cheers
Mark
-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Stephen
Andert
Sent: 13 September 2000 01:46
To: Multiple recipients of list ORACLE-L
Subject: Re: Sqlplus and connect internal
It worked for me:
SQL> connect internal
Connected.
SQL>
I'm on Digital Unix and I tried both Oracle 8.0.4.3.0 and Oracle 8.1.6.
I don't have an NT instance to try on, is that what you guys are using? Might be an OS difference.
L8R
Stephen Andert
>>> jonathan_at_gennick.com 09/11 8:03 AM >>>
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=none, 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 ?
>
>Steve O'Donnell
-- Author: Jonathan Gennick INET: jonathan_at_gennick.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Author: Stephen Andert INET: StephenAndert_at_firsthealth.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You mayReceived on Wed Sep 13 2000 - 05:38:20 CDT
 |
 |