Oracle
解决方案 »
- 虚拟机的oracle连接主机,连接不上
- oracle里是否有函数,能把中文的符号和数字转换成英文?
- 想实现从3张表中取出数据形成一张表,但里面涉及了很多时间条件,请教一下如何取出一段时间的数据。
- 我的ORACLE怎么了
- 看大家写的代码有没有比我少!
- 急问,我把一台机子的Oracle客户端81升到92客户端,升级会不会出现问题?
- Oracle 里 redo log 是不是:恢复日志
- 以前在oracle里建了一个表,现在忘了表名,怎么办?
- 重金求解!!!
- 不安装oracle客户端,pb应用程序如何连接到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))
)