刚安装了ORACLE 11g。。listener.ora 配置如下
# listener.ora Network Configuration File: D:\oracle\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
#CLRExtProc#DIRECT_HANDOFF_TTC_LISTENER = OFFSID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = orcl)
(ORACLE_HOME = D:\oracle\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:D:\oracle\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)ADR_BASE_LISTENER = D:\oracle
tnsnames.ora 配置如下
# tnsnames.ora Network Configuration File: D:\oracle\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)orcl =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)sqlnet.ora 配置如下
# sqlnet.ora Network Configuration File: D:\oracle\product\11.2.0\dbhome_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.# 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, EZCONNECT)
刚开始是可以的用的 什么也没动 突然之间。
到实例的代理连接 ORA-28547: connection to server failed, probable Oracle Net admin error (DBD ERROR: OCISessionBegin)请高手指点。
# listener.ora Network Configuration File: D:\oracle\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
#CLRExtProc#DIRECT_HANDOFF_TTC_LISTENER = OFFSID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = orcl)
(ORACLE_HOME = D:\oracle\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:D:\oracle\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)ADR_BASE_LISTENER = D:\oracle
tnsnames.ora 配置如下
# tnsnames.ora Network Configuration File: D:\oracle\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)orcl =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)sqlnet.ora 配置如下
# sqlnet.ora Network Configuration File: D:\oracle\product\11.2.0\dbhome_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.# 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, EZCONNECT)
刚开始是可以的用的 什么也没动 突然之间。
到实例的代理连接 ORA-28547: connection to server failed, probable Oracle Net admin error (DBD ERROR: OCISessionBegin)请高手指点。
解决方案 »
- 关于查询的问题,请求大牛指教
- 存储过程改了N次,仍然出错后,我来了............
- oracel遇到00922错误 急急!!!
- 一个有关pl/sql developer开发工具结构的问题!在线等待!!来者有分!!!
- oracle中什么能替代in?
- ora-12535:TNS:操作超时
- 初学者问题:在ORACLE的LOOP当中有没有类似于DELPHI当中的continue和break的操作
- 如何把一个数据库里面的数据(包括表的结构)导入另外一个数据库
- 老板催得急啊,各位好心人,帮帮忙吧如何在jsp中把word文档上传到oracle数据库
- 分页,每一页内某个字段重复列不超过两条,怎么实现
- 求一条sql语句
- 请问Oracle 8i客户端如何静默卸载
用记事本打开把文件中的一行:
SQLNET_AUTHENTICATION_SERVICES= (NTS)
修改为:
SQLNET_AUTHENTICATION_SERVICES= (NONE) --*3).同时修改监听器配置文件,具体做法是: 在oracle安装目录下搜索listener.ora文件,一般在$\NETWORK\ADMIN目录下,把主机名用ip地址代替,例如(ADDRESS = (PROTOCOL = TCP)(HOST = HBONLINE1)(PORT = 1523))改为(ADDRESS = (PROTOCOL = TCP)(HOST = 168.168.168.42)(PORT = 1523))。
用Google可以搜到好多回答的
1,,我是自己电脑链接自己电脑上的oracle 不会跟IP有什么关系吧?
2,,修改为: SQLNET_AUTHENTICATION_SERVICES= (NONE) 没作用啊。
3,,那个我改过了也没用。
我在Google 搜索2,3天了 什么都看过 什么都试过,就是不行。
改成
SQLNET.AUTHENTICATION_SERVICES= (NONE)
試一下
Action: Check Net8 administration in the following ways: -- When using TNSNAMES.ORA or an Oracle Names server, make sure that the client connection to the ORACLE server uses the correct service name or SID. -- Check LISTENER.ORA on the connection end point's host machine to assure that this service name or SID refers to the correct server. -- Confirm in TNSNAMES.ORA or the equivalent service definition that the connect string does NOT contain (HS=).