欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  IT编程

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

程序员文章站 2022-05-21 12:36:19
是因为在连接的时候使用了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 2020Version 21.1.0.0.0Copyright (c) 1982, 2020, Oracle. All ri...

是因为在连接的时候使用了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

本文地址:https://blog.csdn.net/wgz7747147820/article/details/107313131