我在虚拟机中用sqlplus dev/dev@wind可以登录,请问我在配置oracle客户端的时候tnsnames.ora文件里面的内容填什么?
databasename =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ip address)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = database name)
)
)HOST = ip address这个填IP地址,那SERVICE_NAME = database name这个值应该填什么呢?
databasename =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ip address)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = database name)
)
)HOST = ip address这个填IP地址,那SERVICE_NAME = database name这个值应该填什么呢?
host = localhost
sid = wind
user = dev
pass = dev
对应的配置为
databasename =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = wind)
)
)
错误代号是:ORA-12154:TNS:无法解析指定的连接标识符.
2、不要多加了引号之类的标点
3、实例名区分大小写