UserID=HHKSH,dbserver=HHKSH_10.4.49.13.password=123456;
上面这些是Oracle远程数据库的信息。
我要怎没配置tnsnames.ora。才能连接上?我的配置文件是
# TNSNAMES.ORA Network Configuration File: C:\oracle\ora90\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.#sample#HHKSH =
# (DESCRIPTION =
# (ADDRESS_LIST =
# (ADDRESS = (PROTOCOL = TCP)(HOST = 10.4.49.13)(PORT = 1521))
# )
# (CONNECT_DATA =
# (SERVICE_NAME = HHKSH)
# )
# )ORACLE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 130.81.100.101)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = scbus)
)
)ORACLEBCV =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 130.81.100.136)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = scbus)
)
)
REPORT =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 9.83.70.14)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = report)
)
)
但是连接时间报错 是 监听程序不能解析连接字符中的SERVICE_NAME那个地方错了。?我以前用的都是sqlservice
第一次用Oracle 大伙帮忙看看 谢谢
上面这些是Oracle远程数据库的信息。
我要怎没配置tnsnames.ora。才能连接上?我的配置文件是
# TNSNAMES.ORA Network Configuration File: C:\oracle\ora90\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.#sample#HHKSH =
# (DESCRIPTION =
# (ADDRESS_LIST =
# (ADDRESS = (PROTOCOL = TCP)(HOST = 10.4.49.13)(PORT = 1521))
# )
# (CONNECT_DATA =
# (SERVICE_NAME = HHKSH)
# )
# )ORACLE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 130.81.100.101)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = scbus)
)
)ORACLEBCV =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 130.81.100.136)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = scbus)
)
)
REPORT =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 9.83.70.14)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = report)
)
)
但是连接时间报错 是 监听程序不能解析连接字符中的SERVICE_NAME那个地方错了。?我以前用的都是sqlservice
第一次用Oracle 大伙帮忙看看 谢谢
另外可以根据ORACLE 的net manager 向导进行配置。
# (DESCRIPTION =
# (ADDRESS_LIST =
# (ADDRESS = (PROTOCOL = TCP)(HOST = 10.4.49.13)(PORT = 1521))
# )
# (CONNECT_DATA =
# (SERVICE_NAME = HHKSH)
# )
# )
把#号注释掉
连接的时候用
sqlplus user/password@HHKSH
# TNSNAMES.ORA Network Configuration File: C:\oracle\ora90\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.#sampleHHKSH =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.4.49.13)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = HHKSH)
)
)然后用sqlplusw.exe 连接
用户名:HHKSH
口令:123456
主机字符串:10.4.49.13但是出现 监听程序不能解析连接字符中的SERVICE_NAME 的错误
UserID=HHKSH,dbserver=HHKSH ,password=123456;
能在问下吗?
为什么要用
用户名:HHKSH
口令:123456
主机字符串:HHKSH
连接?