问题描述: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor The Connection descriptor used by the client was: 10.12.162.84:1521:xxxx oracle数据的tnsnames.ora中配置的是:SERVICE
在RAC 环境下使用DataPump工具,alert log会出现修改SERVICE_NAMES参数的提示。 如: Sat Sep 1 13:33:20 2012 ALTER SYSTEM SETservice_names='pmos','SYS$SYS.KUPC$C_1_20120901133317.PMOS' SCOPE=MEMORY SID='
Oracle报错:Listener refused the connection with following error:ORA-12505,TNS:listener...... 这是连接数据库的SID错误, 解决方法: 1.知道你的SID名:可以再注册表中查找,也可以通过借助Oracle的sqlplus工具并以管理员方式连接敲命令查看:select instance_name from
select name from v$database; /*查看数据库名*/select instance_name from v$instance; /*查看sid*/ select * from dba_users; /*查看数据库里面所有用户,前提是有dba权限的帐号,如sys,system*/select * from all_users; /*查看能管理