PLSQL 配置监听程序的问题 本帖最后由 elison_16 于 2010-01-21 14:40:06 编辑 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 修改tnsname.ora和listener.ora里面的SID为对应7.0版本的SID不知道行不。7.0也太火星了点,没用过 这还要看你的orcal是什么版本,下面是我的tnsname.oraimss = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.1.241)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = imss) ) )orclA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.0.11)(PORT = 1521)) ) (CONNECT_DATA = (SID = orclA) ) )看到了吗,这两上地方不同,10G版本用SERVICE_NAME ,低版本用SID 换个端口:1. 配置listener.oraLISTENER2 = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.37.38)(PORT = 1522)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) ) ) )SID_LIST_LISTENER2 = (SID_LIST = (SID_DESC = (SID_NAME = ORCL) (ORACLE_HOME = d:\oracle\product\10.1.0\Db_1)# (PROGRAM = extproc) ) )2. 启动listener2c:\ lsnrctl start listener2就哦了楼上说的对,要是8i一下,就只能用SID了 oracle中与||功能相同的是哪个?十个选择题,但记不清选项,有谁知道答案呢?谢谢大家!!! 一个表空间exp出来,为啥有的表里的中文是??,有的确很正常? 如何实现在限定的时间内允许访问视图? 请问怎样知道索引是否起了效果?小妹十分感谢~ Backup table以及权限,制约信息的确认!在线等…… 这个sql 怎么写 急急,菜鸟SQL问题 ★★★★★如何在pro*c中insert或者update BLOB类型字段!★★★★★ 那里有developer/2000下载 关于游标的一个题。 oracle安装时出现三次错误。 ora-14454:试图引用引用完整性约束条件中的临时表
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.1.241)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = imss)
)
)orclA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.0.11)(PORT = 1521))
)
(CONNECT_DATA =
(SID = orclA)
)
)看到了吗,这两上地方不同,10G版本用SERVICE_NAME ,低版本用SID
1. 配置listener.ora
LISTENER2 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.37.38)(PORT = 1522))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)
SID_LIST_LISTENER2 =
(SID_LIST =
(SID_DESC =
(SID_NAME = ORCL)
(ORACLE_HOME = d:\oracle\product\10.1.0\Db_1)
# (PROGRAM = extproc)
)
)
2. 启动listener2
c:\ lsnrctl start listener2
就哦了楼上说的对,要是8i一下,就只能用SID了