手动配置oracle客户端的方法

当机器名变换的时候,将C:\oracle\ora92\network\admin\ 目录下的文件sqlnet.ora   的对应内容变更为 SQLNET.AUTHENTICATION_SERVICES= (NONE)

当增加Db Server时,将C:\oracle\ora92\network\admin\tnsnames.ora 添加内容:
eg1:
AXXXX =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = BXXXX)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = DXXXX)
      (SERVER = DEDICATED)
    )
  )

eg2:
AXXXX =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = BXXXX)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = CXXXX)
    )
  )

-------------------------------------------------------------
AXXXX: 本地Db ServerName
BXXXX: DbServer 所在的机器的机器名或者IP
CXXXX: DbServer的ServerName
DXXXX: DbServer的SID

原文地址:https://www.cnblogs.com/LiuShui/p/50132.html