ORA-06413 "Connection not open" error

Hi All,

ORA-06413 "Connection not open" error

This is not a question but a warning. Oracle will not allow you to connect if your computer name contains illegal characters (defined by Oracle). This is fairly clearly documented, but pretty lame. Even more lame, and less well documented, is the fact that if your executable's filename contains illegal Oracle characters (parenthisis for instance) you will not be able to connect.

This is purely an Oracle bug--it does not depend on what technology you use to connect (ADO, DAO, OLEDB, OO4O, etc.). In fact, if you rename the SQL*Plus executable to "SQLPLUSW(2).exe" (on a windows machine) you won't even be able to connect with SQL*Plus. I noticed in a very old message on this topic that somebody blamed the Microsoft ODBC driver, but that is not the problem.

Hopefully this warning will help others before they spend hours debugging this obscure and, as usual, unhelpful error message.

--Dan Received on Mon Aug 13 2001 - 17:32:49 CDT