ORA-07501 scgtoa: $deq unexpected return
Oracle Database Error Code Messages ORA-07501 Help About Description;
Scgtoa: $deq unexpected return.
Cause for Error and Problem;
VMS system service $DEQ returned an unexpected value.
How to Solve;ORA-07501 scgtoa: $deq unexpected return?
Action for Solve and Fix Ora-07501;
Check for system error message and refer to VMS documentation.
ORA-04931 unable to set initial sequence number value
Oracle Database Error Code Messages ORA-04931 Description Help About;
Unable to set initial sequence number value.
Cause for Error and Problem;
A call to the SSN failed to set the sequence number to its initial value, possibly caused by an MC hardware problem.
How to Solve; ORA-04931 unable to set initial sequence number value?
Action for Solve and Fix Ora-04931;
Verify that the MC hardware is functioning properly. If it is not, contact Digital's customer support organization. If it is, contact Oracle Support Services.
Next Post Ora-07501;
ORA-02101 PCC: inconsistent cursor cache (uce/cuc mismatch)
Oracle Database Error Code Messages ORA-02101 Help About Description;
PCC: inconsistent cursor cache (uce/cuc mismatch).
Cause for Error and Problem;
This internal error typically indicates a memory-related error.
How to Solve;ORA-02101 PCC: inconsistent cursor cache (uce/cuc mismatch)?
Action for Solve and Fix Ora-02101;
Check the program for memory-related errors, such as invalid pointers or array-bounds violations.
Next Post Ora-04931;
ORA-01501 CREATE DATABASE failed
Oracle Database Error Code Messages ORA-01501 Help Description About;
CREATE DATABASE failed.
Cause for Error and Problem;
An error occurred during CREATE DATABASE.
How to Solve;ORA-01501 CREATE DATABASE failed?
Action for Solve and Fix Ora-01501;
See accompanying errors.
Next Post Ora-02101;
ORA-00918 column ambiguously defined
Oracle Database Error Code Messages ORA-00918 Help About Description;
Column ambiguously defined.
Cause for Error and Problem;
A column name used in a join exists in more than one table and is thus referenced ambiguously. In a join, any column name that occurs in more than one of the tables must be prefixed by its table name when referenced. The column should be referenced as TABLE.COLUMN or TABLE_ALIAS.COLUMN. For example, if tables EMP and DEPT are being joined and both contain the column DEPTNO, then all references to DEPTNO should be prefixed with the table name, as in EMP.DEPTNO or E.DEPTNO.
How to Solve;ORA-00918 column ambiguously defined?
Action for Solve and Fix Ora-00918;
Prefix references to column names that exist in multiple tables with either the table name or a table alias and a period (.), as in the examples above.
Next Post Ora-01501;
ORA-00112 only created up to string (maximum specified) dispatchers
Oracle Database Error Code Messages ORA-00112 Help About Description;
Only created up to string (maximum specified) dispatchers.
Cause for Error and Problem;
An attempt was made to start more dispatchers than the maximum number specified by the system parameter MAX_DISPATCHERS.
How to Solve;ORA-00112 only created up to string (maximum specified) dispatchers?
Action for Solve and Fix Ora-00112;
Increase the value of the MAX_DISPATCHERS initialization parameter as needed.
Next Post Ora-00918;
ORA-29280 invalid directory path
Oracle Database Error Code Messages ORA-29280 Help About Description;
Invalid directory path.
Cause for Error and Problem;
A corresponding directory object does not exist.
How to Solve;ORA-29280 invalid directory path?
Action for Solve and Fix Ora-29280;
Correct the directory object parameter, or create a corresponding directory object with the CREATE DIRECTORY command.
Next Post Ora-00112;
ORA-28542 Error in reading HS init file
Oracle Database Error Code Messages ORA-28542 Help About Description;
Error in reading HS init file.
Cause for Error and Problem;
Reading the gateway init file generated an error.
How to Solve;ORA-28542 Error in reading HS init file?
Action for Solve and Fix Ora-28542;
Check the gateway initialization file name to see that the gateway initialization file acctually exists. Check the ifile parameter to see that it points to the correct location.
Next Post Ora-29280;
ORA-19400 System type conflict with object SYS.string
Oracle Database Error Code Messages ORA-19400 Help About Description;
System type conflict with object SYS.string.
Cause for Error and Problem;
The user had an object with the same name as one of the system types. The system types were not initialized properly.
How to Solve; ORA-19400 System type conflict with object SYS.string?
Action for Solve and Fix Ora-19400;
Remove the conflicting object and re-run migration.
Next Post Ora-28542;
ORA-12700 invalid NLS parameter value (string)
.png)
Oracle Database Error Code Messages ORA-12700 Help About Description;
Invalid NLS parameter value (string).
Cause for Error and Problem;
An invalid NLS initialization parameter was specified.
How to Solve; ORA-12700 invalid NLS parameter value (string)?
Action for Solve and Fix Ora-12700;
Check the syntax and spelling of the parameter. Enter the correct parameter into the initialization parameter file.
Next Post Ora-19400;
ORA-12400 invalid argument to facility error handling
Oracle Database Error Code Messages ORA-12400 Description Help About ;
Invalid argument to facility error handling.
Cause for Error and Problem;
An argument to a facility error handling function exceeded a maximum limit or referred to an invalid product/facility.
How to Solve; ORA-12400 invalid argument to facility error handling?
Action for Solve and Fix Ora-12400;
Specify a valid facility error handling parameter value.
Next Post Ora-12700;
ORA-12315 database link type is invalid for the ALTER DATABASE statement
Oracle Database Error Code Messages ORA-12315 Help About Description;
Database link type is invalid for the ALTER DATABASE statement.
Cause for Error and Problem;
The database link name you specified on the ALTER DATABASE statement is not an ROM: link. You must specify an ROM: link when using the ALTER DATABASE statement to mount or open a secondary database.
How to Solve;ORA-12315 database link type is invalid for the ALTER DATABASE statement?
Action for Solve and Fix Ora-12315;
Re-issue the ALTER DATABASE statement using a valid ROM: link to the database you want to mount or open. If a valid ROM: link does not exist, create one using the CREATE DATABASE LINK statement. See your documentation for Oracle security-related products for more information about creating database links using the ROM: link type.
Next Post Ora-12400;
ORA-09870 spini: failure initializing maximum number of open files.
Oracle Database Error Code Messages ORA-09870 Description Help About;
Spini: failure initializing maximum number of open files.
Cause for Error and Problem;
ULIMIT system call returned an error.
How to Solve;ORA-09870 spini: failure initializing maximum number of open files.?
Action for Solve and Fix Ora-09870;
Check errno.
ORA-07500 scglaa: $cantim unexpected return
Oracle Database Error Code Messages ORA-07500 About Help Description;
Scglaa: $cantim unexpected return.
Cause for Error and Problem;
VMS system service $CANTIM returned an unexpected value.
How to Solve; ORA-07500 scglaa: $cantim unexpected return?
Action for Solve and Fix Ora-07500;
Check for system error message and refer to VMS documentation.
ORA-04930 open sequence number failed or initial state is valid
Oracle Database Error Code Messages ORA-04930 Help About Description;
Open sequence number failed or initial state is valid.
Cause for Error and Problem;
Either Shared Sequence Number operating system component was not installed properly, or an MC hardware failure may have occurred or a previous instance was not shut down properly.
How to Solve; ORA-04930 open sequence number failed or initial state is valid?
Action for Solve and Fix Ora-04930;
Verify that there are no background or foreground Oracle processes from a previous instance on this node using the operating system command ps -ef | grep instance_name. Verify that there are no shared memory segments belonging to the user which owns the Oracle installation by issuing the ipcs -b operating system command. If there are shared memory segments or processes still on the system, use SVRMGRL to shut down the instance with the abort option. If the instance is not up, verify that the cluster software and/or the hardware is installed and working. Log in as superuser and issue the CNXSHOW command. Are all of the nodes in the cluster listed? Are they members of the cluster? Is the communications between nodes okay? If the answer to any of these questions is false, contact Digital's customer support organization.
Next Post Ora-07500;
ORA-02100 PCC: out of memory (i.e., could not allocate)
.png)
Oracle Database Error Code Messages ORA-02100 Help About Description;
PCC: out of memory (i.e., could not allocate).
Cause for Error and Problem;
SQLLIB was unable to allocate enough memory to execute the program.
How to Solve;ORA-02100 PCC: out of memory (i.e., could not allocate)?
Action for Solve and Fix Ora-02100;
Allocate more memory to the user session and then rerun the program. If the error persists, contact Oracle Support Services for assistance.
Next Post Ora-04930;
ORA-01500 failure in getting date/time
Oracle Database Error Code Messages ORA-01500 Help About Description;
Failure in getting date/time.
Cause for Error and Problem;
During CREATE DATABASE or ALTER TABLESPACE, there was a failure in getting the date and time.
How to Solve;ORA-01500 failure in getting date/time?
Action for Solve and Fix Ora-01500;
Contact Oracle Support Services.
Next Post Ora-02100;
ORA-00917 missing comma
Oracle Database Error Code Messages ORA-00917 Help About Description;
Missing comma.
Cause for Error and Problem;
A required comma has been omitted from a list of columns or values in an INSERT statement or a list of the form ((C,D),(E,F), ...).
How to Solve;ORA-00917 missing comma?
Action for Solve and Fix Ora-00917;
Correct the syntax.
Next Post Ora-01500;
ORA-00111 not all servers started because number of servers is limited to string
Oracle Database Error Code Messages ORA-00111 About Help Description;
Not all servers started because number of servers is limited to string.
Cause for Error and Problem;
An attempt was made to start more servers than the maximum number specified by the system parameter MAX_SHARED_SERVERS.
How to Solve;ORA-00111 not all servers started because number of servers is limited to string?
Action for Solve and Fix Ora-00111;
Increase the value of the MAX_SHARED_SERVERS initialization parameter as needed or re-issue the ALTER SYSTEM SET SHARED_SERVERS statement with an appropriate number of servers.
Next Post Ora-00917;
ORA-29279 SMTP permanent error: string
Oracle Database Error Code Messages ORA-29279 About Help Description;
SMTP permanent error: string.
Cause for Error and Problem;
An SMTP permanent error occurred.
How to Solve;ORA-29279 SMTP permanent error: string?
Action for Solve and Fix Ora-29279;
Correct the error and retry the SMTP operation.
Next Post Ora-00111;
ORA-28543 Error initializing apply connection to non-Oracle system
Oracle Database Error Code Messages ORA-28543 Description About Help;
Error initializing apply connection to non-Oracle system.
Cause for Error and Problem;
Attempt to initialize connection to non-Oracle for heterogeneous replication failed.
How to Solve; ORA-28543 Error initializing apply connection to non-Oracle system?
Action for Solve and Fix Ora-28543;
Check if the listener used to connect to the gateway is up and is correctly configured. Make sure that the database link used has been configured correctly and, if a tnsnames alias has been used in the database link definition, make sure that the configuration of the entry in tnsnames.ora has been done correctly.
Next Post Ora-29279;
ORA-00915 network access of dictionary table not currently allowed
Oracle Database Error Code Messages ORA-00915 Help About Description;
Network access of dictionary table not currently allowed.
Cause for Error and Problem;
This is an internal error message not usually issued.
How to Solve;ORA-00915 network access of dictionary table not currently allowed?
Action for Solve and Fix Ora-00915;
Contact Oracle Support Services.
Next Post Ora-28543;
ORA-00108 failed to set up dispatcher to accept connection asynchronously
Oracle Database Error Code Messages ORA-00108 About Help Description;
Failed to set up dispatcher to accept connection asynchronously.
Cause for Error and Problem;
The network protocol used by the dispatcher does not support asynchronous operations.
How to Solve;ORA-00108 failed to set up dispatcher to accept connection asynchronously?
Action for Solve and Fix Ora-00108;
Contact Oracle Support Services.
Next Post Ora-00915;
ORA-29278 SMTP transient error: string
Oracle Database Error Code Messages ORA-29278 Help About Description;
SMTP transient error: string.
Cause for Error and Problem;
An SMTP transient error occurred.
How to Solve;ORA-29278 SMTP transient error: string?
Action for Solve and Fix Ora-29278;
Correct the error and retry the SMTP operation.
Next Post Ora-00108;
ORA-00914 missing ADD keyword
Oracle Database Error Code Messages Ora-00914 About Help Description;
Missing ADD Keyword.
Cause for Error and Problem;
The keyword ADD does not precede one of the following:
ORA-28544 connect to agent failed, probable Net8 administration error
Oracle Database Error Code Messages ORA-28544 Help About Description;
Connect to agent failed, probable Net8 administration error.
Cause for Error and Problem;
Net8 reported a failure to make a RSLV connection or a protocol mode error when the Oracle database server attempted to establish communication with a Heterogeneous Services agent or an external procedure agent. This usually is due to an administration error in setting up Net8 service definitions in TNSNAMES.ORA or LISTENER.ORA: A basic network connection is opened, but it connects to a program which does not use the appropriate protocol. This often is a sign that the connection goes to the wrong program.
How to Solve;ORA-28544 connect to agent failed, probable Net8 administration error?
Action for Solve and Fix Ora-28544;
Check Net8 administration in the following ways:
ORA-00107 failed to connect to ORACLE listener process
Oracle Database Error Code Messages ORA-00107 Help About Description;
Failed to connect to ORACLE listener process.
Cause for Error and Problem;
Most likely due to the fact that the network listener process has not been started.
How to Solve;ORA-00107 failed to connect to ORACLE listener process?
Action for Solve and Fix Ora-00107;
Check for the following:
ORA-29277 invalid SMTP operation
Oracle Database Error Code Messages ORA-29277 About Help Description;
Invalid SMTP operation.
Cause for Error and Problem;
The SMTP operation was invalid at the current stage of the SMTP transaction.
How to Solve;ORA-29277 invalid SMTP operation?
Action for Solve and Fix Ora-29277;
Retry the SMTP operation at the appropriate stage of the SMTP transaction.
Next Post Ora-00107;
ORA-28545 error diagnosed by Net8 when connecting to an agent
Oracle Database Error Code Messages ORA-28545 Help About Description;
Error diagnosed by Net8 when connecting to an agent.
Cause for Error and Problem;
An attempt to call an external procedure or to issue SQL to a non-Oracle system on a Heterogeneous Services database link failed at connection initialization. The error diagnosed by Net8 NCR software is reported separately.
How to Solve;ORA-28545 error diagnosed by Net8 when connecting to an agent?
Action for Solve and Fix Ora-28545;
Refer to the Net8 NCRO error message. If this isn't clear, check connection administrative setup in tnsnames.ora and listener.ora for the service associated with the Heterogeneous Services database link being used, or with 'extproc_connection_data' for an external procedure call.
Next Post Ora-29277;
ORA-00913 too many values
Oracle Database Error Code Messages ORA-00913 About Help Description;
Too many values.
Cause for Error and Problem;
The SQL statement requires two sets of values equal in number. This error occurs when the second set contains more items than the first set. For example, the subquery in a WHERE or HAVING clause may return too many columns, or a VALUES or SELECT clause may return more columns than are listed in the INSERT.
How to Solve;ORA-00913 too many values?
Action for Solve and Fix Ora-00913;
Check the number of items in each set and change the SQL statement to make them equal.
Next Post Ora-28545;
ORA-00106 cannot startup/shutdown database when connected to a dispatcher
Oracle Database Error Code Messages ORA-00106 Description Help About;
Cannot startup/shutdown database when connected to a dispatcher.
Cause for Error and Problem;
An attempt was made to start or shut down an instance while connected to a shared server via a dispatcher.
How to Solve;ORA-00106 cannot startup/shutdown database when connected to a dispatcher?
Action for Solve and Fix Ora-00106;
Reconnect as user INTERNAL without going through the dispatcher. For most cases, this can be done by connect to INTERNAL without specifying a network connect string.
ORA-29276 transfer timeout
Oracle Database Error Code Messages ORA-29276 About Help Description;
Transfer timeout.
Cause for Error and Problem;
Timeout occurred while reading from or writing to a network connection.
How to Solve;ORA-29276 transfer timeout?
Action for Solve and Fix Ora-29276;
Check the remote server or the network to ensure that it responds within the timeout limit. Or increase the timeout value.
Next Post Ora-00106;
ORA-28546 connection initialization failed, probable Net8 admin error
Oracle Database Error Code Messages ORA-28546 About Description Help;
Connection initialization failed, probable Net8 admin error.
Cause for Error and Problem;
A failure occurred during initialization of a network connection from the Oracle database server to a second process: The connection was completed but a disconnect occurred while trying to perform protocol-specific initialization, usually due to use of different network protocols by opposite sides of the connection. This usually is caused by incorrect Net8 administrative setup for database links or external procedure calls. The most frequent specific causes are:
ORA-00911 invalid character
Oracle Database Error Code Messages ORA-00911 Description About Help;
Invalid character.
Cause for Error and Problem;
Special characters are valid only in certain places. If special characters other than $, _, and # are used in a name and the name is not enclosed in double quotation marks ("), this message will be issued. One exception to this rule is for database names; in this case, double quotes are stripped out and ignored.
How to Solve; Ora-00911 invalid character?
Action for Solve and Fix Ora-00911;
Remove the invalid character from the statement or enclose the object name in double quotation marks.
Next Post Ora-28546;
ORA-00105 dispatching mechanism not configured for network protocol string
Oracle Database Error Code Messages ORA-00105 About Description Help;
Dispatching mechanism not configured for network protocol string.
Cause for Error and Problem;
An attempt was made to alter the dispatcher's configuration for a network protocol that was not specified in the initialization parameter file.
How to Solve;ORA-00105 dispatching mechanism not configured for network protocol string?
Action for Solve and Fix Ora-00105;
Do one of the following:
ORA-29275 partial multibyte character
Oracle Database Error Code Messages ORA-29275 About Description Help;
Partial multibyte character.
Cause for Error and Problem;
The requested read operation could not complete because a partial multibyte character was found at the end of the input.
How to Solve; ORA-29275 partial multibyte character?
Action for Solve and Fix Ora-29275;
Ensure that the complete multibyte character is sent from the remote server and retry the operation. Or read the partial multibyte character as RAW.
Next Post Ora-00105;
ORA-28550 pass-through SQL: cursor not found
Oracle Database Error Code Messages ORA-28550 Description Help About;
Pass-through SQL: cursor not found.
Cause for Error and Problem;
A value passed to a pass-through SQL function or procedure call as a cursor does not identify a currently open cursor.
How to Solve;ORA-28550 pass-through SQL: cursor not found?
Action for Solve and Fix Ora-28550;
Use a cursor number returned by the pass-through SQL OPEN_CURSOR call.
Next Post Ora-29275;
ORA-00910 specified length too long for its datatype
Oracle Database Error Code Messages ORA-00910 Description Help About;
Specified length too long for its datatype.
Cause for Error and Problem;
No size was specified for a character field or the size was invalid. A maximum length must be specified for each character column. The maximum value for this length varies for each character datatype, such as CHAR or VARCHAR2.
How to Solve;ORA-00910 specified length too long for its datatype
Action for Solve and Fix Ora-00910;
Enter a maximum length for the field.
Next Post Ora-28550;
ORA-00104 deadlock detected; all public servers blocked waiting for resources
Oracle Database Error Code Messages ORA-00104 Help About Description;
Deadlock detected; all public servers blocked waiting for resources.
Cause for Error and Problem;
All available public servers are servicing requests that require resources locked by a client which is unable to get a public server to release the resources.
How to Solve;ORA-00104 deadlock detected; all public servers blocked waiting for resources?
Action for Solve and Fix Ora-00104;
Increase the limit for the system parameter MAX_SHARED_SERVERS as the system will automatically start new servers to break the deadlock until the number of servers reaches the value specified in MAX_SHARED_SERVERS.
Next Post Ora-00910;
ORA-00921 unexpected end of SQL command Oracle Database Error Code Messages ORA-00921 About Help Description; Unexpected end of SQL com...
