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

2022-08-06,,,

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

《连接数据库报ORA-12541: TNS:no listener.doc》

下载本文的Word格式文档,以方便收藏与打印。