奇怪，用sqlplus登陆可以，但是加上连接串就不行？？

金枪鱼

我的系统 RH9  Oracle817

平时用 sqlplus system/manager 就可以直接进入，但是用sqlplus system/manager@local.world 就出错。

错误代码ORA-06401 NETCMN: invalid driver designator

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

Action: Correct the string and re-submit.

我的tnsnames.ora如下：
LOCAL.world =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 172.31.0.52)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = ora
    )
  )

用DBA Studio也出现一样的报错？？？

请高人指教！！

eagle_fan

Recreate the TNSNAMES.ORA file.

Your existing TNSNAMES.ORA file may be corrupted with hidden characters or ending ^M. These are considered illegal characters for the configuration file (similar to using a tab character
instead of indenting with blank spaces).

These ^M characters can be removed all at once by invoking the following command in the Unix editor vi while still in command mode:

:%s/.$// <enter>;


SQL*Net parses the "tnsnames.ora" file for connection information. Seeing the first character of ^M after the alias somehow made SQL*Net think it had an invalid protocol selection for a version 1 connect string. This prompted the computer to return an invalid version 1 error, ORA-06401.

zhnlet

楼上的正解

whnf

完全正确！

xingj_h

8错

金枪鱼

多谢！！