oracle数据库如何配置tns连接字符信息

方法一：可以通过打开oracle安装目录中的tnsnames.ora进行配置，具体如下：

具体路径比如：F:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora

# tnsnames.ora Network Configuration File: F:\app\Administrator\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORCLYZC =                                                      #注释一  此处为网络服务名，用于plsql远程连接oracle数据库时的数据库名
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.221)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl)                        #注释二   服务名（SID）可重复
    )
  )

ORCL_STJWT =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.221)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl)
    )
  )


TEST =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = USER-20160418LL)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = test)
    )
  )


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

方法二：

通过oracle net configuration assistant工具进行配置：

1、本地网络服务名-》下一步-》添加-》服务名（SID）-》配置主机名和端口号

-》测试-》更改用户密码-》测试成功-》配置网络服务名-》添加成功。