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

Error message:

C:\Users\Administrator>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Wednesday April 24 09:09:33 2019

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

ERROR:

ORA-01031: Insufficient permissions

Please enter your username:

1. View local users and groups to confirm permissions

Add the logged in user to the ora_dba permission group

2. Log in with an account that you can log in to view and check the system parameters

SQL> show parameter password

NAME TYPE VALUE

remote_login_passwordfile string EXCLUSIVE

SQL> select * from v$pwfile_users;

USERNAME SYSDBA SYSOPER SYSASM

SYS TRUE TRUE FALSE

3. Check that there is no sys record in the system parameters, then create a password file and log in again.

C:\Users\Administrator>orapwd file="E:\oracle\product\11.2.0\dbhome_1\database/PWDVIDM.ora" password=oracle oswong entries=10

4. If there is no abnormality, or ORA-12641 is reported after modification: Verification service cannot be initialized, then:

View SQLNET.AUTHENTICATION_SERVICES configuration entry in sqlnet.ora file

Path: E:\oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN

Modified to: SQLNET.AUTHENTICATION_SERVICES = (NTS)

normal connection

C:\Users\Administrator>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Wednesday April 24 09:15:21 2019

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

Connect to:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>

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.