Oracle 11g Error Codes and Solution Suggestions from ORA-07200 to ORA-07400 ORA-07200: slsid: oracle_sid not set. Cause: The environment variable $(ORACLE_SID) is not set. Action: Set ORACLE_SID environment variable. ORA-07201: slhom: oracle_home variable not set in environment. Cause: $(ORACLE_HOME) environment variable not set. Action: Set ORACLE_HOME. ORA-07202: sltln: invalid parameter to sltln. Cause: The sltln name translation routine was called…
Tag: Oracle Error Solutions
Oracle 11g Error Codes and Solution Suggestions from ORA-06800 to ORA-07000
Oracle 11g Error Codes and Solution Suggestions from ORA-06800 to ORA-07000 ORA-06800: TLI Driver: SQL*Net SPX client went away during reconnect Cause: The client process was aborted by the system or the user, and was unable to complete the connection establishment with the server listener process. Action: Determine cause of client exit, and reattempt connection. ORA-06801: TLI…
Oracle 11g Error Codes and Solution Suggestions from ORA-06600 to ORA-06800
Oracle 11g Error Codes and Solution Suggestions from ORA-06600 to ORA-06800 ORA-06600: LU6.2 Driver: SNA software is not loaded Cause: The SNA software is not running. Action: Start the SNA software and try again. ORA-06601: LU6.2 Driver: Invalid database ID string Cause: The database string in the connect was invalid. Action: Provide a valid database string, as defined in…
Oracle 11g Error Codes and Solution Suggestions from ORA-06500 to ORA-06600
Oracle 11g Error Codes and Solution Suggestions from ORA-06500 to ORA-06600 ORA-06500: PL/SQL: storage error Cause: PL/SQL was unable to allocate additional storage. This message normally appears with an ORA-4030 or ORA-4031 error which gives additional information. Sometimes this error can be caused by runaway programs. Action: 1) Ensure there are no issues or bugs in your…
Oracle 11g Error Codes and Solution Suggestions from ORA-06300 to ORA-06500
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
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
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
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
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
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…