Shulou(Shulou.com)06/01 Report--

Prompt ORA-01031: insufficient privileges when using sqlplus / as sysdba to connect to sqlplus locally under the oracle user

View operating system version information

[oracle@OracleBak admin] $lsb_release-aLSB Version:: base-4.0-amd64:base-4.0-noarch:core-4.0-amd64:core-4.0-noarch:graphics-4.0-amd64:graphics-4.0-noarch:printing-4.0-amd64:printing-4.0-noarchDistributor ID: CentOSDescription: CentOS release 6.6 (Final) Release: 6.6Codename: Final

Normal local login should not require authorization, check the sqlnet.ora file, the file path is $ORACLE_HOME/network/admin/sqlnet.ora

[oracle@OracleBak admin] $cat sqlnet.ora# sqlnet.ora Network Configuration File: / opt/ora11/product/11.2/network/admin/sqlnet.ora# Generated by Oracle configuration tools.SQLNET.AUTHENTICATION_SERVICES= (NTS) NAMES.DIRECTORY_PATH= (TNSNAMES,EZCONNECT)

Check that the monitoring and tnsping are normal. After consulting the data, you find the SQLNET.AUTHENTICATION_SERVICES in sqlnet.ora.

1. Under windows, SQLNET.AUTHENTICATION_SERVICES must be set to NTS to use OS authentication.

OS authentication cannot be used if it is not set or set to any other value.

2. Under linux, OS verification can be successful only if the value of SQLNET.AUTHENTICATION_SERVICES is set to ALL or not.

After changing this parameter to ALL, you can log in directly using sqlplus / as sysdba;, but when you log in using sqlplus sys/oracle@orcl as sysdba;, you will be prompted to ORA-12641: Authentication service failed to initialize, and change the

SQLNET.AUTHENTICATION_SERVICES= (ALL)

After this line is removed, you can log in normally by using your user name and password.

Sqlnet.ora file content

# sqlnet.ora Network Configuration File: / opt/ora11/product/11.2/network/admin/sqlnet.ora# Generated by Oracle configuration tools.#SQLNET.AUTHENTICATION_SERVICES= (ALL) NAMES.DIRECTORY_PATH= (TNSNAMES,EZCONNECT)

Tnsnames.ora

# tnsnames.ora Network Configuration File: / opt/ora11/product/11.2/network/admin/tnsnames.ora# Generated by Oracle configuration tools.ORCL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = OracleBak) (PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl))

Listener.ora

# listener.ora Network Configuration File: / opt/ora11/product/11.2/network/admin/listener.ora# Generated by Oracle configuration tools.SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = orcl) (SID_NAME = orcl)) ORCL = (DESCRIPTION_LIST = (DESCRIPTION = (PROTOCOL = TCP) (HOST = 172.16.10.242) (PORT = 1521) ADR_BASE_GNNT = / opt/ora11

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.