使用plsql连接非本地数据库：

10.254.100.58:1521/IRS 用户名：irs_yl5 密码：irs_yl5 cmd中启动oracle监听： lsnrctl start 监听程序无法识别连接描述符中请求的服务 net Configuration Assistant 中重新配置一下监听即可，配置的结果就是下面。。。注：不一定要在图形界面配置，直接找到oracle监听文件加进去就行！ #监听配置一 实例FKDB fkdb_new = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.216.200.105)(PORT = 11521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = FKDB) ) ) #监听配置二 实例orakb ORAKB_222 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.216.200.111)(PORT = 11522)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orakb) ) )     --oracle连接数 select count(*) from v$session; select count(*) from v$session where status = 'ACTIVE'; select username, count(username) from v$session where username is not null group by username;