假设我有一个Oracle数据库.我有一个用户名= x,密码= y,数据库= z.我也知道port = a,SID = b,Hostname = c.
那么我该如何正确连接呢?我使用了很多选项:
sqlplus x/y@'(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=c)(PORT=a))(CONNECT_DATA=(SID=z)(SERVER=DEDICATED)))' sqlplus (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=c)(PORT=a))(CONNECT_DATA=(SID=b)))
ORA-12560: TNS:protocol adapter error
ORA-12514: TNS:listener does not currently know of service
提前谢谢了!!