| 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: Insufficient privs to connect internal
Bill,
Have you tried using the connect "as SYSDBA"? I am not sure this would come into play, but since Oracle is phasing out the INTERNAL usage, maybe sqlplus prefers the "as SYSDBA" syntax.
Jim
-----Original Message-----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Date: Monday, April 02, 2001 4:31 PM
>Greg,
>
>It is my understanding that it is only necessary to set
>SQLNET.AUTHENTICATION_SERVICES= (NTS) if oracle is going to be relying on
>the client NT workstation for authentication. Is that not correct?
>
>Also, in my situation I am invoking SQL*Plus and SVRMGRL from the command
>prompt in a DOS window so sql*net does not come into play.
>
>If I am missing something please let me know.
>
>Thanks.
>
>At 02:16 PM 4/2/01 -0800, Nelson, Greg wrote:
>>Check your SQLNET.ORA. You should have:
>>
>>SQLNET.AUTHENTICATION_SERVICES= (NTS)
>>
>>in it to verify your NT id as a user with database rights
>>
>>Greg
>>
>>-----Original Message-----
>>Sent: Monday, April 02, 2001 5:52 PM
>>To: Multiple recipients of list ORACLE-L
>>
>>
>>Hello,
>>
>>I am running oracle 8.1.6.1.3 on NT 4.0 and am having difficulties
>>attempting to connect internal from SQL*Plus.
>>
>> From a DOS prompt logged in as the Oracle user which has full
>>administrative rights...
>>
>>c:\>set ORACLE_SID=sidname
>>c:\> sqlplus /nolog
>>SQL> connect internal
>>Enter Password: ******
>>ERROR:
>>ORA-01031: insufficient privileges
>>SQL> exit
>>c:\> svrmgrl
>>SVRMGRL> connect internal
>>Password: *****
>>Connected:
>>SVRMGRL>
>>
>>There is an ORA_DBA group on the machine and the oracle user is a member.
>>In the init.ora file...
>>
>>remote_login_passwordfile=shared
>>
>>I do not uderstand the reason for this. Any help in resolving this quandry
>>would be greatly appreciated.
>>
>>Thanks.
>>
>>Bill Wagman
>>Univ. of California at Davis
>>Information Resources
>>wjwagman_at_ucdavis.edu
>>(530) 754-6208
>>
>>--------------------------------------------------------------------------
--Received on Mon Apr 02 2001 - 19:06:42 CDT
>>-
>>I like to pick up hitchhikers. When they get in the car I say, 'Put on
your
>>seat belt. I want to try something. I saw it once in a cartoon, but I
think
>>I can do it.'
>>- Steven Wright
>>
>>--
>>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>>--
>>Author: Bill Wagman
>> INET: wjwagman_at_ucdavis.edu
>>
>>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).
>>--
>>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>>--
>>Author: Nelson, Greg
>> INET: GNelson_at_banknorth.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).
>
>
>Bill Wagman
>Univ. of California at Davis
>Information Resources
>wjwagman_at_ucdavis.edu
>(530) 754-6208
>
>---------------------------------------------------------------------------
--
>I like to pick up hitchhikers. When they get in the car I say, 'Put on your
>seat belt. I want to try something. I saw it once in a cartoon, but I think
>I can do it.'
>- Steven Wright
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Bill Wagman
> INET: wjwagman_at_ucdavis.edu
>
>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).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Walski INET: jwalski3_at_classicplan.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).
 |
 |