客户端连接错误!急 check your listener.ora and correct it. 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 I think you should descirbe more detail about your problem. 我在客户端用sql*plus登陆连接刚建好的库的时候出现这个错误。我是个新手,里面的错误不太看得出来,能不能提示一下可能在什么地方出错了! 可能会出现以下问题: a)用户名或密码错误 b)TNS可能没有配置或启动 c)实例创建的有问题 这是我的LISTENER.ORA文件,那位大哥能帮忙看看啦!很急,多谢了# F:\ORANT\NET80\ADMIN\LISTENER.ORA Configuration File:f:\orant\net80\admin\listener.ora# Generated by Oracle Net8 AssistantPASSWORDS_LISTENER= (oracle)STARTUP_WAIT_TIME_LISTENER = 0LISTENER = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = oracle.world)) (ADDRESS = (PROTOCOL = IPC)(KEY = JZ)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) (ADDRESS = (COMMUNITY = NMP.world)(PROTOCOL = NMP)(SERVER = ZHANGYING)(PIPE = ORAPIPE)) (ADDRESS = (PROTOCOL = TCP)(Host = zhangying)(Port = 1521)) (ADDRESS = (PROTOCOL = TCP)(Host = zhangying)(Port = 1526)) (ADDRESS = (PROTOCOL = TCP)(Host = 127.0.0.1)(Port = 1521)) (ADDRESS = (PROTOCOL = SPX)(Service = zhangying_lsnr)) (ADDRESS = (PROTOCOL=IPC)(KEY=JZ)) )CONNECT_TIMEOUT_LISTENER = 10SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = zhangying) (SID_NAME = JZ) ) (SID_DESC = (SID_NAME = extproc) (PROGRAM = extproc) ) (SID_DESC = (SID_NAME=JZ)) )TRACE_LEVEL_LISTENER = 0 根据提示,说侦听器启动专有服务进程错误。你察看一下这个参数processes(show parameter process)是不是这个值太小了 processes我设的100,应该不小了,今天又莫名其妙的能连上了,玩我一样!比较郁闷,对oracle的网络方面的东西还一片空白。以后还要各位多多指教了! DBLink远程连接数据库和连接池无关吗?DBLink有很多问题? 触发器sql脚本在DOS下执行出错 急!急!!急!! 用VB6.0如何写入一个存储过程 sqlplus中如何运算变量? varchr2(40) 与 number类型怎么才能判断是否想等?怎么格式化之后比较? oracle大量消耗硬盘空间的问题 特简单的菜鸟问题:这个MS SQL触发器转到oracle该怎么写呢 DBArtisan 7.0的注册码(unlock码) 求一个sql !!!求助,关于Oracle存储过程的,需要帮忙 随机数 请问O有没有橡sqlserver那样的数据浏览和xql执行界面?
a)用户名或密码错误
b)TNS可能没有配置或启动
c)实例创建的有问题
# Generated by Oracle Net8 AssistantPASSWORDS_LISTENER= (oracle)STARTUP_WAIT_TIME_LISTENER = 0LISTENER =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = oracle.world))
(ADDRESS = (PROTOCOL = IPC)(KEY = JZ))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
(ADDRESS = (COMMUNITY = NMP.world)(PROTOCOL = NMP)(SERVER = ZHANGYING)(PIPE = ORAPIPE))
(ADDRESS = (PROTOCOL = TCP)(Host = zhangying)(Port = 1521))
(ADDRESS = (PROTOCOL = TCP)(Host = zhangying)(Port = 1526))
(ADDRESS = (PROTOCOL = TCP)(Host = 127.0.0.1)(Port = 1521))
(ADDRESS = (PROTOCOL = SPX)(Service = zhangying_lsnr))
(ADDRESS = (PROTOCOL=IPC)(KEY=JZ))
)CONNECT_TIMEOUT_LISTENER = 10SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = zhangying)
(SID_NAME = JZ)
)
(SID_DESC =
(SID_NAME = extproc)
(PROGRAM = extproc)
)
(SID_DESC = (SID_NAME=JZ))
)TRACE_LEVEL_LISTENER = 0
你察看一下这个参数processes(show parameter process)
是不是这个值太小了