Monday, July 13, 2009

ORA-06401 NETCMN: invalid driver designator

When recently issuing a command to connect to a remote database, the Oracle “ora-06401” error was encountered.

Oracle documentation states the following cause, along with what it suggests to be the sole solution:

ORA-06401 NETCMN: invalid driver designator

Cause: The login (connect) string contains an invalid driver designator.

Action: Correct the string and re-submit.

This usually means that the command syntax is incorrect. However, other causes exist:

1. improper authorization for the user issuing the command
2. invalid connection string for the target database version
3. ^M characters present in the file tnsnanes.ora file. These can be seen by viewing the ascii file after it has been converted to binary or by editing the file in a UNIX/Linux editor, such as vi. These characters are usually created by editing the file with a non-Linux/Unix editor and then transferring it by FTP to the server.
Use the following vi editor command to remove all of these characters from the file:



  1. As far as I see, your blog contains various sources of data, software and hardware related as well. Let me let you know about the database corrupted recovery sql server 2005 tool that quickly repairs database files. This data is not present in your blog yet :)

  2. Thanks for your comment, Helga.

    Happy New Year!

  3. I'm not understand solution that! can you for me more infomation.
    I can speak English A little, sorry if you don't understan i say that. :)