navicat 连接oracle 出现ora-28547 Oracle 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 求大神帮我解决啊 使用Toad for Oracle 11.6 能够连接上 。大神大神啊 把你上面的service name 换成 sid 连接试试 toad可连接? sqlplus 能连接吗?贴出tnsnames.ora的配置和监听文件的配置 我没用sqlplus # tnsnames.ora Network Configuration File: C:\oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora# Generated by Oracle configuration tools.LISTENER_ORCL = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1522))ORCL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1522)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) ) 已经换成SID试过了 还是ora-28547 tnsnames.ora里面怎么要这行?LISTENER_ORCL = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1522))删了吧 不是因为那个原因吧1)把连接类型 basic 改为 tns、试试2)贴上lsnrctl services # listener.ora Network Configuration File: C:\oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora# Generated by Oracle configuration tools.LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) ) (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) )ADR_BASE_LISTENER = C:\oracle\product\11.2.0\dbhome_1\log 非标端口(非5121)、要注意参数local_listener listener.log 可以在简便点:LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = IP)(PORT = 1521)) ) oracle查询动态列 求解这个存储过程中输入游标如何写! 关于oracle的内嵌视图,在哪可以找到详细说明? 菜鸟求一sql 不胜感激 在线等 急 oracle象sql中的test字段类型是什么? database control-orcl是用来做什么的? ORACLE与SQLSever的关系 如何将Interbase数据库导入到ORACLE中相应表中 hoho 调查调查 ORA-12557--SQL Developer链接oracle数据库报错 oracle学习新手,求几条sql的标准答案对照~~~ 为什么编译的时候说标示符出错,在第三行代码,求大神。
贴出tnsnames.ora的配置和监听文件的配置
# Generated by Oracle configuration tools.LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1522))
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1522))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1522))
删了吧
2)贴上lsnrctl services
# Generated by Oracle configuration tools.LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)ADR_BASE_LISTENER = C:\oracle\product\11.2.0\dbhome_1\log
非标端口(非5121)、要注意参数local_listener
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = IP)(PORT = 1521))
)