oracle 11g本地数据库连接 [英] oracle 11g local database connection

问题描述

大家好，

我是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屋！