这是我的listerner.ora
# listener.ora Network Configuration File: f:\oracle\product\10.2.0\client_1\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(SID_NAME = ORCL)
)
)LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =localhost)(PORT = 1521))
)我的监听器监听的host是localhost
但是今天我连到另一台主机的时候只是配了tnsnames.ora
# tnsnames.ora Network Configuration File: f:\oracle\product\10.2.0\client_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
ACCOUNT_10.0.5.201 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =10.0.5.201)(PORT = 1521))
)
(CONNECT_DATA =
(SID = ACCOUNT)
(SERVER = DEDICATED)
)
)
ORCL_LOCALHOST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SID = orcl)
(SERVER = DEDICATED)
)
)
在没有监听的情况下为什么依然能够操作另一台主机上的库?
另外tnsname.ora中的orcl库和orcl_localhost有区别么?
另外就是net configration assitant中本地net服务名配置点下一步不好使 但是用plsql能连上任何库
# listener.ora Network Configuration File: f:\oracle\product\10.2.0\client_1\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(SID_NAME = ORCL)
)
)LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =localhost)(PORT = 1521))
)我的监听器监听的host是localhost
但是今天我连到另一台主机的时候只是配了tnsnames.ora
# tnsnames.ora Network Configuration File: f:\oracle\product\10.2.0\client_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
ACCOUNT_10.0.5.201 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =10.0.5.201)(PORT = 1521))
)
(CONNECT_DATA =
(SID = ACCOUNT)
(SERVER = DEDICATED)
)
)
ORCL_LOCALHOST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SID = orcl)
(SERVER = DEDICATED)
)
)
在没有监听的情况下为什么依然能够操作另一台主机上的库?
另外tnsname.ora中的orcl库和orcl_localhost有区别么?
另外就是net configration assitant中本地net服务名配置点下一步不好使 但是用plsql能连上任何库
2、两个没有什么区别,一个通过指定SID方式来连接(9i以前主要使用的方式),
一个通过SERVICE_NAME方式连接(推荐使用的方式)。
3、既然,你已经可以直接编辑tnsname.ora、listener.ora就不需要netca了。
想问:
我现在想要改一下我本地的库的表空间大小 但是进不去 输入用户名密码后点确定没反应
我点我自己建的库之后出现tns-04404 tns-04414 tns-04612
在netca下本地net服务名配置点下一步后台出的错也是上述的三个
请问如何能去除这三个错误