ORA-12514 TNS:listener does not currently know of service requested in connect descriptor问题解决,
第一步:
在数据库中查询数据库服务名称
select value from v$parameter where name='service_names'
第二步:
port后为查询到的服务名称
sqlplus username/passwd@IP:port/servicename
或者修改tnsnames.ora中的SERVICE_NAME
TEST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = *<validhost>*)(PORT = *<validport>*)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = *<servicenamefromDB>*) ) )
本站文章为和通数据库网友分享或者投稿,欢迎任何形式的转载,但请务必注明出处.
同时文章内容如有侵犯了您的权益,请联系QQ:970679559,我们会在尽快处理。