12523, 00000, "TNS:listener could not find instance appropriate for the client connection" // *Cause: The listener could not find any available (database) instances, // that are appropriate for the client connection. // *Action: Run "lsnrctl services" to ensure that the instance(s) are // registered with the listener, and have status READY.运行lsnrctl services 看看isntance的服务是否已经注册。 看看isntance是否已经启动,如果已经启动,还没有注册 可以试试alter system register 注册试试。
2、测试一下本机能访问吗
3、TNSPING 服务名 如果不通检查服务名的参数配置
4、用PL或SQLPLUS链接
在服务器上也不行,
tnsping通,
pl或sqlplus不通
lsnrctl status查看监听状态
12523, 00000, "TNS:listener could not find instance appropriate for the client connection"
// *Cause: The listener could not find any available (database) instances,
// that are appropriate for the client connection.
// *Action: Run "lsnrctl services" to ensure that the instance(s) are
// registered with the listener, and have status READY.运行lsnrctl services 看看isntance的服务是否已经注册。
看看isntance是否已经启动,如果已经启动,还没有注册
可以试试alter system register 注册试试。