如题,请问发生这样的错误如何解决?
解决方案 »
- oracle package
- 动态游标ref cursor
- 64位windows7系统安装Oracle失败,求帮忙
- ◆◆◆请一类似SQLServer 语句IF exists 的Oracle写法
- 请大神帮忙 excel语言转为SQL语言
- imp的时候有时候会中止,不知道什么问题
- 想学数据库开发啊,大家给点意见,我都应该学些什么呢?
- 存储过程返回记录集得问题!
- 为什么我安装完oracle以后,进入企业管理器的时候,出现不能处理sid
- 在线等待 sql高手 解决难题
- sysdate+1/24/30 是啥意思呀?
- 实施现场在客户端用PB连接Oracle非常慢,但用Toad 连接Oracle速度正常,请帮忙分析一下原因
中
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = zl)(PORT = 1521))
)
)
设置后重启listener
lsnrctl stoplsnrctl start.
ORA-12528: TNS: 监听程序: 所有适用例程都无法建立新连接说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。 异常详细信息: System.Data.OracleClient.OracleException: ORA-12528: TNS: 监听程序: 所有适用例程都无法建立新连接
源错误:
行 22: {
行 23: this.dbcon = this.CreateConn("bbs","bbs","192.168.0.2/oracle");
行 24: dbcon.Open();
行 25: }
行 26: public DataBase(int is2008)
---------------------------------------------------------------
请详细说明一下如何不通过监听登进去,谢谢大侠了
你在服务器上通过“sqlplus user/pwd” 不指定连接串就行了。
根本就不显示命令提示符
ncdb =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = xxx)
(UR=A)
)
)
# listener.ora Network Configuration File: E:\oracle\product\10.2.0\db_2\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E:\oracle\product\10.2.0\db_2)
(PROGRAM = extproc)
) (SID_DESC =
(GLOBAL_DBNAME = ORACLE)
(ORACLE_HOME = E:\oracle\product\10.2.0\db_2)
(SID_NAME = ORACLE)
) )
ORACLE =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = *.*.*.*)(PORT = 1521))
)
) ---------------------------------------------------------------------------- tnsnames.ora ----------------------------------------------------------------------------
# tnsnames.ora Network Configuration File: E:\oracle\product\10.2.0\db_2\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools. ORACLE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = *.*.*.*)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = oracle)
(UR = A)
)
) EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(Key = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
----------------------------------------------------------------------------