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

one。 Problem description

Today, we set up an Oracle environment on the new machine (WINDOWS). After that, we logged in locally through SQL*PLUS.

Ora-01031 insufficient privileges-insufficient permissions

two。 Solution process

Error elimination

1. The first thing that came to mind at that time was that oracle did not allow login with the sqlplus tool, but then tried to get rid of it.

Sqlplus sys/admin as sysdba-successfully logged in!

Sqlplus sys/admin as sysdba-successfully log in!

two。 Specify native IP and instance login with details

Sqlplus sys/admin@127.0.0.1:1521/ORCL as sysdba-successfully logged in!

Sqlplus sys/admin@127.0.0.1:1521/ORCL as sysdba-successfully log in!

3. Login with PLSQL developer is also successful

Guess: the above login methods all belong to Oracle password login mode, while / as sysdba logs in to Oracle through operating system.

Error location

An error occurred when logging in locally with the operating system, most likely because the current windows user is not in the user group that Oracle allows login.

Solution.

1. Open windows user group management with the command, and add the users who install Oracle to the ORA_DBA user group (Liunx system this user group name is different)

Compmgmt.msc

two。 Open $ORACLE_HOME/NETWORK/ADMIN/sqlnet.ora

Make sure SQLNET.AUTHENTICATION_SERVICES= (NTS)-allow local login

3. Restart the computer (in order to update and apply the newly modified user group)

4. test

C:\ Users\ Jan > sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Mon Dec 14 22:12:29 2015 Copyright (c) 1982, 2010, Oracle. All rights reserved. Connected.C:\ Users\ Jan > sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Mon Dec 14 22:12:29 2015 Copyright (c) 1982, 2010, Oracle. All rights reserved. Connected.

three。 Summary of results

Two necessary conditions for using sqlplus / as sysdba to log in locally

1. The current user is in the user group of Oracle dba

2. Sqlnet.ora file parameter SQLNET.AUTHENTICATION_SERVICES= (NTS)

Summary

The above is the Oracle environment introduced by the editor to you through the SQL*PLUS local login Times error resolution process, I hope to help you, if you have any questions, please leave me a message, the editor will reply to you in time. Thank you very much for your support to the website!

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.