但是plsql数据库能登陆进去 sqlplus也能登陆 监听状态也查看了 都很正常 tns文件里也没错误 求大神帮忙看看

CodePudding user response:

Plsqldev login using the oracle client database, using configuration is tnsnames. Ora, what does this informatica use JDBC or odbc connection database? Do you want to take a look at the configuration of the right there,
See this error, generally is the service name in the connection configuration didn't write to, want to see the instance registered to monitor the service name, server using LSNRCTL status can be confirmed, or access user login database using the following query can be used to confirm: select the name, the value of the from v $parameter where name='services an instance belongs to';