连接数据库报ORA-12541: TNS:no listener

最新推荐文章于 2024-07-18 18:43:30 发布

wgz7747147820

最新推荐文章于 2024-07-18 18:43:30 发布

阅读量578

点赞数

分类专栏： orale 文章标签： oracle

本文链接：https://blog.csdn.net/wgz7747147820/article/details/107313131

版权

orale 专栏收录该内容

204 篇文章 0 订阅

订阅专栏

是因为在连接的时候使用了ip，使用hostname则没有这个问题

[crsusr@slcz01db04 bin]$ ./sqlplus "system/aug@10.242.3.72:1521/augpdb10010_srv_20200708"

SQL*Plus: Release 21.0.0.0.0 - Development on Sun Jul 12 21:07:46 2020
Version 21.1.0.0.0

Copyright (c) 1982, 2020, Oracle.  All rights reserved.

ERROR:
ORA-12541: TNS:no listener



[crsusr@slcz01db04 bin]$ ./sqlplus "system/aug@slcz01db04:1521/augpdb10010_srv_20200708"

SQL*Plus: Release 21.0.0.0.0 - Development on Sun Jul 12 21:07:32 2020
Version 21.1.0.0.0

Copyright (c) 1982, 2020, Oracle.  All rights reserved.

Last Successful login time: Sun Jul 12 2020 21:07:17 -06:00

Connected to:
Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Development
Version 21.1.0.0.0

SQL> exit