然后建立tnsnames.ora文件,内容如下: 显示代码打印1 oracledata = 2 (DESCRIPTION = 3 (ADDRESS_LIST = 4 (ADDRESS = (PROTOCOL = TCP)(HOST = yourhostIp )(PORT = 1521)) 5 ) 6 (CONNECT_DATA = 7 (SERVICE_NAME = yourSID ) 8 ) 9 ) 请问SERVICE_NAME = yourSID ,yourSID是啥意思呢?
绿色方法访问 服务器的oracle yourSID是不是就得问服务器的管理员 这个yourSID的值是啥?
SQL> conn sys/zeng as sysdba
已连接。
SQL> show parameter serviceNAME TYPE VALUE
------------------------------------ ----------- ------------------------------
service_names string orcl
SQL>