我使用PL/SQL出现这个问 这个问题如何解决啊 看到别的帖子说是listener.ora和tnsnames.ora这两个文件有问题我附上这两个文件 希望能给我点帮助 我是新手 请详细点
# listener.ora Network Configuration File: H:\app\Admin\product\11.1.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = UN)(PORT = 1521))
) )# tnsnames.ora Network Configuration File: H:\app\Admin\product\11.1.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = UN)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
# listener.ora Network Configuration File: H:\app\Admin\product\11.1.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = UN)(PORT = 1521))
) )# tnsnames.ora Network Configuration File: H:\app\Admin\product\11.1.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = UN)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
解决方案 »
- 增量备份的基本备份是不是逻辑备份?
- ORACLE 监听无法启动(LINUX 下)
- “Refcursor值无效“的错误
- 请问各位oracle 高手一个关于sqlldr 的问题............
- 一个简单的问题,希望各位能指点一下,谢谢了!
- 如何让ORACLE限制IP登陆?
- 请问很简单的Insert Into语句包括varchar(4000) 的记录,字段超长时为会不会报错?
- 两个查询问题,请高手指教
- 怎么用Oracle Spatial建立数据库呢?刚把Oracle8i装上,不知道从那个程序进去,怎么动手?
- java编程和数据库关系
- ORA-01219:数据库未打开:仅允许在固定表/视图中查询
- 请问我的OEM内该填些什么老是显示密码错误
tnsping orcl看是否Ok?
orcl 里面 的SID 要标注一下,