Linux, "ora-01031:insufficient privileges" processing ____linux

Under Linux, it is customary to log in with Sqlplus "/as sysdba".

Today, on other machines, you have encountered an error as follows:

[Oracle@db ~]$ sqlplus "/as sysdba"

Sql*plus:release 11.2.0.3.0 Production on Mon June 24 01:59:24 2013

Copyright (c) 1982, Oracle. All rights reserved.

ERROR:
Ora-01031:insufficient Privileges

Enter User-name: ^c
[Oracle@db ~]$

Online look for a bit, a lot of introductions, but not much effective.

The main is $oracle_home/network/admin/sqlnet.ora, either delete the file, or put the parameters "sqlnet." Authentication_services "changed to all."

Simply commenting out this parameter does not work.

The following are now used:

[Oracle@db admin]$ Cat Sqlnet.ora
# Generated by Oracle configuration tools.
Sqlnet. Authentication_services= (All)
Remote_login_passwordfile=exclusive
Sqlnet. Inbound_connect_timeout=0
NAMES. Directory_path= (TNSNAMES)

[Oracle@db admin]$

The following URL is referenced:

http://hunt1574.blog.51cto.com/1390776/857841

Understanding Sqlnet.authentication_services Parameters

Understanding Sqlnet.authentication_services Parameters 1. Official Description: sqlnet. Authentication_services PurposeUse the parameter sqlnet. Authentication_services to enable one or more authentication SERVICES. IF authentication has been installed, it is recommended which this parameter are set to either none or to one of the authent Ication methods.DefaultNoneValues authentication Methods Available with Oracle Net Services:· None for no authentication methods. A valid username and password can is used to access the database.         ·         All to all authentication methods NTS forWindows NT native authentication2, testing:You can view the impact by modifying the Sqlnet.authentication_services value. Lwindowns: A. No Sqlnet.ora documents:  E:\oracle\product\10.2.0\db_1\network\admin>dir sqlnet.oraThe volume in drive E is not labeled. The volume's serial number is 1CF8-89BB E:\oracle\product\10.2.0\db_1\NETWORK\ADMIN directory cannot find the file E:\oracle\product\10.2.0\db_1\NETWORK\ADMIN > e:\oracle\product\10.2.0\db_1\network\admin>sqlplus "/As SYSDBA"Sql*plus:release 10.2.0.1.0-production on Tuesday May 8 20:45:35 Copyright (c) 1982,%, Oracle. All rights reserved. error:ora-01031: Insufficient permissions Please enter user name:B. Sqlnet. Authentication_services= (NONE)  E:\oracle\product\10.2.0\db_1\network\admin>dir sqlnet.oraThe volume in drive E is not labeled.                The serial number of the volume is the directory of 1CF8-89BB E:\oracle\product\10.2.0\db_1\NETWORK\ADMIN 2012-05-08 20:48 266 Sqlnet.ora 1 files 266 bytes 0 Directories 1,969,827,840 Free bytes e:\oracle\product\10.2.0\db_1\network\admin>type Sqlnet.ora# This file was actually generated by NETCA. But if customers choose to # Install ' Software only ', this file wont exist and without the native # authentication, they w Ill is able to connect to the database on NT. Sqlnet. Authentication_services = (NONE) e:\oracle\product\10.2.0\db_1\network\admin>sqlplus "/As SYSDBA"Sql*plus:release 10.2.0.1.0-production on Tuesday May 8 20:48:53 Copyright (c) 1982,%, Oracle. All rights reserved. error:ora-01031: Insufficient permissions Please enter user name:C. Sqlnet. authentication_services= (All)  E:\oracle\product\10.2.0\db_1\network\admin>type Sqlnet.ora# This file was actually generated by NETCA. But if customers choose to # Install ' Software only ', this file wont exist and without the native # authentication, they w Ill is able to connect to the database on NT. Sqlnet. Authentication_services = (All) e:\oracle\product\10.2.0\db_1\network\admin>sqlplus "/As SYSDBA"Sql*plus:release 10.2.0.1.0-production on Tuesday May 8 20:51:28 Copyright (c) 1982,%, Oracle. All rights reserved. ERROR:ORA-12641: Authentication Service failed to initialize please enter user name:D. Sqlnet. Authentication_services= (NTS)  E:\oracle\product\10.2.0\db_1\network\admin>type Sqlnet.ora# This file was actually generated by NETCA. But if customers choose to # Install ' Software only ', this file wont exist and without the native # authentication, they w Ill is able to connect to the database on NT. Sqlnet. Authentication_services = (NTS) e:\oracle\product\10.2.0\db_1\network\admin>sqlplus "/As SYSDBA"Sql*plus:release 10.2.0.1.0-production on Tuesday May 8 20:53:49 Copyright (c) 1982,%, Oracle. All rights reserved. Connecting to: Oracle Database 10g Enterprise Edition release 10.2.0.1.0-production with the partitioning, OLAP and Data Mining o Ptions sql> LLINUX A. No Sqlnet.ora documents:  bash-3.00$ls-l Sqlnet.oraSqlnet.ora: No such file or directory bash-3.00$sqlplus "/As SYSDBA"Sql*plus:release 10.2.0.1.0-production on Tue May 8 21:11:04 (c) 1982,%, Oracle. All rights reserved. Connected to:oracle Database 10g Enterprise Edition release 10.2.0.1.0-64bit Production with the partitioning, OLAP and Data Mining Options Sql>B. Sqlnet. Authentication_services= (NONE)  bash-3.00$Cat Sqlnet.oraSqlnet. Authentication_services = (NONE) bash-3.00$sqlplus "/As SYSDBA"Sql*plus:release 10.2.0.1.0-production on Tue May 8 21:13:00 (c) 1982,%, Oracle. All rights reserved. Error:ora-01031:insufficient Privileges Enter User-name:C. Sqlnet. authentication_services= (All)  bash-3.00$Cat Sqlnet.oraSqlnet. Authentication_services = (All) bash-3.00$sqlplus "/As SYSDBA"Sql*plus:release 10.2.0.1.0-production on Tue May 8 21:13:59 (c) 1982,%, Oracle. All rights reserved. Connected to:oracle Database 10g Enterprise Edition release 10.2.0.1.0-64bit Production with the partitioning, OLAP and Data Mining Options Sql>D. Sqlnet. Authentication_services= (NTS)  bash-3.00$Cat Sqlnet.oraSqlnet. Authentication_services = (NTS) bash-3.00$sqlplus "/As SYSDBA"Sql*plus:release 10.2.0.1.0-production on Tue May 8 21:15:05 (c) 1982,%, Oracle. All rights reserved. Error:ora-01031:insufficient Privileges Enter User-name:3. Summary:1 under Windows, sqlnet. Authentication_services must be set to NTS to be available, this value applies only to WINDOWS. 2 under Linux, Sqlnet. Authentication_services is all or not set (Sqlnet.ora file does not exist) can log on.

This article is from the "HUNT" blog, please be sure to keep this source http://hunt1574.blog.51cto.com/1390776/857841