PLSQL连接Oracle数据库配置简要记录

1.在系统环境变量中配置TNS_ADMIN指向tnsnames.ora文件所在的目录;
2.在系统环境变量path中加入instantclient-win32的路径;

tnsnames.ora内容格式：

orcl =

  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = IP )(PORT = 7521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl )
    )
  )