Category Archives: TNS Database Error Messages

TNS-02402: Bad CLBGNAMES parameter in tnsnames.ora

oracle

TNS-02402: Bad CLBGNAMES parameter in tnsnames.ora
Cause: CLBGNAMES parameter in TNSNAMES.ORA is bad.
Action: Check the CLBGNAMES parameter format and correct it. Make sure that the TNSNAMES.ORA file is there.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

TNS-02401: gbname string too long, allowed number characters

oracle

TNS-02401: gbname string too long, allowed number characters
Cause: GBNAME or domain name too long.
Action: Check the GBNAME parameter in LISTENER.ORA, shorten it.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

TNS-02021: DIRECT_HANDOFF can be either ON or OFF

oracle

TNS-02021: DIRECT_HANDOFF can be either ON or OFF
Cause: Invalid value for the LSNRCTL DIRECT_HANDOFF parameter.
Action: Specify either ON or OFF.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

TNS-02020: set displaymode RAW | COMPAT | NORMAL | VERBOSE: output mode for lsnrctl display

oracle

TNS-02020: set displaymode RAW | COMPAT | NORMAL | VERBOSE: output mode for lsnrctl display
Cause: Control program usage message.
Action: No action required.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

TNS-01421: Session: string

oracle

TNS-01421: Session: string
Cause: Control program status message.
Action: No action required.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

TNS-01420: Presentation: string

oracle

TNS-01420: Presentation: string
Cause: Control program status message.
Action: No action required.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

TNS-01417: “string” established:string refused:string state:string

oracle

TNS-01417: "string" established:string refused:string state:string
Cause: Control program status message.
Action: No action required.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

TNS-01416: Process ID string

oracle

TNS-01416: Process ID string
Cause: Control program status message.
Action: No action required.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

TNS-01414: “string”, state string, established string, refused string, current string, max string

oracle

TNS-01414: "string", state string, established string, refused string, current string, max string
Cause: Control program status message.
Action: No action required.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

TNS-01414: “string”, state string, established string, refused string, current string, max string

oracle

TNS-01414: "string", state string, established string, refused string, current string, max string
Cause: Control program status message.
Action: No action required.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/