Oracle Database Errors or Warnings from Error ORA-06957 to ORA-07200



ORA-06957: No SID is currently available
Cause: Incoming SQL*Net connection specified invalid SID name.
Action: Specify correct SID in connect string and retry.
ORA-06958: Failed to access configuration file
Cause: Unable to access CONFIG.ATK
Action: Check file protections.
ORA-06959: Buffer I/O quota is too small
Cause: Buffered I/O quota exceeded.
Action: Increase BIOlm using AUTHORIZE utility and retry.
ORA-06960: Failed to access log file
Cause: SQL*Net Appletalk listener could not create log file.
Action: Check directory path and protections.

ORA-06970: X.25 Driver: remote host is unknown
Cause: Host name specified in the login (connect string) is unknown.
Action: Check spelling; make sure name is in the X.25 HOST file.
ORA-06973: X.25 Driver: invalid buffer size
Cause: The buffer size specified in the login string must be between 5 and 4096.
Action: Re-submit with valid buffer size.
ORA-06974: X.25 Driver: SID lookup failure
Cause: From the remote host’s SQL*Net X.25 server: the database SID, specified in the login (connect) string, was not recognized.
Action: Add the appropriate SID entry to the CONFIG.ORA file on the remote host (and restart the SQL*Net X.25 server).
ORA-06975: X.25 Driver: connect to host failed
Cause: Connection attempt to remote host has failed. Probably means that the SQL*Net X.25 server on the remote host is not up, or the host itself is not up.
Action: Start the SQL*Net X.25 server process on the remote host.

ORA-06976: X.25 Driver: endpoint creation failure
Cause: Process open file quota probably exceeded.
Action: Contact your customer support representative.
ORA-06977: X.25 Driver: X.25 Level 2 failure
Cause: X.25 level 2 is down. X.25 link is not working.
Action: Run system checks to verify functioning of X.25 software. Contact your hardware vendor.
ORA-06978: X.25 Driver: Too many callback tries
Cause: Call back address probably same as called address.
Action: Verify that callback address and called address are different.
ORA-06979: X.25 Driver: server cannot start oracle
Cause: The remote X.25 server was unable to start an ORACLE process on behalf of the client.
Action: Make sure permissions on the remote ORACLE program are correctly set. Contact your system administrator.
ORA-07200: slsid: oracle_sid not set.
Cause: The environment variable $(ORACLE_SID) is not set.
Action: Set ORACLE_SID environment variable.

Above are list of Oracle Database Errors or Warnings from Error ORA-06957 to ORA-07200 received while performing certain operation against Oracle Database or related products.

What are Oracle Database Error Messages?

Oracle Error Messages may be returned while using products which are part of Oracle Database.  Each Oracle Database Error or Warning Message mentioned above contains the Warning or Error Message Statement, a short explanation of the probable causes of the Error message, and a recommended action.

Hope this was helpful.

SQLServerF1 Team
Information about Oracle Database Error Messages or Warning Messages on Windows and Linux Operating Systems.


Leave a Reply

Your email address will not be published. Required fields are marked *