ORA12546TNS权限被拒绝
tnsping遇到tns-12546: tns: 权限被拒绝
上一篇 / 下一篇 2009-05-08 11:21:26 / 个人分类： by linuxboy823 - Oracle - 2011-12-20 09:48:13 阅读（3065） 回复（0）
我用delphi 的ADO连接oracle 时出错 :ora-12546 tns:许可被拒绝 tnsping ora10 可以解析 plsql 可以连接到oracle ado 用的驱动:microsoft odbc for oracle 为什么tns许可被拒绝,而PLSQL Developer 可以连上， 在线等待...........................
windows XP 安装oracle 10g 后 一切正常，到实例的代理连接没有问题 可是重启以后就提示： 状态 失败 详细资料 ora-12505: tns: 监听程序当前无法识别连接描述符中所给出的 SID (DBD ERROR: OCIServerAttach) 用SQL plus 登陆也提示 ERROR ora-12514 : tns :监听程序当前无法识别连接描述符中请求的服务
本帖最后由 fly_hxiao 于 2010-09-10 14:32 编辑 help ... OS:win xp,装的 oracle 8.17 版本的客户端，服务器也是8.17 测试服务时，老提示这种错误... tnsnames 如下： ORCL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.17.21.1)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = orcl) ) ) -----------------------------------------------------------...
:cry: -------------------------------------------------------------------------------- ora-12541: tns:no listener 急！急！急！求救！
这两天被ora-04031这个问题折磨死了, SELECT FREE_SPACE, FREE_COUNT, REQUEST_FAILURES, REQUEST_MISSES, LAST_FAILURE_SIZE FROM V$SHARED_POOL_RESERVED;执行后 FREE_SPACE FREE_COUNT REQUEST_FAILURES REQUEST_MISSES LAST_FAILURE_SIZE ---------- ---------- ---------------- -------------- ----------------- 11388924 27 1 0 236 空闲空间很大,看来碎片很多哦.根...
请教各位: 我在window2000上装完oracle8i后,以sqlplus进入,我用startup启动数据库,但是提示:ora-01031: 权限不足.怎么办?我是以sys和system进入的.
ora-12505, tns:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was...
only create listener by netca is not sufficient, manually add block in listener.ora
ps.also check your tnsnames.ora corresponding rows
#new added:
SID_LIST_mySID1 =
(SID_LIST =
(SID_DESC =
&nbs...
刚刚开始学习oraCLE Linux rel6 oracle 11gr2 看到 emctl start dbconsole emctl stop dbconsole 的时候提示not gracefully [root@oracle ~]# su - oracle [oracle@oracle ~]$ sqlplus /nolog SQL*Plus: Release 11.2.0.1.0 Production on Wed Dec 14 23:36:24 2011 Copyright (c) 1982, 2009, oracle. All rights reserved. SQL> conn / as sysdba; ERROR: ora-12547: tns:lost contact SQL> /u01/app/oracle/diag/rd...
