ITPub博客

首页 > 数据库 > Oracle > 【故障处理】ORA-28547: connection to server failed, probable

【故障处理】ORA-28547: connection to server failed, probable

原创 Oracle 作者:lhrbest 时间:2020-03-28 22:00:07 0 删除 编辑

【故障处理】ORA-28547: connection to server failed, probable Oracle Net admin error


------------windows 下
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = D:\app\oracle\product\11.2.0.1)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:D:\app\oracle\product\11.2.0.1\bin\oraclr11.dll")
    )
    (SID_DESC =
     (GLOBAL_DBNAME = orcl.lhr.com)
     (SID_NAME = orcl)
     (ORACLE_HOME = D:\app\oracle\product\11.2.0.1)
   )
  )


第一个方法解决方案:

listener.ora是服务器端的配置oracle的文件。

后来将listener.ora的这一行注释掉,就行了,, (PROGRAM = extproc)
修改为:
SID_LIST_LISTENER =
  (SID_LIST =
  (SID_DESC =
  (SID_NAME = prod)
  (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
# (PROGRAM = extproc)
  )
  )

LISTENER =
  (DESCRIPTION_LIST =
  (DESCRIPTION =
  (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.8)(PORT = 1522))
  (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
  )
  )

 

第二种解决方案如下:

客户端的配置文件sqlnet.ora中配置如下:

将#SQLNET.AUTHENTICATION_SERVICES= (NTS)注释掉,改成如下即可!

如下:
SQLNET.AUTHENTICATION_SERVICES= (NONE)

同时修改监听器配置文件,具体做法是: 在oracle安装目录下搜索listener.ora文件,一般在$/NETWORK/ADMIN目录下,把主机名用ip地址代替,例如(ADDRESS = (PROTOCOL = TCP)(HOST = HBONLINE1)(PORT = 1523))改为(ADDRESS = (PROTOCOL = TCP)(HOST = 168.168.168.42)(PORT = 1523))。


ORA-28547: connection to server failed, probable Oracle Net admin error

现象

C:\Users\Administrator>sqlplus scott/tiger@192.168.1.11:1521/orcl

SQL*Plus: Release 11.2.0.4.0 Production on Wed Nov 13 17:53:59 2019

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

ERROR:
ORA-28547: connection to server failed, probable Oracle Net admin error

监听配置

# listener.ora Network Configuration File: C:\oracle\product\.======= C:\oracle\product\.====== (PROTOCOL = TCP)(HOST = .)(PORT = = (PROTOCOL = TCP)(HOST = .)(PORT = = C:\oracle

处理

注释掉 extproc 相关项,重启监听,恢复正常。

# listener.ora Network Configuration File: C:\oracle\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
     #(SID_NAME = CLRExtProc)
      (SID_NAME = orcl)
      (GLOBAL_DBNAME = orcl)
      (ORACLE_HOME = C:\oracle\product\11.2.0\dbhome_1)     # (PROGRAM = extproc)
     # (ENVS ="EXTPROC_DLLS=ONLY:C:\oracle\product\11.2.0\dbhome_1\bin\oraclr11.dll")
    )
  )
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.11)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.11)(PORT = 1521))
    )
  )
ADR_BASE_LISTENER = C:\oracle

 






ORA-28547: Connection To Server Failed, Probable Oracle Net Admin Error (Doc ID 2565870.1)


In this Document

Symptoms
Changes
Cause
Solution
References


APPLIES TO:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

SYMPTOMS

ORA-28547: connection to server failed, probable Oracle Net admin error

CHANGES

 

CAUSE

Wrong parameter in sqlnet.ora file.

SOLUTION

After changing sqlnet.ora parameter from  SQLNET.AUTHENTICATION_SERVICES= (NTS) to SQLNET.AUTHENTICATION_SERVICES= (NONE) issue fixed.

SQLNET.AUTHENTICATION_SERVICES allows Windows users to be authenticated using Windows NT native security. NTS ONLY used for windows OS.

REFERENCES

NOTE:1274184.1  - "ORA-28547: Connection to Server Failed, Probable Oracle Net Admin Error" When Connecting to P6 Standalone Oracle XE Database
NOTE:2425839.1  - Shared Server: ORA-28547: Connection To Server Failed, Probable Oracle Net Admin Error








About Me

........................................................................................................................

● 本文作者:小麦苗,部分内容整理自网络,若有侵权请联系小麦苗删除

● 本文在itpub、博客园、CSDN和个人微 信公众号( xiaomaimiaolhr)上有同步更新

● 本文itpub地址: http://blog.itpub.net/26736162

● 本文博客园地址: http://www.cnblogs.com/lhrbest

● 本文CSDN地址: https://blog.csdn.net/lihuarongaini

● 本文pdf版、个人简介及小麦苗云盘地址: http://blog.itpub.net/26736162/viewspace-1624453/

● 数据库笔试面试题库及解答: http://blog.itpub.net/26736162/viewspace-2134706/

● DBA宝典今日头条号地址: http://www.toutiao.com/c/user/6401772890/#mid=1564638659405826

........................................................................................................................

● QQ群号: 230161599 、618766405

● 微 信群:可加我微 信,我拉大家进群,非诚勿扰

● 联系我请加QQ好友 646634621 ,注明添加缘由

● 于 2020-03-01 06:00 ~ 2020-03-31 24:00 在西安完成

● 最新修改时间:2020-03-01 06:00 ~ 2020-03-31 24:00

● 文章内容来源于小麦苗的学习笔记,部分整理自网络,若有侵权或不当之处还请谅解

● 版权所有,欢迎分享本文,转载请保留出处

........................................................................................................................

小麦苗的微店https://weidian.com/s/793741433?wfr=c&ifr=shopdetail

小麦苗出版的数据库类丛书http://blog.itpub.net/26736162/viewspace-2142121/

小麦苗OCP、OCM、高可用网络班http://blog.itpub.net/26736162/viewspace-2148098/

小麦苗腾讯课堂主页https://lhr.ke.qq.com/

........................................................................................................................

使用 微 信客户端扫描下面的二维码来关注小麦苗的微 信公众号( xiaomaimiaolhr)及QQ群(DBA宝典)、添加小麦苗微 信, 学习最实用的数据库技术。

........................................................................................................................

欢迎与我联系

 

 



来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26736162/viewspace-2683161/,如需转载,请注明出处,否则将追究法律责任。

上一篇: Oracle 19c RPM安装
下一篇: Docker中安装Oracle
全部评论
【QQ:646634621】【微信:lhrbestxh】【微信公众号:DB宝】【11g、12c OCM】【QQ群:230161599、618766405】【《数据库笔试面试宝典》作者】【OCP、OCM、高可用(RAC+DG+OGG)、MySQL培训班已开讲,只讲实用内容】

注册时间:2012-09-23

  • 博文量
    1491
  • 访问量
    8664138