Tag: Oracle Administration

Oracle 11g Error Codes and Solution Suggestions from ORA-06300 to ORA-06500 ORA-06300: IPA: Disconnect failure Cause: A fatal error occurred during the disconnect from the server. This was probably caused by inaccessible message queues. Action: If there is no message queue, restart the SQL*Net IPA servers using ipactl. Otherwise contact your customer support representative. ORA-06301: IPA: Cannot…

Oracle 11g Error Codes and Solution Suggestions from ORA-06100 to ORA-06300 ORA-06102: NETTCP: cannot allocate context area Cause: Insufficient dynamic memory available for connection context area. Action: Contact your customer support representative. ORA-06105: NETTCP: remote host is unknown Cause: Host name specified in the login (connect) string is unknown. Action: Check spelling; make sure name is in the TCP/IP…

Oracle 11g Error Codes and Solution Suggestions from ORA-04900 to ORA-06100 ORA-04930: open sequence number failed or initial state is valid Cause: Either Shared Sequence Number OS component was not installed properly, or an MC hardware failure may have occurred or a previous instance was not shut down properly. Action: Verify that there are no background or…

Oracle 11g Error Codes and Solution Suggestions from ORA-04000 to ORA-04100 ORA-04000: the sum of PCTUSED and PCTFREE cannot exceed 100 Cause: the sum of PCTUSED and PCTFREE for a cluster or table exceeds 100 Action: create the table/cluster specifying values whose sum is <= 100 ORA-04001: sequence parameter string must be an integer Cause: %s (a sequence parameter) specified…

Oracle 11g Error Codes and Solution Suggestions from ORA-03200 to ORA-03300 ORA-03200: the segment type specification is invalid Cause: segment type is not TABLE, INDEX, or CLUSTER Action: use a correct segment type ORA-03201: the group number specification is invalid Cause: the freelist group number was either negative or larger than the the number of freelist groups in…

Oracle 11g Error Codes and Solution Suggestions from ORA-03000 to ORA-03200 ORA-03001: unimplemented feature Cause: This feature is not implemented. Action: None ORA-03002: operator not implemented Cause: This is an internal error. Action: Contact your customer support representative. ORA-03007: obsolete feature Cause: User attempted to use a feature which is no longer supported. Action: None ORA-03009: Incompatible OCI function call Cause: An…

Oracle 11g Error Codes and Solution Suggestions from ORA-02800 to ORA-02900 ORA-02800: Requests timed out Cause: Some of the requests for asynchronous input or output were not serviced in the required amount of time. Action: If the load on the system is high, it is possible that the timeout limit is too low. Reset it with sfainit()….

Oracle 11g Error Codes and Solution Suggestions from ORA-02700 to ORA-02800 ORA-02700: osnoraenv: error translating ORACLE_SID Cause: Two-task driver could not find the value of ORACLE_SID in the environment. Action: Make sure that the ORACLE_SID environment variable has been properly set and exported. ORA-02701: osnoraenv: error translating oracle image name Cause: ORACLE_HOME environment variable not set. Action: Make sure…

Oracle 11g Error Codes and Solution Suggestions from ORA-02400 to ORA-02500 ORA-02400: explain plan output buffer size limit exceeded Cause: Internally this error is raised and caught to handle cases where the plan output exceeds te buffer size. The output is truncated in cases. Action: This error should never be seen externally. ORA-02401: cannot EXPLAIN view owned…

Oracle 11g Error Codes and Solution Suggestions from ORA-02300 to ORA-02400 ORA-02300: invalid value for OIDGENERATORS Cause: A number was not specified for the value of OIDGENERATORS. Action: Specify a number for OIDGENERATORS. ORA-02301: maximum number of OIDGENERATORS is 255 Cause: A number greater than 255 was specified for the value of OIDGENERATORS. Action: Make sure the number specified…