报错显示: C:\Users\Administrator>sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on 星期三 4月 24 09:09:33 2019
Copyright (c) 1982, 2010, Oracle. All rights reserved.
ERROR: ORA-01031: 权限不足
请输入用户名:
1、查看本地用户和组确认权限 将登录的用户添加进ora_dba权限组中 2、用可以登录的账号登录查看检查系统参数 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、检查系统参数无sys记录,则创建密码文件,再次登录 C:\Users\Administrator>orapwd file="E:\oracle\product\11.2.0\dbhome_1\database/PWDVIDM.ora" password=oracle oswong entries=10
4、均无异常,或修改后报ORA-12641: 验证服务无法初始化,则: 查看sqlnet.ora文件中的SQLNET.AUTHENTICATION_SERVICES配置项 路径:E:\oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN 修改为:SQLNET.AUTHENTICATION_SERVICES = (NTS) 正常连接 C:\Users\Administrator>sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on 星期三 4月 24 09:15:21 2019
Copyright (c) 1982, 2010, Oracle. All rights reserved.
连接到: 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>