问题描述:sqlplus / as sysdba连接oracle时显示错误如下:
C:\Users\Administrator>sqlplus / as sysdbaSQL*Plus: Release 11.2.0.1.0 Production on 星期三 6月 14 13:53:01 2017Copyright (c) 1982, 2010, Oracle. All rights reserved.ERROR:ORA-12546: TNS: 权限被拒绝
Enter user-name:C:\Users\Administrator>
原因描述:是由于sqlnet.ora里面的信息不全
解决方法:数据库所在的服务器重启
注:
(1)错误时的sqlnet.ora
# This file is actually generated by netca. But if customers choose to# install "Software Only", this file wont exist and without the native# authentication, they will not be able to connect to the database on NT.SQLNET.AUTHENTICATION_SERVICES = (NTS)
(2)无错误时的sqlnet.ora
# This file is actually generated by netca. But if customers choose to# install "Software Only", this file wont exist and without the native# authentication, they will not be able to connect to the database on NT.SQLNET.AUTHENTICATION_SERVICES = (NTS)NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)