今天尝试服务器名配置,过程中出现错误:(如下所示)
正在连接...ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务
测试未成功。您提供的一些信息可能不正确。
单击“后退”检查提供的 Net 服务名的信息, 或单击“更改登录”来更改用户名。我的listener.ora文件内容是:
LISTENER2 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ZQ)(PORT = 1521))
)
)LISTENER1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ZQ)(PORT = 1521))
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ZQ)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)tnsnames.ora内容是:OAMISGIS =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ZQ)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = oamisgis.beijing)
)
)OAMISGIS1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = oamisgis.beijing)
)
)
怎么解决呢?求高人指点
正在连接...ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务
测试未成功。您提供的一些信息可能不正确。
单击“后退”检查提供的 Net 服务名的信息, 或单击“更改登录”来更改用户名。我的listener.ora文件内容是:
LISTENER2 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ZQ)(PORT = 1521))
)
)LISTENER1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ZQ)(PORT = 1521))
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ZQ)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)tnsnames.ora内容是:OAMISGIS =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ZQ)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = oamisgis.beijing)
)
)OAMISGIS1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = oamisgis.beijing)
)
)
怎么解决呢?求高人指点
正在连接...ORA-01017: invalid username/password; logon denied
测试未成功。您提供的一些信息可能不正确。
单击“后退”检查提供的 Net 服务名的信息, 或单击“更改登录”来更改用户名。