Summary
When performing a Remote Execution task on an Oracle database with the etap.trace enabled you might see some ORA-XXXXX errors which can help identify exactly what the issue is.
Question
What do the Oracle ORA-XXXXX messages relate to?
Answer
When performing a Remote Execution task on an Oracle database with the etap.trace enabled you might see some ORA-XXXXX errors which can help identify exactly what the issue is. Some of these are listed below along with some suggestions on the resolution
|
Error Code
|
Error Text
|
Possible Causes / Solutions
|
| ORA-01034 | ORACLE not available | This often appears after a message saying "Failed to connect to the database, using connection string..." check that the Oracle the service (look at SERVICE_NAME or SID in the connection string) is running. |
| ORA-01169 | The listener has not recognized the password | This means that the Listener password in the EDS Password Store is incorrect |
| ORA-01189 | The listener cound not authenticate the user | This means that Local OS Authentication is turned on and therefore the Listener cannot be managed remotely. Check the listener.ora file to see if it says "Security ON: Password or Local OS Authentication" or "Security ON: Local OS Authentication" |
| ORA-12170 | TNS:Connect timeout occurred | This means that the remote connection failed using the connection string provided, the error will display the connection string, check it to ensure all the elements in the string are valid. |
| ORA-12500 | TNS:listener failed to start a dedicated server process | This says that the listener couldn?t start one of the services, this could be that it?s invalid, disabled etc there should be other ORA errors alongside this which will give more detail |
| ORA-12514 | TNS:listener does not currently know of service requested in connect descriptor | This basically means that the service you?re trying to connect to in the connection string is unrecognised; check that the service exists on the specified host. |
| ORA-24247 | Network access denied by access control list (ACL) | This error is an authentication issue using the ACL. Try KB Q200934 as a fix. |
| ORA-27101 | Shared memory realm does not exist... | this can either be caused by a service being inactive (as with ORA-01034) or it could be that the _SID values in one of the .ora files is different than it is in the others e.g. in one .ora file it is "A123" and in another it is "a123" (_SID values are case sensitive). |
| ORA-28112 | Failed to execute policy function | This is a generic error however it will fortunately produce a trace file in the user_dump_dest directory that can be examined and the error can be corrected |
| ORA-03134 | Connections to this server version are no longer supported | This is generally caused because the OLE DB Provider version is incompatible with the DB Version. Check release notes for the provider to see which DB versions it supports. |
