Oracle Notes

Sharing Oracle technology knowledge and experiences.

ORA-06401 NETCMN: invalid driver designator

Posted by sdefilip on July 13, 2009

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:

:%s/.$//

Advertisements

2 Responses to “ORA-06401 NETCMN: invalid driver designator”

  1. Helga said

    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!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: