Re: ERROR: ORA-06401: NETCMN: invalid driver designator

From: TurkBear <johng_at_mm.com>
Date: Thu, 21 May 1998 20:06:51 GMT
Message-ID: <356488ab.22965332@news2.mm.com>

Grace Tsai <gtsai_at_ribm00.rhic.bnl.gov> wrote:

>If I enter the following sqlplus, it works fine
>
> sqlplus <username>/<password>@<DBname>
>
>But if I enter the following sqlplus, I got error message:
>
> sqlplus <username>/<password>@<ORACLE Server address>:1521:<DBname>
>
> ERROR: ORA-06401: NETCMN: invalid driver designator
>
>Any idea? Thanks in advance.
>
>Grace Tsai
>Brookhaven National Laboratory

It appears, at least from what I could read in various docs, that the way you tried would have worked with SqlNet v1 ( if you preceeded your connect string with T:, i.e. @T:<OracleAdress>:1521:<DbName>) But in SqlNet V2 you need to use the service name ( that is, the alias in TNSNAMES.ORA )

Hope it helps,
John Greco
Oracle DBA Received on Thu May 21 1998 - 15:06:51 CDT