12C ORA-错误汇总8 ORA-12150 to ORA-12236

本文主要分享了一篇关于人工智能的教程,适合零基础学习者,讲解深入浅出。同时,文章提到了在学习过程中可能遇到的数据库错误代码范围从ORA-12150到ORA-12236,并鼓励读者分享知识,为科技进步贡献力量。
摘要由CSDN通过智能技术生成

分享一下我老师大神的人工智能教程!零基础,通俗易懂!http://blog.csdn.net/jiangjunshow

也欢迎大家转载本篇文章。分享知识,造福人民,实现我们中华民族伟大复兴!

                ORA-12150 to ORA-12236 9
ORA-12150: TNS:unable to send data
Cause: Unable to send data. Connection probably disconnected.
Action: Reestablish connection. If the error is persistent, turn on tracing and
reexecute the operation.
ORA-12151: TNS:received bad packet type from network layer
Cause: Internal error.
Action: Not normally visible to the user. For further details, turn on tracing and
reexecute the operation. If error persists, contact Worldwide Customer Support.
ORA-12152: TNS:unable to send break message
Cause: Unable to send break message. Connection probably disconnected.
Action: Reestablish connection. If the error is persistent, turn on tracing and
reexecute the operation.
ORA-12153: TNS:not connected
Cause: Not currently connected to a remote host.
Action: Reestablish connection.
ORA-12154: TNS:could not resolve the connect identifier specified
Cause: A connection to a database or other service was requested using a connect
identifier, and the connect identifier specified could not be resolved into a connect
descriptor using one of the naming methods configured. For example, if the type
of connect identifier used was a net service name then the net service name could
not be found in a naming method repository, or the repository could not be located
or reached.
Action:
- If you are using local naming (TNSNAMES.ORA file):
- Make sure that "TNSNAMES" is listed as one of the values of the
NAMES.DIRECTORY_PATH parameter in the Oracle Net profile (SQLNET.ORA)
- Verify that a TNSNAMES.ORA file exists and is in the proper directory and is
accessible.
- Check that the net service name used as the connect identifier exists in the
TNSNAMES.ORA file.
- Make sure there are no syntax errors anywhere in the TNSNAMES.ORA file.
Look for unmatched parentheses or stray characters. Errors in a TNSNAMES.ORA
file may make it unusable.
9-2 Oracle Database Error Messages
- If you are using directory naming:
- Verify that "LDAP" is listed as one of the values of the NAMES.DIRETORY_
PATH parameter in the Oracle Net profile (SQLNET.ORA).
- Verify that the LDAP directory server is up and that it is accessible.
- Verify that the net service name or database name used as the connect identifier
is configured in the directory.
- Verify that the default context being used is correct by specifying a fully qualified
net service name or a full LDAP DN as the connect identifier
- If you are using easy connect naming:
- Verify that "EZCONNECT" is listed as one of the values of the
NAMES.DIRETORY_PATH parameter in the Oracle Net profile (SQLNET.ORA).
- Make sure the host, port and service name specified are correct.
- Try enclosing the connect identifier in quote marks. See the Oracle Net Services
Administrators Guide or the Oracle operating system specific guide for more
information on naming.
ORA-12155: TNS:received bad datatype in NSWMARKER packet
Cause: Internal error during break handling.
Action: Not normally visible to the user. For further details, turn on tracing and
reexecute the operation. If error persists, contact Worldwide Customer Support.
ORA-12156: TNS:tried to reset line from incorrect state
Cause: Internal error during break handling.
Action: Not normally visible to the user. For further details, turn on tracing and
reexecute the operation. If error persists, contact Worldwide Customer Support.
ORA-12157: TNS:internal network communication error
Cause: Internal error during network communication.
Action: Not normally visible to the user. For further details, turn on tracing and
reexecute the operation. If error persists, contact Worldwide Customer Support.
ORA-12158: TNS:could not initialize parameter subsystem
Cause: Unable to locate parameter file.
Action: Verify that a valid parameter file exists, and is readable.
ORA-12159: TNS:trace file not writeable
Cause: The trace file to be generated is not writeable by this user.
Action: If the user does not have write permissions in the directory to which the
trace file will be written, contact an administrator to get the proper permissions or
set the TRACE_DIRECTORY_CLIENT parameter in the net profile (SQLNET.ORA
file) to a directory the user can write to.
ORA-12160: TNS:internal error: Bad error number
Cause: C
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
ORA-01017错误Oracle数据库中一个常见的错误,它表示用户在进行认证时没有提供正确的用户名或密码,导致登录失败。这个错误可能会在用户在进行各种数据库操作时出现,例如启动或连接数据库、执行SQL查询、创建或删除表等。 如果您遇到ORA-01017错误,首先应该确认您输入的用户名和密码是否正确。您可以尝试使用其他有效的用户名和密码重新登录数据库。如果您使用的是Oracle数据库的默认账户,例如SYS或SYSTEM账户,那么可以使用以下命令来重置密码: ALTER USER username IDENTIFIED BY new_password; 其中username为您要重置密码的账户名,new_password为新密码。 除了输入错误的用户名或密码外,还有一些其他常见的原因可能会导致ORA-01017错误。例如,您的数据库可能已被锁定,可能是由于某些数据库对象被其他用户或进程所占用,或者因为数据库正在进行备份或恢复操作。在这种情况下,您需要等待一段时间,直到数据库解锁。您还可以尝试重启数据库实例来解决此问题。 另外,ORA-01017错误也可能是由于网络故障或连接问题引起的。如果您正在通过网络连接数据库,请检查您的网络连接是否正常、数据库服务器是否可用,并确保您使用的是正确的连接字符串和端口号。 总之,ORA-01017错误可能是由多种原因引起的,但它通常表示用户输入了错误的用户名或密码。如果您遇到此问题,您需要核实提供的认证信息是否正确,并尝试使用其他有效的用户名和密码重新登录数据库。如果错误仍然存在,您可以考虑其他可能的原因,并采取相应的措施来解决问题。
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值