ORA-12516

最新推荐文章于 2023-11-03 14:40:27 发布

Microjoey

最新推荐文章于 2023-11-03 14:40:27 发布

阅读量1.6k

点赞数

CC 4.0 BY-SA版权

分类专栏： RAC 文章标签： service oracle session sql null c

本文链接：https://blog.youkuaiyun.com/Microjoey/article/details/7571048

RAC 专栏收录该内容

47 篇文章

订阅专栏

ORA-12516:	TNS:listener could not find available handler with matching protocol stack
Cause:	None of the known and available service handlers for the given SERVICE_NAME support the client's protocol stack: transport, session, and presentation protocols.
Action:	Check to make sure that the service handlers (e.g. dispatchers) for the given SERVICE_NAME are registered with the listener, are accepting connections, and that they are properly configured to support the desired protocols.

[oracle@nshexdaj4db01 asmtests]$ sh test_asm.sh

SQL*Plus: Release 12.1.0.0.2 Beta on Wed May 16 01:23:40 2012

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

ERROR:
ORA-12516: TNS:listener could not find available handler with matching protocol
stack

Enter user-name: SP2-0306: Invalid option.
Usage: CONN[ECT] [{logon|/|proxy} [AS {SYSDBA|SYSOPER|SYSASM|SYSBACKUP|SYSDG|SYSKM}] [edition=value]]
where <logon> ::= <username>[/<password>][@<connect_identifier>]
<proxy> ::= <proxyuser>[<username>][/<password>][@<connect_identifier>]
Enter user-name: Enter password:
ERROR:
ORA-01005: null password given; logon denied

SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus