oracle 11g本地数据库连接 [英] oracle 11g local database connection
本文介绍了oracle 11g本地数据库连接的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
大家好,
我是oracle的新手,我试图通过使用TOAD连接到本地oracle数据库.为了做到这一点,我需要一个tns文件和侦听器文件.但是,我无法生产它们.请帮助我获取样本tns和侦听器文件以及将它们放在哪里.
在此先感谢.
Hi all,
I am new at oracle and I am trying to connect to my local oracle database via using TOAD. In order to do that i need a tns file and listener file. But, I could not produce them. Please help me to get a sample tns and listener file and where I should put them.
Thanks in advance.
推荐答案
此处带有路径的示例.您需要将其(端口,服务名称等)映射到您的安装并将其放置:
tnsnames.ora
文件:
Here sample with path. You need to map(port, service name, etc) it to your install and place them:
tnsnames.ora
file:
# tnsnames.ora Network Configuration File: E:\app\IT\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
SampleConnectionName =
( DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = IT-PC)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
listner.ora
文件:
listner.ora
file:
# listener.ora Network Configuration File: E:\app\IT\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
MyLISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST =IT-PC)(PORT = 1521))
)
)
这篇关于oracle 11g本地数据库连接的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文