Category Archives: Database

ORA-12164: TNS:Sqlnet.fdf file not present

oracle

ORA-12164: TNS:Sqlnet.fdf file not present
Cause: The sqlnet.fdf file doesn’t exist in $ORACLE_HOME/network/admin.
Action: The sqlnet.fdf file is required for Oracle Tracing to occur. Either install the sqlnet.fdf file in $ORACLE_HOME/network/admin or turn off tracing in your ORA file.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-12163: TNS:connect descriptor is too long

oracle

ORA-12163: TNS:connect descriptor is too long
Cause: The connect descriptor corresponding to the net service name specified as the connect identifier is too long. The maximum length for a connect descriptor is 512 bytes and this limit has been exceeded.
Action: Check the net service name’s connect descriptor in the local naming file (TNSNAMES.ORA) or in the directory server (Oracle Internet Directory). Use a smaller connect descriptor. If this is not possible, contact Worldwide Customer Support.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-12162: TNS:net service name is incorrectly specified

oracle

ORA-12162: TNS:net service name is incorrectly specified
Cause: The connect descriptor corresponding to the net service name in TNSNAMES.ORA or in the directory server (Oracle Internet Directory) is incorrectly specified.
Action: If using local naming make sure there are no syntax errors in the corresponding connect descriptor in the TNSNAMES.ORA file. If using directory naming check the information provided through the administration used for directory naming.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-12161: TNS:internal error: partial data received

oracle

ORA-12161: TNS:internal error: partial data received
Cause: The connection may be terminated.
Action: Reconnect and try again. For further details, turn on tracing and reexecute the operation. If error persists, contact Worldwide Customer Support.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-12160: TNS:internal error: Bad error number

oracle

ORA-12160: TNS:internal error: Bad error number
Cause: Corrupt error reporting subsystem.
Action: Not normally visible to the user. For further details, turn on tracing and reexecute the operation. If error persists, contact Worldwide Customer Support.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-12159: TNS:trace file not writeable

oracle

ORA-12159: TNS:trace file not writeable
Cause: The trace file to be generated is not writeable by this user.
Action: If the user does not have write permissions in the directory to which the trace file will be written, contact an administrator to get the proper permissions or set the TRACE_DIRECTORY_CLIENT parameter in the net profile (SQLNET.ORA file) to a directory the user can write to.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-12158: TNS:could not initialize parameter subsystem

oracle

ORA-12158: TNS:could not initialize parameter subsystem
Cause: Unable to locate parameter file.
Action: Verify that a valid parameter file exists, and is readable.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-12157: TNS:internal network communication error

oracle

ORA-12157: TNS:internal network communication error
Cause: Internal error during network communication.
Action: Not normally visible to the user. For further details, turn on tracing and reexecute the operation. If error persists, contact Worldwide Customer Support.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-12156: TNS:tried to reset line from incorrect state

oracle

ORA-12156: TNS:tried to reset line from incorrect state
Cause: Internal error during break handling.
Action: Not normally visible to the user. For further details, turn on tracing and reexecute the operation. If error persists, contact Worldwide Customer Support.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-12155: TNS:received bad datatype in NSWMARKER packet

oracle

ORA-12155: TNS:received bad datatype in NSWMARKER packet
Cause: Internal error during break handling.
Action: Not normally visible to the user. For further details, turn on tracing and reexecute the operation. If error persists, contact Worldwide Customer Support.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/