高价寻求关于TNSlistener良方,急急急!!!!! 用lsnrctl>status看看网络侦听的状态,如果是没有 起来可能是listener.ora文件中的一些参数配置错误引起的 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 很可能是listener.ora参数配置错误,oracle数据库服务器必须安装有网卡或虚拟网卡 是第一次安装,还是安装后的修改,如果是修改的话,和网络协议有关.如为新装置,则查看listener.ora文件.有没有把主机明,SID加进去给你一个例子做参考:# LISTENER.ORA Network Configuration File: C:\oracle\ora81\network\admin\listener.ora# Generated by Oracle configuration tools.LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = cglv0005)(PORT = 1521)) ) ) (DESCRIPTION = (PROTOCOL_STACK = (PRESENTATION = GIOP) (SESSION = RAW) ) (ADDRESS = (PROTOCOL = TCP)(HOST = cglv0005)(PORT = 2481)) ) )SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = C:\oracle\ora81) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = glam) (ORACLE_HOME = C:\oracle\ora81) (SID_NAME = glam) ) ) oracle中update触发器更新当前(自己)表某条数据的某个字段 ORACLE 导入DAT数据文件 求某张表中某字段每天的最大值,急,在线等 oracle ora-01507 ora-01102错误 ,急 C#程序连接Oracle问题 如何将表中的字段设为关键字段? 关于日期判断的语句 怎么设置sql-plus才能捕获异常,很简单的问题 高分:linux7.3下oracle8.1.7如何配置JDBC? Oracle触发器问题 神啊,救救我吧! ORA-12560 TNS: 协议适配器错误 我刚装了系统就报了这种错误,请问是不是数据库设置有问题?无法创建表空间、
如为新装置,则查看listener.ora文件.有没有把主机明,SID加进去
给你一个例子做参考:
# LISTENER.ORA Network Configuration File: C:\oracle\ora81\network\admin\listener.ora
# Generated by Oracle configuration tools.LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = cglv0005)(PORT = 1521))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = cglv0005)(PORT = 2481))
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\ora81)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = glam)
(ORACLE_HOME = C:\oracle\ora81)
(SID_NAME = glam)
)
)