监听程序出错 使用shutdown immediate后重新连接出错:ORA:12528:TNS:监听程序,所有适用的例程都不允许建立新的连接。各位大侠,怎么解决啊? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 lsnrctl start...........shutdown了你还连接数据库 = =!先startup了再讨论监听的问题 兄弟啊,你把数据库都shutdown了,还咋连啊 9i的数据库吗?9i数据库处理办法: *:\oracle\ora92\network\admin修改LISTENER.ora为LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) ) ) )SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = *:\oracle\ora92) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = sgcc) (ORACLE_HOME = *:\oracle\ora92) (SID_NAME = sgcc) ) )重启你oracle的监听服务,应该可以解决 dbms_sql ORA-29471: DBMS_SQL 访问被拒绝; 在线等 求一个语句转换 高分 急啊,请大家帮忙 if(条件) sql语句怎么写? 求助:连接不上Oracle Enterprise Manager,是为什么 请教一个SQL查询,高手请进! SQL*Loader是Oracle提供的一个工具,请问这个工具存在哪里? 请问sql plus 有哪些常用命令啊 从oracle网站上下的oracle 9i和购买的oracle 9i有什么区别? 怎样把8i中的表导入到9i中? oracle中管理服务器只能管理一个数据库吗? ORACLE 10
...........
shutdown了你还连接数据库 = =!
先startup了再讨论监听的问题
*:\oracle\ora92\network\admin修改LISTENER.ora为
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = *:\oracle\ora92)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = sgcc)
(ORACLE_HOME = *:\oracle\ora92)
(SID_NAME = sgcc)
)
)重启你oracle的监听服务,应该可以解决