我已将连接字符串配置为tnsnames.ora。在我的sqlnet.ora中,我的内容如下:
NAMES.DIRECTORY_PATH= (LDAP, TNSNAMES, HOSTNAME)
NAMES.DEFAULT_DOMAIN = WORLD
TRACE_LEVEL_CLIENT = OFF
SQLNET.EXPIRE_TIME = 30
当我从tnsnames.ora向SID进行tnsping呼叫时,我会发现错误:
TNS-03505: Failed to resolve name
tnsname.ora的示例配置
TNS_NAME =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = HOST.NAME)(PORT = PORT_NUMBER))
)
(CONNECT_DATA =
(SERVICE_NAME = SID)
)
)
我在做什么错?
我使用以下连接字符串而不使用tnsnames.ora进行映射以连接到远程数据库:
sqlplus username/password@(DESCRIPTION =
(ADDRESS = (PROTOCOL= TCP)(Host= hostname.network)(Port= remote_port))
(CONNECT_DATA = (SID = remote_SID))
)