oracle ora12154 无法解析连接字符串

1、可能是客户端文件配置有问题，listener.ora、tnsnames.ora

2、把两个文件拷贝到客户端安装目录的$ORACLE_HOME\client_1\network\admin下面

3、在tnsnames.ora添加如下内容：

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

4、在listener.ora添加如下内容：

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
    )
  )

5、打开pl\sql工具，输入用户名：scott；密码：tiger；数据库是orcl；登录模式：Normal

6、搞定。！！