ORA-28547的解决之道

1. 修改oracle的网络配置文件,具体做法是:在oracle安装目录下搜索sqlnet.ora文件,一般在$\NETWORK\ADMIN目录下,
用记事本打开把文件中的一行:
SQLNET_AUTHENTICATION_SERVICES= (NTS)
修改为:
SQLNET_AUTHENTICATION_SERVICES= (NONE)

2. 同时修改监听器配置文件,具体做法是: 在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 如何解决?

08-08

刚安装了ORACLE 11g。。rnrn[color=#FF0000]listener.ora 配置如下[/color]rn# listener.ora Network Configuration File: D:\oracle\product\11.2.0\dbhome_1\network\admin\listener.orarn# Generated by Oracle configuration tools.rn#CLRExtProcrnrn#DIRECT_HANDOFF_TTC_LISTENER = OFFrnrnSID_LIST_LISTENER =rn (SID_LIST =rn (SID_DESC =rn (SID_NAME = orcl)rn (ORACLE_HOME = D:\oracle\product\11.2.0\dbhome_1)rn (PROGRAM = extproc)rn (ENVS = "EXTPROC_DLLS=ONLY:D:\oracle\product\11.2.0\dbhome_1\bin\oraclr11.dll")rn )rn )rnrnLISTENER =rn (DESCRIPTION_LIST =rn (DESCRIPTION =rn (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))rn (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))rn )rn )rnrnADR_BASE_LISTENER = D:\oraclernrnrn[color=#FF0000]tnsnames.ora 配置如下[/color]rn# tnsnames.ora Network Configuration File: D:\oracle\product\11.2.0\dbhome_1\network\admin\tnsnames.orarn# Generated by Oracle configuration tools.rnrnLISTENER_ORCL =rn (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))rnrnrnORACLR_CONNECTION_DATA =rn (DESCRIPTION =rn (ADDRESS_LIST =rn (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))rn )rn (CONNECT_DATA =rn (SID = CLRExtProc)rn (PRESENTATION = RO)rn )rn )rnrnorcl =rn (DESCRIPTION =rn (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))rn (CONNECT_DATA =rn (SERVER = DEDICATED)rn (SERVICE_NAME = orcl)rn )rn )rnrnrnrn[color=#FF0000]sqlnet.ora 配置如下[/color]rn# sqlnet.ora Network Configuration File: D:\oracle\product\11.2.0\dbhome_1\network\admin\sqlnet.orarn# Generated by Oracle configuration tools.rnrn# This file is actually generated by netca. But if customers choose to rn# install "Software Only", this file wont exist and without the native rn# authentication, they will not be able to connect to the database on NT.rnrnSQLNET.AUTHENTICATION_SERVICES= (NTS)rnrnNAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)rnrnrn刚开始是可以的用的 什么也没动 突然之间。rn rn到实例的代理连接 ORA-28547: connection to server failed, probable Oracle Net admin error (DBD ERROR: OCISessionBegin)rnrn请高手指点。

没有更多推荐了,返回首页