解释一下上面的疑点:在A,B能通过测试连接到C,D,而在C,D则不能通过测试连接到A,B
解决方案 »
- PLSqlDev 登录oracle出现:ORA-12514 监听程序当前无法识别连接!跪求高手帮忙
- 新装的数据库连不上
- oracle DBA和j2EE开发哪个有发展
- 关于Oracle服务启动的问题,求高手解决
- 某个目录出现core.xxxx的文件占满整个硬盘空间
- 请问大家在PL/SQL里面怎么用 SQL Window啊?能介绍几个快捷键吗
- oracle存储过程,要求能输入数组作为参数,数组长度不一样,用另外一个参数表示长度是多少 ,给个例子
- 关于ORACLE的存储过程
- 各位老道:菜鸟请教一个问题,如何在ORACLE中操作LONG型的字段????急急急急急急
- pl/sql简单的自定义function编译错误
- ...where to_char(END_TIME, 'day') = '星期三' 居然和 where END_TIME = to_date('星期三', 'day');不一样,怎么回事?
- 请大伙推荐一个优秀的建库工具
还有一点要说明:能被连通的服务器是装了WIN2K,后安装双网卡,我判断是WIN2K不能调节网卡的出口问题
大家说说呢?
你说会不会和操作系统有关系的,我真是纳闷,居然有这么的现象。
# Generated by Oracle configuration tools.SHISI =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 176.231.0.40)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ShiSi.txzx.org)
)
)SHISAN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 176.231.0.30)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ShiSan.txzx.org)
)
)ZHONGSHAN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 176.231.0.60)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ZhongSh.txzx.org)
)
)SHIZHONG =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 176.231.0.10)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ShiZhong.txzx.org)
)
)SERVER.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 176.231.0.70)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = gongshu.txzx.org)
)
)YL.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 176.231.0.78)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = gongshu.txzx.org)
)
)GONGSHU =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 176.231.0.70)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = GongShu.txzx.org)
)
)EXTPROC_CONNECTION_DATA.TXZX.ORG =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)INST1_HTTP.TXZX.ORG =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = gongshu)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = gongshu.txzx.org)
(PRESENTATION = http://admin)
)
)HONGHUI =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 176.231.0.20)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = HongHui.txzx.org)
)
)
# Generated by Oracle configuration tools.LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 176.231.0.70)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 176.231.0.70)(PORT = 2481))
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 176.231.0.78)(PORT = 1521))
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\ora81)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = gongshu.txzx.org)
(ORACLE_HOME = D:\oracle\ora81)
(SID_NAME = gongshu)
)
)
ping通是吗?
tnsping呢?
现在的一个新问题是:用SQL*PLUS登录的时候提示“监听器不能解析SERVICE_NAME”,大家有什么好方法解决吗?
ping 测试网络是否通
tnsping 检测服务器的监听器是否启动
不能解析服务名:你是否连接串写的不对?好好检查。不要连net8都没有测试通过就开始登陆
sql/sqlus了,没有用的。