12C ORA-错误汇总20

这篇博客汇总了关于12C ORA-错误的20个常见问题,包括详细的解释和解决建议。适合遇到此类问题的数据库管理员参考学习。
摘要由CSDN通过智能技术生成

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

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

                CLSMDNS-00000: no error
Cause: A command completely successfully.
Action: No action is needed.
CLSMDNS-00001: GIPC endpoint creation failed.
Cause: An attempt to create a GIPC endpoint for use multicast operations failed.
Action: Examine the accompanying error (if any) and the log file for details as to
why the operation failed.
CLSMDNS-00002: bind failed.
Cause: An attempt to bind an address to a GIPC endpoint failed.
Action: Examine the accompanying error (if any) and the log file for details as to
why the operation failed.
CLSMDNS-00003: address creation failed.
Cause: An attempt to create a GIPC address failed.
Action: Examine the accompanying error (if any) and the log file for details as to
why the operation failed.
CLSMDNS-00004: attribute setting failed.
Cause: An attempt to set an attribute on a GIPC endpoint or address failed.
Action: Examine the accompanying error (if any) and the log file for details as to
why the operation failed.
CLSMDNS-00005: interface registration failed.
Cause: The registration of an interface with mDNS failed.
Action: Examine the accompanying error (if any) and the log file for details as to
why the operation failed.
CLSMDNS-00006: failed to get name server list.
Cause: An attempt to get the list of available name servers failed.
Action: Examine the accompanying error (if any) and the log file for details as to
why the operation failed.
CLSMDNS-00007: mDNS initialization failed.
Cause: The initialization of the mDNS subsystem failed.
Action: Examine the accompanying error (if any) and the log file for details as to
why the operation failed.
58-2 Oracle Database Error Messages
CLSMDNS-00008: start of host query failed.
Cause: The query for hosts from mDNS failed to start.
Action: Examine the accompanying error (if any) and the log file for details as to
why the operation failed.
CLSMDNS-00009: stop of host query failed.
Cause: Termination of the query for hosts from mDNS failed.
Action: Examine the accompanying error (if any) and the log file for details as to
why the operation failed.
CLSMDNS-00010: Initialization of name server name retrieval failed.
Cause: The initialization of the retrieval of the names of the name servers used by
multicast DNS failed.
Action: Examine the accompanying messages(s) that detail the platform error(s)
for details about the exception.
CLSMDNS-00011: retrieval of name server name failed.
Cause: The retrieval of the name of a name server to be used by multicast DNS
failed.
Action: Examine the accompanying messages(s) that detail the platform error(s)
for details about the exception.
CLSMDNS-00012: no name servers found.
Cause: No name servers were found that could be used by multicast DNS.
Action: Check the system configuration and ensure that or more DNS name
servers are configured, operating and accessible.
CLSMDNS-00013: Send of response to DNS server failed.
Cause: An attempt to send a response to a query from the DNS server failed.
Action: Examine accompanying exceptions for details about the exact error.
CLSMDNS-00015: invalid record type: number
Cause: The DNS server sent a record whose type is unknown.
Action: This is a warning message which can be ignored because the error should
occur very infrequently. If the error occurs frequently, Oracle Customer Support
should be contacted.
CLSMDNS-02000: unknown error.
Cause: An unknown error occurred. This error can occur when the multicast DNS
server is not running.
Action: If the multicast server is not running, start it and try the operation again.
If it is running, this is an internal error and Oracle Customer Support should be
contacted with details about how and when the error occurred.
CLSMDNS-02001: no such name exists.
Cause: This error is internal and should not ordinarily be seen by the user.
Action: Contact Oracle Customer Support.
CLSMDNS-02002: memory allocation failure.
Cause: The allocation of process memory failed.
CLSMDNS-00000 to CLSMDNS-02255 58-3
Action: If memory is low on the system, terminate other processes and/or threads
and try the operation again. Otherwise, this is an internal error and Oracle
Customer Support should be contacted.
CLSMDNS-02003: invalid parameter.
Cause: This error is internal and should not ordinarily be seen by the user.
Action: Contact Oracle Customer Support.
CLSMDNS-02004: invalid reference.
Cause: This error is internal and should not ordinarily be seen by the user.
Action: Contact Oracle Customer Support.
CLSMDNS-02005: invalid state.
Cause: This error is internal and should not ordinarily be seen by the user.
Action: Contact Oracle Customer Support.
CLSMDNS-02006: invalid flags.
Cause: This error is internal and should not ordinarily be seen by the user.
Action: Contact Oracle Customer Support.
CLSMDNS-02007: operation is unsupported.
Cause: This error is internal and should not ordinarily be seen by the user.
Action: Contact Oracle Customer Support.
CLSMDNS-02008: uninitialized.
Cause: This error is internal and should not ordinarily be seen by the user.
Action: Contact Oracle Customer Support.
CLSMDNS-02009: no cache.
Cause: This error is internal and should not ordinarily be seen by the user.
Action: Contact Oracle Customer Support.
CLSMDNS-02010: record or service is already registered.
Cause: This error is internal and should not ordinarily be seen by the user.
Action: Contact Oracle Customer Support.
CLSMDNS-02011: name conflict found.
Cause: This error is internal and should not ordinarily be seen by the user.
Action: Contact Oracle Customer Support.
CLSMDNS-02012: Invalid.
Cause: This error is internal and should not ordinarily be seen by the user.
Action: Contact Oracle Customer Support.
CLSMDNS-02013: Firewall.
Cause: This error is internal and should not ordinarily be seen by the user.
Action: Contact Oracle Customer Support.
CLSMDNS-02014: Incompatible.
Cause: This error is internal and should not ordinarily be seen by the user.
Action: Contact Oracle Customer Support.
58-4 Oracle Database Error Messages
CLSMDNS-02015: invalid interface.
Cause: This error is internal and should not ordinarily be seen by the user.
Action: Contact Oracle Customer Support.
CLSMDNS-02016: Refused.
Cause: This error is internal and should not ordinarily be seen by the user.
Action: Contact Oracle Customer Support.
CLSMDNS-02017: no such record.
Cause: This error is internal and should not ordinarily be seen by the user.
Action: Contact Oracle Customer Support.
CLSMDNS-02018: no authentication.
Cause: This error is internal and should not ordinarily be seen by the user.
Action: Contact Oracle Customer Support.
CLSMDNS-02019: no such key.
Cause: This error is internal and should not ordinarily be seen by the user.
Action: Contact Oracle Customer Support.
CLSMDNS-02020: error occurred while passing through NAT.
Cause: This error is internal and should not ordinarily be seen by the user.
Action: Contact Oracle Customer Support.
CLSMDNS-02021: double NAT encountered.
Cause: This error is internal and should not ordinarily be seen by the user.
Action: Contact Oracle Customer Support.
CLSMDNS-02022: invalid time.
Cause: This error is internal and should not ordinarily be seen by the user.
Action: Contact Oracle Customer Support.
CLSMDNS-02023: invalid signature.
Cause: This error is internal and should not ordinarily be seen by the user.
Action: Contact Oracle Customer Support.
CLSMDNS-02024: invalid key.
Cause: This error is internal and should not ordinarily be seen by the user.
Action: Contact Oracle Customer Support.
CLSMDNS-02025: transient error.
Cause: This error is internal and should not ordinarily be seen by the user.
Action: Contact Oracle Customer Support.
CLSMDNS-02250: connection pending.
Cause: This error is internal and should not ordinarily be seen by the user.
Action: Contact Oracle Customer Support.
CLSMDNS-02251: connection failed.
Cause: This error is internal and should not ordinarily be seen by the user.
Action: Contact Oracle Customer Support.
CLSMDNS-00000 to CLSMDNS-02255 58-5
CLSMDNS-02252: connection established.
Cause: This error is internal and should not ordinarily be seen by the user.
Action: Contact Oracle Customer Support.
CLSMDNS-02253: more memory needed for cache.
Cause: This error is internal and should not ordinarily be seen by the user.
Action: Contact Oracle Customer Support.
CLSMDNS-02254: configuration changed.
Cause: This error is internal and should not ordinarily be seen by the user.
Action: Contact Oracle Customer Support.
CLSMDNS-02255: memory free needed.
Cause: This error is internal and should not ordinarily be seen by the user.
Action: Contact Oracle Customer Support.
58-6 Oracle Database Error Messages
59
CLSR-00001 to CLSR-06507 59-1
CLSR-00001 to CLSR-06507 9 5
CLSR-00001: Oracle error number encountered
Cause: Oracle-related error is encountered.
Action: Check alert log and trace file for more detail.
CLSR-00002: Oracle error encountered while executing string
Cause: Oracle-related error is encountered while executing a request.
Action: Check alert log for more detail.
CLSR-00003: ORACLE_HOME environment variable not set
Cause: ORACLE_HOME environment variable is not set.
Action: Make sure that the ORACLE_HOME environment variable has been
properly set and exported.
CLSR-00004: Error encountered at string, category=number, operation=string, OS
error=number
Cause: Operating system error occurred.
Action: Check for the error message for more detail.
CLSR-00005: Error encountered during memory allocation
Cause: System memory is insufficient.
Action: Check the availability of memory in the system before retrying.
CLSR-00006: Error encountered when writing file string
Cause: Error when writing file.
Action: Check the permission of the file and the existence of its path.
CLSR-00007: Error encountered when reading file string
Cause: Error when reading file.
Action: Check the permission and existence of the file.
CLSR-00501: Error number encountered when connecting to EVM daemon
Cause: Error encountered when connecting to EVM daemon.
Action: Check status of EVM daemon and log file for detail.
CLSR-00502: Error number encountered when subscribing an EVM event
Cause: Error encountered when subscribing an EVM event.
Action: Contact customer support.
CLSR-00503: Error number encountered when creating an EVM event
59-2 Oracle Database Error Messages
Cause: Error encountered when creating an EVM event.
Action: Contact customer support.
CLSR-00504: Error number encountered when posting an EVM event
Cause: Error encountered when posting an EVM event.
Action: Contact customer support.
CLSR-00505: Empty event type is specified
Cause: Empty event type is specified.
Action: Try again with a valid event type.
CLSR-00506: Unmatched resource name prefix string is specified
Cause: Specified resource name prefix does not match as required.
Action: Try again with a valid resource name prefix.
CLSR-00507: The length of the facility name string exceeds the limit (number)
Cause: The given facility name is too long.
Action: Try again with a short facility name.
CLSR-00508: Invalid message number number
Cause: An incorrect message number is specified.
Action: Try again with a correct message number.
CLSR-00509: Unable to initialize NLS
Cause: Failed to initialize callback structure for NLS.
Action: Contact customer support.
CLSR-00510: Unable to load NLS data
Cause: Failed to initialize NLS data loading.
Action: Not action required as default data loading will be used.
CLSR-00511: Error number encountered when handling incoming EVM message
Cause: Error encountered when handling incoming EVM message.
Action: Check log file for detail.
CLSR-00512: Invalid CAA trigger event type [string]
Cause: Invalid CAA trigger event type is specified.
Action: Try again with a valid type.
CLSR-00513: Message file is not found
Cause: The requested OCI message file is not found.
Action: Check if the message file is properly installed.
CLSR-00514: Unable to locate PMON [pid=string]
Cause: Cannot find PMON with this pid.
Action: Check the existence of PMON.
CLSR-00515: A service member is already running on this node
Cause: There is a service member of the same service running on this node.
Action: No action required as the service member will try to start on another
node.
CLSR-00001 to CLSR-06507 59-3
CLSR-00516: No service provider found at this node
Cause: No suitable service provider is found on this node.
Action: No action required as the service member will try to start on another
node.
CLSR-00517: Failed to register a service name
Cause: The requested service name cannot be registered.
Action: Check log file for detail.
CLSR-00518: Failed to register a preconnect service name
Cause: The requested preconnect service name cannot be registered.
Action: Check log file for detail.
CLSR-00519: No instance found
Cause: No instance is found running for the database resource.
Action: No action required as the database resource will fail itself.
CLSR-00520: No service member found
Cause: No service member is found running for the composite service resource.
Action: No action required as the composite service resource will fail itself.
CLSR-00521: Event string is rejected by EVM daemon
Cause: No template has been registered for the event or caller is not authorized to
post the event.
Action: Check if there is a template registered for this event and the authority of
posting this event.
CLSR-00522: Resource string is not registered
Cause: CRS resource is not registered.
Action: Register the CRS resource.
CLSR-00523: Resource string is not enabled
Cause: CRS resource is not enabled.
Action: Enable the CRS resource.
CLSR-00524: Resource string is stopping, resource string cannot start
Cause: Resource cannot start because its composite resource is stopping.
Action: Retry to start the resource when its composite resource is not stopping.
CLSR-00525: prsr initialization failed
Cause: See the related error message.
Action: Run crs_stat to make sure CSS and OCR working properly.
CLSR-00526: Failed to retrieve database configuration in OCR
Cause: See the related error message.
Action: Run crs_stat to make sure CSS and OCR working properly and database
configuration in ocr is initialized.
CLSR-00527: OCR operation failed
Cause: See related error messages about the OCR operation.
Action: Fix the related error. Then try again.
59-4 Oracle Database Error Messages
CLSR-00528: RACGONS: host and port number already configured in OCR
Cause: host and port number already configured in OCR.
Action: None
CLSR-00529: RACGONS: host and port number to be removed does not exist
Cause: host and port number to be removed is not configured in OCR.
Action: None
CLSR-00530: Can not get user name
Cause: Error caused by OSD layer.
Action: Contact Oracle support.
CLSR-00531: Can not get primary group name
Cause: There is no primary group for this OS.
Action: Not faital. None.
CLSR-01001: Unsupported open mode number is specified
Cause: Unsupported open mode is specified for mounting database.
Action: Retry again with a valid open mode.
CLSR-01002: Unable to process instance startup
Cause: ORACLE_HOME environment variable not set.
Action: Make sure that the ORACLE_HOME environment variable has been
properly set and exported.
CLSR-01003: Error number encountered during mounting database
Cause: Unexpected error occurs when mounting database.
Action: Check current status of database before retrying.
CLSR-01004: Failed to mount database
Cause: Database cannot be mounted by an instance.
Action: Check alert log for error detail.
CLSR-01005: Error number encountered during altering database open mode
Cause: Unexpected error occurs when altering database open mode.
Action: Check current database status.
CLSR-01006: Unable to process instance shutdown
Cause: ORACLE_HOME environment variable not set.
Action: Make sure that the ORACLE_HOME environment variable has been
properly set and exported.
CLSR-01007: Connection to database was not established
Cause: Connection to database is failed to establish.
Action: Make sure connection and environment are properly set up.
CLSR-01008: Error number encountered during querying for PMON status
Cause: Unexpected error encountered when querying v$process for PMON.
Action: Check alert log and connection to database.
CLSR-01009: database management module failed to start
CLSR-00001 to CLSR-06507 59-5
Cause: Error encountered during initializing database management module.
Action: Check previous error message for detail.
CLSR-01010: Unable to record PMON pid to string
Cause: Failed to write os pid for PMON to file.
Action: Check file system for disk space and access privilege.
CLSR-01011: Invalid instance startup mode [string] is specified
Cause: Invalid startup mode is specified.
Action: Retry again with a valid startup mode.
CLSR-01012: Invalid instance stop mode [string] is specified
Cause: Invalid stop mode is specified.
Action: Retry again with a vaild stop mode.
CLSR-06500: Invalid input arguments
Cause: Invalid input arguments are specified.
Action: Retry again with a valid argument.
CLSR-06501: Exceeds maximum number of arguments
Cause: Too many input arguments are specified.
Action: Retry again with correct number of arguments.
CLSR-06502: Failed to connect to database 'string' as user 'string'
Cause: Failed to connect to database.
Action: Check database and log file for details.
CLSR-06503: Service name already registered
Cause: Requested service name has been registered by another service.
Action: Choose another service name and retry registration again.
CLSR-06504: Service name not in SERVICE_NAMES
Cause: Requested service name is not registered.
Action: Make sure the correct service name is specified in the request.
CLSR-06505: SERVICE_NAMES found null and fixed
Cause: SERVICE_NAMES parameter becomes null after the delete operation.
Action: Not action required as SERVICE_NAMES is set to default value.
CLSR-06506: Error number encountered when executing string
Cause: Error occurred when executing the SQL statement.
Action: Check alert log for more detail.
CLSR-06507: Cannot add to SERVICE_NAMES, SERVICE_NAMES will be too long
Cause: Adding the service name will exceed the limit of SERVICE_NAMES.
Action: Change the configuration to avoid SERVICE_NAMES becomes too long.
59-6 Oracle Database Error Messages
60
CLSS-00001 to CLSS-03202 60-1
CLSS-00001 to CLSS-
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、付费专栏及课程。

余额充值